Versions in this module Expand all Collapse all v2 v2.9.9 Mar 7, 2023 v2.9.8 Feb 21, 2023 v2.9.7 Feb 15, 2023 v2.9.6 Feb 14, 2023 v2.9.4 Dec 26, 2022 v2.9.3 Dec 26, 2022 v2.9.2 Dec 26, 2022 v2.9.1 Dec 26, 2022 v2.9.0 Dec 26, 2022 Changes in this version + const AND + const ASC + const BETWEEN + const DESC + const EQUAL + const GREATER + const GREATEREQUAL + const IN + const INNERJOIN + const ISNOTNULL + const ISNULL + const JOIN + const LEFTJOIN + const LESS + const LESSEQUAL + const LIKE + const NOTBETWEEN + const NOTEQUAL + const NOTIN + const OR + const RIGHTJOIN + const UNION + const UNIONALL + func NewSQLConn(driverName, server string, opt *Opt) (*sql.DB, error) + type BatchError struct + func (be *BatchError) Add(err error) + func (be *BatchError) Err() error + func (be *BatchError) NotNil() bool + type Builder struct + func (builder *Builder) Between(column string, value1 interface{}, value2 interface{}) *Builder + func (builder *Builder) Count() (int64, error) + func (builder *Builder) Delete() (int64, error) + func (builder *Builder) DeleteSQL() string + func (builder *Builder) Distinct() *Builder + func (builder *Builder) Equal(column string, value interface{}) *Builder + func (builder *Builder) Exec(sql string, args ...interface{}) (int64, error) + func (builder *Builder) ExecSQL(sql string, args ...interface{}) string + func (builder *Builder) Greater(column string, value interface{}) *Builder + func (builder *Builder) GreaterEqual(column string, value interface{}) *Builder + func (builder *Builder) GroupBy(groups ...string) *Builder + func (builder *Builder) In(column string, value ...interface{}) *Builder + func (builder *Builder) InnerJoin(tablename string, on string) *Builder + func (builder *Builder) Insert(data interface{}) (int64, error) + func (builder *Builder) InsertSQL(data interface{}) string + func (builder *Builder) InsertUpdate(insert interface{}, update interface{}) (int64, error) + func (builder *Builder) InsertUpdateSQL(insert interface{}, update interface{}) string + func (builder *Builder) IsNULL(column string) *Builder + func (builder *Builder) IsNotNULL(column string) *Builder + func (builder *Builder) IsZero(v reflect.Value) bool + func (builder *Builder) Join(tablename string, on string) *Builder + func (builder *Builder) LeftJoin(tablename string, on string) *Builder + func (builder *Builder) Less(column string, value interface{}) *Builder + func (builder *Builder) LessEqual(column string, value interface{}) *Builder + func (builder *Builder) Like(column string, value interface{}) *Builder + func (builder *Builder) Limit(limit int64) *Builder + func (builder *Builder) MultiInsert(datas ...interface{}) (int64, error) + func (builder *Builder) MultiInsertSQL(datas ...interface{}) string + func (builder *Builder) NotBetween(column string, value1 interface{}, value2 interface{}) *Builder + func (builder *Builder) NotEqual(column string, value interface{}) *Builder + func (builder *Builder) NotIn(column string, value ...interface{}) *Builder + func (builder *Builder) NotOrBetween(column string, value1 interface{}, value2 interface{}) *Builder + func (builder *Builder) Offset(offset int64) *Builder + func (builder *Builder) OrBetween(column string, value1 interface{}, value2 interface{}) *Builder + func (builder *Builder) OrEqual(column string, value interface{}) *Builder + func (builder *Builder) OrIn(column string, value ...interface{}) *Builder + func (builder *Builder) OrIsNULL(column string) *Builder + func (builder *Builder) OrIsNotNULL(column string) *Builder + func (builder *Builder) OrLike(column string, value interface{}) *Builder + func (builder *Builder) OrNotEqual(column string, value interface{}) *Builder + func (builder *Builder) OrNotIn(column string, value ...interface{}) *Builder + func (builder *Builder) OrWhere(column string, value ...interface{}) *Builder + func (builder *Builder) OrderBy(column string, direction string) *Builder + func (builder *Builder) QueryRow(sql string, args ...interface{}) *Row + func (builder *Builder) QueryRowSQL(sql string, args ...interface{}) string + func (builder *Builder) QueryRows(sql string, args ...interface{}) *Rows + func (builder *Builder) QueryRowsSQL(sql string, args ...interface{}) string + func (builder *Builder) Replace(datas ...interface{}) (int64, error) + func (builder *Builder) ReplaceSQL(datas ...interface{}) string + func (builder *Builder) RightJoin(tablename string, on string) *Builder + func (builder *Builder) Row() *Row + func (builder *Builder) RowSQL() string + func (builder *Builder) Rows() *Rows + func (builder *Builder) RowsSQL() string + func (builder *Builder) Select(columns ...string) *Builder + func (builder *Builder) Skip(offset int64) *Builder + func (builder *Builder) Table(tableName ...string) *Builder + func (builder *Builder) ToSQL(method string) string + func (builder *Builder) Union(unions ...Builder) *Builder + func (builder *Builder) UnionAll(unions ...Builder) *Builder + func (builder *Builder) UnionLimit(limit int64) *Builder + func (builder *Builder) UnionOffset(offset int64) *Builder + func (builder *Builder) UnionOrderBy(column string, direction string) *Builder + func (builder *Builder) Update(data interface{}) (int64, error) + func (builder *Builder) UpdateSQL(data interface{}) string + func (builder *Builder) Where(column string, value ...interface{}) *Builder + type Connection interface + Exec func(ctx context.Context, querySQL string, args ...interface{}) (sql.Result, error) + LastSQL func(querySQL string, args ...interface{}) + NewBuilder func(ctx context.Context) *Builder + Query func(ctx context.Context, querySQL string, args ...interface{}) (*sql.Rows, error) + SQLRaw func() string + type Epr struct + func NewEpr(value string) Epr + func (e Epr) ToString() string + type Grammar struct + func (g Grammar) Delete() string + func (g Grammar) Insert() string + func (g Grammar) InsertUpdate() string + func (g Grammar) Replace() string + func (g Grammar) Select() string + func (g Grammar) ToSQL() string + func (g Grammar) Update() string + type Opt struct + MaxIdleConns int + MaxIdleTime time.Duration + MaxLifetime time.Duration + MaxOpenConns int + type Query struct + Addr string + DB *sql.DB + DBName string + DisableMetric bool + DisableTrace bool + DriverName string + Func string + Path string + Prepare bool + SQL SQL + func (query *Query) Begin() (*Transaction, error) + func (query *Query) Exec(ctx context.Context, querySQL string, args ...interface{}) (sql.Result, error) + func (query *Query) LastSQL(querySQL string, args ...interface{}) + func (query *Query) NewBuilder(ctx context.Context) *Builder + func (query *Query) Query(ctx context.Context, querySQL string, args ...interface{}) (*sql.Rows, error) + func (query *Query) SQLRaw() string + type ResourceManager struct + func NewResourceManager() *ResourceManager + func (manager *ResourceManager) Close() error + func (manager *ResourceManager) GetResource(key string, create func() (io.Closer, error)) (io.Closer, error) + type Row struct + func (r *Row) ToArray() (result []string, err error) + func (r *Row) ToInterface() (result map[string]interface{}, err error) + func (r *Row) ToMap() (result map[string]string, err error) + func (r *Row) ToStruct(st interface{}) error + type Rows struct + func (r *Rows) ToArray() (data [][]string, err error) + func (r *Rows) ToInterface() (data []map[string]interface{}, err error) + func (r *Rows) ToMap() (data []map[string]string, err error) + func (r *Rows) ToStruct(st interface{}) error + type SQL struct + Args []interface{} + CostTime time.Duration + SQL string + func (SQLRaw SQL) ToString() string + func (sql SQL) ToJSON() string + type SharedCalls = SingleFlight + type SingleFlight interface + Do func(key string, fn func() (interface{}, error)) (interface{}, error) + DoEx func(key string, fn func() (interface{}, error)) (interface{}, bool, error) + func NewSharedCalls() SingleFlight + func NewSingleFlight() SingleFlight + type Transaction struct + Addr string + DBName string + DisableMetric bool + DisableTrace bool + DriverName string + Func string + Path string + Prepare bool + SQL SQL + Transaction *sql.Tx + func (query *Transaction) Commit() error + func (query *Transaction) Exec(ctx context.Context, querySQL string, args ...interface{}) (sql.Result, error) + func (query *Transaction) LastSQL(querySQL string, args ...interface{}) + func (query *Transaction) NewBuilder(ctx context.Context) *Builder + func (query *Transaction) Query(ctx context.Context, querySQL string, args ...interface{}) (*sql.Rows, error) + func (query *Transaction) Rollback() error + func (query *Transaction) SQLRaw() string Other modules containing this package github.com/abulo/ratel/v3