builder

package

Go to main page

Versions in this module

v1

v1.0.10

Sep 24, 2020

v1.0.9

Sep 23, 2020

v1.0.8

Sep 22, 2020

v1.0.7

Sep 17, 2020

v1.0.6

Sep 11, 2020

v1.0.5

Sep 10, 2020

v1.0.4

Sep 10, 2020

v1.0.3

Sep 10, 2020

v1.0.2

Sep 9, 2020

v1.0.1

Sep 8, 2020

Changes in this version

+ var ToggleMultiTable = "MultiTable"

+ var ToggleNeedAutoAlias = "NeedAlias"

+ var ToggleUseValues = "UseValues"

+ func Alias(expr SqlExpr, name string) *exAlias

+ func Comment(c string) *comment

+ func ContextWithToggles(ctx context.Context, toggles Toggles) context.Context

+ func CrossJoin(table *Table) *join

+ func Expect() *combination

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

+ func FullJoin(table *Table) *join

+ func GetColumnName(fieldName, tagValue string) string

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

+ func InnerJoin(table *Table) *join

+ func Intersect() *combination

+ func IsNilExpr(e SqlExpr) bool

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

+ func LeftJoin(table *Table) *join

+ func Limit(rowCount int64) *limit

+ func MultiMayAutoAlias(columns ...SqlExpr) *exMayAutoAlias

+ func OnConflict(columns *Columns) *onConflict

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

+ func RangeNotNilExpr(exprs []SqlExpr, each func(e SqlExpr, i int))

+ func ResolveIndexNameAndMethod(n string) (name string, method string)

+ func RightJoin(table *Table) *join

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

+ func ToMap(list []string) map[string]bool

+ func Union() *combination

+ func Where(c SqlCondition) *where

+ func WriteAdditions(e *Ex, additions ...Addition)

+ func WriteAssignments(e *Ex, assignments ...*Assignment)

+ type Addition interface

+ AdditionType func() AdditionType

+ type AdditionType int

+ const AdditionCombination

+ const AdditionComment

+ const AdditionGroupBy

+ const AdditionJoin

+ const AdditionLimit

+ const AdditionOnConflict

+ const AdditionOrderBy

+ const AdditionOther

+ const AdditionWhere

+ type Additions []Addition

+ func (additions Additions) Len() int

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

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

type Assignment

+ func ColumnsAndValues(columnOrColumns SqlExpr, values ...interface{}) *Assignment

+ func (a *Assignment) Ex(ctx context.Context) *Ex

+ func (a *Assignment) IsNil() bool

+ type BuildSubQuery func(table *Table) SqlExpr

type Column

+ Description []string

+ Relation []string

+ func (c *Column) Ex(ctx context.Context) *Ex

+ func (c *Column) IsNil() bool

+ func (c *Column) Of(table *Table) *Column

+ func (c *Column) T() *Table

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

+ func (c Column) Full() *Column

+ func (c Column) On(table *Table) *Column

+ type ColumnType struct

+ AutoIncrement bool

+ Comment string

+ Decimal uint64

+ Default *string

+ DeprecatedActions *DeprecatedActions

+ GetDataType func(engine string) string

+ Length uint64

+ Null bool

+ Type reflect.Type

+ func ColumnTypeFromTypeAndTag(typ reflect.Type, nameAndFlags string) *ColumnType

type Columns

+ func (cols *Columns) Ex(ctx context.Context) *Ex

+ func (cols *Columns) IsNil() bool

+ func (cols *Columns) MustFields(fieldNames ...string) *Columns

+ type CombinationAddition struct

+ func (CombinationAddition) AdditionType() AdditionType

+ type CommentAddition struct

+ func (CommentAddition) AdditionType() AdditionType

+ type ComposedCondition struct

+ func (c *ComposedCondition) And(cond SqlCondition) SqlCondition

+ func (c *ComposedCondition) Ex(ctx context.Context) *Ex

+ func (c *ComposedCondition) IsNil() bool

+ func (c *ComposedCondition) Or(cond SqlCondition) SqlCondition

+ func (c *ComposedCondition) Xor(cond SqlCondition) SqlCondition

type Condition

+ func AsCond(ex SqlExpr) *Condition

+ func (c *Condition) Ex(ctx context.Context) *Ex

+ func (c *Condition) IsNil() bool

+ type DataTypeDescriber interface

+ DataType func(driverName string) string

+ type DeprecatedActions struct

+ RenameTo string

+ type Dialect interface

+ AddColumn func(col *Column) SqlExpr

+ AddIndex func(key *Key) SqlExpr

+ CreateDatabase func(dbName string) SqlExpr

+ CreateSchema func(schemaName string) SqlExpr

+ CreateTableIsNotExists func(t *Table) []SqlExpr

+ DataType func(columnType *ColumnType) SqlExpr

+ DriverName func() string

+ DropColumn func(col *Column) SqlExpr

+ DropDatabase func(dbName string) SqlExpr

+ DropIndex func(key *Key) SqlExpr

+ DropTable func(t *Table) SqlExpr

+ IsErrorConflict func(err error) bool

+ IsErrorUnknownDatabase func(err error) bool

+ ModifyColumn func(col *Column) SqlExpr

+ PrimaryKeyName func() string

+ RenameColumn func(col *Column, target *Column) SqlExpr

+ TruncateTable func(t *Table) SqlExpr

+ type Ex struct

+ func ResolveExpr(v interface{}) *Ex

+ func ResolveExprContext(ctx context.Context, v interface{}) *Ex

+ func (e *Ex) AppendArgs(args ...interface{})

+ func (e *Ex) Args() []interface{}

+ func (e *Ex) ArgsLen() int

+ func (e *Ex) Err() error

+ func (e *Ex) IsNil() bool

+ func (e *Ex) Query() string

+ func (e *Ex) WhiteComments(comments []byte)

+ func (e *Ex) WriteEnd()

+ func (e *Ex) WriteExpr(expr SqlExpr)

+ func (e *Ex) WriteGroup(fn func(e *Ex))

+ func (e *Ex) WriteHolder(idx int)

+ func (e Ex) Ex(ctx context.Context) *Ex

type FieldValues

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

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

type Function

+ func (f *Function) Ex(ctx context.Context) *Ex

+ func (f *Function) IsNil() bool

+ type GroupByAddition struct

+ func (GroupByAddition) AdditionType() AdditionType

+ type Indexes map[string][]string

+ type JoinAddition struct

+ func (JoinAddition) AdditionType() AdditionType

type Key

+ Columns *Columns

+ IsUnique bool

+ Method string

+ Table *Table

+ func (key *Key) IsPrimary() bool

+ func (key *Key) T() *Table

+ func (key Key) On(table *Table) *Key

+ func (key Key) Using(method string) *Key

+ type LimitAddition struct

+ func (LimitAddition) AdditionType() AdditionType

+ type Model interface

+ TableName func() string

+ type OnConflictAddition struct

+ func (OnConflictAddition) AdditionType() AdditionType

+ type Order struct

+ func AscOrder(target SqlExpr) *Order

+ func DescOrder(target SqlExpr) *Order

+ func (o *Order) Ex(ctx context.Context) *Ex

+ func (o *Order) IsNil() bool

+ type OrderByAddition struct

+ func (OrderByAddition) AdditionType() AdditionType

+ type OtherAddition struct

+ func AsAddition(expr SqlExpr) *OtherAddition

+ func ForUpdate() *OtherAddition

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

+ func Returning(expr SqlExpr) *OtherAddition

+ func (OtherAddition) AdditionType() AdditionType

+ func (a *OtherAddition) IsNil() bool

+ type SelectStatement interface

+ type SqlAssignment interface

+ type SqlAssignmentMarker interface

+ type SqlCondition interface

+ And func(cond SqlCondition) SqlCondition

+ Or func(cond SqlCondition) SqlCondition

+ Xor func(cond SqlCondition) SqlCondition

+ func EmptyCond() SqlCondition

+ type SqlConditionMarker interface

+ type SqlExpr interface

+ Ex func(ctx context.Context) *Ex

+ IsNil func() bool

+ func ExprBy(build func(ctx context.Context) *Ex) SqlExpr

+ func Multi(exprs ...SqlExpr) SqlExpr

+ func MultiWith(connector string, exprs ...SqlExpr) SqlExpr

type StmtDelete

+ func (s *StmtDelete) Ex(ctx context.Context) *Ex

+ func (s *StmtDelete) IsNil() bool

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

type StmtInsert

+ func (s *StmtInsert) Ex(ctx context.Context) *Ex

+ func (s *StmtInsert) IsNil() bool

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

type StmtSelect

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

+ func (s *StmtSelect) Ex(ctx context.Context) *Ex

+ func (s *StmtSelect) IsNil() bool

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

type StmtUpdate

+ func (s *StmtUpdate) Ex(ctx context.Context) *Ex

+ func (s *StmtUpdate) IsNil() bool

type Table

+ Description []string

+ Model Model

+ ModelName string

+ Schema string

+ func TableFromModel(model Model) *Table

+ func (t *Table) AddCol(d *Column)

+ func (t *Table) AddKey(key *Key)

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

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

+ func (t *Table) IsNil() bool

+ func (t *Table) TableName() string

+ func (t Table) WithSchema(schema string) *Table

+ type TableDefinition interface

+ T func() *Table

type Tables

+ func (tables *Tables) Model(structName string) *Table

+ func (tables *Tables) Range(cb func(tab *Table, idx int))

+ func (tables *Tables) Remove(name string)

+ func (tables *Tables) Table(tableName string) *Table

+ type Toggles map[string]bool

+ func TogglesFromContext(ctx context.Context) Toggles

+ func (toggles Toggles) Is(key string) bool

+ func (toggles Toggles) Merge(next Toggles) Toggles

+ type ValuerExpr interface

+ ValueEx func() string

+ type WhereAddition struct

+ func (WhereAddition) AdditionType() AdditionType

+ type WithColDescriptions interface

+ ColDescriptions func() map[string][]string

+ type WithComments interface

+ Comments func() map[string]string

+ type WithIndexes interface

+ Indexes func() Indexes

+ type WithPrimaryKey interface

+ PrimaryKey func() []string

+ type WithRelations interface

+ ColRelations func() map[string][]string

+ type WithStmt struct

+ func With(t *Table, build BuildSubQuery, modifiers ...string) *WithStmt

+ func WithRecursive(t *Table, build BuildSubQuery) *WithStmt

+ func (w *WithStmt) Ex(ctx context.Context) *Ex

+ func (w *WithStmt) IsNil() bool

+ func (w WithStmt) Exec(statement func(tables ...*Table) SqlExpr) *WithStmt

+ func (w WithStmt) With(t *Table, build BuildSubQuery) *WithStmt

+ type WithTableDescription interface

+ TableDescription func() []string

+ type WithUniqueIndexes interface

+ UniqueIndexes func() Indexes

v1.0.0

Sep 8, 2020

Changes in this version

+ const INDEX

+ const PRIMARY

+ const UNIQUE_INDEX

+ var Configuration = &struct{ ... }

+ var DeleteNeedLimitByWhere = fmt.Errorf("no where limit for delete")

+ var InsertValuesLengthNotMatch = fmt.Errorf("value length is not equal Col length")

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

+ func HolderRepeat(length int) string

+ func Star() star

+ type Assignment Expression

+ func (a Assignment) Expr() *Expression

+ type Assignments []*Assignment

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

+ type CanExpr interface

+ Expr func() *Expression

+ type Column struct

+ FieldName string

+ Name string

+ Table *Table

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

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

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

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

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

+ func (c *Column) Drop() *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) Modify() *Expression

+ 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) Def() *Expression

+ func (c Column) Enum(enumType string, enums map[int][]string) *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) Wrap() (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, conds ...*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) Create(ifNotExists bool) *Stmt

+ func (d *Database) Drop() *Stmt

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

+ func (d *Database) String() string

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

+ type Expression struct

+ Args []interface{}

+ Err error

+ Query string

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

+ func ExprErr(err error) *Expression

+ func ExprFrom(v interface{}) *Expression

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

+ func (e Expression) ConcatBy(joiner string, canExpr CanExpr) *Expression

+ type FieldValues map[string]interface

+ type Function struct

+ Name string

+ func Avg(canExpr CanExpr) *Function

+ func Count(canExpr CanExpr) *Function

+ func Distinct(canExpr CanExpr) *Function

+ func First(canExpr CanExpr) *Function

+ func Func(name string, canExpr CanExpr) *Function

+ func Last(canExpr CanExpr) *Function

+ func Max(canExpr CanExpr) *Function

+ func Min(canExpr CanExpr) *Function

+ func Sum(canExpr CanExpr) *Function

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

+ type Key struct

+ Name string

+ Type keyType

+ func Index(name string) *Key

+ func PrimaryKey() *Key

+ func UniqueIndex(name string) *Key

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

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

+ func (key *Key) Drop() *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 OrderType string

+ const ORDER_ASC

+ const ORDER_DESC

+ const ORDER_NO

+ type Statement interface

+ Type func() StmtType

+ type Stmt Expression

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

+ func (s *Stmt) Type() StmtType

+ type StmtDelete struct

+ func Delete(table *Table) *StmtDelete

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

+ func (s *StmtDelete) Type() StmtType

+ func (s StmtDelete) AscendBy(col *Column) *StmtDelete

+ func (s StmtDelete) Comment(comment string) *StmtDelete

+ func (s StmtDelete) DescendBy(col *Column) *StmtDelete

+ func (s StmtDelete) Limit(size int32) *StmtDelete

+ func (s StmtDelete) Modifier(modifiers ...string) *StmtDelete

+ func (s StmtDelete) OrderBy(col *Column, orderType OrderType) *StmtDelete

+ func (s StmtDelete) Where(cond *Condition) *StmtDelete

+ type StmtInsert struct

+ func Insert(table *Table) *StmtInsert

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

+ func (s *StmtInsert) Type() StmtType

+ func (s StmtInsert) Columns(cols Columns) *StmtInsert

+ func (s StmtInsert) Comment(comment string) *StmtInsert

+ func (s StmtInsert) Modifier(modifiers ...string) *StmtInsert

+ func (s StmtInsert) OnDuplicateKeyUpdate(assigns ...*Assignment) *StmtInsert

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

+ type StmtSelect struct

+ func SelectFrom(table *Table) *StmtSelect

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

+ func (s *StmtSelect) Type() StmtType

+ func (s StmtSelect) Comment(comment string) *StmtSelect

+ func (s StmtSelect) For(expr CanExpr) *StmtSelect

+ func (s StmtSelect) ForUpdate() *StmtSelect

+ func (s StmtSelect) GroupAscBy(canExpr CanExpr) *StmtSelect

+ func (s StmtSelect) GroupBy(canExpr CanExpr) *StmtSelect

+ func (s StmtSelect) GroupDescBy(canExpr CanExpr) *StmtSelect

+ func (s StmtSelect) Having(cond *Condition) *StmtSelect

+ func (s StmtSelect) Limit(size int32) *StmtSelect

+ func (s StmtSelect) Modifier(modifiers ...string) *StmtSelect

+ func (s StmtSelect) Offset(offset int32) *StmtSelect

+ func (s StmtSelect) OrderAscBy(canExpr CanExpr) *StmtSelect

+ func (s StmtSelect) OrderBy(canExpr CanExpr, orderType OrderType) *StmtSelect

+ func (s StmtSelect) OrderDescBy(canExpr CanExpr) *StmtSelect

+ func (s StmtSelect) Where(cond *Condition) *StmtSelect

+ func (s StmtSelect) WithRollup() *StmtSelect

+ type StmtType int16

+ const STMT_DELETE

+ const STMT_INSERT

+ const STMT_RAW

+ const STMT_SELECT

+ const STMT_UNKNOWN

+ const STMT_UPDATE

+ type StmtUpdate struct

+ func Update(table *Table) *StmtUpdate

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

+ func (s *StmtUpdate) Type() StmtType

+ func (s StmtUpdate) Comment(comment string) *StmtUpdate

+ func (s StmtUpdate) Limit(size int32) *StmtUpdate

+ func (s StmtUpdate) Modifier(modifiers ...string) *StmtUpdate

+ func (s StmtUpdate) OrderAscBy(col *Column) *StmtUpdate

+ func (s StmtUpdate) OrderBy(col *Column, orderType OrderType) *StmtUpdate

+ func (s StmtUpdate) OrderDescBy(col *Column) *StmtUpdate

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

+ func (s StmtUpdate) Where(cond *Condition) *StmtUpdate

+ type Table struct

+ Charset string

+ DB *Database

+ Engine string

+ Name string

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

+ func (t *Table) AssignsByFieldValues(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) Create(ifNotExists bool) *Stmt

+ func (t *Table) Delete() *StmtDelete

+ func (t *Table) Diff(table *Table) *Stmt

+ func (t *Table) Drop() *Stmt

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

+ func (t *Table) FullName() string

+ func (t *Table) Insert() *StmtInsert

+ func (t *Table) Select() *StmtSelect

+ func (t *Table) String() string

+ func (t *Table) Truncate() *Stmt

+ func (t *Table) Update() *StmtUpdate

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

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