squirrel

package module

Go to main page

Versions in this module

v1

v1.5.4

Mar 17, 2023

Changes in this version

type SelectBuilder

+ func (b SelectBuilder) RemoveColumns() SelectBuilder

type UpdateBuilder

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

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

v1.5.3

May 20, 2022

v1.5.2

Nov 12, 2021

v1.5.1

Oct 13, 2021

Changes in this version

type CaseBuilder

+ func (b CaseBuilder) MustSql() (string, []interface{})

type DeleteBuilder

+ func (b DeleteBuilder) MustSql() (string, []interface{})

type InsertBuilder

+ func (b InsertBuilder) MustSql() (string, []interface{})

type UpdateBuilder

+ func (b UpdateBuilder) MustSql() (string, []interface{})

v1.5.0

Nov 27, 2020

Changes in this version

type SelectBuilder

+ func (b SelectBuilder) CrossJoin(join string, rest ...interface{}) SelectBuilder

+ func (b SelectBuilder) InnerJoin(join string, rest ...interface{}) SelectBuilder

v1.4.0

May 9, 2020

Changes in this version

type StatementBuilderType

+ func (b StatementBuilderType) Where(pred interface{}, args ...interface{}) StatementBuilderType

v1.3.0

Apr 27, 2020

Changes in this version

+ var AtP = atpFormat

type DeleteBuilder

+ func (b DeleteBuilder) QueryContext(ctx context.Context) (*sql.Rows, error)

+ func (b DeleteBuilder) QueryRowContext(ctx context.Context) RowScanner

+ func (b DeleteBuilder) ScanContext(ctx context.Context, dest ...interface{}) error

v1.2.0

Jan 13, 2020

Changes in this version

+ func ConcatExpr(parts ...interface{}) concatExpr

type DeleteBuilder

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

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

+ type ILike Like

+ func (ilk ILike) ToSql() (sql string, args []interface{}, err error)

type InsertBuilder

+ func Replace(into string) InsertBuilder

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

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

+ type NotILike Like

+ func (nilk NotILike) ToSql() (sql string, args []interface{}, err error)

type Runner

+ func WrapStdSql(stdSql StdSql) Runner

+ type RunnerContext interface

+ func WrapStdSqlCtx(stdSqlCtx StdSqlCtx) RunnerContext

type SelectBuilder

+ func (b SelectBuilder) OrderByClause(pred interface{}, args ...interface{}) SelectBuilder

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

+ func (b SelectBuilder) RemoveOffset() SelectBuilder

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

type StatementBuilderType

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

+ 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 StmtCache struct

+ func NewStmtCache(prep PreparerContext) *StmtCache

+ func (sc *StmtCache) Clear() (err error)

+ func (sc *StmtCache) Exec(query string, args ...interface{}) (res sql.Result, err error)

+ func (sc *StmtCache) ExecContext(ctx context.Context, query string, args ...interface{}) (res sql.Result, err error)

+ func (sc *StmtCache) Prepare(query string) (*sql.Stmt, error)

+ func (sc *StmtCache) PrepareContext(ctx context.Context, query string) (*sql.Stmt, error)

+ func (sc *StmtCache) Query(query string, args ...interface{}) (rows *sql.Rows, err error)

+ func (sc *StmtCache) QueryContext(ctx context.Context, query string, args ...interface{}) (rows *sql.Rows, err error)

+ func (sc *StmtCache) QueryRow(query string, args ...interface{}) RowScanner

+ func (sc *StmtCache) QueryRowContext(ctx context.Context, query string, args ...interface{}) RowScanner

type UpdateBuilder

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

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

v1.1.0

Jan 7, 2019

Changes in this version

+ 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(Question)

+ func Alias(expr Sqlizer, alias string) aliasExpr

+ 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 Expr(sql string, args ...interface{}) expr

+ 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) ToSql() (string, []interface{}, error)

+ func (b CaseBuilder) When(when interface{}, then interface{}) CaseBuilder

+ type DBProxy interface

+ type DBProxyBeginner interface

+ Begin func() (*sql.Tx, error)

+ func NewStmtCacheProxy(db *sql.DB) DBProxyBeginner

+ type DBProxyContext interface

+ func NewStmtCacher(prep PreparerContext) DBProxyContext

+ 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) 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) Query() (*sql.Rows, error)

+ func (b DeleteBuilder) RunWith(runner BaseRunner) DeleteBuilder

+ func (b DeleteBuilder) Suffix(sql string, args ...interface{}) 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 InsertBuilder builder.Builder

+ func Insert(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) Options(options ...string) InsertBuilder

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

+ func (b InsertBuilder) Prefix(sql string, args ...interface{}) 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) 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 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 Preparer interface

+ Prepare func(query string) (*sql.Stmt, error)

+ type PreparerContext interface

+ PrepareContext func(ctx context.Context, query string) (*sql.Stmt, 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

+ 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) 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) 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) PlaceholderFormat(f PlaceholderFormat) SelectBuilder

+ func (b SelectBuilder) Prefix(sql string, args ...interface{}) 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) RemoveLimit() 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) ToSql() (string, []interface{}, error)

+ func (b SelectBuilder) Where(pred interface{}, args ...interface{}) SelectBuilder

+ type Sqlizer interface

+ ToSql func() (string, []interface{}, error)

+ 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) RunWith(runner BaseRunner) StatementBuilderType

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

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

+ 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) Limit(limit uint64) UpdateBuilder

+ 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) 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) Table(table string) UpdateBuilder

+ func (b UpdateBuilder) ToSql() (string, []interface{}, error)

+ func (b UpdateBuilder) Where(pred interface{}, args ...interface{}) UpdateBuilder

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL