sqld

Jan 9, 2025

Changes in this version

type PrinterFn

+ func PgILike(target string) PrinterFn

Oct 24, 2024

Changes in this version

+ func Cond(op Op, filters ...string) string

+ func FmtContains[S string | *string](val S) S

+ func FmtEndsWith[S string | *string](val S) S

+ func FmtStartsWith[S string | *string](val S) S

+ func IfNotZero[T comparable](val T, params *Params, printer PrinterFn) string

+ func Section(sect Sect, cond string) string

+ type Op string

+ type Params map[string]any

+ type PredicateFn func(T) bool

+ type PrinterFn func(string) string

+ func Gt(target string) PrinterFn

+ func Gte(target string) PrinterFn

+ func ILike(target string) PrinterFn

+ func Like(target string) PrinterFn

+ func Lt(target string) PrinterFn

+ func Lte(target string) PrinterFn

+ type Sect string

+ const HAVING

+ const WHERE

+ type Sorting string

Feb 22, 2024

Changes in this version

type SqldFn

+ func Coalesce(op SqldFn, fallback string) SqldFn

Feb 22, 2024

Changes in this version

type SqldFn

+ func GroupBy(ops ...SqldFn) SqldFn

Feb 16, 2024

Changes in this version

type SqldFn

+ func PgPrepareOp(op SqldFn) SqldFn

Feb 16, 2024

Changes in this version

+ func PgPrepare(query string, args []driver.Value) string

Feb 2, 2024

Changes in this version

type SqldFn

+ func IfStringEmpty(val string, op SqldFn) SqldFn

+ func IfStringEmptyElse(val string, trueFn, falseFn SqldFn) SqldFn

+ func IfStringNotEmpty(val string, op SqldFn) SqldFn

+ func IfStringNotEmptyElse(val string, trueFn, falseFn SqldFn) SqldFn

Feb 1, 2024

Changes in this version

type SqldFn

+ func Sort(order SortingOrder, columnExpr *string) SqldFn

Feb 1, 2024

Changes in this version

+ type Condition string

+ const AND

+ const OR

+ type SortingOrder string

+ const ASC

+ const DESC

Jan 31, 2024

Changes in this version

type SqldFn

+ func AllWildcard() SqldFn

+ func Count(op SqldFn) SqldFn

Jan 29, 2024

Changes in this version

type SqldFn

+ func Limit(count *int) SqldFn

+ func Offset(skip *int) SqldFn

+ func SubQuery(op SqldFn, aliasName string) SqldFn

Jan 25, 2024

Changes in this version

+ func TableColumnErr[M Model](column string) (string, error)

+ func TableColumn[M Model](column string) string

+ func TableColumns[M Model]() []string

type SqldFn

+ func Just(s string) SqldFn

Jan 19, 2024

Changes in this version

type SqldFn

+ func As(op SqldFn, aliasName string) SqldFn

+ func TableNameOp[M Model]() SqldFn

Jan 18, 2024

Changes in this version

type SqldFn

+ func LeftJoin(tableName string, op SqldFn) SqldFn

+ func RightJoin(tableName string, op SqldFn) SqldFn

Jan 18, 2024

Changes in this version

+ func ColumnErr[M Model](column string) (string, error)

type SqldFn

+ func ColumnEq(firstColumn string, secondColumn string) SqldFn

Jan 18, 2024

Changes in this version

+ const CROSS_JOIN

+ const CROSS_OUTER_JOIN

+ const FULL_JOIN

+ const FULL_OUTER_JOIN

+ const INNER_JOIN

+ const INNER_OUTER_JOIN

+ const LEFT_JOIN

+ const LEFT_OUTER_JOIN

+ const RIGHT_JOIN

+ const RIGHT_OUTER_JOIN

+ func Columns[M Model]() []string

+ func TableName[M Model]() string

+ type JoinType string

+ type Model interface

+ TableName func() string

type SqldFn

+ func Column[M Model](column string) SqldFn

+ func From(tableName string) SqldFn

+ func Join(joinType JoinType, tableName string, op SqldFn) SqldFn

+ func JoinEq(firstColumn string, secondColumn string) SqldFn

Jan 18, 2024

Changes in this version

+ var ErrNoColumns = errors.New("no columns in select statement")

type SqldFn

+ func Select(columns ...string) SqldFn

Jan 12, 2024

Changes in this version

+ var ErrArgNotSlice = errors.New("argument is not a slice")

+ var ErrEmptySlice = errors.New("slice is empty")

+ var ErrNilColumnExpr = errors.New("column expression is nil")

+ var ErrNilVal = errors.New("value is nil")

+ var ErrNoOps = errors.New("operations slice is empty")

+ func NoOp() (string, []driver.Value, error)

+ type SqldFn func() (string, []driver.Value, error)

+ func And(ops ...SqldFn) SqldFn

+ func Asc(columnExpr *string) SqldFn

+ func Block(block string) SqldFn

+ func Desc(columnExpr *string) SqldFn

+ func Eq[T driver.Value](columnExpr string, val *T) SqldFn

+ func Having(ops ...SqldFn) SqldFn

+ func If(pred func() bool, op SqldFn) SqldFn

+ func IfElse(pred func() bool, trueFn SqldFn, falseFn SqldFn) SqldFn

+ func IfEmptyElse[T driver.Value](vals []T, trueFn SqldFn, falseFn SqldFn) SqldFn

+ func IfEmpty[T driver.Value](vals []T, op SqldFn) SqldFn

+ func IfNilElse[T driver.Value](val *T, trueFn SqldFn, falseFn SqldFn) SqldFn

+ func IfNil[T driver.Value](val *T, op SqldFn) SqldFn

+ func IfNotEmptyElse[T driver.Value](vals []T, trueFn SqldFn, falseFn SqldFn) SqldFn

+ func IfNotEmpty[T driver.Value](vals []T, op SqldFn) SqldFn

+ func IfNotNilElse[T driver.Value](val *T, trueFn SqldFn, falseFn SqldFn) SqldFn

+ func IfNotNil[T driver.Value](val *T, op SqldFn) SqldFn

+ func In[T driver.Value](columnExpr string, vals []T) SqldFn

+ func New(ops ...SqldFn) SqldFn

+ func Not(op SqldFn) SqldFn

+ func Null(columnExpr string) SqldFn

+ func Or(ops ...SqldFn) SqldFn

+ func OrderBy(ops ...SqldFn) SqldFn

+ func Where(ops ...SqldFn) SqldFn