Versions in this module Expand all Collapse all v1 v1.0.0 Jun 7, 2023 Changes in this version + var AtP = atpFormat + var Colon = colonFormat + var Dollar = dollarFormat + var NoContextSupport = errors.New("DB does not support Context") + var Question = questionFormat + var RunnerNotQueryRunner = fmt.Errorf("cannot QueryRow; Runner is not a QueryRower") + var RunnerNotSet = fmt.Errorf("cannot run; no Runner set (RunWith)") + var StatementBuilder = StatementBuilderType(builder.EmptyBuilder).PlaceholderFormat(Dollar) + func Alias(expr Sqlizer, alias string) aliasExpr + func ConcatExpr(parts ...interface{}) concatExpr + func DebugSqlizer(s Sqlizer) string + func ExecContextWith(ctx context.Context, db ExecerContext, s Sqlizer) (res sql.Result, err error) + func ExecWith(db Execer, s Sqlizer) (res sql.Result, err error) + func Placeholders(count int) string + func QueryContextWith(ctx context.Context, db QueryerContext, s Sqlizer) (rows *sql.Rows, err error) + func QueryWith(db Queryer, s Sqlizer) (rows *sql.Rows, err error) + type And conj + func (a And) ToSql() (string, []interface{}, error) + type BaseRunner interface + type CaseBuilder builder.Builder + func Case(what ...interface{}) CaseBuilder + func (b CaseBuilder) Else(expr interface{}) CaseBuilder + func (b CaseBuilder) MustSql() (string, []interface{}) + func (b CaseBuilder) ToSql() (string, []interface{}, error) + func (b CaseBuilder) When(when interface{}, then interface{}) CaseBuilder + type DeleteBuilder builder.Builder + func Delete(from string) DeleteBuilder + func (b DeleteBuilder) Exec() (sql.Result, error) + func (b DeleteBuilder) ExecContext(ctx context.Context) (sql.Result, error) + func (b DeleteBuilder) From(from string) DeleteBuilder + func (b DeleteBuilder) Limit(limit uint64) DeleteBuilder + func (b DeleteBuilder) MustSql() (string, []interface{}) + 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 ...interface{}) DeleteBuilder + func (b DeleteBuilder) PrefixExpr(expr Sqlizer) DeleteBuilder + func (b DeleteBuilder) Query() (*sql.Rows, error) + func (b DeleteBuilder) QueryContext(ctx context.Context) (*sql.Rows, error) + func (b DeleteBuilder) QueryRowContext(ctx context.Context) RowScanner + func (b DeleteBuilder) RunWith(runner BaseRunner) DeleteBuilder + func (b DeleteBuilder) ScanContext(ctx context.Context, dest ...interface{}) error + func (b DeleteBuilder) Suffix(sql string, args ...interface{}) DeleteBuilder + func (b DeleteBuilder) SuffixExpr(expr Sqlizer) DeleteBuilder + func (b DeleteBuilder) ToSql() (string, []interface{}, error) + func (b DeleteBuilder) Where(pred interface{}, args ...interface{}) DeleteBuilder + type Eq map[string]interface + func (eq Eq) ToSql() (sql string, args []interface{}, err error) + type Execer interface + Exec func(query string, args ...interface{}) (sql.Result, error) + type ExecerContext interface + ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error) + type Gt Lt + func (gt Gt) ToSql() (sql string, args []interface{}, err error) + type GtOrEq Lt + func (gtOrEq GtOrEq) ToSql() (sql string, args []interface{}, err error) + type ILike Like + func (ilk ILike) ToSql() (sql string, args []interface{}, 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) Exec() (sql.Result, error) + func (b InsertBuilder) ExecContext(ctx context.Context) (sql.Result, error) + func (b InsertBuilder) Into(from string) InsertBuilder + func (b InsertBuilder) MustSql() (string, []interface{}) + func (b InsertBuilder) Options(options ...string) InsertBuilder + func (b InsertBuilder) PlaceholderFormat(f PlaceholderFormat) InsertBuilder + func (b InsertBuilder) Prefix(sql string, args ...interface{}) InsertBuilder + func (b InsertBuilder) PrefixExpr(expr Sqlizer) InsertBuilder + func (b InsertBuilder) Query() (*sql.Rows, error) + func (b InsertBuilder) QueryContext(ctx context.Context) (*sql.Rows, error) + func (b InsertBuilder) QueryRow() RowScanner + func (b InsertBuilder) QueryRowContext(ctx context.Context) RowScanner + func (b InsertBuilder) RunWith(runner BaseRunner) InsertBuilder + func (b InsertBuilder) Scan(dest ...interface{}) error + func (b InsertBuilder) ScanContext(ctx context.Context, dest ...interface{}) error + func (b InsertBuilder) Select(sb SelectBuilder) InsertBuilder + func (b InsertBuilder) SetMap(clauses map[string]interface{}) InsertBuilder + func (b InsertBuilder) Suffix(sql string, args ...interface{}) InsertBuilder + func (b InsertBuilder) SuffixExpr(expr Sqlizer) InsertBuilder + func (b InsertBuilder) ToSql() (string, []interface{}, error) + func (b InsertBuilder) Values(values ...interface{}) InsertBuilder + type Like map[string]interface + func (lk Like) ToSql() (sql string, args []interface{}, err error) + type Lt map[string]interface + func (lt Lt) ToSql() (sql string, args []interface{}, err error) + type LtOrEq Lt + func (ltOrEq LtOrEq) ToSql() (sql string, args []interface{}, err error) + type NotEq Eq + func (neq NotEq) ToSql() (sql string, args []interface{}, err error) + type NotILike Like + func (nilk NotILike) ToSql() (sql string, args []interface{}, err error) + type NotLike Like + func (nlk NotLike) ToSql() (sql string, args []interface{}, err error) + type Or conj + func (o Or) ToSql() (string, []interface{}, error) + type PlaceholderFormat interface + ReplacePlaceholders func(sql string) (string, error) + type QueryRower interface + QueryRow func(query string, args ...interface{}) RowScanner + type QueryRowerContext interface + QueryRowContext func(ctx context.Context, query string, args ...interface{}) RowScanner + type Queryer interface + Query func(query string, args ...interface{}) (*sql.Rows, error) + type QueryerContext interface + QueryContext func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error) + type Row struct + func (r *Row) Scan(dest ...interface{}) error + type RowScanner interface + Scan func(...interface{}) error + func QueryRowContextWith(ctx context.Context, db QueryRowerContext, s Sqlizer) RowScanner + func QueryRowWith(db QueryRower, s Sqlizer) RowScanner + type Runner interface + func WrapStdSql(stdSql StdSql) Runner + type RunnerContext interface + func WrapStdSqlCtx(stdSqlCtx StdSqlCtx) RunnerContext + type SelectBuilder builder.Builder + func Select(columns ...string) SelectBuilder + func (b SelectBuilder) Column(column interface{}, args ...interface{}) SelectBuilder + func (b SelectBuilder) Columns(columns ...string) SelectBuilder + func (b SelectBuilder) CrossJoin(join string, rest ...interface{}) SelectBuilder + func (b SelectBuilder) Distinct() SelectBuilder + func (b SelectBuilder) Exec() (sql.Result, error) + func (b SelectBuilder) ExecContext(ctx context.Context) (sql.Result, error) + 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 interface{}, rest ...interface{}) SelectBuilder + func (b SelectBuilder) InnerJoin(join string, rest ...interface{}) SelectBuilder + func (b SelectBuilder) Join(join string, rest ...interface{}) SelectBuilder + func (b SelectBuilder) JoinClause(pred interface{}, args ...interface{}) SelectBuilder + func (b SelectBuilder) LeftJoin(join string, rest ...interface{}) SelectBuilder + func (b SelectBuilder) Limit(limit uint64) SelectBuilder + func (b SelectBuilder) MustSql() (string, []interface{}) + 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 interface{}, args ...interface{}) SelectBuilder + func (b SelectBuilder) PlaceholderFormat(f PlaceholderFormat) SelectBuilder + func (b SelectBuilder) Prefix(sql string, args ...interface{}) SelectBuilder + func (b SelectBuilder) PrefixExpr(expr Sqlizer) SelectBuilder + func (b SelectBuilder) Query() (*sql.Rows, error) + func (b SelectBuilder) QueryContext(ctx context.Context) (*sql.Rows, error) + func (b SelectBuilder) QueryRow() RowScanner + func (b SelectBuilder) QueryRowContext(ctx context.Context) RowScanner + func (b SelectBuilder) RemoveColumns() SelectBuilder + func (b SelectBuilder) RemoveLimit() SelectBuilder + func (b SelectBuilder) RemoveOffset() SelectBuilder + func (b SelectBuilder) RightJoin(join string, rest ...interface{}) SelectBuilder + func (b SelectBuilder) RunWith(runner BaseRunner) SelectBuilder + func (b SelectBuilder) Scan(dest ...interface{}) error + func (b SelectBuilder) ScanContext(ctx context.Context, dest ...interface{}) error + func (b SelectBuilder) Suffix(sql string, args ...interface{}) SelectBuilder + func (b SelectBuilder) SuffixExpr(expr Sqlizer) SelectBuilder + func (b SelectBuilder) ToSql() (string, []interface{}, error) + func (b SelectBuilder) Where(pred interface{}, args ...interface{}) SelectBuilder + type Sqlizer interface + ToSql func() (string, []interface{}, error) + func Expr(sql string, args ...interface{}) 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) RunWith(runner BaseRunner) StatementBuilderType + func (b StatementBuilderType) Select(columns ...string) SelectBuilder + func (b StatementBuilderType) Update(table string) UpdateBuilder + func (b StatementBuilderType) Where(pred interface{}, args ...interface{}) StatementBuilderType + type StdSql interface + Exec func(string, ...interface{}) (sql.Result, error) + Query func(string, ...interface{}) (*sql.Rows, error) + QueryRow func(string, ...interface{}) *sql.Row + type StdSqlCtx interface + ExecContext func(context.Context, string, ...interface{}) (sql.Result, error) + QueryContext func(context.Context, string, ...interface{}) (*sql.Rows, error) + QueryRowContext func(context.Context, string, ...interface{}) *sql.Row + type UpdateBuilder builder.Builder + func Update(table string) UpdateBuilder + func (b UpdateBuilder) Exec() (sql.Result, error) + func (b UpdateBuilder) ExecContext(ctx context.Context) (sql.Result, error) + 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, []interface{}) + 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 ...interface{}) UpdateBuilder + func (b UpdateBuilder) PrefixExpr(expr Sqlizer) UpdateBuilder + func (b UpdateBuilder) Query() (*sql.Rows, error) + func (b UpdateBuilder) QueryContext(ctx context.Context) (*sql.Rows, error) + func (b UpdateBuilder) QueryRow() RowScanner + func (b UpdateBuilder) QueryRowContext(ctx context.Context) RowScanner + func (b UpdateBuilder) RunWith(runner BaseRunner) UpdateBuilder + func (b UpdateBuilder) Scan(dest ...interface{}) error + func (b UpdateBuilder) ScanContext(ctx context.Context, dest ...interface{}) error + func (b UpdateBuilder) Set(column string, value interface{}) UpdateBuilder + func (b UpdateBuilder) SetMap(clauses map[string]interface{}) UpdateBuilder + func (b UpdateBuilder) Suffix(sql string, args ...interface{}) UpdateBuilder + func (b UpdateBuilder) SuffixExpr(expr Sqlizer) UpdateBuilder + func (b UpdateBuilder) Table(table string) UpdateBuilder + func (b UpdateBuilder) ToSql() (string, []interface{}, error) + func (b UpdateBuilder) Where(pred interface{}, args ...interface{}) UpdateBuilder
Go to main page