sql

package

Go to main page

Versions in this module

v0

v0.3.0

Aug 4, 2020

v0.2.7

Jul 16, 2020

v0.2.6

Jul 12, 2020

v0.2.5

Jun 17, 2020

v0.2.4

Jun 16, 2020

v0.2.3

Jun 9, 2020

v0.2.2

May 21, 2020

Changes in this version

type ColumnScanner

+ Err func() error

v0.2.1

Apr 21, 2020

v0.2.0

Apr 20, 2020

v0.1.5

Apr 19, 2020

Changes in this version

type ColumnBuilder

+ func (c *ColumnBuilder) Constraint(fk *ForeignKeyBuilder) *ColumnBuilder

v0.1.4

Mar 22, 2020

v0.1.3

Mar 7, 2020

v0.1.2

Feb 14, 2020

v0.1.1

Feb 3, 2020

Changes in this version

+ func ScanOne(rows ColumnScanner, v interface{}) error

+ func ScanString(rows ColumnScanner) (string, error)

type TableAlter

+ func (t *TableAlter) RenameColumn(old, new string) *TableAlter

v0.1.0

Jan 30, 2020

Changes in this version

+ func As(ident string, as string) string

+ func Asc(column string) string

+ func Avg(name string) string

+ func Count(name string) string

+ func Desc(column string) string

+ func Distinct(idents ...string) string

+ func Lower(name string) string

+ func Max(name string) string

+ func Min(name string) string

+ func ScanInt(rows ColumnScanner) (int, error)

+ func ScanInt64(rows ColumnScanner) (int64, error)

+ func ScanSlice(rows ColumnScanner, v interface{}) error

+ func Sum(name string) string

+ type Builder struct

+ func (b *Builder) Arg(a interface{}) *Builder

+ func (b *Builder) Args(a ...interface{}) *Builder

+ func (b *Builder) Comma() *Builder

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

+ func (c *ColumnBuilder) Type(t string) *ColumnBuilder

+ type ColumnScanner interface

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

+ Next func() bool

+ Scan func(...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) 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 (c *Driver) Exec(ctx context.Context, query string, args, v interface{}) error

+ func (c *Driver) Query(ctx context.Context, query string, args, v interface{}) error

+ 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) Avg(ident string) string

+ func (f Func) Count(ident string) string

+ func (f Func) Lower(name string) string

+ func (f Func) Max(ident string) string

+ func (f Func) Min(ident string) string

+ func (f Func) Sum(ident string) 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) 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 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() *Predicate

+ func (p *Predicate) And() *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) Or() *Predicate

+ func (p *Predicate) Query() (string, []interface{})

+ type Querier interface

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

+ 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) 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) 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) 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) Or() *Selector

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

+ func (s *Selector) P() *Predicate

+ func (s *Selector) Query() (string, []interface{})

+ 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

+ 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) 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) PrimaryKey(column ...string) *TableBuilder

+ func (t *TableBuilder) Query() (string, []interface{})

+ type TableView interface

+ type Tx struct

+ func (c *Tx) Exec(ctx context.Context, query string, args, v interface{}) error

+ func (c *Tx) Query(ctx context.Context, query string, args, v interface{}) error

+ func (t *Tx) Commit() error

+ func (t *Tx) Rollback() error

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

+ 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