Documentation
¶
Overview ¶
* @Author: kamalyes 501893067@qq.com * @Date: 2025-11-23 00:00:00 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2025-11-23 00:00:00 * @FilePath: \go-sqlbuilder\constants\operators.go * @Description: 操作符常量定义 * * Copyright (c) 2025 by kamalyes, All Rights Reserved.
* @Author: kamalyes 501893067@qq.com * @Date: 2025-11-23 00:00:00 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2025-11-23 00:00:00 * @FilePath: \go-sqlbuilder\constants\pagination.go * @Description: 分页和批处理常量定义 * * Copyright (c) 2025 by kamalyes, All Rights Reserved.
* @Author: kamalyes 501893067@qq.com * @Date: 2025-11-23 00:00:00 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2025-11-23 00:00:00 * @FilePath: \go-sqlbuilder\constants\sort.go * @Description: 排序方向常量定义 * * Copyright (c) 2025 by kamalyes, All Rights Reserved.
* @Author: kamalyes 501893067@qq.com * @Date: 2025-11-23 00:00:00 * @LastEditors: kamalyes 501893067@qq.com * @LastEditTime: 2025-11-23 00:00:00 * @FilePath: \go-sqlbuilder\constants\sql_templates.go * @Description: SQL模板常量定义 * * Copyright (c) 2025 by kamalyes, All Rights Reserved.
Index ¶
Constants ¶
const ( OP_EQ = OpEqual OP_NEQ = OpNotEqual OP_GT = OpGreaterThan OP_GTE = OpGreaterThanOrEqual OP_LT = OpLessThan OP_LTE = OpLessThanOrEqual OP_LIKE = OpLike OP_NOT_LIKE = OpNotLike OP_IN = OpIn OP_NOT_IN = OpNotIn OP_BETWEEN = OpBetween OP_IS_NULL = OpIsNull OP_IS_NOT_NULL = OpIsNotNull OP_FIND_IN_SET = OpFindInSet LOGIC_AND = LogicAnd LOGIC_OR = LogicOr )
const ( // DefaultPage 默认页码 DefaultPage = 1 // DefaultPageSize 默认每页大小 DefaultPageSize = 10 )
const ( // Asc 升序 Asc = "ASC" // Desc 降序 Desc = "DESC" // DefaultOrder 默认排序方向 DefaultOrder = Asc )
const ( // SQL_EQUAL 等于条件模板 SQL_EQUAL = "%s = ?" // SQL_NOT_EQUAL 不等于条件模板 SQL_NOT_EQUAL = "%s != ?" // SQL_GREATER 大于条件模板 SQL_GREATER = "%s > ?" // SQL_GREATER_EQUAL 大于等于条件模板 SQL_GREATER_EQUAL = "%s >= ?" // SQL_LESS 小于条件模板 SQL_LESS = "%s < ?" // SQL_LESS_EQUAL 小于等于条件模板 SQL_LESS_EQUAL = "%s <= ?" // SQL_IN IN条件模板 SQL_IN = "%s IN ?" // SQL_NOT_IN NOT IN条件模板 SQL_NOT_IN = "%s NOT IN ?" // SQL_LIKE LIKE条件模板 SQL_LIKE = "%s LIKE ?" // SQL_NOT_LIKE NOT LIKE条件模板 SQL_NOT_LIKE = "%s NOT LIKE ?" // SQL_BETWEEN BETWEEN条件模板 SQL_BETWEEN = "%s BETWEEN ? AND ?" // SQL_IS_NULL IS NULL条件模板 SQL_IS_NULL = "%s IS NULL" // SQL_IS_NOT_NULL IS NOT NULL条件模板 SQL_IS_NOT_NULL = "%s IS NOT NULL" // SQL_FIND_IN_SET FIND_IN_SET条件模板 SQL_FIND_IN_SET = "FIND_IN_SET(?, %s)" // SQL_ORDER_BY 排序模板 SQL_ORDER_BY = "%s %s" // SQL_INCREMENT 字段自增模板 SQL_INCREMENT = "%s + ?" // SQL_DECREMENT 字段自减模板 SQL_DECREMENT = "%s - ?" )
const (
// DefaultBatchSize 默认批处理大小
DefaultBatchSize = 100
)
const (
// DefaultQueryTimeout 默认查询超时时间(秒)
DefaultQueryTimeout = 30
)
Variables ¶
var OperatorTemplateMap = map[Operator]string{ OP_EQ: SQL_EQUAL, OP_NEQ: SQL_NOT_EQUAL, OP_GT: SQL_GREATER, OP_GTE: SQL_GREATER_EQUAL, OP_LT: SQL_LESS, OP_LTE: SQL_LESS_EQUAL, OP_LIKE: SQL_LIKE, OP_NOT_LIKE: SQL_NOT_LIKE, OP_IN: SQL_IN, OP_NOT_IN: SQL_NOT_IN, OP_IS_NULL: SQL_IS_NULL, OP_IS_NOT_NULL: SQL_IS_NOT_NULL, OP_FIND_IN_SET: SQL_FIND_IN_SET, }
OperatorTemplateMap 操作符到SQL模板的映射
Functions ¶
This section is empty.