sql

Dec 21, 2025

Changes in this version

type List

+ Pagination Pagination

+ Sort Sorts

+ type SortExpr struct

+ Sql string

+ Var any

+ WithoutParenthesis bool

+ type Sorts []Sort

Dec 17, 2025

Changes in this version

+ func AnyToAnys(a any) []any

+ type Cursor struct

+ Field string

+ Prev T

+ Size int

+ type FilterExprMap map[string]FilterExpr

+ type Id struct

+ Id uint64

+ type List struct

+ Filters FilterExprs

+ type Ordered interface

+ type Pageable interface

+ PageNo func() uint32

+ PageSize func() uint32

+ Sort func() []Sort

+ type Pagination struct

+ No uint32

+ Size uint32

+ Sort []Sort

+ type PaginationEmbedded struct

+ PageNo uint32

+ PageSize uint32

+ Sort []Sort

+ type Range struct

+ Begin T

+ End T

+ Field string

+ Type RangeMode

+ type RangeMode int8

+ const RangeModeContainsBegin

+ const RangeModeContainsEnd

+ const RangeModeHasBegin

+ const RangeModeHasEnd

+ func (r RangeMode) ContainsBegin() bool

+ func (r RangeMode) ContainsEnd() bool

+ func (r RangeMode) HasBegin() bool

+ func (r RangeMode) HasEnd() bool

+ type Sort struct

+ Field string

+ Type SortType

+ type SortType uint8

+ const SortTypeAsc

+ const SortTypeDesc

Dec 14, 2025

Changes in this version

type ConditionOperation

+ const NotLike

type ConditionTag

+ Operate string

+ func GetConditionTagTag(tag reflect.StructTag) (*ConditionTag, error)

Nov 3, 2025

Changes in this version

+ const ColumnDeletedAt

+ const ColumnId

+ const ColumnName

+ const CondiTagName

+ const Delete

+ const ExprEqual

+ const ExprGreater

+ const ExprNotEqual

+ const IdEqual

+ const InnerJoin

+ const Insert

+ const LeftJoin

+ const Limit

+ const Limit1

+ const Mysql

+ const NameEqual

+ const NotDeleted

+ const NullStr

+ const Offset

+ const Postgres

+ const RightJoin

+ const Select

+ const Sqlite

+ const TmFmtWithMS

+ const Update

+ const WithNotDeleted

+ func ConvertParams(v interface{}, escaper string) string

+ func DeleteByIdSQL(tableName string) string

+ func DeleteSQL(tableName, column string) string

+ func ExistsByFilterExprs(db *sql.DB, tableName string, filters FilterExprs) (bool, error)

+ func ExistsByFilterExprsSQL(tableName string, filters FilterExprs) string

+ func ExistsByQuerySQL(qsql string) string

+ func ExistsSQL(tableName, column string, withDeletedAt bool) string

+ func StringConvertFor[T any](str string) (T, error)

+ func TableName(name string, id uint64) string

+ type ConditionOperation int

+ const Between

+ const Equal

+ const Greater

+ const GreaterOrEqual

+ const In

+ const IsNotNull

+ const IsNull

+ const Less

+ const LessOrEqual

+ const Like

+ const NotEqual

+ const NotIn

+ const OperationPlace

+ func ParseConditionOperation(op string) ConditionOperation

+ func (m ConditionOperation) SQL() string

+ func (m ConditionOperation) String() string

+ type ConditionTag struct

+ Column string

+ EmptyValid bool

+ Expr string

+ Op string

+ func GetSQLCondition(tag reflect.StructTag) (*ConditionTag, error)

+ type Config struct

+ Charset string

+ Database string

+ Host string

+ MaxIdleConns int

+ MaxOpenConns int

+ Password string

+ Port int32

+ TimeFormat string

+ TimeZone string

+ Type string

+ User string

+ type FilterExpr struct

+ Field string

+ Operation ConditionOperation

+ Value []any

+ func (filter *FilterExpr) Build() string

+ type FilterExprs []FilterExpr

+ func (f FilterExprs) Build() string

+ func (f FilterExprs) BuildSQL() (string, []interface{})