sqlx

Apr 28, 2025

Changes in this version

type JoinOn

+ IsArg bool

+ func OnArg(left, right string) JoinOn

Apr 13, 2025

Changes in this version

+ func RegisterMapRowsBinder[K comparable, V any](b *MixRowsBinder, keyf func(V) K)

type MixRowsBinder

+ func (b *MixRowsBinder) Get(vtype reflect.Type) RowsBinder

Apr 8, 2025

Changes in this version

+ func DecodeInt64s[S ~[]int64](s *S, src any) error

+ func EncodeInt64s[S ~[]int64](s S) string

+ func EncodeStrings[S ~[]string](s S, sep string) string

+ func IsUnsupportedTypeError(err error) bool

type DeleteBuilder

+ func (b *DeleteBuilder) Join(table, alias string, ons ...JoinOn) *DeleteBuilder

+ func (b *DeleteBuilder) JoinInner(table, alias string, ons ...JoinOn) *DeleteBuilder

+ type Int64s []int64

+ func (vs *Int64s) Scan(src any) error

+ func (vs Int64s) IsZero() bool

+ func (vs Int64s) Value() (driver.Value, error)

type Map

+ func (m Map[T]) IsZero() bool

type Oper

+ func (o Oper[T]) AppendRowsBinders(binders ...RowsBinder) Oper[T]

+ func (o Oper[T]) RowsBinder() RowsBinder

type RowsBinder

+ func ComposeRowsBinders(binders ...RowsBinder) RowsBinder

type SelectBuilder

+ func (b *SelectBuilder) ForceOrderBy(force bool) *SelectBuilder

+ func (b *SelectBuilder) JoinInner(table, alias string, ons ...JoinOn) *SelectBuilder

type Strings

+ func (vs Strings) IsZero() bool

+ type UnsupportedTypeError struct

+ Name string

+ Type string

+ func (e UnsupportedTypeError) Error() string

type UpdateBuilder

+ func (b *UpdateBuilder) Join(table, alias string, ons ...JoinOn) *UpdateBuilder

+ func (b *UpdateBuilder) JoinInner(table, alias string, ons ...JoinOn) *UpdateBuilder

Feb 10, 2025

Changes in this version

type InsertBuilder

+ func (b *InsertBuilder) GrowValues(newcap int) *InsertBuilder

+ func (b *InsertBuilder) ValuesFromStructs(slice any) *InsertBuilder

type Oper

+ func (o Oper[T]) DeleteWithId(id int64, conds ...op.Condition) error

+ func (o Oper[T]) ExistById(id int64) (bool, error)

+ func (o Oper[T]) ExistWithId(id int64, conds ...op.Condition) (bool, error)

+ func (o Oper[T]) GetWithId(id int64, conds ...op.Condition) (v T, ok bool, err error)

+ func (o Oper[T]) SoftDeleteWithId(id int64, conds ...op.Condition) error

+ func (o Oper[T]) SoftExistById(id int64) (bool, error)

+ func (o Oper[T]) SoftExistWithId(id int64, conds ...op.Condition) (bool, error)

+ func (o Oper[T]) SoftGetWithId(id int64, conds ...op.Condition) (v T, ok bool, err error)

Jan 8, 2025

Changes in this version

+ type Base1 struct

+ CreatedAt time.Time

+ Id int64

+ type Base2 struct

+ CreatedAt time.Time

+ DeletedAt time.Time

+ Id int64

+ UpdatedAt time.Time

type DB

+ func (db *DB) DeleteBuilder() *DeleteBuilder

+ func (db *DB) InsertBuilder() *InsertBuilder

+ func (db *DB) SelectBuilder() *SelectBuilder

+ func (db *DB) UpdateBuilder() *UpdateBuilder

+ type Namer struct

+ Alias string

+ Name string

type Oper

+ func (o Oper[T]) IgnoredColumns() []string

+ func (o Oper[T]) WithIgnoredColumns(columns []string) Oper[T]

type SelectBuilder

+ func (b *SelectBuilder) SelectNamers(columns ...Namer) *SelectBuilder

Jan 6, 2025

Changes in this version

type Oper

+ func (o Oper[T]) WithRowsBinder(binder RowsBinder) Oper[T]

Jan 6, 2025

Changes in this version

+ var CommonSliceRowsBinder RowsBinder = RowsBinderFunc(commonSliceRowsBinder)

+ var DefaultMixRowsBinder = NewMixRowsBinder()

+ var DefaultRowsCap = 16

+ func IsPointerToStruct(v any) (ok bool)

type DB

+ func (db *DB) QueryRowOne(query string, args ...any) Row

+ func (db *DB) QueryRowOneContext(ctx context.Context, query string, args ...any) Row

+ type GeneralScanner struct

+ Value any

+ func (s GeneralScanner) Scan(src any) (err error)

+ type MixRowsBinder struct

+ func NewMixRowsBinder() *MixRowsBinder

+ func (b *MixRowsBinder) BindRows(scanner RowScanner, dst any) (err error)

+ func (b *MixRowsBinder) Register(vtype reflect.Type, binder RowsBinder) (old RowsBinder)

type Oper

+ RowScannerWrapper RowScannerWrapper

+ RowsCap int

+ SliceRowsBinder RowsBinder

+ func (o Oper[T]) SoftGetRow(columns any, conds ...op.Condition) Row

+ func (o Oper[T]) SoftGetRowContext(ctx context.Context, columns any, conds ...op.Condition) Row

+ func (o Oper[T]) WithRowScannerWrapper(wrapper RowScannerWrapper) Oper[T]

+ func (o Oper[T]) WithRowsCap(cap int) Oper[T]

+ func (o Oper[T]) WithSliceRowsBinder(binder RowsBinder) Oper[T]

type Row

+ func (r Row) Next() bool

+ func (r Row) WithColumns(columns ...string) Row

+ func (r Row) WithScanner(wrapper RowScannerWrapper) Row

+ type RowScanner interface

+ Columns func() ([]string, error)

+ Next func() bool

+ Scan func(dst ...any) error

+ type RowScannerWrapper func(scanner RowScanner, dsts ...any) (err error)

+ var DefaultRowScanWrapper RowScannerWrapper = defaultRowScanWrapper

type Rows

+ Err error

+ func (r Rows) Bind(dst any) error

+ func (r Rows) RowsCap() int

+ func (r Rows) WithBinder(binder RowsBinder) Rows

+ func (r Rows) WithColumns(columns ...string) Rows

+ func (r Rows) WithRowsCap(cap int) Rows

+ func (r Rows) WithScanner(wrapper RowScannerWrapper) Rows

+ type RowsBinder interface

+ BindRows func(scanner RowScanner, dst any) error

+ func NewDegradedSliceRowsBinder[S ~[]T, T any](degraded RowsBinder) RowsBinder

+ func NewMapRowsBinderForKeyAndFixedValue[M ~map[K]V, K comparable, V any](value V) RowsBinder

+ func NewMapRowsBinderForKeyValue[M ~map[K]V, K comparable, V any]() RowsBinder

+ func NewMapRowsBinderForKey[M ~map[K]V, K comparable, V any](valuef func(K) V) RowsBinder

+ func NewMapRowsBinderForValue[M ~map[K]V, K comparable, V any](keyf func(V) K) RowsBinder

+ func NewSliceRowsBinder[S ~[]T, T any]() RowsBinder

+ type RowsBinderFunc func(scanner RowScanner, dst any) (err error)

+ func (f RowsBinderFunc) BindRows(scanner RowScanner, dst any) error

type SelectBuilder

+ func (b *SelectBuilder) IgnoreColumns(columns []string) *SelectBuilder

+ func (b *SelectBuilder) Pagination(page op.Pagination) *SelectBuilder

+ func (b *SelectBuilder) QueryRows() Rows

+ func (b *SelectBuilder) QueryRowsContext(ctx context.Context) Rows

Dec 25, 2024

Changes in this version

type MapBinder

+ func NewKeyStructMapBinder[K comparable, V any](value func(K) V) MapBinder[K, V, map[K]V]

+ func NewValueStructMapBinder[K comparable, V any](key func(V) K) MapBinder[K, V, map[K]V]

+ func (b MapBinder[K, V, M]) BindInto(rows Rows, m M) (err error)

+ func (b MapBinder[K, V, M]) TryBindInto(rows Rows, err error, m M) error

type MapRowScanner

+ func MapRowScanKeyStruct[K comparable, V any](value func(K) V) MapRowScanner[K, V]

Dec 22, 2024

Changes in this version

+ type MapBinder struct

+ ScanRow MapRowScanner[K, V]

+ func NewBoolMapBinder[K comparable]() MapBinder[K, bool, map[K]bool]

+ func NewEmptyMapBinder[K comparable]() MapBinder[K, struct{}, map[K]struct{}]

+ func NewKVMapBinder[K comparable, V any]() MapBinder[K, V, map[K]V]

+ func NewMapBinder[K comparable, V any, M map[K]V](scanrow MapRowScanner[K, V]) MapBinder[K, V, M]

+ func NewStructMapBinder[K comparable, V any](key func(V) K) MapBinder[K, V, map[K]V]

+ func (b MapBinder[K, V, M]) Bind(rows Rows, initcap int) (m M, err error)

+ func (b MapBinder[K, V, M]) TryBind(rows Rows, err error, initcap int) (M, error)

+ type MapRowScanner func(rows Rows) (K, V, error)

+ func MapRowScanKeyValue[K comparable, V any]() MapRowScanner[K, V]

+ func MapRowScanKey[K comparable, V any](value V) MapRowScanner[K, V]

+ func MapRowScanValueStruct[K comparable, V any](key func(V) K) MapRowScanner[K, V]

type Oper

+ SliceCap int

+ Sorter op.Sorter

+ func (o Oper[T]) CountQuery(page, pagesize int64, conds ...op.Condition) (total int, objs []T, err error)

+ func (o Oper[T]) CountQueryContext(ctx context.Context, page, pagesize int64, conds ...op.Condition) (total int, objs []T, err error)

+ func (o Oper[T]) SoftCountQuery(page, pagesize int64, conds ...op.Condition) (total int, objs []T, err error)

+ func (o Oper[T]) SoftCountQueryContext(ctx context.Context, page, pagesize int64, conds ...op.Condition) (total int, objs []T, err error)

+ func (o Oper[T]) WithSliceCap(cap int) Oper[T]

+ func (o Oper[T]) WithSorter(sorter op.Sorter) Oper[T]

type SelectBuilder

+ func (b *SelectBuilder) Sorts(sorters ...op.Sorter) *SelectBuilder

Nov 4, 2024

Changes in this version

type Oper

+ func (o Oper[T]) GetAll(conds ...op.Condition) ([]T, error)

+ func (o Oper[T]) SoftGetAll(conds ...op.Condition) ([]T, error)

Sep 24, 2024

Changes in this version

+ const SliceSep

+ func DecodeMap[M ~map[string]T, T any](m *M, src any) error

+ func DecodeStrings[S ~[]string](s *S, src any, sep string) error

+ func EncodeMap[M ~map[string]T, T any](m M) (string, error)

+ type Map map[string]T

+ func (m *Map[T]) Scan(src any) error

+ func (m Map[T]) Value() (driver.Value, error)

+ type Strings []string

+ func (vs *Strings) Scan(src any) error

+ func (vs Strings) Value() (driver.Value, error)

Sep 2, 2024

Changes in this version

type DB

+ func (db *DB) Reset(other *DB)

type DeleteBuilder

+ func (b *DeleteBuilder) Comment(comment string) *DeleteBuilder

type InsertBuilder

+ func (b *InsertBuilder) Comment(comment string) *InsertBuilder

type SelectBuilder

+ func (b *SelectBuilder) Comment(comment string) *SelectBuilder

type UpdateBuilder

+ func (b *UpdateBuilder) Comment(comment string) *UpdateBuilder

Aug 20, 2024

Changes in this version

+ var DefaultSqlCollector = NewSqlCollector()

+ type Interceptors []Interceptor

+ func (is Interceptors) Intercept(sql string, args []any) (string, []any, error)

type Oper

+ func (o Oper[T]) DeleteById(id int64) error

+ func (o Oper[T]) GetById(id int64) (v T, ok bool, err error)

+ func (o Oper[T]) GetRow(ctx context.Context, columns any, sort op.Sorter, conds ...op.Condition) Row

+ func (o Oper[T]) GetRowContext(ctx context.Context, columns any, sort op.Sorter, conds ...op.Condition) Row

+ func (o Oper[T]) Query(page, pageSize int64, conds ...op.Condition) ([]T, error)

+ func (o Oper[T]) QueryContext(ctx context.Context, page, pageSize int64, conds ...op.Condition) ([]T, error)

+ func (o Oper[T]) Select(columns any, conds ...op.Condition) *SelectBuilder

+ func (o Oper[T]) SoftCountContext(ctx context.Context, conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) SoftCountDistinctContext(ctx context.Context, field string, conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) SoftExistContext(ctx context.Context, conds ...op.Condition) (exist bool, err error)

+ func (o Oper[T]) SoftQueryContext(ctx context.Context, page, pageSize int64, conds ...op.Condition) ([]T, error)

+ func (o Oper[T]) SoftSelect(columns any, conds ...op.Condition) *SelectBuilder

+ func (o Oper[T]) SoftSumContext(ctx context.Context, field string, conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) UpdateById(id int64, updaters ...op.Updater) error

+ type SqlCollector struct

+ func NewSqlCollector() *SqlCollector

+ func (c *SqlCollector) Intercept(sql string, args []any) (string, []any, error)

+ func (c *SqlCollector) SetEnableFunc(enablef func() bool) *SqlCollector

+ func (c *SqlCollector) SetEnabled(enabled bool) *SqlCollector

+ func (c *SqlCollector) SetFilterFunc(filterf func(sql string) bool) *SqlCollector

+ func (c *SqlCollector) Sqls() []string

Jul 19, 2024

Changes in this version

+ func BindToMapBool[M ~map[K]bool, K comparable](rows Rows, initcap int) (M, error)

+ func BindToMapEmptyStruct[M ~map[K]struct{}, K comparable](rows Rows, initcap int) (M, error)

+ func BindToMapKV[M ~map[K]V, K comparable, V any](rows Rows, initcap int) (m M, err error)

+ func Today() time.Time

+ func TryBindToMapBool[M ~map[K]bool, K comparable](rows Rows, err error, initcap int) (m M, e error)

+ func TryBindToMapEmptyStruct[M ~map[K]struct{}, K comparable](rows Rows, err error, initcap int) (m M, e error)

+ func TryBindToMapKV[M ~map[K]V, K comparable, V any](rows Rows, err error, initcap int) (m M, e error)

type Oper

+ func (o Oper[T]) CountContext(ctx context.Context, conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) CountDistinctContext(ctx context.Context, field string, conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) ExistContext(ctx context.Context, conds ...op.Condition) (exist bool, err error)

+ func (o Oper[T]) GetRows(order op.Sorter, columns any, conds ...op.Condition) (Rows, error)

+ func (o Oper[T]) GetRowsContext(ctx context.Context, order op.Sorter, columns any, conds ...op.Condition) (rows Rows, err error)

+ func (o Oper[T]) SelectStructRow(structvalue any) *SelectBuilder

+ func (o Oper[T]) SelectsRow(columns ...string) *SelectBuilder

+ func (o Oper[T]) SoftGetRows(order op.Sorter, columns any, conds ...op.Condition) (Rows, error)

+ func (o Oper[T]) SoftGetRowsContext(ctx context.Context, order op.Sorter, columns any, conds ...op.Condition) (Rows, error)

+ func (o Oper[T]) SoftSelectStructRow(structvalue any) *SelectBuilder

+ func (o Oper[T]) SoftSelectsRow(columns ...string) *SelectBuilder

+ func (o Oper[T]) SoftSum(field string, conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) Sum(field string, conds ...op.Condition) (int, error)

+ func (o Oper[T]) SumContext(ctx context.Context, field string, conds ...op.Condition) (total int, err error)

type Row

+ func (r Row) Bind(dests ...any) (ok bool, err error)

+ func (r Row) BindStruct(s any) (ok bool, err error)

type Rows

+ func (r Rows) BindSlice(slice any) (err error)

+ func (r Rows) TryBindSlice(slice any, err error) error

Jun 27, 2024

Changes in this version

type ArgsBuilder

+ func GetArgsBuilderFromPool(dialect Dialect) *ArgsBuilder

+ func (a *ArgsBuilder) Release()

+ func (a *ArgsBuilder) Reset()

+ func (a *ArgsBuilder) WithDialect(dialect Dialect) *ArgsBuilder

+ type Oper struct

+ SoftCondition op.Condition

+ SoftDeleteUpdater func(context.Context) op.Updater

+ Table Table

+ func NewOperWithTable[T any](table Table) Oper[T]

+ func NewOper[T any](table string) Oper[T]

+ func (o Oper[T]) Add(obj T) (err error)

+ func (o Oper[T]) AddContext(ctx context.Context, obj T) (err error)

+ func (o Oper[T]) AddContextWithId(ctx context.Context, obj T) (id int64, err error)

+ func (o Oper[T]) AddWithId(obj T) (id int64, err error)

+ func (o Oper[T]) Count(conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) CountDistinct(field string, conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) Delete(conds ...op.Condition) (err error)

+ func (o Oper[T]) DeleteContext(ctx context.Context, conds ...op.Condition) error

+ func (o Oper[T]) Exist(conds ...op.Condition) (exist bool, err error)

+ func (o Oper[T]) Get(sort op.Sorter, conds ...op.Condition) (obj T, ok bool, err error)

+ func (o Oper[T]) GetContext(ctx context.Context, sort op.Sorter, conds ...op.Condition) (obj T, ok bool, err error)

+ func (o Oper[T]) Gets(sort op.Sorter, page op.Paginator, conds ...op.Condition) (objs []T, err error)

+ func (o Oper[T]) GetsContext(ctx context.Context, sort op.Sorter, page op.Paginator, conds ...op.Condition) (objs []T, err error)

+ func (o Oper[T]) MakeSlice(cap int64) []T

+ func (o Oper[T]) SoftCount(conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) SoftCountDistinct(field string, conds ...op.Condition) (total int, err error)

+ func (o Oper[T]) SoftDelete(conds ...op.Condition) error

+ func (o Oper[T]) SoftDeleteById(id int64) error

+ func (o Oper[T]) SoftDeleteContext(ctx context.Context, conds ...op.Condition) error

+ func (o Oper[T]) SoftExist(conds ...op.Condition) (exist bool, err error)

+ func (o Oper[T]) SoftGet(sort op.Sorter, conds ...op.Condition) (obj T, ok bool, err error)

+ func (o Oper[T]) SoftGetById(id int64) (v T, ok bool, err error)

+ func (o Oper[T]) SoftGetContext(ctx context.Context, sort op.Sorter, conds ...op.Condition) (obj T, ok bool, err error)

+ func (o Oper[T]) SoftGets(sort op.Sorter, page op.Paginator, conds ...op.Condition) ([]T, error)

+ func (o Oper[T]) SoftGetsContext(ctx context.Context, sort op.Sorter, page op.Paginator, conds ...op.Condition) ([]T, error)

+ func (o Oper[T]) SoftQuery(page, pageSize int64, conds ...op.Condition) ([]T, error)

+ func (o Oper[T]) SoftUpdate(updater op.Updater, conds ...op.Condition) (err error)

+ func (o Oper[T]) SoftUpdateById(id int64, updaters ...op.Updater) error

+ func (o Oper[T]) SoftUpdateContext(ctx context.Context, updater op.Updater, conds ...op.Condition) error

+ func (o Oper[T]) Update(updater op.Updater, conds ...op.Condition) error

+ func (o Oper[T]) UpdateContext(ctx context.Context, updater op.Updater, conds ...op.Condition) error

+ func (o Oper[T]) WithDB(db *DB) Oper[T]

+ func (o Oper[T]) WithSoftCondition(softcond op.Condition) Oper[T]

+ func (o Oper[T]) WithSoftDeleteUpdater(softDeleteUpdater func(context.Context) op.Updater) Oper[T]

+ func (o Oper[T]) WithTable(table Table) Oper[T]

type Operation

+ func (o Operation[T]) Exist(conds ...op.Condition) (exist bool, err error)

Jun 17, 2024

Changes in this version

type Operation

+ DisableUpdater op.Updater

+ EnableUpdater op.Updater

+ func (o Operation[T]) Count(conds ...op.Condition) (total int, err error)

+ func (o Operation[T]) CountDistinct(field string, conds ...op.Condition) (total int, err error)

+ func (o Operation[T]) DeleteById(id int64) error

+ func (o Operation[T]) DisableById(id int64) (err error)

+ func (o Operation[T]) EnableById(id int64) (err error)

+ func (o Operation[T]) GetById(id int64) (v T, ok bool, err error)

+ func (o Operation[T]) Query(page, pageSize int64, conds ...op.Condition) ([]T, error)

+ func (o Operation[T]) UpdateById(id int64, updaters ...op.Updater) error

May 29, 2024

Changes in this version

type DB

+ func (db *DB) QueryRows(query string, args ...interface{}) (Rows, error)

+ func (db *DB) QueryRowsContext(ctx context.Context, query string, args ...interface{}) (rows Rows, err error)

+ func (db *DB) QueryRowx(query string, args ...interface{}) Row

+ func (db *DB) QueryRowxContext(ctx context.Context, query string, args ...interface{}) Row

type Operation

+ func (o Operation[T]) AddWithId(obj T) (id int64, err error)

May 22, 2024

Changes in this version

+ func Sum(field string) string

type SelectBuilder

+ func (b *SelectBuilder) Sum(field string) *SelectBuilder

Apr 6, 2024

Changes in this version

+ func Count(field string) string

+ func CountDistinct(field string) string

type Base

+ Id int64

type SelectBuilder

+ func (b *SelectBuilder) SelectCount(field string) *SelectBuilder

+ func (b *SelectBuilder) SelectCountDistinct(field string) *SelectBuilder

Aug 7, 2023

Changes in this version

+ const DateZero

+ const TimeZero

Jul 27, 2023

Changes in this version

+ var DefaultArgsCap = 4

+ var DefaultBufferCap = 128

+ var DefaultDeletedAt = op.Key("deleted_at")

+ var DefaultSliceCap = 8

+ func BuildOp(ab *ArgsBuilder, op op.Op) string

+ func BuildOper(ab *ArgsBuilder, op op.Oper) string

+ func RegisterOpBuilder(op string, builder OpBuilder)

type DB

+ func (db *DB) SelectAlias(column, alias string) *SelectBuilder

+ func (db *DB) SelectStructWithTable(s interface{}, table string) *SelectBuilder

type DeleteBuilder

+ func (b *DeleteBuilder) FromAlias(table string, alias string) *DeleteBuilder

type InsertBuilder

+ func (b *InsertBuilder) Ops(ops ...op.Op) *InsertBuilder

+ type OpBuilder interface

+ Build func(*ArgsBuilder, op.Op) string

+ func GetOpBuilder(op string) OpBuilder

+ type OpBuilderFunc func(ab *ArgsBuilder, op op.Op) string

+ func (f OpBuilderFunc) Build(ab *ArgsBuilder, op op.Op) string

+ type Operation struct

+ SoftDeleteUpdater func(context.Context) op.Updater

+ func NewOperation(table string) Operation[T]

+ func NewOperationWithTable(table Table) Operation[T]

+ func (o Operation[T]) Add(obj T) (err error)

+ func (o Operation[T]) AddContext(ctx context.Context, obj T) (err error)

+ func (o Operation[T]) AddContextWithId(ctx context.Context, obj T) (id int64, err error)

+ func (o Operation[T]) Get(conds ...op.Condition) (obj T, ok bool, err error)

+ func (o Operation[T]) GetContext(ctx context.Context, conds ...op.Condition) (obj T, ok bool, err error)

+ func (o Operation[T]) Gets(sort op.Sort, page op.Paginator, conds ...op.Condition) (objs []T, err error)

+ func (o Operation[T]) GetsContext(ctx context.Context, sort op.Sort, page op.Paginator, conds ...op.Condition) (objs []T, err error)

+ func (o Operation[T]) MakeSlice(cap int64) []T

+ func (o Operation[T]) Remove(conds ...op.Condition) (err error)

+ func (o Operation[T]) RemoveContext(ctx context.Context, conds ...op.Condition) (err error)

+ func (o Operation[T]) Update(updater op.Updater, conds ...op.Condition) error

+ func (o Operation[T]) UpdateContext(ctx context.Context, updater op.Updater, conds ...op.Condition) error

+ func (o Operation[T]) UpdateRemove(conds ...op.Condition) (err error)

+ func (o Operation[T]) UpdateRemoveContext(ctx context.Context, conds ...op.Condition) (err error)

+ func (o Operation[T]) WithDB(db *DB) Operation[T]

+ func (o Operation[T]) WithSoftDeleteUpdater(softDeleteUpdater func(context.Context) op.Updater) Operation[T]

+ func (o Operation[T]) WithTable(table Table) Operation[T]

type SelectBuilder

+ func SelectAlias(column, alias string) *SelectBuilder

+ func SelectStructWithTable(s interface{}, table string) *SelectBuilder

+ func (b *SelectBuilder) FromAlias(table, alias string) *SelectBuilder

+ func (b *SelectBuilder) Paginator(page op.Paginator) *SelectBuilder

+ func (b *SelectBuilder) SelectAlias(column, alias string) *SelectBuilder

+ func (b *SelectBuilder) SelectStructWithTable(s interface{}, table string) *SelectBuilder

+ func (b *SelectBuilder) Sort(sorts ...op.Sort) *SelectBuilder

type Table

+ func (t Table) SelectAlias(column, alias string) *SelectBuilder

+ func (t Table) SelectStructWithTable(s interface{}, table string) *SelectBuilder

+ func (t Table) String() string

type UpdateBuilder

+ func (b *UpdateBuilder) FromAlias(table string, alias string) *UpdateBuilder

+ func (b *UpdateBuilder) TableAlias(table string, alias string) *UpdateBuilder

May 6, 2023

Changes in this version

+ var ConverterType = "sqlx"

type DB

+ func (db *DB) Exec(ctx context.Context, query string, args ...interface{}) (r sql.Result, err error)

+ func (db *DB) GetDialect() Dialect

+ func (db *DB) Intercept(sql string, args []interface{}) (string, []interface{}, error)

+ func (db *DB) Query(ctx context.Context, query string, args ...interface{}) (rows *sql.Rows, err error)

+ func (db *DB) QueryRow(ctx context.Context, query string, args ...interface{}) *sql.Row

+ func (db *DB) Set(other *DB)

type DeleteBuilder

+ func (b *DeleteBuilder) WhereOp(andConditions ...op.Condition) *DeleteBuilder

type Interceptor

+ Intercept func(sql string, args []interface{}) (string, []interface{}, error)

+ type InterceptorFunc func(sql string, args []interface{}) (string, []interface{}, error)

+ func (f InterceptorFunc) Intercept(sql string, args []interface{}) (string, []interface{}, error)

type SelectBuilder

+ func (b *SelectBuilder) WhereOp(andConditions ...op.Condition) *SelectBuilder

type Table

+ func (t Table) DeleteFromOp(conds ...op.Condition) *DeleteBuilder

+ func (t Table) UpdateOp(setters ...op.Setter) *UpdateBuilder

type UpdateBuilder

+ func (b *UpdateBuilder) SetOp(setters ...op.Setter) *UpdateBuilder

+ func (b *UpdateBuilder) WhereOp(andConditions ...op.Condition) *UpdateBuilder

Apr 1, 2023

Changes in this version

+ const DateTimeZero

+ var ArgsDefaultCap = 4

+ var BufferDefaultCap = 64

+ var ColumnCreatedAt = NewColumn("created_at")

+ var ColumnDeletedAt = NewColumn("deleted_at")

+ var ColumnID = NewColumn("id")

+ var ColumnUpdatedAt = NewColumn("updated_at")

+ var DefaultConfigs = []Config

+ var DefaultDB = new(DB)

+ var DefaultDialect = MySQL

+ var Sep = "_"

+ func CheckErrNoRows(err error) (exist bool, e error)

+ func ColumnsContain(columns []Column, column Column) bool

+ func ConditionsContain(conditions []Condition, column Column) bool

+ func RegisterDialect(dialect Dialect, force bool)

+ func ScanColumnsToStruct(scan func(...interface{}) error, columns []string, s interface{}) (err error)

+ func ScanRow(scan func(dests ...interface{}) error, dests ...interface{}) error

+ func SetConnURLLocation(connURL string, loc *time.Location) string

+ type ArgsBuilder struct

+ func NewArgsBuilder(dialect Dialect) *ArgsBuilder

+ func (a *ArgsBuilder) Add(arg interface{}) (placeholder string)

+ func (a *ArgsBuilder) Args() []interface{}

+ type Base struct

+ CreatedAt Time

+ DeletedAt Time

+ ID int

+ UpdatedAt Time

+ type Builder interface

+ Build func() (sql string, args []interface{})

+ type Column struct

+ Alias string

+ Name string

+ Table string

+ Value interface{}

+ func NewColumn(colName string) Column

+ func (c Column) Add(value interface{}) ColumnSetter

+ func (c Column) Assign(value interface{}) ColumnSetter

+ func (c Column) Between(lower, upper interface{}) ColumnCondition

+ func (c Column) ColEq(otherColumn string) Condition

+ func (c Column) ColGt(otherColumn string) Condition

+ func (c Column) ColGtEq(otherColumn string) Condition

+ func (c Column) ColLe(otherColumn string) Condition

+ func (c Column) ColLeEq(otherColumn string) Condition

+ func (c Column) ColNotEq(otherColumn string) Condition

+ func (c Column) ColumnEqual(otherColumn string) Condition

+ func (c Column) ColumnGreater(otherColumn string) Condition

+ func (c Column) ColumnGreaterEqual(otherColumn string) Condition

+ func (c Column) ColumnLess(otherColumn string) Condition

+ func (c Column) ColumnLessEqual(otherColumn string) Condition

+ func (c Column) ColumnNotEqual(otherColumn string) Condition

+ func (c Column) Dec() ColumnSetter

+ func (c Column) Div(value interface{}) ColumnSetter

+ func (c Column) Eq(value interface{}) ColumnCondition

+ func (c Column) Equal(value interface{}) ColumnCondition

+ func (c Column) EqualColumn(other Column) Condition

+ func (c Column) FromTable(t Table) Column

+ func (c Column) FullName() string

+ func (c Column) Greater(value interface{}) ColumnCondition

+ func (c Column) GreaterColumn(other Column) Condition

+ func (c Column) GreaterEqual(value interface{}) ColumnCondition

+ func (c Column) GreaterEqualColumn(other Column) Condition

+ func (c Column) Gt(value interface{}) ColumnCondition

+ func (c Column) GtEq(value interface{}) ColumnCondition

+ func (c Column) In(values ...interface{}) ColumnCondition

+ func (c Column) Inc() ColumnSetter

+ func (c Column) IsNotNull() ColumnCondition

+ func (c Column) IsNull() ColumnCondition

+ func (c Column) Le(value interface{}) ColumnCondition

+ func (c Column) LeEq(value interface{}) ColumnCondition

+ func (c Column) Less(value interface{}) ColumnCondition

+ func (c Column) LessColumn(other Column) Condition

+ func (c Column) LessEqual(value interface{}) ColumnCondition

+ func (c Column) LessEqualColumn(other Column) Condition

+ func (c Column) Like(value string) ColumnCondition

+ func (c Column) Mul(value interface{}) ColumnSetter

+ func (c Column) NamedArg() sql.NamedArg

+ func (c Column) NotBetween(lower, upper interface{}) ColumnCondition

+ func (c Column) NotEq(value interface{}) ColumnCondition

+ func (c Column) NotEqual(value interface{}) ColumnCondition

+ func (c Column) NotEqualColumn(other Column) Condition

+ func (c Column) NotIn(values ...interface{}) ColumnCondition

+ func (c Column) NotLike(value string) ColumnCondition

+ func (c Column) Set(value interface{}) ColumnSetter

+ func (c Column) Sub(value interface{}) ColumnSetter

+ func (c Column) WithAlias(alias string) Column

+ func (c Column) WithTable(tname string) Column

+ func (c Column) WithValue(value interface{}) Column

+ type ColumnCondition interface

+ Column func() string

+ func Between(column string, lower, upper interface{}) ColumnCondition

+ func Eq(column string, value interface{}) ColumnCondition

+ func Equal(column string, value interface{}) ColumnCondition

+ func Greater(column string, value interface{}) ColumnCondition

+ func GreaterEqual(column string, value interface{}) ColumnCondition

+ func Gt(column string, value interface{}) ColumnCondition

+ func GtEq(column string, value interface{}) ColumnCondition

+ func In(column string, values ...interface{}) ColumnCondition

+ func IsNotNull(column string) ColumnCondition

+ func IsNull(column string) ColumnCondition

+ func Le(column string, value interface{}) ColumnCondition

+ func LeEq(column string, value interface{}) ColumnCondition

+ func Less(column string, value interface{}) ColumnCondition

+ func LessEqual(column string, value interface{}) ColumnCondition

+ func Like(column string, value string) ColumnCondition

+ func NotBetween(column string, lower, upper interface{}) ColumnCondition

+ func NotEq(column string, value interface{}) ColumnCondition

+ func NotEqual(column string, value interface{}) ColumnCondition

+ func NotIn(column string, values ...interface{}) ColumnCondition

+ func NotLike(column string, value string) ColumnCondition

+ type ColumnSetter interface

+ Column func() string

+ func Add(column string, value interface{}) ColumnSetter

+ func Assign(column string, value interface{}) ColumnSetter

+ func Dec(column string) ColumnSetter

+ func Div(column string, value interface{}) ColumnSetter

+ func Inc(column string) ColumnSetter

+ func Mul(column string, value interface{}) ColumnSetter

+ func Set(column string, value interface{}) ColumnSetter

+ func Sub(column string, value interface{}) ColumnSetter

+ type Condition interface

+ BuildCondition func(*ArgsBuilder) string

+ func And(exprs ...Condition) Condition

+ func ColEq(c1, c2 string) Condition

+ func ColGt(c1, c2 string) Condition

+ func ColGtEq(c1, c2 string) Condition

+ func ColLe(c1, c2 string) Condition

+ func ColLeEq(c1, c2 string) Condition

+ func ColNotEq(c1, c2 string) Condition

+ func ColumnCond(left, op, right string) Condition

+ func ColumnEqual(column1, column2 string) Condition

+ func ColumnGreater(column1, column2 string) Condition

+ func ColumnGreaterEqual(column1, column2 string) Condition

+ func ColumnLess(column1, column2 string) Condition

+ func ColumnLessEqual(column1, column2 string) Condition

+ func ColumnNotEqual(column1, column2 string) Condition

+ func Or(exprs ...Condition) Condition

+ type ConditionSet struct

+ func (c ConditionSet) And(exprs ...Condition) Condition

+ func (c ConditionSet) Between(column string, lower, upper interface{}) ColumnCondition

+ func (c ConditionSet) ColEq(c1, c2 string) Condition

+ func (c ConditionSet) ColGt(c1, c2 string) Condition

+ func (c ConditionSet) ColGtEq(c1, c2 string) Condition

+ func (c ConditionSet) ColLe(c1, c2 string) Condition

+ func (c ConditionSet) ColLeEq(c1, c2 string) Condition

+ func (c ConditionSet) ColNotEq(c1, c2 string) Condition

+ func (c ConditionSet) ColumnCond(left, op, right string) Condition

+ func (c ConditionSet) ColumnEqual(column1, column2 string) Condition

+ func (c ConditionSet) ColumnGreater(column1, column2 string) Condition

+ func (c ConditionSet) ColumnGreaterEqual(column1, column2 string) Condition

+ func (c ConditionSet) ColumnLess(column1, column2 string) Condition

+ func (c ConditionSet) ColumnLessEqual(column1, column2 string) Condition

+ func (c ConditionSet) ColumnNotEqual(column1, column2 string) Condition

+ func (c ConditionSet) Eq(col string, v interface{}) ColumnCondition

+ func (c ConditionSet) Equal(column string, value interface{}) ColumnCondition

+ func (c ConditionSet) Greater(column string, value interface{}) ColumnCondition

+ func (c ConditionSet) GreaterEqual(column string, value interface{}) ColumnCondition

+ func (c ConditionSet) Gt(col string, v interface{}) ColumnCondition

+ func (c ConditionSet) GtEq(col string, v interface{}) ColumnCondition

+ func (c ConditionSet) In(column string, values ...interface{}) ColumnCondition

+ func (c ConditionSet) IsNotNull(column string) ColumnCondition

+ func (c ConditionSet) IsNull(column string) ColumnCondition

+ func (c ConditionSet) Le(col string, v interface{}) ColumnCondition

+ func (c ConditionSet) LeEq(col string, v interface{}) ColumnCondition

+ func (c ConditionSet) Less(column string, value interface{}) ColumnCondition

+ func (c ConditionSet) LessEqual(column string, value interface{}) ColumnCondition

+ func (c ConditionSet) Like(column string, value string) ColumnCondition

+ func (c ConditionSet) NotBetween(column string, lower, upper interface{}) ColumnCondition

+ func (c ConditionSet) NotEq(col string, v interface{}) ColumnCondition

+ func (c ConditionSet) NotEqual(column string, value interface{}) ColumnCondition

+ func (c ConditionSet) NotIn(column string, values ...interface{}) ColumnCondition

+ func (c ConditionSet) NotLike(column string, value string) ColumnCondition

+ func (c ConditionSet) Or(exprs ...Condition) Condition

+ type Config func(*DB)

+ func ConnMaxIdleTime(d time.Duration) Config

+ func ConnMaxLifetime(d time.Duration) Config

+ func MaxIdleConns(n int) Config

+ func MaxOpenConns(maxnum int) Config

+ type DB struct

+ func Open(driverName, dataSourceName string, configs ...Config) (*DB, error)

+ func (db *DB) CreateTable(table string) *TableBuilder

+ func (db *DB) Delete(tables ...string) *DeleteBuilder

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

+ func (db *DB) GetExecutor() Executor

+ func (db *DB) Insert() *InsertBuilder

+ func (db *DB) NewTable(name string) Table

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

+ func (db *DB) QueryRowContext(ctx context.Context, query string, args ...interface{}) *sql.Row

+ func (db *DB) Select(column string, alias ...string) *SelectBuilder

+ func (db *DB) SelectColumns(columns ...Column) *SelectBuilder

+ func (db *DB) SelectStruct(s interface{}, table ...string) *SelectBuilder

+ func (db *DB) Selects(columns ...string) *SelectBuilder

+ func (db *DB) Update(table ...string) *UpdateBuilder

+ type DeleteBuilder struct

+ func Delete(tables ...string) *DeleteBuilder

+ func NewDeleteBuilder(tables ...string) *DeleteBuilder

+ func (b *DeleteBuilder) Build() (sql string, args []interface{})

+ func (b *DeleteBuilder) Exec() (sql.Result, error)

+ func (b *DeleteBuilder) ExecContext(ctx context.Context) (sql.Result, error)

+ func (b *DeleteBuilder) From(table string, alias ...string) *DeleteBuilder

+ func (b *DeleteBuilder) JoinFull(table, alias string, ons ...JoinOn) *DeleteBuilder

+ func (b *DeleteBuilder) JoinFullOuter(table, alias string, ons ...JoinOn) *DeleteBuilder

+ func (b *DeleteBuilder) JoinLeft(table, alias string, ons ...JoinOn) *DeleteBuilder

+ func (b *DeleteBuilder) JoinLeftOuter(table, alias string, ons ...JoinOn) *DeleteBuilder

+ func (b *DeleteBuilder) JoinRight(table, alias string, ons ...JoinOn) *DeleteBuilder

+ func (b *DeleteBuilder) JoinRightOuter(table, alias string, ons ...JoinOn) *DeleteBuilder

+ func (b *DeleteBuilder) SetDB(db *DB) *DeleteBuilder

+ func (b *DeleteBuilder) SetDialect(dialect Dialect) *DeleteBuilder

+ func (b *DeleteBuilder) SetExecutor(exec Executor) *DeleteBuilder

+ func (b *DeleteBuilder) SetInterceptor(f Interceptor) *DeleteBuilder

+ func (b *DeleteBuilder) String() string

+ func (b *DeleteBuilder) Table(table string) *DeleteBuilder

+ func (b *DeleteBuilder) Where(andConditions ...Condition) *DeleteBuilder

+ func (b *DeleteBuilder) WhereNamedArgs(args ...sql.NamedArg) *DeleteBuilder

+ type Dialect interface

+ LimitOffset func(limit, offset int64) string

+ Name func() string

+ Placeholder func(i int) string

+ Quote func(s string) string

+ var MySQL Dialect = dialect{ ... }

+ var Postgres Dialect = dialect{ ... }

+ var Sqlite3 Dialect = dialect{ ... }

+ func GetDialect(name string) Dialect

+ type Executor interface

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

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

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

+ type InsertBuilder struct

+ func Insert() *InsertBuilder

+ func NewInsertBuilder() *InsertBuilder

+ func (b *InsertBuilder) Build() (sql string, args []interface{})

+ func (b *InsertBuilder) ColumnValues(columns ...Column) *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) IgnoreInto(table string) *InsertBuilder

+ func (b *InsertBuilder) Into(table string) *InsertBuilder

+ func (b *InsertBuilder) NamedValues(values ...sql.NamedArg) *InsertBuilder

+ func (b *InsertBuilder) ReplaceInto(table string) *InsertBuilder

+ func (b *InsertBuilder) SetDB(db *DB) *InsertBuilder

+ func (b *InsertBuilder) SetDialect(dialect Dialect) *InsertBuilder

+ func (b *InsertBuilder) SetExecutor(exec Executor) *InsertBuilder

+ func (b *InsertBuilder) SetInterceptor(f Interceptor) *InsertBuilder

+ func (b *InsertBuilder) String() string

+ func (b *InsertBuilder) Struct(s interface{}) *InsertBuilder

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

+ type Interceptor func(sql string, args []interface{}) (string, []interface{})

+ func LogInterceptor(logf func(string, ...interface{}), logArgs ...bool) Interceptor

+ type JoinOn struct

+ Left string

+ Right string

+ func On(left, right string) JoinOn

+ type Opener func(driverName, dataSourceName string) (*sql.DB, error)

+ var DefaultOpener Opener = sql.Open

+ type Order string

+ const Asc

+ const Desc

+ type Row struct

+ Columns []string

+ func NewRow(row *sql.Row, columns ...string) Row

+ func (r Row) Scan(dests ...interface{}) (err error)

+ func (r Row) ScanStruct(s interface{}) (err error)

+ func (r Row) ScanStructWithColumns(s interface{}, columns ...string) (err error)

+ type Rows struct

+ Columns []string

+ func NewRows(rows *sql.Rows, columns ...string) Rows

+ func (r Rows) Scan(dests ...interface{}) (err error)

+ func (r Rows) ScanSlice(slice interface{}) (err error)

+ func (r Rows) ScanStruct(s interface{}) (err error)

+ func (r Rows) ScanStructWithColumns(s interface{}, columns ...string) (err error)

+ type SelectBuilder struct

+ func NewSelectBuilder(column string, alias ...string) *SelectBuilder

+ func Select(column string, alias ...string) *SelectBuilder

+ func SelectColumns(columns ...Column) *SelectBuilder

+ func SelectStruct(s interface{}, table ...string) *SelectBuilder

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

+ func (b *SelectBuilder) BindRow(dest ...interface{}) error

+ func (b *SelectBuilder) BindRowContext(c context.Context, dest ...interface{}) error

+ func (b *SelectBuilder) BindRowStruct(dest interface{}) error

+ func (b *SelectBuilder) BindRowStructContext(c context.Context, dest interface{}) error

+ func (b *SelectBuilder) BindRows(slice interface{}) error

+ func (b *SelectBuilder) BindRowsContext(ctx context.Context, slice interface{}) error

+ func (b *SelectBuilder) Build() (sql string, args []interface{})

+ func (b *SelectBuilder) Distinct() *SelectBuilder

+ func (b *SelectBuilder) From(table string, alias ...string) *SelectBuilder

+ func (b *SelectBuilder) FromTable(table Table, alias ...string) *SelectBuilder

+ func (b *SelectBuilder) FromTables(tables ...Table) *SelectBuilder

+ func (b *SelectBuilder) Froms(tables ...string) *SelectBuilder

+ func (b *SelectBuilder) GetExecutor() Executor

+ func (b *SelectBuilder) GroupBy(columns ...string) *SelectBuilder

+ func (b *SelectBuilder) Having(exprs ...string) *SelectBuilder

+ func (b *SelectBuilder) Join(table, alias string, ons ...JoinOn) *SelectBuilder

+ func (b *SelectBuilder) JoinFull(table, alias string, ons ...JoinOn) *SelectBuilder

+ func (b *SelectBuilder) JoinFullOuter(table, alias string, ons ...JoinOn) *SelectBuilder

+ func (b *SelectBuilder) JoinLeft(table, alias string, ons ...JoinOn) *SelectBuilder

+ func (b *SelectBuilder) JoinLeftOuter(table, alias string, ons ...JoinOn) *SelectBuilder

+ func (b *SelectBuilder) JoinRight(table, alias string, ons ...JoinOn) *SelectBuilder

+ func (b *SelectBuilder) JoinRightOuter(table, alias string, ons ...JoinOn) *SelectBuilder

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

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

+ func (b *SelectBuilder) OrderBy(column string, order Order) *SelectBuilder

+ func (b *SelectBuilder) OrderByAsc(column string) *SelectBuilder

+ func (b *SelectBuilder) OrderByDesc(column string) *SelectBuilder

+ func (b *SelectBuilder) Paginate(pageNum, pageSize int64) *SelectBuilder

+ func (b *SelectBuilder) Query() (Rows, error)

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

+ func (b *SelectBuilder) QueryRow() Row

+ func (b *SelectBuilder) QueryRowContext(ctx context.Context) Row

+ func (b *SelectBuilder) Select(column string, alias ...string) *SelectBuilder

+ func (b *SelectBuilder) SelectColumns(columns ...Column) *SelectBuilder

+ func (b *SelectBuilder) SelectStruct(s interface{}, table ...string) *SelectBuilder

+ func (b *SelectBuilder) SelectedColumns() []string

+ func (b *SelectBuilder) SelectedFullColumns() []string

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

+ func (b *SelectBuilder) SetDB(db *DB) *SelectBuilder

+ func (b *SelectBuilder) SetDialect(dialect Dialect) *SelectBuilder

+ func (b *SelectBuilder) SetExecutor(exec Executor) *SelectBuilder

+ func (b *SelectBuilder) SetInterceptor(f Interceptor) *SelectBuilder

+ func (b *SelectBuilder) String() string

+ func (b *SelectBuilder) Where(andConditions ...Condition) *SelectBuilder

+ func (b *SelectBuilder) WhereNamedArgs(args ...sql.NamedArg) *SelectBuilder

+ type Setter interface

+ BuildSetter func(*ArgsBuilder) string

+ type SetterSet struct

+ func (s SetterSet) Add(column string, value interface{}) ColumnSetter

+ func (s SetterSet) Assign(column string, value interface{}) ColumnSetter

+ func (s SetterSet) Dec(column string) ColumnSetter

+ func (s SetterSet) Div(column string, value interface{}) ColumnSetter

+ func (s SetterSet) Inc(column string) ColumnSetter

+ func (s SetterSet) Mul(column string, value interface{}) ColumnSetter

+ func (s SetterSet) Set(column string, value interface{}) ColumnSetter

+ func (s SetterSet) Sub(column string, value interface{}) ColumnSetter

+ type Table struct

+ Name string

+ func NewTable(name string) Table

+ func (t *Table) SetDB(db *DB)

+ func (t Table) CreateTable() *TableBuilder

+ func (t Table) DeleteFrom(conds ...Condition) *DeleteBuilder

+ func (t Table) GetDB() *DB

+ func (t Table) InsertInto() *InsertBuilder

+ func (t Table) NewColumn(colName string) Column

+ func (t Table) Select(column string, alias ...string) *SelectBuilder

+ func (t Table) SelectColumns(columns ...Column) *SelectBuilder

+ func (t Table) SelectStruct(s interface{}, table ...string) *SelectBuilder

+ func (t Table) Selects(columns ...string) *SelectBuilder

+ func (t Table) Update(setters ...Setter) *UpdateBuilder

+ func (t Table) WithDB(db *DB) Table

+ type TableBuilder struct

+ func NewTableBuilder(table string) *TableBuilder

+ func (b *TableBuilder) Build() (sql string, args []interface{})

+ func (b *TableBuilder) Define(colName, colType string, colOpts ...interface{}) *TableBuilder

+ func (b *TableBuilder) Exec() (sql.Result, error)

+ func (b *TableBuilder) ExecContext(ctx context.Context) (sql.Result, error)

+ func (b *TableBuilder) IfNotExist() *TableBuilder

+ func (b *TableBuilder) Option(options ...string) *TableBuilder

+ func (b *TableBuilder) SetDB(db *DB) *TableBuilder

+ func (b *TableBuilder) SetDialect(dialect Dialect) *TableBuilder

+ func (b *TableBuilder) SetExecutor(exec Executor) *TableBuilder

+ func (b *TableBuilder) SetInterceptor(f Interceptor) *TableBuilder

+ func (b *TableBuilder) String() string

+ func (b *TableBuilder) Temporary() *TableBuilder

+ type Time struct

+ Layout string

+ func Now() Time

+ func (t *Time) Scan(src interface{}) (err error)

+ func (t *Time) SetFormat(layout string)

+ func (t Time) MarshalJSON() ([]byte, error)

+ func (t Time) String() string

+ func (t Time) Value() (driver.Value, error)

+ type UpdateBuilder struct

+ func NewUpdateBuilder(table ...string) *UpdateBuilder

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

+ func (b *UpdateBuilder) Build() (sql string, args []interface{})

+ func (b *UpdateBuilder) Exec() (sql.Result, error)

+ func (b *UpdateBuilder) ExecContext(ctx context.Context) (sql.Result, error)

+ func (b *UpdateBuilder) From(table string, alias ...string) *UpdateBuilder

+ func (b *UpdateBuilder) JoinFull(table, alias string, ons ...JoinOn) *UpdateBuilder

+ func (b *UpdateBuilder) JoinFullOuter(table, alias string, ons ...JoinOn) *UpdateBuilder

+ func (b *UpdateBuilder) JoinLeft(table, alias string, ons ...JoinOn) *UpdateBuilder

+ func (b *UpdateBuilder) JoinLeftOuter(table, alias string, ons ...JoinOn) *UpdateBuilder

+ func (b *UpdateBuilder) JoinRight(table, alias string, ons ...JoinOn) *UpdateBuilder

+ func (b *UpdateBuilder) JoinRightOuter(table, alias string, ons ...JoinOn) *UpdateBuilder

+ func (b *UpdateBuilder) Set(setters ...Setter) *UpdateBuilder

+ func (b *UpdateBuilder) SetDB(db *DB) *UpdateBuilder

+ func (b *UpdateBuilder) SetDialect(dialect Dialect) *UpdateBuilder

+ func (b *UpdateBuilder) SetExecutor(exec Executor) *UpdateBuilder

+ func (b *UpdateBuilder) SetInterceptor(f Interceptor) *UpdateBuilder

+ func (b *UpdateBuilder) SetNamedArg(args ...sql.NamedArg) *UpdateBuilder

+ func (b *UpdateBuilder) String() string

+ func (b *UpdateBuilder) Table(table string, alias ...string) *UpdateBuilder

+ func (b *UpdateBuilder) Where(andConditions ...Condition) *UpdateBuilder

+ func (b *UpdateBuilder) WhereNamedArgs(args ...sql.NamedArg) *UpdateBuilder