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_STARTS_WITH    = OpStartsWith
	OP_ENDS_WITH      = OpEndsWith
	OP_CONTAINS       = OpContains
	OP_IN             = OpIn
	OP_NOT_IN         = OpNotIn
	OP_BETWEEN        = OpBetween
	OP_NOT_BETWEEN    = OpNotBetween
	OP_IS_NULL        = OpIsNull
	OP_IS_NOT_NULL    = OpIsNotNull
	OP_FIND_IN_SET    = OpFindInSet
	OP_REGEX          = OpRegex
	OP_NOT_REGEX      = OpNotRegex
	OP_ILIKE          = OpILike
	OP_NOT_ILIKE      = OpNotILike
	OP_SIMILAR_TO     = OpSimilarTo
	OP_NOT_SIMILAR_TO = OpNotSimilarTo
	OP_ALL            = OpAll
	OP_ANY            = OpAny
	OP_SOME           = OpSome
	OP_EXISTS         = OpExists
	OP_NOT_EXISTS     = OpNotExists
	LOGIC_AND         = LogicAnd
	LOGIC_OR          = LogicOr
	LOGIC_NOT         = LogicNot
)

const (
	// 聚合函数
	FUNC_COUNT        = "COUNT"        // 计数
	FUNC_SUM          = "SUM"          // 求和
	FUNC_AVG          = "AVG"          // 平均值
	FUNC_MIN          = "MIN"          // 最小值
	FUNC_MAX          = "MAX"          // 最大值
	FUNC_GROUP_CONCAT = "GROUP_CONCAT" // MySQL 分组连接
	FUNC_STRING_AGG   = "STRING_AGG"   // PostgreSQL 字符串聚合

	// 窗口函数
	FUNC_ROW_NUMBER = "ROW_NUMBER" // 行号
	FUNC_RANK       = "RANK"       // 排名
	FUNC_DENSE_RANK = "DENSE_RANK" // 密集排名
	FUNC_LAG        = "LAG"        // 滞后
	FUNC_LEAD       = "LEAD"       // 超前
)

const (
	ORDER_ASC  = "ASC"  // 升序
	ORDER_DESC = "DESC" // 降序
)

const (
	JOIN_INNER = "INNER JOIN" // 内连接
	JOIN_LEFT  = "LEFT JOIN"  // 左连接
	JOIN_RIGHT = "RIGHT JOIN" // 右连接
	JOIN_FULL  = "FULL JOIN"  // 全外连接
	JOIN_CROSS = "CROSS JOIN" // 交叉连接
)

const (
	// DefaultPage 默认页码
	DefaultPage = 1

	// DefaultPageSize 默认每页大小
	DefaultPageSize = 20

	// MaxPageSize 最大每页大小
	MaxPageSize = 100

	// MinPageSize 最小每页大小
	MinPageSize = 1
)

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 - ?"

	// SQL通配符常量
	SQL_WILDCARD_ANY    = "%" // 匹配任意字符
	SQL_WILDCARD_SINGLE = "_" // 匹配单个字符
)

const (
	// DefaultBatchSize 默认批处理大小
	DefaultBatchSize = 100
)

const (
	// DefaultQueryTimeout 默认查询超时时间（秒）
	DefaultQueryTimeout = 30
)