sql

package

Go to main page

Versions in this module

v0

v0.14.1

Aug 23, 2024

v0.14.0

Jul 28, 2024

Changes in this version

+ func WithIntVar(ctx context.Context, name string, value int) context.Context

+ func WithVar(ctx context.Context, name, value string) context.Context

type Selector

+ func (s *Selector) New() *Selector

+ func (s *Selector) SelectDistinct(columns ...string) *Selector

v0.13.1

Feb 26, 2024

v0.13.0

Feb 7, 2024

v0.12.5

Nov 13, 2023

v0.12.4

Sep 18, 2023

Changes in this version

+ func AndPredicates(predicates ...P) func(*Selector)

+ func FieldsHasPrefix(field1, field2 string) func(*Selector)

+ func NotPredicates(predicates ...P) func(*Selector)

+ func OrPredicates(predicates ...P) func(*Selector)

+ func OrderByRand() func(*Selector)

type Predicate

+ func ColumnsHasPrefix(col, prefixC string) *Predicate

+ func (p *Predicate) ColumnsHasPrefix(col, prefixC string) *Predicate

type Selector

+ func (s *Selector) CollectPredicates() *Selector

+ func (s *Selector) CollectedPredicates() []*Predicate

+ func (s *Selector) UncollectedPredicates() *Selector

v0.12.3

May 1, 2023

v0.12.2

Apr 20, 2023

v0.12.1

Apr 16, 2023

Changes in this version

type Selector

+ func (s *Selector) FindSelection(name string) (matches []string)

v0.12.0

Apr 9, 2023

Changes in this version

+ func FieldsGT(field1, field2 string) func(*Selector)

+ func FieldsGTE(field1, field2 string) func(*Selector)

+ func FieldsLT(field1, field2 string) func(*Selector)

+ func FieldsLTE(field1, field2 string) func(*Selector)

+ func ScanTypeOf(rows *Rows, i int) any

type Builder

+ func (b *Builder) S(s string) *Builder

+ type ColumnCheck func(table, column string) error

+ func NewColumnCheck(checks map[string]func(string) bool) ColumnCheck

type DialectBuilder

+ func (d *DialectBuilder) Expr(f func(*Builder)) Querier

+ func (d *DialectBuilder) String(f func(*Builder)) string

+ type OrderExprTerm struct

+ Expr func(*Selector) Querier

+ func OrderByCount(field string, opts ...OrderTermOption) *OrderExprTerm

+ func OrderBySum(field string, opts ...OrderTermOption) *OrderExprTerm

+ type OrderFieldTerm struct

+ Field string

+ func OrderByField(field string, opts ...OrderTermOption) *OrderFieldTerm

+ func (f *OrderFieldTerm) ToFunc() func(*Selector)

+ type OrderTerm interface

+ type OrderTermOption func(*OrderTermOptions)

+ func OrderAs(as string) OrderTermOption

+ func OrderAsc() OrderTermOption

+ func OrderDesc() OrderTermOption

+ func OrderNullsFirst() OrderTermOption

+ func OrderNullsLast() OrderTermOption

+ func OrderSelectAs(as string) OrderTermOption

+ func OrderSelected() OrderTermOption

+ type OrderTermOptions struct

+ As string

+ Desc bool

+ NullsFirst bool

+ NullsLast bool

+ Selected bool

+ func NewOrderTermOptions(opts ...OrderTermOption) *OrderTermOptions

+ type SelectValues map[string]any

+ func (s *SelectValues) Set(name string, v any)

+ func (s SelectValues) Get(name string) (any, error)

type Selector

+ func (s *Selector) AppendSelectAs(column, as string) *Selector

+ func (s *Selector) HasJoins() bool

+ func (s *Selector) JoinedTable(name string) (*SelectTable, bool)

+ func (s *Selector) JoinedTableView(name string) (TableView, bool)

+ func (s *Selector) OrderExprFunc(f func(*Builder)) *Selector

type TableView

+ C func(string) string

+ type UnknownType any

v0.11.10

Mar 12, 2023

v0.11.9

Mar 1, 2023

v0.11.8

Feb 12, 2023

Changes in this version

type InsertBuilder

+ func (i *InsertBuilder) QueryErr() (string, []any, error)

type Querier

+ func DescExpr(x Querier) Querier

v0.11.7

Jan 24, 2023

v0.11.6

Jan 19, 2023

Changes in this version

type Selector

+ func (s *Selector) ClearOrder() *Selector

v0.11.5

Jan 6, 2023

Changes in this version

+ func FieldContains(name string, substr string) func(*Selector)

+ func FieldContainsFold(name string, substr string) func(*Selector)

+ func FieldEQ(name string, v any) func(*Selector)

+ func FieldEqualFold(name string, substr string) func(*Selector)

+ func FieldGT(name string, v any) func(*Selector)

+ func FieldGTE(name string, v any) func(*Selector)

+ func FieldHasPrefix(name string, prefix string) func(*Selector)

+ func FieldHasSuffix(name string, suffix string) func(*Selector)

+ func FieldIn(name string, vs ...T) func(*Selector)

+ func FieldIsNull(name string) func(*Selector)

+ func FieldLT(name string, v any) func(*Selector)

+ func FieldLTE(name string, v any) func(*Selector)

+ func FieldNEQ(name string, v any) func(*Selector)

+ func FieldNotIn(name string, vs ...T) func(*Selector)

+ func FieldNotNull(name string) func(*Selector)

+ func FieldsEQ(field1, field2 string) func(*Selector)

+ func FieldsNEQ(field1, field2 string) func(*Selector)

type Selector

+ func (s *Selector) Except(t TableView) *Selector

+ func (s *Selector) ExceptAll(t TableView) *Selector

+ func (s *Selector) Intersect(t TableView) *Selector

+ func (s *Selector) IntersectAll(t TableView) *Selector

v0.11.4

Oct 29, 2022

Changes in this version

type Builder

+ func (b *Builder) Argf(format string, a any) *Builder

+ func (b *Builder) Wrap(f func(*Builder)) *Builder

type UpdateBuilder

+ func (u *UpdateBuilder) Limit(limit int) *UpdateBuilder

+ func (u *UpdateBuilder) Returning(columns ...string) *UpdateBuilder

type WindowBuilder

+ func Window(fn func(*Builder)) *WindowBuilder

v0.11.3

Sep 28, 2022

Changes in this version

type Selector

+ func (s *Selector) AppendFrom(t TableView) *Selector

+ func (s *Selector) AppendFromExpr(x Querier) *Selector

+ func (s *Selector) FromExpr(x Querier) *Selector

+ func (s *Selector) FullJoin(t TableView) *Selector

type UpdateBuilder

+ func (u *UpdateBuilder) Prefix(stmts ...Querier) *UpdateBuilder

v0.11.2

Aug 5, 2022

Changes in this version

type UpdateBuilder

+ func (u *UpdateBuilder) OrderBy(columns ...string) *UpdateBuilder

v0.11.1

Jul 14, 2022

v0.11.0

Jul 13, 2022

Changes in this version

+ func ScanBool(rows ColumnScanner) (bool, error)

type Driver

+ func NewDriver(dialect string, c Conn) *Driver

type Predicate

+ func IsFalse(col string) *Predicate

+ func IsTrue(col string) *Predicate

+ func (p *Predicate) IsFalse(col string) *Predicate

+ func (p *Predicate) IsTrue(col string) *Predicate

type Selector

+ func (s *Selector) AppendSelectExprAs(expr Querier, as string) *Selector

+ func (s *Selector) OrderColumns() []string

+ func (s *Selector) UnqualifiedColumns() []string

+ type WindowBuilder struct

+ func RowNumber() *WindowBuilder

+ func (w *WindowBuilder) OrderBy(columns ...string) *WindowBuilder

+ func (w *WindowBuilder) OrderExpr(exprs ...Querier) *WindowBuilder

+ func (w *WindowBuilder) PartitionBy(columns ...string) *WindowBuilder

+ func (w *WindowBuilder) PartitionExpr(x Querier) *WindowBuilder

+ func (w *WindowBuilder) Query() (string, []interface{})

type WithBuilder

+ func (w *WithBuilder) With(name string, columns ...string) *WithBuilder

v0.10.1

Mar 4, 2022

v0.10.0

Jan 20, 2022

Changes in this version

type ColumnScanner

+ Close func() error

+ ColumnTypes func() ([]*sql.ColumnType, error)

+ NextResultSet func() bool

type DialectBuilder

+ func (d *DialectBuilder) SelectExpr(exprs ...Querier) *Selector

type Selector

+ func SelectExpr(exprs ...Querier) *Selector

+ func (s *Selector) AppendSelectExpr(exprs ...Querier) *Selector

+ func (s *Selector) SelectExpr(exprs ...Querier) *Selector

type UpdateSet

+ func (u *UpdateSet) Add(column string, v interface{}) *UpdateSet

v0.9.1

Aug 17, 2021

Changes in this version

type Predicate

+ func ColumnsOp(col1, col2 string, op Op) *Predicate

+ func (p *Predicate) ColumnsOp(col1, col2 string, op Op) *Predicate

type UpdateSet

+ func (u *UpdateSet) SetIgnore(name string) *UpdateSet

v0.9.0

Aug 5, 2021

Changes in this version

type Builder

+ func (b *Builder) Len() int

+ func (b *Builder) Reset() *Builder

+ func (b *Builder) String() string

+ 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 IndexBuilder

+ func (i *IndexBuilder) IfNotExists() *IndexBuilder

+ func (i *IndexBuilder) Using(method string) *IndexBuilder

+ 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 NullScanner struct

+ S sql.Scanner

+ Valid bool

+ func (n *NullScanner) Scan(value interface{}) error

type Op

+ const OpAdd

+ const OpDiv

+ const OpMod

+ const OpMul

+ const OpSub

type Predicate

+ func Exists(query Querier) *Predicate

+ func NotExists(query Querier) *Predicate

+ func (p *Predicate) Exists(query Querier) *Predicate

+ func (p *Predicate) NotExists(query Querier) *Predicate

type Querier

+ func ExprFunc(fn func(*Builder)) Querier

type Selector

+ func (s *Selector) AppendSelect(columns ...string) *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) Prefix(queries ...Querier) *Selector

+ func (s *Selector) SelectedColumns() []string

+ func (s *Selector) Union(t TableView) *Selector

+ func (s *Selector) UnionAll(t TableView) *Selector

+ func (s *Selector) UnionDistinct(t TableView) *Selector

type TableBuilder

+ func (t *TableBuilder) Checks(checks ...func(*Builder)) *TableBuilder

+ type UpdateSet struct

+ func (u *UpdateSet) Columns() []string

+ func (u *UpdateSet) Set(column string, v interface{}) *UpdateSet

+ func (u *UpdateSet) SetExcluded(name string) *UpdateSet

+ func (u *UpdateSet) SetNull(column string) *UpdateSet

+ func (u *UpdateSet) Table() *SelectTable

+ func (u *UpdateSet) UpdateColumns() []string

type WithBuilder

+ func WithRecursive(name string, columns ...string) *WithBuilder

+ func (w *WithBuilder) C(column string) string

v0.8.0

Apr 14, 2021

Changes in this version

+ type ConflictResolutionOp int

+ const OpResolveWithAlternateValues

+ const OpResolveWithIgnore

+ const OpResolveWithNewValues

type InsertBuilder

+ func (i *InsertBuilder) ConflictColumns(values ...string) *InsertBuilder

+ func (i *InsertBuilder) OnConflict(op ConflictResolutionOp) *InsertBuilder

+ func (i *InsertBuilder) UpdateSet(column string, v interface{}) *InsertBuilder

type Predicate

+ func ColumnsEQ(col1 string, col2 string) *Predicate

+ func ColumnsGT(col1 string, col2 string) *Predicate

+ func ColumnsGTE(col1 string, col2 string) *Predicate

+ func ColumnsLT(col1 string, col2 string) *Predicate

+ func ColumnsLTE(col1 string, col2 string) *Predicate

+ func ColumnsNEQ(col1 string, col2 string) *Predicate

+ func (p *Predicate) ColumnsEQ(col1 string, col2 string) *Predicate

+ func (p *Predicate) ColumnsGT(col1 string, col2 string) *Predicate

+ func (p *Predicate) ColumnsGTE(col1 string, col2 string) *Predicate

+ func (p *Predicate) ColumnsLT(col1 string, col2 string) *Predicate

+ func (p *Predicate) ColumnsLTE(col1 string, col2 string) *Predicate

+ func (p *Predicate) ColumnsNEQ(col1 string, col2 string) *Predicate

type Selector

+ func (s *Selector) TableName() string

v0.7.0

Mar 10, 2021

Changes in this version

+ type ParamFormatter interface

+ FormatParam func(placeholder string, info *StmtInfo) string

type Predicate

+ func ExprP(exr string, args ...interface{}) *Predicate

+ type StmtInfo struct

+ Dialect string

v0.6.0

Feb 2, 2021

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 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 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) Nested(f func(*Builder)) *Builder

+ func (b *Builder) Pad() *Builder

+ func (b *Builder) Quote(ident string) string

+ func (b *Builder) SetDialect(dialect string)

+ func (b *Builder) SetTotal(total int)

+ 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) Type(t string) *ColumnBuilder

+ type ColumnScanner interface

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

+ Err func() error

+ Next func() bool

+ Scan func(...interface{}) error

+ 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) 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) 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) Query() (string, []interface{})

+ func (i *IndexBuilder) Table(table string) *IndexBuilder

+ func (i *IndexBuilder) Unique() *IndexBuilder

+ type InsertBuilder struct

+ func Insert(table string) *InsertBuilder

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

+ func (i *InsertBuilder) Default() *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 NullBool = sql.NullBool

+ type NullFloat64 = sql.NullFloat64

+ type NullInt64 = sql.NullInt64

+ type NullString = sql.NullString

+ type NullTime = sql.NullTime

+ type Op int

+ const OpEQ

+ const OpGT

+ const OpGTE

+ const OpIn

+ const OpIsNull

+ const OpLT

+ const OpLTE

+ const OpLike

+ const OpNEQ

+ const OpNotIn

+ const OpNotNull

+ type Predicate struct

+ func And(preds ...*Predicate) *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 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 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) CompositeGT(columns []string, args ...interface{}) *Predicate

+ func (p *Predicate) CompositeLT(columns []string, args ...interface{}) *Predicate

+ func (p *Predicate) Contains(col, sub string) *Predicate

+ func (p *Predicate) ContainsFold(col, sub string) *Predicate

+ func (p *Predicate) EQ(col string, arg interface{}) *Predicate

+ func (p *Predicate) EqualFold(col, sub string) *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) 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 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 (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) 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) Query() (string, []interface{})

+ func (s *Selector) RightJoin(t TableView) *Selector

+ func (s *Selector) Select(columns ...string) *Selector

+ func (s *Selector) SetDistinct(v bool) *Selector

+ func (s *Selector) SetP(p *Predicate) *Selector

+ func (s *Selector) Table() *SelectTable

+ func (s *Selector) Where(p *Predicate) *Selector

+ func (s *Selector) WithContext(ctx context.Context) *Selector

+ 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) 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{})

+ 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 WithBuilder struct

+ func With(name string) *WithBuilder

+ func (w *WithBuilder) As(s *Selector) *WithBuilder

+ 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

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL