sql

Documentation

Index

• func GetKeySQL(key string, model interface{}, alias string) (sqlKey string, argsKey []interface{})
• func GetMoreKeySQL(key string, searModel interface{}, tables ...string) (sqlKey string, argsKey []interface{})
• func GetReflectTags(ref reflect.Type) (tags []string)
• func GetSQLError(error string) (err error)
• func GetTags(model interface{}) []string
• func GtTag(structTag reflect.StructTag, curTag string) (oTag, tag, tagTable string, b bool)
• func StructWhereSQL(st interface{}) (sql string, args []interface{})
• func Table(table string) string

Functions

func GetKeySQL

func GetKeySQL(key string, model interface{}, alias string) (sqlKey string, argsKey []interface{})

key search sql

func GetMoreKeySQL

func GetMoreKeySQL(key string, searModel interface{}, tables ...string) (sqlKey string, argsKey []interface{})

多张表, 第一个表为主表 key search sql tables [table1:table1_alias] searModel : 搜索字段模型

func GetReflectTags

func GetReflectTags(ref reflect.Type) (tags []string)

层级递增解析tag

func GetSQLError

func GetSQLError(error string) (err error)

数据库错误过滤、转换(友好提示)

func GetTags

func GetTags(model interface{}) []string

根据model中表模型的json标签获取表字段 将select* 变为对应的字段名

func GtTag

func GtTag(structTag reflect.StructTag, curTag string) (oTag, tag, tagTable string, b bool)

get tag

func StructWhereSQL

func StructWhereSQL(st interface{}) (sql string, args []interface{})

struct to where sql return key1 = value1 and key2 = value2...

func Table

func Table(table string) string

table parse