mquery

Documentation

Index

• Constants
• Variables
• func Delete() *deleteData
• func FormatMapKey(oldKey string) string
• func GetValuesFromMap(m map[string]gin.H, key string) ([]interface{}, error)
• func GetValuesFromMapRows(ms map[string][]gin.H, key string) ([]interface{}, error)
• func GetValuesFromRows(rows []gin.H, key string) ([]interface{}, error)
• func Insert() *insertData
• func InterfaceToStruct(inc interface{}, s interface{}) error
• func Join(joinType int64) *joinData
• func Select() *selectData
• func SelectKeys2Many(ctx context.Context, tx mdb.ExecuteAble, keyValues []interface{}, ...) (map[string][]gin.H, error)
• func SelectKeys2One(ctx context.Context, tx mdb.ExecuteAble, keyValues []interface{}, ...) (map[string]gin.H, error)
• func SelectRows2Many(ctx context.Context, tx mdb.ExecuteAble, sourceRows []gin.H, ...) (map[string][]gin.H, []interface{}, error)
• func SelectRows2One(ctx context.Context, tx mdb.ExecuteAble, sourceRows []gin.H, ...) (map[string]gin.H, []interface{}, error)
• func Update() *updateData
• type ConvertAdd
  • func ConvertAddMake(k string, v interface{}) ConvertAdd
  • func (o ConvertAdd) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertDesc
  • func (o ConvertDesc) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertEq
  • func ConvertEqMake(k string, v interface{}) ConvertEq
  • func (o ConvertEq) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertEqRaw
  • func ConvertEqRawMake(k, v string) ConvertEqRaw
  • func (o ConvertEqRaw) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertFuncAs
  • func ConvertFuncAsMake(f, col, as string) ConvertFuncAs
  • func (o ConvertFuncAs) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertFuncColAs
• type ConvertGt
  • func ConvertGtMake(k string, v interface{}) ConvertGt
  • func (o ConvertGt) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertKv
• type ConvertKvStr
• type ConvertLt
  • func ConvertLtMake(k string, v interface{}) ConvertLt
  • func (o ConvertLt) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertMinus
  • func ConvertMinusMake(k string, v interface{}) ConvertMinus
  • func (o ConvertMinus) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertOr
  • func ConvertOrMake(left, right SQLAble) ConvertOr
  • func (o ConvertOr) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertRaw
  • func (o ConvertRaw) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type ConvertValues
  • func (o ConvertValues) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)
• type SQLAble

Constants

const (
	JoinTypeInner = 1
	JoinTypeLeft  = 2
)

join类型

Variables

var ErrInValueLenZero = errors.New("sql in values len 0")

ErrInValueLenZero in 条件数据长度为0

Functions

func Delete

func Delete() *deleteData

Delete 创建删除

func FormatMapKey

func FormatMapKey(oldKey string) string

FormatMapKey 格式化字段名到key

func GetValuesFromMap

func GetValuesFromMap(m map[string]gin.H, key string) ([]interface{}, error)

GetValuesFromMap 获取values

func GetValuesFromMapRows

func GetValuesFromMapRows(ms map[string][]gin.H, key string) ([]interface{}, error)

GetValuesFromMapRows 获取values

func GetValuesFromRows

func GetValuesFromRows(rows []gin.H, key string) ([]interface{}, error)

GetValuesFromRows 获取values

func Insert

func Insert() *insertData

Insert 创建搜索

func InterfaceToStruct

func InterfaceToStruct(inc interface{}, s interface{}) error

InterfaceToStruct 转换到struct

func Join

func Join(joinType int64) *joinData

Join 链接

func Select

func Select() *selectData

Select 创建搜索

func SelectKeys2Many

func SelectKeys2Many(ctx context.Context, tx mdb.ExecuteAble, keyValues []interface{}, targetTableName, targetKey string, targetColumns []string) (map[string][]gin.H, error)

SelectKeys2Many 获取关联map

func SelectKeys2One

func SelectKeys2One(ctx context.Context, tx mdb.ExecuteAble, keyValues []interface{}, targetTableName, targetKey string, targetColumns []string) (map[string]gin.H, error)

SelectKeys2One 获取关联map

func SelectRows2Many

func SelectRows2Many(ctx context.Context, tx mdb.ExecuteAble, sourceRows []gin.H, sourceKey, targetTableName, targetKey string, targetColumns []string) (map[string][]gin.H, []interface{}, error)

SelectRows2Many 获取关联map

func SelectRows2One

func SelectRows2One(ctx context.Context, tx mdb.ExecuteAble, sourceRows []gin.H, sourceKey, targetTableName, targetKey string, targetColumns []string) (map[string]gin.H, []interface{}, error)

SelectRows2One 获取关联map

func Update

func Update() *updateData

Update 创建更新

Types

type ConvertAdd

type ConvertAdd ConvertKv

ConvertAdd k=k+:k

func ConvertAddMake

func ConvertAddMake(k string, v interface{}) ConvertAdd

ConvertAddMake 生成

func (ConvertAdd) AppendToQuery

func (o ConvertAdd) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertDesc

type ConvertDesc string

ConvertDesc k DESC

func (ConvertDesc) AppendToQuery

func (o ConvertDesc) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertEq

type ConvertEq ConvertKv

ConvertEq k=:k or k IN (:k)

func ConvertEqMake

func ConvertEqMake(k string, v interface{}) ConvertEq

ConvertEqMake 生成

func (ConvertEq) AppendToQuery

func (o ConvertEq) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertEqRaw

type ConvertEqRaw ConvertKvStr

ConvertEqRaw k=v

func ConvertEqRawMake

func ConvertEqRawMake(k, v string) ConvertEqRaw

ConvertEqRawMake 生成

func (ConvertEqRaw) AppendToQuery

func (o ConvertEqRaw) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertFuncAs

type ConvertFuncAs ConvertFuncColAs

ConvertFuncAs func(col) AS as

func ConvertFuncAsMake

func ConvertFuncAsMake(f, col, as string) ConvertFuncAs

ConvertFuncAsMake 生成

func (ConvertFuncAs) AppendToQuery

func (o ConvertFuncAs) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertFuncColAs

type ConvertFuncColAs struct {
	Func string
	Col  string
	As   string
}

ConvertFuncColAs 字符串

type ConvertGt

type ConvertGt ConvertKv

ConvertGt k>:k

func ConvertGtMake

func ConvertGtMake(k string, v interface{}) ConvertGt

ConvertGtMake 生成

func (ConvertGt) AppendToQuery

func (o ConvertGt) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertKv

type ConvertKv struct {
	K string
	V interface{}
}

ConvertKv kv结构

type ConvertKvStr

type ConvertKvStr struct {
	K string
	V string
}

ConvertKvStr kv字符串

type ConvertLt

type ConvertLt ConvertKv

ConvertLt k<:k

func ConvertLtMake

func ConvertLtMake(k string, v interface{}) ConvertLt

ConvertLtMake 生成

func (ConvertLt) AppendToQuery

func (o ConvertLt) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertMinus

type ConvertMinus ConvertKv

ConvertMinus k=k-:k

func ConvertMinusMake

func ConvertMinusMake(k string, v interface{}) ConvertMinus

ConvertMinusMake 生成

func (ConvertMinus) AppendToQuery

func (o ConvertMinus) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertOr

type ConvertOr struct {
	Left  SQLAble
	Right SQLAble
}

ConvertOr 或条件

func ConvertOrMake

func ConvertOrMake(left, right SQLAble) ConvertOr

ConvertOrMake 生成

func (ConvertOr) AppendToQuery

func (o ConvertOr) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertRaw

type ConvertRaw string

ConvertRaw 原样生成

func (ConvertRaw) AppendToQuery

func (o ConvertRaw) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type ConvertValues

type ConvertValues string

ConvertValues k=VALUES(k)

func (ConvertValues) AppendToQuery

func (o ConvertValues) AppendToQuery(buf bytes.Buffer, arg gin.H) (bytes.Buffer, gin.H, error)

AppendToQuery 写入sql,填充arg

type SQLAble

type SQLAble interface {
	AppendToQuery(bytes.Buffer, gin.H) (bytes.Buffer, gin.H, error)
}

SQLAble sql语句生成接口