Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security Policy
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

builder

package

Go to main page

Versions in this module

v1

v1.2.0

Dec 12, 2018

v1.1.2

Nov 7, 2018

v1.1.1

Oct 23, 2018

v1.1.0

Oct 23, 2018

Changes in this version

+ const SPATIAL_INDEX

type Key

+ func SpatialIndex(name string) *Key

+ type ValuerExpr interface

+ ValueEx func() string

+ type WithSpatialIndexes interface

+ SpatialIndexes func() Indexes

v1.0.9

Oct 13, 2018

v1.0.8

Oct 10, 2018

v1.0.7

Sep 20, 2018

v1.0.6

Sep 19, 2018

v1.0.5

Sep 19, 2018

v1.0.4

Sep 17, 2018

v1.0.3

Sep 17, 2018

v1.0.2

Sep 14, 2018

v1.0.1

Sep 14, 2018

v1.0.0

Aug 28, 2018

Changes in this version

+ const ALL

+ const DELAYED

+ const DISTINCT

+ const DISTINCTROW

+ const HIGH_PRIORITY

+ const IGNORE

+ const INDEX

+ const LOW_PRIORITY

+ const PRIMARY

+ const QUICK

+ const SQL_BIG_RESULT

+ const SQL_BUFFER_RESULT

+ const SQL_SMALL_RESULT

+ const STRAIGHT_JOIN

+ const UNIQUE_INDEX

+ var UpdateNeedLimitByWhere = fmt.Errorf("no where limit for update")

+ func AscOrder(expr SqlExpr) *order

+ func Comment(c string) comment

+ func DescOrder(expr SqlExpr) *order

+ func FlattenArgs(query string, args ...interface{}) (finalQuery string, finalArgs []interface{})

+ func ForEachStructField(structType reflect.Type, ...)

+ func ForEachStructFieldValue(rv reflect.Value, ...)

+ func ForUpdate() *otherAddition

+ func GroupBy(groups ...SqlExpr) *groupBy

+ func HolderRepeat(length int) string

+ func Join(table *Table, modifies ...string) *join

+ func Limit(rowCount int32) *limit

+ func LockInShareMode() *otherAddition

+ func OnDuplicateKeyUpdate(assignments ...*Assignment) *otherAddition

+ func OrderBy(orders ...*order) *orderBy

+ func ScanDefToTable(rv reflect.Value, table *Table)

+ func Where(c *Condition) *where

+ type Addition interface

+ type Additions []Addition

+ func (a Additions) Expr() *Expression

+ func (a Additions) Len() int

+ func (a Additions) Less(i, j int) bool

+ func (a Additions) Swap(i, j int)

+ type Assignment Expression

+ func ColumnsAndValues(cols Columns, values ...interface{}) *Assignment

+ func (a Assignment) Expr() *Expression

+ type Assignments []*Assignment

+ func (assigns Assignments) Expr() (e *Expression)

+ type Column struct

+ FieldName string

+ Name string

+ Table *Table

+ func Col(table *Table, columnName string) *Column

+ func (c *Column) Between(leftValue interface{}, rightValue interface{}) *Condition

+ func (c *Column) Def() *Expression

+ func (c *Column) Desc(d int) *Expression

+ func (c *Column) Eq(value interface{}) *Condition

+ func (c *Column) Expr() *Expression

+ func (c *Column) Gt(v interface{}) *Condition

+ func (c *Column) Gte(v interface{}) *Condition

+ func (c *Column) In(args ...interface{}) *Condition

+ func (c *Column) Incr(d int) *Expression

+ func (c *Column) IsNotNull() *Condition

+ func (c *Column) IsNull() *Condition

+ func (c *Column) IsValidDef() bool

+ func (c *Column) LeftLike(v string) *Condition

+ func (c *Column) Like(v string) *Condition

+ func (c *Column) Lt(v interface{}) *Condition

+ func (c *Column) Lte(v interface{}) *Condition

+ func (c *Column) Neq(v interface{}) *Condition

+ func (c *Column) NotBetween(leftValue interface{}, rightValue interface{}) *Condition

+ func (c *Column) NotIn(args ...interface{}) *Condition

+ func (c *Column) NotLike(v string) *Condition

+ func (c *Column) RightLike(v string) *Condition

+ func (c *Column) String() string

+ func (c *Column) ValueBy(v interface{}) *Assignment

+ func (c Column) Enum(enum enumeration.Enum) *Column

+ func (c Column) Field(fieldName string) *Column

+ func (c Column) Type(tpe string) *Column

+ type Columns struct

+ func Cols(t *Table, columnNames ...string) (cols Columns)

+ func (cols *Columns) Add(columns ...*Column)

+ func (cols *Columns) AutoIncrement() (col *Column)

+ func (cols *Columns) Clone() *Columns

+ func (cols *Columns) Col(columnName string) (col *Column)

+ func (cols *Columns) Cols(colNames ...string) (columns *Columns)

+ func (cols *Columns) F(fileName string) (col *Column)

+ func (cols *Columns) FieldNames() []string

+ func (cols *Columns) Fields(fieldNames ...string) (columns *Columns)

+ func (cols *Columns) IsEmpty() bool

+ func (cols *Columns) Len() int

+ func (cols *Columns) List() (l []*Column)

+ func (cols *Columns) Range(cb func(col *Column, idx int))

+ func (cols *Columns) Remove(name string)

+ func (cols Columns) Diff(targetCols Columns) columnsDiffResult

+ func (cols Columns) Expr() (e *Expression)

+ func (cols Columns) Group() (e *Expression)

+ type CondRule struct

+ Conditions []*Condition

+ When bool

+ type CondRules struct

+ func NewCondRules() *CondRules

+ func (rules *CondRules) ToCond() *Condition

+ func (rules *CondRules) When(rule bool, conditions ...*Condition) *CondRules

+ type Condition Expression

+ func And(condList ...*Condition) (cond *Condition)

+ func Or(condList ...*Condition) (cond *Condition)

+ func Xor(condList ...*Condition) (cond *Condition)

+ func (c *Condition) Expr() *Expression

+ func (c Condition) And(cond *Condition) *Condition

+ func (c Condition) Or(cond *Condition) *Condition

+ func (c Condition) Xor(cond *Condition) *Condition

+ type Database struct

+ Name string

+ func DB(name string) *Database

+ func (d *Database) DBName() string

+ func (d *Database) Register(table *Table) *Database

+ func (d *Database) Table(name string) *Table

+ type DatabaseDefiner interface

+ DBName func() string

+ type DiffOptions struct

+ DropColumn bool

+ type Expression struct

+ Args []interface{}

+ Err error

+ Query string

+ func AddCol(c *Column) *Expression

+ func AddKey(key *Key) *Expression

+ func DropCol(c *Column) *Expression

+ func DropKey(key *Key) *Expression

+ func Expr(query string, args ...interface{}) *Expression

+ func ExprErr(err error) *Expression

+ func ExprFrom(v interface{}) *Expression

+ func JoinExpr(joiner string, sqlExprs ...SqlExpr) (*Expression, error)

+ func ModifyCol(c *Column) *Expression

+ func MustJoinExpr(joiner string, sqlExprs ...SqlExpr) *Expression

+ func (e *Expression) Expr() *Expression

+ type FieldNames []string

+ func (fieldNames FieldNames) Map() map[string]bool

+ type FieldValues map[string]interface

+ func FieldValuesFromStructBy(structValue interface{}, fieldNames []string) (fieldValues FieldValues)

+ func FieldValuesFromStructByNonZero(structValue interface{}, excludes ...string) (fieldValues FieldValues)

+ type Function struct

+ Name string

+ func Avg(sqlExprs ...SqlExpr) *Function

+ func Count(sqlExprs ...SqlExpr) *Function

+ func Distinct(sqlExprs ...SqlExpr) *Function

+ func First(sqlExprs ...SqlExpr) *Function

+ func Func(name string, sqlExprs ...SqlExpr) *Function

+ func Last(sqlExprs ...SqlExpr) *Function

+ func Max(sqlExprs ...SqlExpr) *Function

+ func Min(sqlExprs ...SqlExpr) *Function

+ func Sum(sqlExprs ...SqlExpr) *Function

+ func (f *Function) Expr() *Expression

+ type IndexDeclarer func() (indexName string, fieldNames FieldNames)

+ type Indexes map[string]FieldNames

+ type Key struct

+ Name string

+ Type keyType

+ func Index(name string) *Key

+ func PrimaryKey() *Key

+ func UniqueIndex(name string) *Key

+ func (key *Key) Def() *Expression

+ func (key *Key) IsValidDef() bool

+ func (key *Key) String() string

+ func (key *Key) WithCols(columns ...*Column) *Key

+ type Keys struct

+ func (keys *Keys) Add(nextKeys ...*Key)

+ func (keys *Keys) Clone() *Keys

+ func (keys *Keys) IsEmpty() bool

+ func (keys *Keys) Key(keyName string) (key *Key, exists bool)

+ func (keys *Keys) Len() int

+ func (keys *Keys) Range(cb func(key *Key, idx int))

+ func (keys *Keys) Remove(name string)

+ func (keys Keys) Diff(targetKeys Keys) keysDiffResult

+ type Model interface

+ TableName func() string

+ type SqlExpr interface

+ Expr func() *Expression

+ func AlterTable(t *Table) SqlExpr

+ func CreateDatebase(d DatabaseDefiner) SqlExpr

+ func CreateDatebaseIfNotExists(d DatabaseDefiner) SqlExpr

+ func CreateTable(t *Table) SqlExpr

+ func CreateTableIsNotExists(t *Table) SqlExpr

+ func DropDatabase(d DatabaseDefiner) SqlExpr

+ func DropTable(t *Table) SqlExpr

+ func TruncateTable(t *Table) SqlExpr

+ type StmtDelete struct

+ func Delete(modifiers ...string) *StmtDelete

+ func (s *StmtDelete) Expr() *Expression

+ func (s StmtDelete) From(table *Table, additions ...Addition) *StmtDelete

+ type StmtInsert struct

+ func Insert(modifiers ...string) *StmtInsert

+ func (s *StmtInsert) Expr() *Expression

+ func (s StmtInsert) Into(table *Table, additions ...Addition) *StmtInsert

+ func (s StmtInsert) Set(assignments ...*Assignment) *StmtInsert

+ func (s StmtInsert) Values(cols Columns, values ...interface{}) *StmtInsert

+ type StmtSelect struct

+ func Select(sqlExpr SqlExpr, modifiers ...string) *StmtSelect

+ func (s *StmtSelect) Expr() *Expression

+ func (s StmtSelect) From(table *Table, additions ...Addition) *StmtSelect

+ type StmtUpdate struct

+ func Update(table *Table, modifiers ...string) *StmtUpdate

+ func (s *StmtUpdate) Expr() *Expression

+ func (s StmtUpdate) Set(assignments ...*Assignment) *StmtUpdate

+ func (s StmtUpdate) Where(c *Condition, additions ...Addition) *StmtUpdate

+ type Table struct

+ Charset string

+ DB *Database

+ Engine string

+ Name string

+ func T(db *Database, tableName string) *Table

+ func (t *Table) AssignmentsByFieldValues(fieldValues FieldValues) (assignments Assignments)

+ func (t *Table) ColumnsAndValuesByFieldValues(fieldValues FieldValues) (columns Columns, args []interface{})

+ func (t *Table) Cond(query string, args ...interface{}) *Condition

+ func (t *Table) Diff(table *Table, opts DiffOptions) SqlExpr

+ func (t *Table) Ex(query string, args ...interface{}) *Expression

+ func (t *Table) Expr() *Expression

+ func (t *Table) FullName() string

+ func (t *Table) TableName() string

+ func (t Table) Define(defs ...TableDef) *Table

+ type TableDef interface

+ Def func() *Expression

+ IsValidDef func() bool

+ type Tables map[string]*Table

+ func (tables Tables) Add(table *Table)

+ func (tables Tables) TableNames() (names []string)

+ type WithComments interface

+ Comments func() map[string]string

+ type WithIndexes interface

+ Indexes func() Indexes

+ type WithPrimaryKey interface

+ PrimaryKey func() FieldNames

+ type WithUniqueIndexes interface

+ UniqueIndexes func() Indexes

Other modules containing this package

github.com/go-courier/sqlx/v2