1 Star 0 Fork 0

h79 / goutils

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
克隆/下载
group.go 1.63 KB
一键复制 编辑 原始数据 按行查看 历史
huqiuyun 提交于 2023-11-30 15:11 . perf redis
package wrapper
import (
"gitee.com/h79/goutils/dao/option"
"strings"
)
type GroupBy []Column
var _ IBuilder = (*GroupBy)(nil)
func (g *GroupBy) Is() bool {
return len(*g) > 0
}
func (g *GroupBy) Build(opts ...option.Option) string {
var ii = 0
var m = 6
var full = true
var convert option.ColumnConvertFunc
option.Filter(func(opt option.Option) bool {
if opt.Type() == option.TypeMaxColumn {
m = opt.Value().(int)
ii++
} else if opt.Type() == option.TypeFullSql {
full = opt.Value().(bool)
ii++
} else if opt.Type() == option.TypeSqlColumnConvert {
convert = opt.Value().(option.ColumnConvertFunc)
ii++
}
return ii == 3
}, opts...)
return g.buildOpt(full, convert, m)
}
func (g *GroupBy) Check(filters []FField, opts ...option.Option) {
length := len(*g)
m := option.MaxColumnExist(opts...)
if length > m { //防止多
length = m
}
cols := (*g)[:length]
for i := range cols {
cols[i].Check(filters)
}
}
func (g *GroupBy) buildOpt(full bool, convert option.ColumnConvertFunc, max int) string {
count := 0
builder := strings.Builder{}
expr := false
cc := false
for i := range *g {
if count >= max {
//后面不要接入
break
}
if count == 0 {
if full {
builder.WriteString(" GROUP BY ")
}
} else if count > 0 {
builder.WriteByte(',')
}
expr = (*g)[i].Expr != ""
if (*g)[i].Column != "" {
if convert != nil {
cc = SqlColumn(&builder, convert((*g)[i].Column))
} else {
cc = SqlColumn(&builder, (*g)[i].Column)
}
if expr && cc {
builder.WriteByte(' ')
}
}
if expr {
builder.WriteString((*g)[i].Expr)
}
count++
}
return builder.String()
}
Go
1
https://gitee.com/h79/goutils.git
git@gitee.com:h79/goutils.git
h79
goutils
goutils
v1.20.65

搜索帮助