Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

squirrel

package

Go to main page

Versions in this module

v1

v1.3.0

Mar 29, 2021

v1.2.3

Jan 5, 2021

v1.2.2

Nov 3, 2020

v1.2.1

Sep 29, 2020

v1.2.0

Sep 22, 2020

v1.1.0

Feb 12, 2020

v1.0.0

Feb 10, 2020

Changes in this version

+ var Dollar = dollarFormat

+ 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 ExecWith(db Execer, s Sqlizer) (res sql.Result, err error)

+ func Expr(sql string, args ...interface{}) expr

+ func Placeholders(count int) string

+ 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

+ func NewStmtCacher(prep Preparer) DBProxy

+ type DBProxyBeginner interface

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

+ func NewStmtCacheProxy(db *sql.DB) DBProxyBeginner

+ type DeleteBuilder builder.Builder

+ func Delete(from string) DeleteBuilder

+ func (b DeleteBuilder) Exec() (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) 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 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) 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) QueryRow() RowScanner

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

+ func (b InsertBuilder) Scan(dest ...interface{}) error

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

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

+ type Queryer interface

+ Query func(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 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) 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) 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) QueryRow() RowScanner

+ 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) 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) 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) QueryRow() RowScanner

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

+ func (b UpdateBuilder) Scan(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