builder

Dec 16, 2021

Changes in this version

type Column

+ func (c *Column) Dec(d int) SqlExpr

Sep 13, 2021

Changes in this version

type StructField

+ ModelLoc []int

+ func (p *StructField) FieldModelValue(structReflectValue reflect.Value) reflect.Value

Sep 9, 2021

Changes in this version

+ func EachStructField(ctx context.Context, tpe typesx.Type, each func(p *StructField) bool)

type ColumnType

+ DataType string

+ Description []string

+ Relation []string

type Columns

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

+ func (cols *Columns) MustCols(colNames ...string) *Columns

type Ex

+ func ExactlyExpr(query string, args ...interface{}) *Ex

+ func (e *Ex) Grow(n int)

+ func (e *Ex) QueryGrow(n int)

+ func (e *Ex) SetExactly(exactly bool)

+ func (e *Ex) WriteByte(b byte) error

+ func (e *Ex) WriteQuery(s string)

+ func (e *Ex) WriteQueryByte(b byte)

+ func (e *Ex) WriteString(s string) (int, error)

+ type IndexDef struct

+ ColNames []string

+ Expr string

+ FieldNames []string

+ func ParseIndexDef(parts ...string) *IndexDef

+ func (e IndexDef) TableExpr(t *Table) *Ex

+ func (e IndexDef) ToDefs() []string

+ type IndexDefine struct

+ Kind string

+ Method string

+ Name string

+ func ParseIndexDefine(def string) *IndexDefine

+ func (i IndexDefine) ID() string

type Key

+ Def IndexDef

type StructField

+ ColumnType ColumnType

+ FieldName string

+ Loc []int

+ Name string

+ Tags map[string]reflectx.StructTag

+ Type typesx.Type

+ func StructFieldsFor(ctx context.Context, typ typesx.Type) []*StructField

+ func (p *StructField) FieldValue(structReflectValue reflect.Value) reflect.Value

+ type StructFieldValue struct

+ Field StructField

+ TableName string

+ Value reflect.Value

+ type StructFieldsFactory struct

+ func (tf *StructFieldsFactory) TableFieldsFor(ctx context.Context, typ typesx.Type) []*StructField

+ type WithConditionFor interface

+ ConditionFor func(c *Column) SqlCondition

Dec 14, 2020

Changes in this version

type ColumnType

+ OnUpdate *string

Sep 15, 2020

Changes in this version

+ func TableAliasFromContext(ctx context.Context) string

+ func WithTableAlias(tableName string) func(ctx context.Context) context.Context

Jul 15, 2020

Changes in this version

+ func TableNameFromContext(ctx context.Context) string

+ func WithTableName(tableName string) func(ctx context.Context) context.Context

type Ex

+ func ColumnsByStruct(v interface{}) *Ex

+ type StructField struct

+ ColumnName string

+ Field reflect.StructField

+ TableName string

+ TagValue string

+ Value reflect.Value

Dec 21, 2019

Changes in this version

type Addition

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

+ func (CombinationAddition) AdditionType() AdditionType

type CommentAddition

+ func (CommentAddition) AdditionType() AdditionType

type GroupByAddition

+ func (GroupByAddition) AdditionType() AdditionType

type JoinAddition

+ func (JoinAddition) AdditionType() AdditionType

type LimitAddition

+ func (LimitAddition) AdditionType() AdditionType

type OnConflictAddition

+ func (OnConflictAddition) AdditionType() AdditionType

type OrderByAddition

+ func (OrderByAddition) AdditionType() AdditionType

type OtherAddition

+ func (OtherAddition) AdditionType() AdditionType

type WhereAddition

+ func (WhereAddition) AdditionType() AdditionType

Dec 21, 2019

Changes in this version

+ type Order struct

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

+ func (o *Order) IsNil() bool

Dec 10, 2019

Changes in this version

+ var ToggleUseValues = "UseValues"

type Assignment

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

Dec 5, 2019

Changes in this version

+ type SelectStatement interface

Dec 5, 2019

Changes in this version

+ func Expect() *combination

+ func Intersect() *combination

+ func Union() *combination

+ type BuildSubQuery func(table *Table) SqlExpr

+ type CombinationAddition struct

type WithStmt

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

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

Dec 4, 2019

Changes in this version

+ var ToggleMultiTable = "MultiTable"

+ var ToggleNeedAutoAlias = "NeedAlias"

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

+ func CrossJoin(table *Table) *join

+ func FullJoin(table *Table) *join

+ func InnerJoin(table *Table) *join

+ func IsNilExpr(e SqlExpr) bool

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

+ func LeftJoin(table *Table) *join

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

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

+ func RightJoin(table *Table) *join

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

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

type Column

+ func (c Column) Full() *Column

type Columns

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

+ type CommentAddition struct

+ 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 (c *Condition) Ex(ctx context.Context) *Ex

type Ex

+ func ResolveExpr(v interface{}) *Ex

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

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

type Function

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

+ type JoinAddition struct

type SqlCondition

+ func EmptyCond() SqlCondition

+ And func(cond SqlCondition) SqlCondition

+ Or func(cond SqlCondition) SqlCondition

+ Xor func(cond SqlCondition) SqlCondition

type SqlExpr

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

+ func Multi(exprs ...SqlExpr) SqlExpr

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

+ func UnionAll(exprs ...SqlExpr) SqlExpr

+ Ex func(ctx context.Context) *Ex

type StmtDelete

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

type StmtInsert

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

type StmtSelect

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

type StmtUpdate

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

type Table

+ func TableFromModel(model Model) *Table

+ func (t *Table) TableName() string

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

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

+ func WithRecursive(t *Table) *WithStmt

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

+ func (w *WithStmt) IsNil() bool

+ func (w *WithStmt) T() *Table

+ func (w WithStmt) As(as func(t *Table) SqlExpr) *WithStmt

+ func (w WithStmt) Do(do func(t *Table) SqlExpr) *WithStmt

Oct 17, 2019

Changes in this version

type ColumnType

+ DeprecatedActions *DeprecatedActions

+ type DeprecatedActions struct

+ RenameTo string

type Dialect

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

Sep 23, 2019

Changes in this version

type Columns

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

May 15, 2019

Changes in this version

+ type GroupByAddition struct

+ type LimitAddition struct

+ type OnConflictAddition struct

+ type OrderByAddition struct

+ type OtherAddition struct

+ func (a *OtherAddition) IsNil() bool

+ type WhereAddition struct

Mar 18, 2019

Changes in this version

type Table

+ Description []string

+ type WithTableDescription interface

+ TableDescription func() []string

Mar 16, 2019

Changes in this version

type Column

+ Description string

+ Relation []string

type Table

+ ModelName string

type Tables

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

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

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

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

+ type WithColDescriptions interface

+ ColDescriptions func() map[string]string

+ type WithRelations interface

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

Dec 11, 2018

Changes in this version

type Dialect

+ CreateSchema func(schemaName string) SqlExpr

Dec 10, 2018

Changes in this version

type Column

+ func (c *Column) Ex(query string, args ...interface{}) *Ex

Dec 10, 2018

Changes in this version

+ type AliasEx struct

+ Name string

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

+ func (expr *AliasEx) Expr() *Ex

type Column

+ Exactly bool

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

type SqlExpr

+ func MultiExpr(exprs ...SqlExpr) SqlExpr

type Table

+ Model Model

+ Schema string

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

Nov 5, 2018

Changes in this version

+ var UpdateNeedLimitByWhere = errors.New("no where limit for update")

+ func AsAddition(expr SqlExpr) *otherAddition

+ func AscOrder(expr SqlExpr) *order

+ func Comment(c string) comment

+ func DescOrder(expr SqlExpr) *order

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

+ func ForUpdate() *otherAddition

+ func GetColumnName(fieldName, tagValue string) string

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

+ func Limit(rowCount int64) *limit

+ func OnConflict(columns *Columns) *onConflict

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

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

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

+ func Returning(expr SqlExpr) *otherAddition

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

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

+ func Where(c SqlCondition) *where

+ type Addition interface

+ type Additions []Addition

+ func (additions Additions) Expr() *Ex

+ func (additions Additions) IsNil() bool

+ func (additions Additions) Len() int

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

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

+ type Assignment struct

+ func AsAssignment(ex SqlExpr) *Assignment

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

+ func (a *Assignment) IsNil() bool

+ type Assignments []*Assignment

+ func (assigns Assignments) Expr() *Ex

+ func (assigns Assignments) IsNil() bool

+ type Column struct

+ FieldName string

+ Name string

+ Table *Table

+ func Col(name string) *Column

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

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

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

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

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

+ func (c *Column) IsNil() bool

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

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

+ 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) T() *Table

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

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

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

+ func (c Column) Type(v interface{}, tagValue string) *Column

+ type ColumnType struct

+ AutoIncrement bool

+ Comment string

+ Decimal uint64

+ Default *string

+ GetDataType func(engine string) string

+ Length uint64

+ Null bool

+ Type reflect.Type

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

+ type Columns struct

+ func Cols(names ...string) *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, error)

+ func (cols *Columns) Expr() *Ex

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

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

+ func (cols *Columns) Fields(fieldNames ...string) (*Columns, error)

+ func (cols *Columns) IsNil() 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)

+ type CondRule struct

+ Conditions []*Condition

+ When bool

+ type CondRules struct

+ func NewCondRules() *CondRules

+ func (rules *CondRules) Expr() *Ex

+ func (rules *CondRules) IsNil() bool

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

+ type Condition struct

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

+ func AsCond(ex SqlExpr) *Condition

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

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

+ func (c *Condition) IsNil() bool

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

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

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

+ type DataTypeDescriber interface

+ DataType func(driverName string) string

+ type Dialect interface

+ AddColumn func(col *Column) SqlExpr

+ AddIndex func(key *Key) SqlExpr

+ BindVar func(i int) string

+ CreateDatabase func(dbName 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

+ TruncateTable func(t *Table) SqlExpr

+ type Ex struct

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

+ func ExprFrom(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) Expr() *Ex

+ func (e *Ex) Flatten() *Ex

+ func (e *Ex) IsNil() bool

+ func (e *Ex) Query() string

+ func (e *Ex) ReplaceValueHolder(bindVar func(idx int) string) *Ex

+ func (e *Ex) WhiteComments(comments string)

+ func (e *Ex) WriteEnd()

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

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

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

+ type FieldValues map[string]interface

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

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

+ type Function struct

+ Exprs []SqlExpr

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

+ func (f *Function) IsNil() bool

+ type Indexes map[string][]string

+ type Key struct

+ Columns *Columns

+ IsUnique bool

+ Method string

+ Name string

+ Table *Table

+ func Index(name string, columns *Columns) *Key

+ func PrimaryKey(columns *Columns) *Key

+ func UniqueIndex(name string, columns *Columns) *Key

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

+ func (keys *Keys) Len() int

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

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

+ type Model interface

+ TableName func() string

+ type SqlAssignment interface

+ type SqlAssignmentMarker interface

+ type SqlCondition interface

+ type SqlConditionMarker interface

+ type SqlExpr interface

+ Expr func() *Ex

+ IsNil func() bool

+ type StmtDelete struct

+ func Delete() *StmtDelete

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

+ func (s *StmtDelete) IsNil() bool

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

+ type StmtInsert struct

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

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

+ func (s *StmtInsert) IsNil() bool

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

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

+ type StmtSelect struct

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

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

+ func (s *StmtSelect) IsNil() bool

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

+ type StmtUpdate struct

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

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

+ func (s *StmtUpdate) IsNil() bool

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

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

+ type Table struct

+ Name string

+ func T(tableName string, tableDefinitions ...TableDefinition) *Table

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

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

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

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

+ func (t *Table) Diff(prevTable *Table, dialect Dialect, skipDropColumn bool) (exprList []SqlExpr)

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

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

+ func (t *Table) IsNil() bool

+ type TableDefinition interface

+ T func() *Table

+ type Tables map[string]*Table

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

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

+ type ValuerExpr interface

+ ValueEx func() string

+ type WithComments interface

+ Comments func() map[string]string

+ type WithIndexes interface

+ Indexes func() Indexes

+ type WithPrimaryKey interface

+ PrimaryKey func() []string

+ type WithUniqueIndexes interface

+ UniqueIndexes func() Indexes