query

Documentation

Index

• Constants
• func FormatQueryForRows(ctx context.Context, q string, inputs [][]interface{}) (string, []interface{}, error)
• func NewSQLQueryBuilder(db sql.Interface, paramTag, dbTag string, option *Option) *sqlClausebuilder
• type Cursor
• type Option

Constants

const (
	Int int8 = iota
	IntArr
	Int64
	Int64Arr
	Int32
	Int32Arr
	Int16
	Int16Arr
	Int8
	Int8Arr
	Uint
	UintArr
	Uint64
	Uint64Arr
	Uint32
	Uint32Arr
	Uint16
	Uint16Arr
	Uint8
	Uint8Arr
	String
	StringArr
	Float32
	Float32Arr
	Float64
	Float64Arr
	Bool
	Time
	TimeArr
)

const (
	MaxFloat64 float64 = math.MaxFloat64
	MaxFloat32 float32 = math.MaxFloat32
	MinFloat64 float64 = math.MaxFloat64 * -1
	MinFloat32 float32 = math.MaxFloat32 * -1
)

const (
	MaxUint64 = ^uint64(0)
	MinUint64 = uint64(0)
	MaxUint32 = ^uint32(0)
	MinUint32 = uint32(0)
	MaxUint16 = ^uint16(0)
	MinUint16 = uint16(0)
	MaxUint8  = ^uint8(0)
	MinUint8  = uint8(0)
	MaxUint   = ^uint(0)
	MinUint   = uint(0)
	MaxInt64  = int64(MaxUint64 >> 1)
	MinInt64  = -MaxInt64 - 1
	MaxInt32  = int32(MaxUint32 >> 1)
	MinInt32  = -MaxInt32 - 1
	MaxInt16  = int16(MaxUint16 >> 1)
	MinInt16  = -MaxInt16 - 1
	MaxInt8   = int8(MaxUint8 >> 1)
	MinInt8   = -MaxInt8 - 1
	MaxInt    = int(MaxUint >> 1)
	MinInt    = -MaxInt - 1
)

Functions

func FormatQueryForRows

func FormatQueryForRows(ctx context.Context, q string, inputs [][]interface{}) (string, []interface{}, error)

FormatQueryForRows I hate this, find a better way for insert many rows

func NewSQLQueryBuilder

func NewSQLQueryBuilder(db sql.Interface, paramTag, dbTag string, option *Option) *sqlClausebuilder

Initiate new query builder object

Types

type Cursor

type Cursor interface {
	DecodeCursor(v string) error
	EncodeCursor() (string, error)
}

type Option

type Option struct {
	DisableLimit bool `form:"disableLimit"`
	IsActive     bool
	IsInactive   bool
}