squirrel

May 7, 2024

Changes in this version

type Sqlizer

+ func Coalesce(nullValue any, exprs ...Sqlizer) Sqlizer

Apr 18, 2024

Changes in this version

+ type OrderByCondOption struct

+ ColumnID int

+ NullsType OrderNullsType

+ type OrderNullsType int

+ const OrderNullsFirst

+ const OrderNullsLast

+ const OrderNullsUndefined

+ func (o OrderNullsType) String() string

Apr 18, 2024

Changes in this version

+ func Equal(e Sqlizer, v any) equalExpr

+ func Greater(e Sqlizer, v any) greaterExpr

+ func GreaterOrEqual(e Sqlizer, v any) greaterOrEqualExpr

+ func Less(e Sqlizer, v any) lessExpr

+ func LessOrEqual(e Sqlizer, v any) lessOrEqualExpr

+ func NotEqual(e Sqlizer, v any) notEqualExpr

Apr 17, 2024

Changes in this version

type SelectBuilder

+ func (b SelectBuilder) With(cteName string, cte SelectBuilder) SelectBuilder

Mar 30, 2024

Changes in this version

+ func Cte(e Sqlizer, cte string) cteExpr

+ type CommonTableExpressionsBuilder builder.Builder

+ func With(cte string) CommonTableExpressionsBuilder

+ func WithRecursive(cte string) CommonTableExpressionsBuilder

+ func (b CommonTableExpressionsBuilder) As(as SelectBuilder) CommonTableExpressionsBuilder

+ func (b CommonTableExpressionsBuilder) Cte(cte string) CommonTableExpressionsBuilder

+ func (b CommonTableExpressionsBuilder) Delete(statement DeleteBuilder) CommonTableExpressionsBuilder

+ func (b CommonTableExpressionsBuilder) Insert(statement InsertBuilder) CommonTableExpressionsBuilder

+ func (b CommonTableExpressionsBuilder) MustSql() (string, []any)

+ func (b CommonTableExpressionsBuilder) PlaceholderFormat(f PlaceholderFormat) CommonTableExpressionsBuilder

+ func (b CommonTableExpressionsBuilder) Recursive(recursive bool) CommonTableExpressionsBuilder

+ func (b CommonTableExpressionsBuilder) Replace(statement InsertBuilder) CommonTableExpressionsBuilder

+ func (b CommonTableExpressionsBuilder) Select(statement SelectBuilder) CommonTableExpressionsBuilder

+ func (b CommonTableExpressionsBuilder) ToSql() (string, []any, error)

+ func (b CommonTableExpressionsBuilder) Update(statement UpdateBuilder) CommonTableExpressionsBuilder

type Sqlizer

+ func Not(e Sqlizer) Sqlizer

type StatementBuilderType

+ func (b StatementBuilderType) With(cte string) CommonTableExpressionsBuilder

Mar 13, 2024

Changes in this version

type SelectBuilder

+ func (b SelectBuilder) Alias(table string, prefix ...string) alias

Mar 12, 2024

Changes in this version

type Paginator

+ func (p Paginator) LastID() int64

+ func (p Paginator) Limit() uint64

+ func (p Paginator) PageNumber() uint64

+ func (p Paginator) PageSize() uint64

+ func (p Paginator) Type() PaginatorType

+ type PaginatorType int

+ const PaginatorTypeByID

+ const PaginatorTypeByPage

+ const PaginatorTypeUndefined

Mar 4, 2024

Changes in this version

+ type Direction int

+ const Asc

+ const Desc

+ func (d Direction) String() string

+ type OrderCond struct

+ ColumnID int

+ Direction Direction

+ type Paginator struct

+ func PaginatorByID(limit uint64, lastID int64) Paginator

+ func PaginatorByPage(limit, page uint64) Paginator

type SelectBuilder

+ func (b SelectBuilder) OrderByCond(columns map[int]string, conds []OrderCond) SelectBuilder

+ func (b SelectBuilder) Paginate(p Paginator) SelectBuilder

+ func (b SelectBuilder) PaginateByID(limit uint64, startID int64, columnID string) SelectBuilder

+ func (b SelectBuilder) PaginateByPage(limit uint64, page uint64) SelectBuilder

+ func (b SelectBuilder) Search(value any, columns ...string) SelectBuilder

+ func (b SelectBuilder) SetIDColumn(column string) SelectBuilder

Mar 3, 2024

Changes in this version

+ func Range(column string, start, end any) rangeExpr

+ type EqNotEmpty map[string]any

+ func (eq EqNotEmpty) ToSql() (sql string, args []any, err error)

Mar 1, 2024

Changes in this version

+ func Avg(e Sqlizer) avgExpr

+ func Count(e Sqlizer) countExpr

+ func Exists(e Sqlizer) existsExpr

+ func In(e any) inExpr

+ func Max(e Sqlizer) maxExpr

+ func Min(e Sqlizer) minExpr

+ func NotExists(e Sqlizer) notExistsExpr

+ func NotIn(e Sqlizer) notInExpr

+ func Sum(e Sqlizer) sumExpr

Feb 15, 2024

Changes in this version

+ var AtP = atpFormat

+ var Colon = colonFormat

+ var Dollar = dollarFormat

+ var Question = questionFormat

+ var StatementBuilder = StatementBuilderType(builder.EmptyBuilder).PlaceholderFormat(Question)

+ func Alias(e Sqlizer, alias string) aliasExpr

+ func ConcatExpr(parts ...any) concatExpr

+ func DebugSqlizer(s Sqlizer) string

+ func Placeholders(count int) string

+ type And conj

+ func (a And) ToSql() (string, []any, error)

+ type CaseBuilder builder.Builder

+ func Case(what ...any) CaseBuilder

+ func (b CaseBuilder) Else(e any) CaseBuilder

+ func (b CaseBuilder) MustSql() (string, []any)

+ func (b CaseBuilder) ToSql() (string, []any, error)

+ func (b CaseBuilder) When(when any, then any) CaseBuilder

+ type DeleteBuilder builder.Builder

+ func Delete(from string) DeleteBuilder

+ func (b DeleteBuilder) From(from string) DeleteBuilder

+ func (b DeleteBuilder) Limit(limit uint64) DeleteBuilder

+ func (b DeleteBuilder) MustSql() (string, []any)

+ func (b DeleteBuilder) Offset(offset uint64) DeleteBuilder

+ func (b DeleteBuilder) OrderBy(orderBys ...string) DeleteBuilder

+ func (b DeleteBuilder) PlaceholderFormat(f PlaceholderFormat) DeleteBuilder

+ func (b DeleteBuilder) Prefix(sql string, args ...any) DeleteBuilder

+ func (b DeleteBuilder) PrefixExpr(e Sqlizer) DeleteBuilder

+ func (b DeleteBuilder) Suffix(sql string, args ...any) DeleteBuilder

+ func (b DeleteBuilder) SuffixExpr(e Sqlizer) DeleteBuilder

+ func (b DeleteBuilder) ToSql() (string, []any, error)

+ func (b DeleteBuilder) Where(pred any, args ...any) DeleteBuilder

+ type Eq map[string]any

+ func (eq Eq) ToSql() (sql string, args []any, err error)

+ type Gt Lt

+ func (gt Gt) ToSql() (sql string, args []any, err error)

+ type GtOrEq Lt

+ func (gtOrEq GtOrEq) ToSql() (sql string, args []any, err error)

+ type ILike Like

+ func (ilk ILike) ToSql() (sql string, args []any, err error)

+ type InsertBuilder builder.Builder

+ func Insert(into string) InsertBuilder

+ func Replace(into string) InsertBuilder

+ func (b InsertBuilder) Columns(columns ...string) InsertBuilder

+ func (b InsertBuilder) Into(from string) InsertBuilder

+ func (b InsertBuilder) MustSql() (string, []any)

+ func (b InsertBuilder) Options(options ...string) InsertBuilder

+ func (b InsertBuilder) PlaceholderFormat(f PlaceholderFormat) InsertBuilder

+ func (b InsertBuilder) Prefix(sql string, args ...any) InsertBuilder

+ func (b InsertBuilder) PrefixExpr(e Sqlizer) InsertBuilder

+ func (b InsertBuilder) Select(sb SelectBuilder) InsertBuilder

+ func (b InsertBuilder) SetMap(clauses map[string]any) InsertBuilder

+ func (b InsertBuilder) Suffix(sql string, args ...any) InsertBuilder

+ func (b InsertBuilder) SuffixExpr(e Sqlizer) InsertBuilder

+ func (b InsertBuilder) ToSql() (string, []any, error)

+ func (b InsertBuilder) Values(values ...any) InsertBuilder

+ type Like map[string]any

+ func (lk Like) ToSql() (sql string, args []any, err error)

+ type Lt map[string]any

+ func (lt Lt) ToSql() (sql string, args []any, err error)

+ type LtOrEq Lt

+ func (ltOrEq LtOrEq) ToSql() (sql string, args []any, err error)

+ type NotEq Eq

+ func (neq NotEq) ToSql() (sql string, args []any, err error)

+ type NotILike Like

+ func (nilk NotILike) ToSql() (sql string, args []any, err error)

+ type NotLike Like

+ func (nlk NotLike) ToSql() (sql string, args []any, err error)

+ type Or conj

+ func (o Or) ToSql() (string, []any, error)

+ type PlaceholderFormat interface

+ ReplacePlaceholders func(sql string) (string, error)

+ type Row struct

+ func (r *Row) Scan(dest ...any) error

+ type RowScanner interface

+ Scan func(...any) error

+ type SelectBuilder builder.Builder

+ func Select(columns ...string) SelectBuilder

+ func (b SelectBuilder) Column(column any, args ...any) SelectBuilder

+ func (b SelectBuilder) Columns(columns ...string) SelectBuilder

+ func (b SelectBuilder) CrossJoin(join string, rest ...any) SelectBuilder

+ func (b SelectBuilder) Distinct() SelectBuilder

+ func (b SelectBuilder) From(from string) SelectBuilder

+ func (b SelectBuilder) FromSelect(from SelectBuilder, alias string) SelectBuilder

+ func (b SelectBuilder) GroupBy(groupBys ...string) SelectBuilder

+ func (b SelectBuilder) Having(pred any, rest ...any) SelectBuilder

+ func (b SelectBuilder) InnerJoin(join string, rest ...any) SelectBuilder

+ func (b SelectBuilder) Join(join string, rest ...any) SelectBuilder

+ func (b SelectBuilder) JoinClause(pred any, args ...any) SelectBuilder

+ func (b SelectBuilder) LeftJoin(join string, rest ...any) SelectBuilder

+ func (b SelectBuilder) Limit(limit uint64) SelectBuilder

+ func (b SelectBuilder) MustSql() (string, []any)

+ func (b SelectBuilder) Offset(offset uint64) SelectBuilder

+ func (b SelectBuilder) Options(options ...string) SelectBuilder

+ func (b SelectBuilder) OrderBy(orderBys ...string) SelectBuilder

+ func (b SelectBuilder) OrderByClause(pred any, args ...any) SelectBuilder

+ func (b SelectBuilder) PlaceholderFormat(f PlaceholderFormat) SelectBuilder

+ func (b SelectBuilder) Prefix(sql string, args ...any) SelectBuilder

+ func (b SelectBuilder) PrefixExpr(e Sqlizer) SelectBuilder

+ func (b SelectBuilder) RemoveColumns() SelectBuilder

+ func (b SelectBuilder) RemoveLimit() SelectBuilder

+ func (b SelectBuilder) RemoveOffset() SelectBuilder

+ func (b SelectBuilder) RightJoin(join string, rest ...any) SelectBuilder

+ func (b SelectBuilder) Suffix(sql string, args ...any) SelectBuilder

+ func (b SelectBuilder) SuffixExpr(e Sqlizer) SelectBuilder

+ func (b SelectBuilder) ToSql() (string, []any, error)

+ func (b SelectBuilder) Where(pred any, args ...any) SelectBuilder

+ type Sqlizer interface

+ ToSql func() (string, []any, error)

+ func Expr(sql string, args ...any) Sqlizer

+ type StatementBuilderType builder.Builder

+ func (b StatementBuilderType) Delete(from string) DeleteBuilder

+ func (b StatementBuilderType) Insert(into string) InsertBuilder

+ func (b StatementBuilderType) PlaceholderFormat(f PlaceholderFormat) StatementBuilderType

+ func (b StatementBuilderType) Replace(into string) InsertBuilder

+ func (b StatementBuilderType) Select(columns ...string) SelectBuilder

+ func (b StatementBuilderType) Update(table string) UpdateBuilder

+ func (b StatementBuilderType) Where(pred any, args ...any) StatementBuilderType

+ type UpdateBuilder builder.Builder

+ func Update(table string) UpdateBuilder

+ func (b UpdateBuilder) From(from string) UpdateBuilder

+ func (b UpdateBuilder) FromSelect(from SelectBuilder, alias string) UpdateBuilder

+ func (b UpdateBuilder) Limit(limit uint64) UpdateBuilder

+ func (b UpdateBuilder) MustSql() (string, []any)

+ func (b UpdateBuilder) Offset(offset uint64) UpdateBuilder

+ func (b UpdateBuilder) OrderBy(orderBys ...string) UpdateBuilder

+ func (b UpdateBuilder) PlaceholderFormat(f PlaceholderFormat) UpdateBuilder

+ func (b UpdateBuilder) Prefix(sql string, args ...any) UpdateBuilder

+ func (b UpdateBuilder) PrefixExpr(e Sqlizer) UpdateBuilder

+ func (b UpdateBuilder) Set(column string, value any) UpdateBuilder

+ func (b UpdateBuilder) SetMap(clauses map[string]any) UpdateBuilder

+ func (b UpdateBuilder) Suffix(sql string, args ...any) UpdateBuilder

+ func (b UpdateBuilder) SuffixExpr(e Sqlizer) UpdateBuilder

+ func (b UpdateBuilder) Table(table string) UpdateBuilder

+ func (b UpdateBuilder) ToSql() (string, []any, error)

+ func (b UpdateBuilder) Where(pred any, args ...any) UpdateBuilder