Documentation ¶
Index ¶
- Constants
- func BuildFieldSelect(s *sql.Selector, fields []string)
- func BuildFieldSelector(fields []string) (error, func(s *sql.Selector))
- func BuildFilterSelector(andFilterJsonString, orFilterJsonString string) (error, []func(s *sql.Selector))
- func BuildOrderSelect(s *sql.Selector, field string, desc bool)
- func BuildOrderSelector(orderBys []string, defaultOrderField string) (error, func(s *sql.Selector))
- func BuildPaginationSelect(s *sql.Selector, page, pageSize int32)
- func BuildPaginationSelector(page, pageSize int32, noPaging bool) func(*sql.Selector)
- func BuildQuerySelector(andFilterJsonString, orFilterJsonString string, page, pageSize int32, ...) (err error, whereSelectors []func(s *sql.Selector), ...)
- func QueryCommandToOrderConditions(orderBys []string) (error, func(s *sql.Selector))
- func QueryCommandToWhereConditions(strJson string, isOr bool) (error, func(s *sql.Selector))
- type DatePart
- type FilterOp
Constants ¶
View Source
const ( FilterNot = "not" // 不等于 FilterIn = "in" // 检查值是否在列表中 FilterNotIn = "not_in" // 不在列表中 FilterGTE = "gte" // 大于或等于传递的值 FilterGT = "gt" // 大于传递值 FilterLTE = "lte" // 小于或等于传递值 FilterLT = "lt" // 小于传递值 FilterRange = "range" // 是否介于和给定的两个值之间 FilterIsNull = "isnull" // 是否为空 FilterNotIsNull = "not_isnull" // 是否不为空 FilterContains = "contains" // 是否包含指定的子字符串 FilterInsensitiveContains = "icontains" // 不区分大小写,是否包含指定的子字符串 FilterStartsWith = "startswith" // 以值开头 FilterInsensitiveStartsWith = "istartswith" // 不区分大小写,以值开头 FilterEndsWith = "endswith" // 以值结尾 FilterInsensitiveEndsWith = "iendswith" // 不区分大小写,以值结尾 FilterExact = "exact" // 精确匹配 FilterInsensitiveExact = "iexact" // 不区分大小写,精确匹配 FilterRegex = "regex" // 正则表达式 FilterInsensitiveRegex = "iregex" // 不区分大小写,正则表达式 FilterSearch = "search" // 全文搜索 )
Variables ¶
This section is empty.
Functions ¶
func BuildFieldSelect ¶
func BuildFilterSelector ¶
func BuildOrderSelector ¶
func BuildPaginationSelect ¶
func BuildPaginationSelector ¶
func BuildQuerySelector ¶
func BuildQuerySelector( andFilterJsonString, orFilterJsonString string, page, pageSize int32, noPaging bool, orderBys []string, defaultOrderField string, selectFields []string, ) (err error, whereSelectors []func(s *sql.Selector), querySelectors []func(s *sql.Selector))
BuildQuerySelector 构建分页过滤查询器
func QueryCommandToOrderConditions ¶
QueryCommandToOrderConditions 查询命令转换为排序条件
Types ¶
type DatePart ¶
type DatePart int
const ( DatePartDate DatePart = iota // 日期 DatePartYear // 年 DatePartISOYear // ISO 8601 一年中的周数 DatePartQuarter // 季度 DatePartMonth // 月 DatePartWeek // ISO 8601 周编号 一年中的周数 DatePartWeekDay // 星期几 DatePartISOWeekDay // 星期几 DatePartDay // 日 DatePartTime // 小时:分钟:秒 DatePartHour // 小时 DatePartMinute // 分钟 DatePartSecond // 秒 DatePartMicrosecond // 微秒 )
Click to show internal directories.
Click to hide internal directories.