sql

func Count ¶

func Count(table string, count int, search string) int

2018-01-17 12:40 获取表的行数

func CountSearchMap ¶

func CountSearchMap(table string, searchMap SearchMap, num int, search string) int

获取有条件的计算 2018-02-01 9:38

func CountSqlTotal ¶

func CountSqlTotal(query string) int64

*

2018-11-27 09:09
获取查询sql的总行数

func DeleteSql ¶

func DeleteSql(sql string, data SearchMap) string

deleteSql := util.DeleteSql("delete from docker_application", searchMap)

func Exec ¶

func Exec(q string) (sql.Result, error)

执行sql语句

func FindById ¶

func FindById(sql string, id int) string

func GetOrm ¶

func GetOrm() orm.Ormer

func GetString ¶

func GetString(ctx context.Context, key ...string) map[string]string

获取参数并写入到map里面 2018-01-13 19:36

func GetWhere ¶

func GetWhere(searchSql string, searchMap SearchMap) string

func Insert ¶

func Insert(obj interface{}) (int64, error)

插入数据

func InsertSql ¶

func InsertSql(obj interface{}, sql string) string

insertSql := util.InsertSql(data,"insert into docker_application")

func IsExists ¶

func IsExists(strs []string, key string) bool

判断某个元素是否在splice

func MKeyV ¶

func MKeyV(key ...string) []string

2018-02-09 06:40 将要获取的参数都写到一起

func ObjToString ¶

func ObjToString(v interface{}) string

2018-01-20 9:30 将对象转成字符串

func OrderByPagingSql ¶

func OrderByPagingSql(searchSql string, column string, request http.Request, obj interface{}, structObj interface{}) (int, error)

2018-02-05 09:09 公共查询方法，包含orderby和分页sql

func Raw ¶

func Raw(q string) orm.RawSeter

执行sql语句

func Replace ¶

func Replace(sql string) string

func SearchOrder ¶

func SearchOrder(sql string, columnt ...string) string

添加排序 2018-01-13 07:08

func SearchSql ¶

func SearchSql(obj interface{}, sql string, data SearchMap) string

searchMap := util.SearchMap{} searchMap.Put("CreateUser", "zhaozq14") sql := util.SearchSql(index.DockerCloudApp{},index.SelectDockerCloudApp, searchMap)

func SearchSqlPages ¶

func SearchSqlPages(sql string, request http.Request) string

带分页的sql语句 2018-01-15

func StringToLower ¶

func StringToLower(str string) string

func StringToUpper ¶

func StringToUpper(str string) string

func UpdateSql ¶

func UpdateSql(obj interface{}, sql string, data SearchMap, extCloumnt string) string

searchMap := util.SearchMap{} searchMap.Put("CreateUser", "zhaozq14") searchMap.Put("AppId", 89) data := index.DockerCloudApp{} data.AppName = "1111" data.Status = "1" data.AppId = 10 data.AppDescription = "测试update" extCloumnt 排除的列,多个逗号隔开 updateSql := util.UpdateSql(data, index.UpdateDockerCloudApp, searchMap)