mquery

package

v0.0.37 Latest Latest Go to latest Published: Mar 3, 2022 License: MIT Imports: 11 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/moremorefun/mtool

Links

Open Source Insights

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 ¶

View Source

const (
	JoinTypeInner = 1
	JoinTypeLeft  = 2
)

join类型

Variables ¶

View Source

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 ¶ added in v0.0.21

type ConvertMinus ConvertKv

ConvertMinus k=k-:k

func ConvertMinusMake ¶ added in v0.0.21

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

ConvertMinusMake 生成

func (ConvertMinus) AppendToQuery ¶ added in v0.0.21

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 ¶ added in v0.0.10

type ConvertValues string

ConvertValues k=VALUES(k)

func (ConvertValues) AppendToQuery ¶ added in v0.0.10

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语句生成接口

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL