Versions in this module Expand all Collapse all v1 v1.0.1 May 18, 2023 v1.0.0 Nov 10, 2022 Changes in this version + func As(ident string, as string) string + func Asc(column string) string + func Avg(ident string) string + func Count(ident string) string + func Desc(column string) string + func Distinct(idents ...string) string + func GetSoftDelete() bool + func Lower(ident string) string + func Max(ident string) string + func Min(ident string) string + func ScanInt(rows ColumnScanner) (int, error) + func ScanInt64(rows ColumnScanner) (int64, error) + func ScanOne(rows ColumnScanner, v interface{}) error + func ScanSlice(rows ColumnScanner, v interface{}) error + func ScanString(rows ColumnScanner) (string, error) + func ScanValue(rows ColumnScanner) (driver.Value, error) + func SetSoftDelete(value bool) + func Sum(ident string) string + type Builder struct + func (b *Builder) AddError(err error) *Builder + func (b *Builder) Arg(a interface{}) *Builder + func (b *Builder) Args(a ...interface{}) *Builder + func (b *Builder) Comma() *Builder + func (b *Builder) Err() error + func (b *Builder) Ident(s string) *Builder + func (b *Builder) IdentComma(s ...string) *Builder + func (b *Builder) Join(qs ...Querier) *Builder + func (b *Builder) JoinComma(qs ...Querier) *Builder + func (b *Builder) Len() int + func (b *Builder) Nested(f func(*Builder)) *Builder + func (b *Builder) Pad() *Builder + func (b *Builder) Quote(ident string) string + func (b *Builder) Reset() *Builder + func (b *Builder) SetDialect(dialect string) + func (b *Builder) SetTotal(total int) + func (b *Builder) String() string + func (b *Builder) WriteByte(c byte) *Builder + func (b *Builder) WriteOp(op Op) *Builder + func (b *Builder) WriteString(s string) *Builder + func (b Builder) Dialect() string + func (b Builder) Query() (string, []interface{}) + func (b Builder) Total() int + type ColumnBuilder struct + func Column(name string) *ColumnBuilder + func (c *ColumnBuilder) Attr(attr string) *ColumnBuilder + func (c *ColumnBuilder) Check(check func(*Builder)) *ColumnBuilder + func (c *ColumnBuilder) Constraint(fk *ForeignKeyBuilder) *ColumnBuilder + func (c *ColumnBuilder) Query() (string, []interface{}) + func (c *ColumnBuilder) Remark(r string) *ColumnBuilder + func (c *ColumnBuilder) Type(t string) *ColumnBuilder + type ColumnScanner interface + Close func() error + ColumnTypes func() ([]*sql.ColumnType, error) + Columns func() ([]string, error) + Err func() error + Next func() bool + NextResultSet func() bool + Scan func(dest ...interface{}) error + type ConflictOption func(*conflict) + func ConflictColumns(names ...string) ConflictOption + func ConflictConstraint(name string) ConflictOption + func ConflictWhere(p *Predicate) ConflictOption + func DoNothing() ConflictOption + func ResolveWith(fn func(*UpdateSet)) ConflictOption + func ResolveWithIgnore() ConflictOption + func ResolveWithNewValues() ConflictOption + func UpdateWhere(p *Predicate) ConflictOption + type Conn struct + func (c Conn) Exec(ctx context.Context, query string, args, v interface{}) error + func (c Conn) Query(ctx context.Context, query string, args, v interface{}) error + type DeleteBuilder struct + func Delete(table string) *DeleteBuilder + func (d *DeleteBuilder) FromSelect(s *Selector) *DeleteBuilder + func (d *DeleteBuilder) Query() (string, []interface{}) + func (d *DeleteBuilder) Schema(name string) *DeleteBuilder + func (d *DeleteBuilder) SetUpdateUser(u *uint64) *DeleteBuilder + func (d *DeleteBuilder) Where(p *Predicate) *DeleteBuilder + type DescribeBuilder struct + func Describe(name string) *DescribeBuilder + func (t *DescribeBuilder) Query() (string, []interface{}) + type DialectBuilder struct + func Dialect(name string) *DialectBuilder + func (d *DialectBuilder) AlterIndex(name string) *IndexAlter + func (d *DialectBuilder) AlterTable(name string) *TableAlter + func (d *DialectBuilder) Column(name string) *ColumnBuilder + func (d *DialectBuilder) CreateIndex(name string) *IndexBuilder + func (d *DialectBuilder) CreateTable(name string) *TableBuilder + func (d *DialectBuilder) Delete(table string) *DeleteBuilder + func (d *DialectBuilder) Describe(name string) *DescribeBuilder + func (d *DialectBuilder) DropIndex(name string) *DropIndexBuilder + func (d *DialectBuilder) Insert(table string) *InsertBuilder + func (d *DialectBuilder) Select(columns ...string) *Selector + func (d *DialectBuilder) SelectExpr(exprs ...Querier) *Selector + func (d *DialectBuilder) Table(name string) *SelectTable + func (d *DialectBuilder) Update(table string) *UpdateBuilder + func (d *DialectBuilder) With(name string) *WithBuilder + type Driver struct + func Open(driver, source string) (*Driver, error) + func OpenDB(driver string, db *sql.DB) *Driver + func (d *Driver) BeginTx(ctx context.Context, opts *TxOptions) (dialect.Tx, error) + func (d *Driver) Close() error + func (d *Driver) Tx(ctx context.Context) (dialect.Tx, error) + func (d Driver) DB() *sql.DB + func (d Driver) Dialect() string + type DropIndexBuilder struct + func DropIndex(name string) *DropIndexBuilder + func (d *DropIndexBuilder) Query() (string, []interface{}) + func (d *DropIndexBuilder) Table(table string) *DropIndexBuilder + type ExecQuerier 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) + type ForeignKeyBuilder struct + func ForeignKey(symbol ...string) *ForeignKeyBuilder + func (fk *ForeignKeyBuilder) Columns(s ...string) *ForeignKeyBuilder + func (fk *ForeignKeyBuilder) OnDelete(action string) *ForeignKeyBuilder + func (fk *ForeignKeyBuilder) OnUpdate(action string) *ForeignKeyBuilder + func (fk *ForeignKeyBuilder) Query() (string, []interface{}) + func (fk *ForeignKeyBuilder) Reference(r *ReferenceBuilder) *ForeignKeyBuilder + func (fk *ForeignKeyBuilder) Symbol(s string) *ForeignKeyBuilder + type Func struct + func (f *Func) Append(fn func(*Builder)) *Func + func (f *Func) Avg(ident string) + func (f *Func) Count(ident string) + func (f *Func) Lower(ident string) + func (f *Func) Max(ident string) + func (f *Func) Min(ident string) + func (f *Func) String() string + func (f *Func) Sum(ident string) + type IndexAlter struct + Queries []Querier + func AlterIndex(name string) *IndexAlter + func (i *IndexAlter) Query() (string, []interface{}) + func (i *IndexAlter) Rename(name string) *IndexAlter + type IndexBuilder struct + func CreateIndex(name string) *IndexBuilder + func (i *IndexBuilder) Column(column string) *IndexBuilder + func (i *IndexBuilder) Columns(columns ...string) *IndexBuilder + func (i *IndexBuilder) IfNotExists() *IndexBuilder + func (i *IndexBuilder) Query() (string, []interface{}) + func (i *IndexBuilder) Table(table string) *IndexBuilder + func (i *IndexBuilder) Unique() *IndexBuilder + func (i *IndexBuilder) Using(method string) *IndexBuilder + type InsertBuilder struct + func Insert(table string) *InsertBuilder + func (i *InsertBuilder) Columns(columns ...string) *InsertBuilder + func (i *InsertBuilder) Default() *InsertBuilder + func (i *InsertBuilder) OnConflict(opts ...ConflictOption) *InsertBuilder + func (i *InsertBuilder) Query() (string, []interface{}) + func (i *InsertBuilder) Returning(columns ...string) *InsertBuilder + func (i *InsertBuilder) Schema(name string) *InsertBuilder + func (i *InsertBuilder) Set(column string, v interface{}) *InsertBuilder + func (i *InsertBuilder) Values(values ...interface{}) *InsertBuilder + type LockAction string + const NoWait + const SkipLocked + type LockOption func(*LockOptions) + func WithLockAction(action LockAction) LockOption + func WithLockClause(clause string) LockOption + func WithLockTables(tables ...string) LockOption + type LockOptions struct + Action LockAction + Strength LockStrength + Tables []string + type LockStrength string + const LockKeyShare + const LockNoKeyUpdate + const LockShare + const LockUpdate + type NullBool = sql.NullBool + type NullFloat64 = sql.NullFloat64 + type NullInt64 = sql.NullInt64 + type NullScanner struct + S sql.Scanner + Valid bool + func (n *NullScanner) Scan(value interface{}) error + type NullString = sql.NullString + type NullTime = sql.NullTime + type Op int + const OpAdd + const OpDiv + const OpEQ + const OpGT + const OpGTE + const OpIn + const OpIsNull + const OpLT + const OpLTE + const OpLike + const OpMod + const OpMul + const OpNEQ + const OpNotIn + const OpNotNull + const OpSub + type ParamFormatter interface + FormatParam func(placeholder string, info *StmtInfo) string + type Predicate struct + func And(preds ...*Predicate) *Predicate + func ColumnsEQ(col1, col2 string) *Predicate + func ColumnsGT(col1, col2 string) *Predicate + func ColumnsGTE(col1, col2 string) *Predicate + func ColumnsLT(col1, col2 string) *Predicate + func ColumnsLTE(col1, col2 string) *Predicate + func ColumnsNEQ(col1, col2 string) *Predicate + func ColumnsOp(col1, col2 string, op Op) *Predicate + func CompositeGT(columns []string, args ...interface{}) *Predicate + func CompositeLT(columns []string, args ...interface{}) *Predicate + func Contains(col, sub string) *Predicate + func ContainsFold(col, sub string) *Predicate + func EQ(col string, value interface{}) *Predicate + func EqualFold(col, sub string) *Predicate + func Exists(query Querier) *Predicate + func ExprP(exr string, args ...interface{}) *Predicate + func False() *Predicate + func GT(col string, value interface{}) *Predicate + func GTE(col string, value interface{}) *Predicate + func HasPrefix(col, prefix string) *Predicate + func HasSuffix(col, suffix string) *Predicate + func In(col string, args ...interface{}) *Predicate + func InInts(col string, args ...int) *Predicate + func InValues(col string, args ...driver.Value) *Predicate + func IsNull(col string) *Predicate + func LT(col string, value interface{}) *Predicate + func LTE(col string, value interface{}) *Predicate + func Like(col, pattern string) *Predicate + func NEQ(col string, value interface{}) *Predicate + func Not(pred *Predicate) *Predicate + func NotExists(query Querier) *Predicate + func NotIn(col string, args ...interface{}) *Predicate + func NotNull(col string) *Predicate + func Or(preds ...*Predicate) *Predicate + func P(fns ...func(*Builder)) *Predicate + func (p *Predicate) Append(f func(*Builder)) *Predicate + func (p *Predicate) ColumnsEQ(col1, col2 string) *Predicate + func (p *Predicate) ColumnsGT(col1, col2 string) *Predicate + func (p *Predicate) ColumnsGTE(col1, col2 string) *Predicate + func (p *Predicate) ColumnsLT(col1, col2 string) *Predicate + func (p *Predicate) ColumnsLTE(col1, col2 string) *Predicate + func (p *Predicate) ColumnsNEQ(col1, col2 string) *Predicate + func (p *Predicate) ColumnsOp(col1, col2 string, op Op) *Predicate + func (p *Predicate) CompositeGT(columns []string, args ...interface{}) *Predicate + func (p *Predicate) CompositeLT(columns []string, args ...interface{}) *Predicate + func (p *Predicate) Contains(col, substr string) *Predicate + func (p *Predicate) ContainsFold(col, substr string) *Predicate + func (p *Predicate) EQ(col string, arg interface{}) *Predicate + func (p *Predicate) EqualFold(col, sub string) *Predicate + func (p *Predicate) Exists(query Querier) *Predicate + func (p *Predicate) False() *Predicate + func (p *Predicate) GT(col string, arg interface{}) *Predicate + func (p *Predicate) GTE(col string, arg interface{}) *Predicate + func (p *Predicate) HasPrefix(col, prefix string) *Predicate + func (p *Predicate) HasSuffix(col, suffix string) *Predicate + func (p *Predicate) In(col string, args ...interface{}) *Predicate + func (p *Predicate) InInts(col string, args ...int) *Predicate + func (p *Predicate) InValues(col string, args ...driver.Value) *Predicate + func (p *Predicate) IsNull(col string) *Predicate + func (p *Predicate) LT(col string, arg interface{}) *Predicate + func (p *Predicate) LTE(col string, arg interface{}) *Predicate + func (p *Predicate) Like(col, pattern string) *Predicate + func (p *Predicate) NEQ(col string, arg interface{}) *Predicate + func (p *Predicate) Not() *Predicate + func (p *Predicate) NotExists(query Querier) *Predicate + func (p *Predicate) NotIn(col string, args ...interface{}) *Predicate + func (p *Predicate) NotNull(col string) *Predicate + func (p *Predicate) Query() (string, []interface{}) + type Querier interface + Query func() (string, []interface{}) + func Expr(exr string, args ...interface{}) Querier + func ExprFunc(fn func(*Builder)) Querier + func Raw(s string) Querier + type Queries []Querier + func (n Queries) Query() (string, []interface{}) + type ReferenceBuilder struct + func Reference() *ReferenceBuilder + func (r *ReferenceBuilder) Columns(s ...string) *ReferenceBuilder + func (r *ReferenceBuilder) Query() (string, []interface{}) + func (r *ReferenceBuilder) Table(s string) *ReferenceBuilder + type Result = sql.Result + type Rows struct + type SelectTable struct + func Table(name string) *SelectTable + func (s *SelectTable) As(alias string) *SelectTable + func (s *SelectTable) C(column string) string + func (s *SelectTable) Columns(columns ...string) []string + func (s *SelectTable) Schema(name string) *SelectTable + func (s *SelectTable) Unquote() *SelectTable + type Selector struct + func Select(columns ...string) *Selector + func SelectExpr(exprs ...Querier) *Selector + func (s *Selector) AppendSelect(columns ...string) *Selector + func (s *Selector) AppendSelectExpr(exprs ...Querier) *Selector + func (s *Selector) As(alias string) *Selector + func (s *Selector) C(column string) string + func (s *Selector) Clone() *Selector + func (s *Selector) Columns(columns ...string) []string + func (s *Selector) Context() context.Context + func (s *Selector) Count(columns ...string) *Selector + func (s *Selector) Distinct() *Selector + func (s *Selector) For(l LockStrength, opts ...LockOption) *Selector + func (s *Selector) ForShare(opts ...LockOption) *Selector + func (s *Selector) ForUpdate(opts ...LockOption) *Selector + func (s *Selector) From(t TableView) *Selector + func (s *Selector) FromSelect(s2 *Selector) *Selector + func (s *Selector) GroupBy(columns ...string) *Selector + func (s *Selector) Having(p *Predicate) *Selector + func (s *Selector) Join(t TableView) *Selector + func (s *Selector) LeftJoin(t TableView) *Selector + func (s *Selector) Limit(limit int) *Selector + func (s *Selector) Not() *Selector + func (s *Selector) Offset(offset int) *Selector + func (s *Selector) On(c1, c2 string) *Selector + func (s *Selector) OnP(p *Predicate) *Selector + func (s *Selector) Or() *Selector + func (s *Selector) OrderBy(columns ...string) *Selector + func (s *Selector) OrderExpr(exprs ...Querier) *Selector + func (s *Selector) P() *Predicate + func (s *Selector) Prefix(queries ...Querier) *Selector + func (s *Selector) Query() (string, []interface{}) + func (s *Selector) RightJoin(t TableView) *Selector + func (s *Selector) Select(columns ...string) *Selector + func (s *Selector) SelectExpr(exprs ...Querier) *Selector + func (s *Selector) SelectedColumns() []string + func (s *Selector) SetDistinct(v bool) *Selector + func (s *Selector) SetP(p *Predicate) *Selector + func (s *Selector) Table() *SelectTable + func (s *Selector) TableName() string + func (s *Selector) Union(t TableView) *Selector + func (s *Selector) UnionAll(t TableView) *Selector + func (s *Selector) UnionDistinct(t TableView) *Selector + func (s *Selector) Where(p *Predicate) *Selector + func (s *Selector) WithContext(ctx context.Context) *Selector + type StmtInfo struct + Dialect string + type TableAlter struct + Queries []Querier + func AlterTable(name string) *TableAlter + func (t *TableAlter) AddColumn(c *ColumnBuilder) *TableAlter + func (t *TableAlter) AddForeignKey(fk *ForeignKeyBuilder) *TableAlter + func (t *TableAlter) AddIndex(idx *IndexBuilder) *TableAlter + func (t *TableAlter) ChangeColumn(name string, c *ColumnBuilder) *TableAlter + func (t *TableAlter) DropColumn(c *ColumnBuilder) *TableAlter + func (t *TableAlter) DropConstraint(ident string) *TableAlter + func (t *TableAlter) DropForeignKey(ident string) *TableAlter + func (t *TableAlter) DropIndex(name string) *TableAlter + func (t *TableAlter) ModifyColumn(c *ColumnBuilder) *TableAlter + func (t *TableAlter) ModifyColumns(cs ...*ColumnBuilder) *TableAlter + func (t *TableAlter) Query() (string, []interface{}) + func (t *TableAlter) RenameColumn(old, new string) *TableAlter + func (t *TableAlter) RenameIndex(curr, new string) *TableAlter + type TableBuilder struct + func CreateTable(name string) *TableBuilder + func (t *TableBuilder) Charset(s string) *TableBuilder + func (t *TableBuilder) Checks(checks ...func(*Builder)) *TableBuilder + func (t *TableBuilder) Collate(s string) *TableBuilder + func (t *TableBuilder) Column(c *ColumnBuilder) *TableBuilder + func (t *TableBuilder) Columns(columns ...*ColumnBuilder) *TableBuilder + func (t *TableBuilder) Constraints(fks ...*ForeignKeyBuilder) *TableBuilder + func (t *TableBuilder) ForeignKeys(fks ...*ForeignKeyBuilder) *TableBuilder + func (t *TableBuilder) IfNotExists() *TableBuilder + func (t *TableBuilder) Options(s string) *TableBuilder + func (t *TableBuilder) PrimaryKey(column ...string) *TableBuilder + func (t *TableBuilder) Query() (string, []interface{}) + func (t *TableBuilder) Remark(r string) *TableBuilder + type TableView interface + type Tx struct + type TxOptions = sql.TxOptions + type UpdateBuilder struct + func Update(table string) *UpdateBuilder + func (u *UpdateBuilder) Add(column string, v interface{}) *UpdateBuilder + func (u *UpdateBuilder) Empty() bool + func (u *UpdateBuilder) FromSelect(s *Selector) *UpdateBuilder + func (u *UpdateBuilder) Query() (string, []interface{}) + func (u *UpdateBuilder) Schema(name string) *UpdateBuilder + func (u *UpdateBuilder) Set(column string, v interface{}) *UpdateBuilder + func (u *UpdateBuilder) SetNull(column string) *UpdateBuilder + func (u *UpdateBuilder) Where(p *Predicate) *UpdateBuilder + type UpdateSet struct + func (u *UpdateSet) Add(column string, v interface{}) *UpdateSet + func (u *UpdateSet) Columns() []string + func (u *UpdateSet) Set(column string, v interface{}) *UpdateSet + func (u *UpdateSet) SetExcluded(name string) *UpdateSet + func (u *UpdateSet) SetIgnore(name string) *UpdateSet + func (u *UpdateSet) SetNull(column string) *UpdateSet + func (u *UpdateSet) Table() *SelectTable + func (u *UpdateSet) UpdateColumns() []string + type WithBuilder struct + func With(name string, columns ...string) *WithBuilder + func WithRecursive(name string, columns ...string) *WithBuilder + func (w *WithBuilder) As(s *Selector) *WithBuilder + func (w *WithBuilder) C(column string) string + func (w *WithBuilder) Name() string + func (w *WithBuilder) Query() (string, []interface{}) + type Wrapper struct + func (w *Wrapper) Dialect() string + func (w *Wrapper) Query() (string, []interface{}) + func (w *Wrapper) SetDialect(name string) + func (w *Wrapper) SetTotal(total int) + func (w *Wrapper) Total() int