dbs

Nov 6, 2023

Changes in this version

+ var ErrStmtExists = errors.New("statement exists")

+ func Exec(ctx context.Context, session Session, query string, args ...interface{}) (result sql.Result, err error)

+ func Query(ctx context.Context, session Session, query string, args ...interface{}) (dst T, err error)

type DB

+ func (db *DB) PrepareStatement(ctx context.Context, key, query string) error

+ func (db *DB) Statement(ctx context.Context, query string) (*sql.Stmt, error)

type InsertBuilder

+ func (ib *InsertBuilder) Returning(columns ...string) *InsertBuilder

+ func (ib *InsertBuilder) Scan(s Session, dst interface{}) (err error)

+ func (ib *InsertBuilder) ScanContext(ctx context.Context, s Session, dst interface{}) (err error)

+ func (ib *InsertBuilder) ScanRow(s Session, dst ...interface{}) (err error)

+ func (ib *InsertBuilder) ScanRowContext(ctx context.Context, s Session, dst ...interface{}) (err error)

type Mapper

+ func (mapper *Mapper) Decode(rows *sql.Rows, dst interface{}) error

type Preparer

+ Statement func(ctx context.Context, query string) (*sql.Stmt, error)

type Tx

+ func (tx *Tx) Statement(ctx context.Context, query string) (*sql.Stmt, error)

Oct 17, 2023

Changes in this version

+ type Clause struct

+ func NewClause(sql interface{}, args ...interface{}) *Clause

+ func (clause *Clause) SQL() (string, []interface{}, error)

+ func (clause *Clause) Write(w Writer) error

+ type Clauses []SQLClause

+ func (clauses Clauses) SQL() (string, []interface{}, error)

+ func (clauses Clauses) Write(w Writer, sep string) error

+ type ExceptBuilder struct

+ func NewExceptBuilder() *ExceptBuilder

+ func (b *ExceptBuilder) GetPlaceholder() Placeholder

+ func (eb *ExceptBuilder) Except(clauses ...SQLClause) *ExceptBuilder

+ func (eb *ExceptBuilder) ExceptAll(clauses ...SQLClause) *ExceptBuilder

+ func (eb *ExceptBuilder) Limit(limit int64) *ExceptBuilder

+ func (eb *ExceptBuilder) Offset(offset int64) *ExceptBuilder

+ func (eb *ExceptBuilder) OrderBy(sql ...string) *ExceptBuilder

+ func (eb *ExceptBuilder) SQL() (string, []interface{}, error)

+ func (eb *ExceptBuilder) Type() string

+ func (eb *ExceptBuilder) UsePlaceholder(p Placeholder) *ExceptBuilder

+ func (eb *ExceptBuilder) Write(w Writer) (err error)

+ type IntersectBuilder struct

+ func NewIntersectBuilder() *IntersectBuilder

+ func (b *IntersectBuilder) GetPlaceholder() Placeholder

+ func (ib *IntersectBuilder) Intersect(clauses ...SQLClause) *IntersectBuilder

+ func (ib *IntersectBuilder) IntersectAll(clauses ...SQLClause) *IntersectBuilder

+ func (ib *IntersectBuilder) Limit(limit int64) *IntersectBuilder

+ func (ib *IntersectBuilder) Offset(offset int64) *IntersectBuilder

+ func (ib *IntersectBuilder) OrderBy(sql ...string) *IntersectBuilder

+ func (ib *IntersectBuilder) SQL() (string, []interface{}, error)

+ func (ib *IntersectBuilder) Type() string

+ func (ib *IntersectBuilder) UsePlaceholder(p Placeholder) *IntersectBuilder

+ func (ib *IntersectBuilder) Write(w Writer) (err error)

+ type SQLClause interface

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

+ Write func(w Writer) error

type SelectBuilder

+ func (sb *SelectBuilder) FromClause(clause SQLClause) *SelectBuilder

+ type UnionBuilder struct

+ func NewUnionBuilder() *UnionBuilder

+ func (b *UnionBuilder) GetPlaceholder() Placeholder

+ func (ub *UnionBuilder) Limit(limit int64) *UnionBuilder

+ func (ub *UnionBuilder) Offset(offset int64) *UnionBuilder

+ func (ub *UnionBuilder) OrderBy(sql ...string) *UnionBuilder

+ func (ub *UnionBuilder) SQL() (string, []interface{}, error)

+ func (ub *UnionBuilder) Type() string

+ func (ub *UnionBuilder) Union(clauses ...SQLClause) *UnionBuilder

+ func (ub *UnionBuilder) UnionAll(clauses ...SQLClause) *UnionBuilder

+ func (ub *UnionBuilder) UsePlaceholder(p Placeholder) *UnionBuilder

+ func (ub *UnionBuilder) Write(w Writer) (err error)

Jul 24, 2023

Changes in this version

+ var DollarPlaceholder = dollar

+ var ErrNoRows = sql.ErrNoRows

+ var ErrTxDone = sql.ErrTxDone

+ var QuestionPlaceholder = question

+ func Open(driver, url string, maxOpen, maxIdle int) (db *sql.DB, err error)

+ func UsePlaceholder(d Placeholder)

type DB

+ func (this *DB) DB() *sql.DB

+ func (this *DB) Exec(query string, args ...interface{}) (sql.Result, error)

+ func (this *DB) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

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

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

+ func (this *DB) PreparedStatement(ctx context.Context, query string) (*sql.Stmt, error)

+ func (this *DB) Query(query string, args ...interface{}) (*sql.Rows, error)

+ func (this *DB) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ func (this *DB) QueryRow(query string, args ...any) *sql.Row

+ func (this *DB) QueryRowContext(ctx context.Context, query string, args ...any) *sql.Row

+ type Database interface

+ Begin func() (*Tx, error)

+ BeginTx func(ctx context.Context, opts *sql.TxOptions) (*Tx, error)

+ Close func() error

type DeleteBuilder

+ func (this *DeleteBuilder) GetPlaceholder() Placeholder

+ func (this *DeleteBuilder) UsePlaceholder(p Placeholder) *DeleteBuilder

type InsertBuilder

+ func (this *InsertBuilder) GetPlaceholder() Placeholder

+ func (this *InsertBuilder) UsePlaceholder(p Placeholder) *InsertBuilder

+ type Mapper struct

+ func NewMapper(tag string) *Mapper

+ func (this *Mapper) Bind(rows *sql.Rows, dst interface{}) error

+ type Placeholder interface

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

+ func GetPlaceholder() Placeholder

type Preparer

+ PreparedStatement func(ctx context.Context, query string) (*sql.Stmt, error)

type RawBuilder

+ func (this *RawBuilder) GetPlaceholder() Placeholder

+ func (this *RawBuilder) UsePlaceholder(p Placeholder) *RawBuilder

type SelectBuilder

+ func (this *SelectBuilder) GetPlaceholder() Placeholder

+ func (this *SelectBuilder) UsePlaceholder(p Placeholder) *SelectBuilder

type Session

+ QueryRow func(query string, args ...any) *sql.Row

+ QueryRowContext func(ctx context.Context, query string, args ...any) *sql.Row

+ type Transaction interface

+ Commit func() error

+ Rollback func() error

+ type Tx struct

+ func (this *Tx) Commit() error

+ func (this *Tx) Exec(query string, args ...interface{}) (sql.Result, error)

+ func (this *Tx) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

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

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

+ func (this *Tx) Query(query string, args ...interface{}) (*sql.Rows, error)

+ func (this *Tx) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ func (this *Tx) QueryRow(query string, args ...any) *sql.Row

+ func (this *Tx) QueryRowContext(ctx context.Context, query string, args ...any) *sql.Row

+ func (this *Tx) Rollback() error

+ func (this *Tx) Tx() *sql.Tx

type UpdateBuilder

+ func (this *UpdateBuilder) GetPlaceholder() Placeholder

+ func (this *UpdateBuilder) UsePlaceholder(p Placeholder) *UpdateBuilder

Sep 21, 2022

Changes in this version

+ func New(driver, url string, maxOpen, maxIdle int) (db *sql.DB, err error)

type Builder

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

type DeleteBuilder

+ func (this *DeleteBuilder) SQL() (string, []interface{}, error)

+ func (this *DeleteBuilder) Write(w Writer) (err error)

type Eq

+ func (this Eq) SQL() (string, []interface{}, error)

+ func (this Eq) Write(w Writer) error

type InsertBuilder

+ func (this *InsertBuilder) SQL() (string, []interface{}, error)

+ func (this *InsertBuilder) Write(w Writer) (err error)

type NotEq

+ func (this NotEq) SQL() (string, []interface{}, error)

+ func (this NotEq) Write(w Writer) error

type RawBuilder

+ func (this *RawBuilder) SQL() (string, []interface{}, error)

+ func (this *RawBuilder) Write(w Writer) error

type SelectBuilder

+ func (this *SelectBuilder) SQL() (string, []interface{}, error)

+ func (this *SelectBuilder) Write(w Writer) (err error)

type Statement

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

+ Write func(w Writer) error

type UpdateBuilder

+ func (this *UpdateBuilder) SQL() (string, []interface{}, error)

+ func (this *UpdateBuilder) Write(w Writer) (err error)

May 25, 2022

Changes in this version

+ func MD5Key(key string) string

Mar 23, 2020

Changes in this version

+ var DialectDefault = DialectMySQL

+ var DialectMySQL = &mysql

+ var DialectPostgreSQL = &postgresql

+ func Next() int64

+ func OnConflictKeyUpdate(columns ...string) *onConflictDoUpdateStmt

+ func UseIdGenerator(g IdGenerator)

type DeleteBuilder

+ func (this *DeleteBuilder) GetDialect() Dialect

+ type Dialect interface

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

+ Quote func(s string) string

+ func GetDialect() Dialect

+ type IdGenerator interface

+ Next func() int64

+ func GetIdGenerator() IdGenerator

type InsertBuilder

+ func (this *InsertBuilder) GetDialect() Dialect

type RawBuilder

+ func (this *RawBuilder) GetDialect() Dialect

type SelectBuilder

+ func (this *SelectBuilder) GetDialect() Dialect

type UpdateBuilder

+ func (this *UpdateBuilder) GetDialect() Dialect

Oct 10, 2019

Changes in this version

+ type MigrateRecord struct

+ Id int64

+ Name string

+ type Migration struct

+ func NewMigration(db DB) *Migration

+ func (this *Migration) Flush() (err error)

+ func (this *Migration) Load(filename string) error

Sep 5, 2019

Changes in this version

type TX

+ String func() string

+ Trace func(string)

Sep 4, 2019

Changes in this version

type TX

+ Id func() string

Aug 23, 2019

Changes in this version

+ type DBCache struct

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

+ func (this *DBCache) BeginTx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)

+ func (this *DBCache) Close() error

+ func (this *DBCache) Exec(query string, args ...interface{}) (sql.Result, error)

+ func (this *DBCache) ExecContext(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ func (this *DBCache) Ping() error

+ func (this *DBCache) PingContext(ctx context.Context) error

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

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

+ func (this *DBCache) Query(query string, args ...interface{}) (*sql.Rows, error)

+ func (this *DBCache) QueryContext(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

Aug 7, 2019

Changes in this version

+ type Session interface

+ Exec func(query string, args ...interface{}) (sql.Result, error)

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

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

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

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

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

Jun 6, 2019

Changes in this version

+ type Buffer struct

+ func (this *Buffer) Release()

+ func (this *Buffer) Reset()

+ func (this *Buffer) String() string

+ func (this *Buffer) Values() []interface{}

+ func (this *Buffer) Write(bs []byte) (int, error)

+ func (this *Buffer) WriteArgs(args ...interface{})

+ func (this *Buffer) WriteString(s string) (n int, err error)

type DB

+ Close func() error

+ SetConnMaxLifetime func(d time.Duration)

type StmtCache

+ func (this *StmtCache) Close() error

+ func (this *StmtCache) SetConnMaxLifetime(d time.Duration)

+ type Writer interface

+ Write func(p []byte) (n int, err error)

+ WriteArgs func(args ...interface{})

+ WriteString func(s string) (n int, err error)

May 30, 2019

Changes in this version

type DeleteBuilder

+ func (this *DeleteBuilder) WriteToSQL(w SQLWriter) error

type Eq

+ func (this Eq) WriteToSQL(w SQLWriter) error

type InsertBuilder

+ func (this *InsertBuilder) WriteToSQL(w SQLWriter) error

type NotEq

+ func (this NotEq) WriteToSQL(w SQLWriter) error

type RawBuilder

+ func (this *RawBuilder) WriteToSQL(w SQLWriter) error

+ type SQLBuffer struct

+ func NewBuffer() *SQLBuffer

+ func (this *SQLBuffer) Release()

+ func (this *SQLBuffer) Reset()

+ func (this *SQLBuffer) String() string

+ func (this *SQLBuffer) Values() []interface{}

+ func (this *SQLBuffer) Write(bs []byte) (int, error)

+ func (this *SQLBuffer) WriteArgs(args ...interface{})

+ func (this *SQLBuffer) WriteString(s string) (n int, err error)

+ type SQLWriter interface

+ Write func(p []byte) (n int, err error)

+ WriteArgs func(args ...interface{})

+ WriteString func(s string) (n int, err error)

type SelectBuilder

+ func (this *SelectBuilder) WriteToSQL(w SQLWriter) error

type Statement

+ WriteToSQL func(w SQLWriter) error

type UpdateBuilder

+ func (this *UpdateBuilder) WriteToSQL(w SQLWriter) error

May 8, 2019

Changes in this version

+ var Default = MySQL

+ var MySQL = &mysql

+ var PostgreSQL = &postgresql

+ func AND(stmts ...Statement) *whereStmt

+ func Alias(sql interface{}, alias string) *aliasStmt

+ func Case(what ...interface{}) *caseStmt

+ func Find(s Executor, table string, dest interface{}, limit, offset int64, w Statement) (err error)

+ func FindAll(s Executor, table string, dest interface{}, w Statement) (err error)

+ func FindOne(s Executor, table string, dest interface{}, w Statement) (err error)

+ func GetFields(dest interface{}) (result []string, err error)

+ func NewSQL(driver, url string, maxOpen, maxIdle int) (db *sql.DB, err error)

+ func NewStatement(sql interface{}, args ...interface{}) *statement

+ func OR(stmts ...Statement) *whereStmt

+ func OnDuplicateKeyUpdate() *onDuplicateKeyUpdateStmt

+ func SQL(sql string, args ...interface{}) *statement

+ func Scan(rows *sql.Rows, dest interface{}) (err error)

+ func SetLogger(l Logger)

+ func UseDialect(d dialect)

+ type Args struct

+ func (this *Args) Append(args ...interface{})

+ type Builder interface

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

+ Type func() string

+ type DB interface

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

+ BeginTx func(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)

+ Ping func() error

+ PingContext func(ctx context.Context) error

+ func NewCache(db DB) DB

+ type DeleteBuilder struct

+ func NewDeleteBuilder() *DeleteBuilder

+ func (this *DeleteBuilder) Alias(alias ...string) *DeleteBuilder

+ func (this *DeleteBuilder) AppendToSQL(w io.Writer, args *Args) error

+ func (this *DeleteBuilder) Join(join, table, suffix string, args ...interface{}) *DeleteBuilder

+ func (this *DeleteBuilder) LeftJoin(table, suffix string, args ...interface{}) *DeleteBuilder

+ func (this *DeleteBuilder) Limit(limit int64) *DeleteBuilder

+ func (this *DeleteBuilder) Offset(offset int64) *DeleteBuilder

+ func (this *DeleteBuilder) Options(options ...string) *DeleteBuilder

+ func (this *DeleteBuilder) OrderBy(sql ...string) *DeleteBuilder

+ func (this *DeleteBuilder) Prefix(sql string, args ...interface{}) *DeleteBuilder

+ func (this *DeleteBuilder) RightJoin(table, suffix string, args ...interface{}) *DeleteBuilder

+ func (this *DeleteBuilder) Suffix(sql interface{}, args ...interface{}) *DeleteBuilder

+ func (this *DeleteBuilder) Table(table string, args ...string) *DeleteBuilder

+ func (this *DeleteBuilder) ToSQL() (string, []interface{}, error)

+ func (this *DeleteBuilder) Type() string

+ func (this *DeleteBuilder) USING(sql string) *DeleteBuilder

+ func (this *DeleteBuilder) Where(sql interface{}, args ...interface{}) *DeleteBuilder

+ func (this DeleteBuilder) Exec(s Executor) (sql.Result, error)

+ func (this DeleteBuilder) ExecContext(ctx context.Context, s Executor) (result sql.Result, err error)

+ func (this DeleteBuilder) UseDialect(d dialect)

+ type Eq map[string]interface

+ func (this Eq) AppendToSQL(w io.Writer, args *Args) error

+ func (this Eq) ToSQL() (string, []interface{}, error)

+ type Executor interface

+ Exec func(query string, args ...interface{}) (sql.Result, error)

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

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

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

+ type InsertBuilder struct

+ func Insert(columns ...string) *InsertBuilder

+ func NewInsertBuilder() *InsertBuilder

+ func (this *InsertBuilder) AppendToSQL(w io.Writer, args *Args) error

+ func (this *InsertBuilder) Clone() *InsertBuilder

+ func (this *InsertBuilder) Column(column string) *InsertBuilder

+ func (this *InsertBuilder) Columns(columns ...string) *InsertBuilder

+ func (this *InsertBuilder) Options(options ...string) *InsertBuilder

+ func (this *InsertBuilder) Prefix(sql string, args ...interface{}) *InsertBuilder

+ func (this *InsertBuilder) SET(column string, value interface{}) *InsertBuilder

+ func (this *InsertBuilder) Select(sb *SelectBuilder) *InsertBuilder

+ func (this *InsertBuilder) Suffix(sql interface{}, args ...interface{}) *InsertBuilder

+ func (this *InsertBuilder) Table(table string) *InsertBuilder

+ func (this *InsertBuilder) ToSQL() (string, []interface{}, error)

+ func (this *InsertBuilder) Type() string

+ func (this *InsertBuilder) UseDialect(d dialect)

+ func (this *InsertBuilder) Values(values ...interface{}) *InsertBuilder

+ func (this InsertBuilder) Exec(s Executor) (sql.Result, error)

+ func (this InsertBuilder) ExecContext(ctx context.Context, s Executor) (result sql.Result, err error)

+ type Logger interface

+ Output func(calldepth int, s string) error

+ Prefix func() string

+ Printf func(format string, args ...interface{})

+ Println func(args ...interface{})

+ SetPrefix func(prefix string)

+ type NotEq Eq

+ func (this NotEq) AppendToSQL(w io.Writer, args *Args) error

+ func (this NotEq) ToSQL() (string, []interface{}, error)

+ type Preparer interface

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

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

+ type RawBuilder struct

+ func NewBuilder(sql string, args ...interface{}) *RawBuilder

+ func (this *RawBuilder) Append(sql string, args ...interface{}) *RawBuilder

+ func (this *RawBuilder) AppendToSQL(w io.Writer, args *Args) error

+ func (this *RawBuilder) Format(format string, args ...interface{}) *RawBuilder

+ func (this *RawBuilder) Params(args ...interface{}) *RawBuilder

+ func (this *RawBuilder) ToSQL() (string, []interface{}, error)

+ func (this *RawBuilder) Type() string

+ func (this RawBuilder) Exec(s Executor) (sql.Result, error)

+ func (this RawBuilder) ExecContext(ctx context.Context, s Executor) (result sql.Result, err error)

+ func (this RawBuilder) Query(s Executor) (*sql.Rows, error)

+ func (this RawBuilder) QueryContext(ctx context.Context, s Executor) (*sql.Rows, error)

+ func (this RawBuilder) Scan(s Executor, dest interface{}) (err error)

+ func (this RawBuilder) ScanContext(ctx context.Context, s Executor, dest interface{}) (err error)

+ func (this RawBuilder) ScanRow(s Executor, dest ...interface{}) (err error)

+ func (this RawBuilder) ScanRowContext(ctx context.Context, s Executor, dest ...interface{}) (err error)

+ func (this RawBuilder) UseDialect(d dialect)

+ type SQLValue interface

+ SQLValue func() string

+ type SelectBuilder struct

+ func NewSelectBuilder() *SelectBuilder

+ func Select(columns ...string) *SelectBuilder

+ func (this *SelectBuilder) AppendToSQL(w io.Writer, args *Args) error

+ func (this *SelectBuilder) Clone() *SelectBuilder

+ func (this *SelectBuilder) Count(args ...string) *SelectBuilder

+ func (this *SelectBuilder) FoundRows(args ...string) *SelectBuilder

+ func (this *SelectBuilder) From(table string, args ...string) *SelectBuilder

+ func (this *SelectBuilder) FromStmt(stmt Statement) *SelectBuilder

+ func (this *SelectBuilder) GroupBy(groupBys ...string) *SelectBuilder

+ func (this *SelectBuilder) Having(sql interface{}, args ...interface{}) *SelectBuilder

+ func (this *SelectBuilder) Join(join, table, suffix string, args ...interface{}) *SelectBuilder

+ func (this *SelectBuilder) LeftJoin(table, suffix string, args ...interface{}) *SelectBuilder

+ func (this *SelectBuilder) Limit(limit int64) *SelectBuilder

+ func (this *SelectBuilder) Offset(offset int64) *SelectBuilder

+ func (this *SelectBuilder) Options(options ...string) *SelectBuilder

+ func (this *SelectBuilder) OrderBy(sql ...string) *SelectBuilder

+ func (this *SelectBuilder) Prefix(sql string, args ...interface{}) *SelectBuilder

+ func (this *SelectBuilder) RightJoin(table, suffix string, args ...interface{}) *SelectBuilder

+ func (this *SelectBuilder) Select(column interface{}, args ...interface{}) *SelectBuilder

+ func (this *SelectBuilder) Selects(columns ...string) *SelectBuilder

+ func (this *SelectBuilder) Suffix(sql interface{}, args ...interface{}) *SelectBuilder

+ func (this *SelectBuilder) ToSQL() (string, []interface{}, error)

+ func (this *SelectBuilder) Type() string

+ func (this *SelectBuilder) UseSQLCalcFoundRows() *SelectBuilder

+ func (this *SelectBuilder) Where(sql interface{}, args ...interface{}) *SelectBuilder

+ func (this SelectBuilder) Query(s Executor) (*sql.Rows, error)

+ func (this SelectBuilder) QueryContext(ctx context.Context, s Executor) (*sql.Rows, error)

+ func (this SelectBuilder) Scan(s Executor, dest interface{}) (err error)

+ func (this SelectBuilder) ScanContext(ctx context.Context, s Executor, dest interface{}) (err error)

+ func (this SelectBuilder) ScanRow(s Executor, dest ...interface{}) (err error)

+ func (this SelectBuilder) ScanRowContext(ctx context.Context, s Executor, dest ...interface{}) (err error)

+ func (this SelectBuilder) UseDialect(d dialect)

+ type Statement interface

+ AppendToSQL func(w io.Writer, args *Args) error

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

+ func IN(sql string, args interface{}) Statement

+ func Like(sql string, args ...interface{}) Statement

+ func NotIn(sql string, args interface{}) Statement

+ func NotLike(sql string, args ...interface{}) Statement

+ type StmtCache struct

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

+ func (this *StmtCache) BeginTx(ctx context.Context, opts *sql.TxOptions) (*sql.Tx, error)

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

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

+ func (this *StmtCache) Ping() error

+ func (this *StmtCache) PingContext(ctx context.Context) error

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

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

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

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

+ type TX interface

+ Commit func() (err error)

+ Rollback func() error

+ Stmt func(stmt *sql.Stmt) *sql.Stmt

+ StmtContext func(ctx context.Context, stmt *sql.Stmt) *sql.Stmt

+ func MustTx(db DB) TX

+ func MustTxContext(ctx context.Context, db DB, opts *sql.TxOptions) TX

+ func NewTx(db DB) (TX, error)

+ func NewTxContext(ctx context.Context, db DB, opts *sql.TxOptions) (tx TX, err error)

+ type UpdateBuilder struct

+ func NewUpdateBuilder() *UpdateBuilder

+ func Update(table string, args ...string) *UpdateBuilder

+ func (this *UpdateBuilder) AppendToSQL(w io.Writer, sep string, args *Args) error

+ func (this *UpdateBuilder) Join(join, table, suffix string, args ...interface{}) *UpdateBuilder

+ func (this *UpdateBuilder) LeftJoin(table, suffix string, args ...interface{}) *UpdateBuilder

+ func (this *UpdateBuilder) Limit(limit int64) *UpdateBuilder

+ func (this *UpdateBuilder) Offset(offset int64) *UpdateBuilder

+ func (this *UpdateBuilder) Options(options ...string) *UpdateBuilder

+ func (this *UpdateBuilder) OrderBy(sql ...string) *UpdateBuilder

+ func (this *UpdateBuilder) Prefix(sql string, args ...interface{}) *UpdateBuilder

+ func (this *UpdateBuilder) RightJoin(table, suffix string, args ...interface{}) *UpdateBuilder

+ func (this *UpdateBuilder) SET(column string, value interface{}) *UpdateBuilder

+ func (this *UpdateBuilder) SETS(kvs ...interface{}) *UpdateBuilder

+ func (this *UpdateBuilder) SetMap(data map[string]interface{}) *UpdateBuilder

+ func (this *UpdateBuilder) Suffix(sql interface{}, args ...interface{}) *UpdateBuilder

+ func (this *UpdateBuilder) Table(table string, args ...string) *UpdateBuilder

+ func (this *UpdateBuilder) ToSQL() (string, []interface{}, error)

+ func (this *UpdateBuilder) Type() string

+ func (this *UpdateBuilder) Where(sql interface{}, args ...interface{}) *UpdateBuilder

+ func (this UpdateBuilder) Exec(s Executor) (sql.Result, error)

+ func (this UpdateBuilder) ExecContext(ctx context.Context, s Executor) (result sql.Result, err error)

+ func (this UpdateBuilder) UseDialect(d dialect)