squirrel

package module

Go to main page

Versions in this module

v1

v1.3.0

Nov 4, 2019

v1.2.5

Nov 4, 2019

v1.2.3

Nov 4, 2019

Changes in this version

+ type LikeLower map[string]interface

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

+ type LikeLowerPercentPrefix map[string]interface

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

+ type LikeLowerPercentPrefixSuffix map[string]interface

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

+ type LikeLowerPercentSuffix map[string]interface

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

+ type NotLikeLower LikeLower

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

+ type NotLikeLowerPercentPrefix LikeLowerPercentPrefix

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

+ type NotLikeLowerPercentPrefixSuffix LikeLowerPercentPrefixSuffix

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

+ type NotLikeLowerPercentSuffix LikeLowerPercentSuffix

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

v1.1.9

Nov 4, 2019

Changes in this version

type SelectBuilder

+ func (b SelectBuilder) HasWhereParts() (hasWhereParts bool)

v1.1.8

Nov 4, 2019

Changes in this version

type SelectBuilder

+ func (b SelectBuilder) CountAll(flag bool) SelectBuilder

+ func (b SelectBuilder) RemoveCountAll() SelectBuilder

v1.1.7

Oct 31, 2019

v1.1.6

Oct 31, 2019

v1.1.5

Oct 31, 2019

Changes in this version

+ func RemoveIndex(s []interface{}, index int) []interface

type SelectBuilder

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

v1.1.4

Oct 28, 2019

Changes in this version

type SelectBuilder

+ func (b SelectBuilder) Page(page uint64) SelectBuilder

+ func (b SelectBuilder) RemovePage() SelectBuilder

v1.1.3

Oct 28, 2019

v1.1.2

Oct 28, 2019

v1.1.1

Oct 28, 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 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 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 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) 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) LimitRowNum(limit uint64, page 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) 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) RemoveLimitRowNum() 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) 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) 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

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