Versions in this module Expand all Collapse all v1 v1.0.0 Apr 28, 2024 Changes in this version + func SetDialect(opt Dialect) + type AlterTableBuilder interface + AddColumn func(col ColumnConfig) AlterTableBuilder + AddColumnAfter func(col ColumnConfig, after Column) AlterTableBuilder + AddColumnFirst func(col ColumnConfig) AlterTableBuilder + ApplyToTable func() error + ChangeColumn func(old_column Column, new_column ColumnConfig) AlterTableBuilder + ChangeColumnAfter func(old_column Column, new_column ColumnConfig, after Column) AlterTableBuilder + ChangeColumnFirst func(old_column Column, new_column ColumnConfig) AlterTableBuilder + DropColumn func(col Column) AlterTableBuilder + RenameTo func(name string) AlterTableBuilder + ToSql func() (query string, args []interface{}, err error) + func AlterTable(tbl Table) AlterTableBuilder + type AlterTableStatement struct + func (b *AlterTableStatement) AddColumn(col ColumnConfig) AlterTableBuilder + func (b *AlterTableStatement) AddColumnAfter(col ColumnConfig, after Column) AlterTableBuilder + func (b *AlterTableStatement) AddColumnFirst(col ColumnConfig) AlterTableBuilder + func (b *AlterTableStatement) ApplyToTable() error + func (b *AlterTableStatement) ChangeColumn(old_column Column, new_column ColumnConfig) AlterTableBuilder + func (b *AlterTableStatement) ChangeColumnAfter(old_column Column, new_column ColumnConfig, after Column) AlterTableBuilder + func (b *AlterTableStatement) ChangeColumnFirst(old_column Column, new_column ColumnConfig) AlterTableBuilder + func (b *AlterTableStatement) DropColumn(col Column) AlterTableBuilder + func (b *AlterTableStatement) RenameTo(name string) AlterTableBuilder + func (b *AlterTableStatement) ToSql() (query string, args []interface{}, err error) + type Buildable interface + AlterTable func(tbl Table) AlterTableBuilder + CreateIndex func(tbl Table) CreateIndexBuilder + CreateTable func(tbl Table) CreateTableBuilder + Delete func(from Table) DeleteBuilder + Insert func(into Table) InsertBuilder + Select func(from Table) SelectBuilder + func NewBuildable(d Dialect) Buildable + type Column interface + As func(alias string) Column + Between func(lower, higher interface{}) Condition + Eq func(right interface{}) Condition + Gt func(right interface{}) Condition + GtEq func(right interface{}) Condition + In func(values ...interface{}) Condition + Like func(right string) Condition + Lt func(right interface{}) Condition + LtEq func(right interface{}) Condition + NotEq func(right interface{}) Condition + var Star Column = &columnImpl{ ... } + type ColumnConfig interface + Name func() string + Option func() *ColumnOption + Type func() ColumnType + func AnyColumn(name string, opt *ColumnOption) ColumnConfig + func BoolColumn(name string, opt *ColumnOption) ColumnConfig + func BytesColumn(name string, opt *ColumnOption) ColumnConfig + func DateColumn(name string, opt *ColumnOption) ColumnConfig + func FloatColumn(name string, opt *ColumnOption) ColumnConfig + func IntColumn(name string, opt *ColumnOption) ColumnConfig + func StringColumn(name string, opt *ColumnOption) ColumnConfig + type ColumnList []Column + type ColumnOption struct + AutoIncrement bool + Default interface{} + NotNull bool + PrimaryKey bool + Size int + SqlType string + Unique bool + type ColumnType int + const ColumnTypeAny + const ColumnTypeBool + const ColumnTypeBytes + const ColumnTypeDate + const ColumnTypeFloat + const ColumnTypeInt + const ColumnTypeString + func (t ColumnType) CapableTypes() []reflect.Type + func (t ColumnType) String() string + type Condition interface + func And(conds ...Condition) Condition + func Or(conds ...Condition) Condition + type CreateIndexBuilder interface + Columns func(columns ...Column) CreateIndexBuilder + IfNotExists func() CreateIndexBuilder + Name func(name string) CreateIndexBuilder + ToSql func() (query string, args []interface{}, err error) + func CreateIndex(tbl Table) CreateIndexBuilder + type CreateIndexStatement struct + func (b *CreateIndexStatement) Columns(columns ...Column) CreateIndexBuilder + func (b *CreateIndexStatement) IfNotExists() CreateIndexBuilder + func (b *CreateIndexStatement) Name(name string) CreateIndexBuilder + func (b *CreateIndexStatement) ToSql() (query string, args []interface{}, err error) + type CreateTableBuilder interface + IfNotExists func() CreateTableBuilder + ToSql func() (query string, args []interface{}, err error) + func CreateTable(tbl Table) CreateTableBuilder + type CreateTableStatement struct + func (b *CreateTableStatement) IfNotExists() CreateTableBuilder + func (b *CreateTableStatement) ToSql() (query string, args []interface{}, err error) + type DeleteBuilder interface + ToSql func() (query string, args []interface{}, err error) + Where func(cond Condition) DeleteBuilder + func Delete(from Table) DeleteBuilder + type DeleteStatement struct + func (b *DeleteStatement) ToSql() (query string, args []interface{}, err error) + func (b *DeleteStatement) Where(cond Condition) DeleteBuilder + type Dialect interface + BindVar func(i int) string + ColumnOptionToString func(*ColumnOption) (string, error) + ColumnTypeToString func(ColumnConfig) (string, error) + QuerySuffix func() string + QuoteField func(field interface{}) string + TableOptionToString func(*TableOption) (string, error) + type DropTableStatement struct + func (b *DropTableStatement) ToSql() (query string, args []interface{}, err error) + type IDropTableStatement interface + ToSql func() (query string, args []interface{}, err error) + func DropTable(tbl Table) IDropTableStatement + type IUpdateStatement interface + Limit func(limit int) IUpdateStatement + Offset func(offset int) IUpdateStatement + OrderBy func(desc bool, columns ...Column) IUpdateStatement + Set func(col Column, val interface{}) IUpdateStatement + ToSql func() (query string, args []interface{}, err error) + Where func(cond Condition) IUpdateStatement + func Update(tbl Table) IUpdateStatement + type InsertBuilder interface + Columns func(columns ...Column) InsertBuilder + Set func(column Column, value interface{}) InsertBuilder + ToSql func() (query string, args []interface{}, err error) + Values func(values ...interface{}) InsertBuilder + func Insert(into Table) InsertBuilder + type InsertStatement struct + func (b *InsertStatement) Columns(columns ...Column) InsertBuilder + func (b *InsertStatement) Set(column Column, value interface{}) InsertBuilder + func (b *InsertStatement) ToSql() (query string, args []interface{}, err error) + func (b *InsertStatement) Values(values ...interface{}) InsertBuilder + type SelectBuilder interface + Columns func(columns ...Column) SelectBuilder + Distinct func() SelectBuilder + GroupBy func(columns ...Column) SelectBuilder + Having func(cond Condition) SelectBuilder + Limit func(limit int) SelectBuilder + Offset func(offset int) SelectBuilder + OrderBy func(desc bool, columns ...Column) SelectBuilder + ToSql func() (query string, args []interface{}, err error) + ToSubquery func(alias string) Table + Where func(cond Condition) SelectBuilder + func Select(from Table) SelectBuilder + type SelectStatement struct + func (b *SelectStatement) Columns(columns ...Column) SelectBuilder + func (b *SelectStatement) Distinct() SelectBuilder + func (b *SelectStatement) GroupBy(columns ...Column) SelectBuilder + func (b *SelectStatement) Having(cond Condition) SelectBuilder + func (b *SelectStatement) Limit(limit int) SelectBuilder + func (b *SelectStatement) Offset(offset int) SelectBuilder + func (b *SelectStatement) OrderBy(desc bool, columns ...Column) SelectBuilder + func (b *SelectStatement) ToSql() (query string, args []interface{}, err error) + func (b *SelectStatement) Where(cond Condition) SelectBuilder + func (m *SelectStatement) ToSubquery(alias string) Table + type SqlFunc interface + func Func(name string, args ...Column) SqlFunc + type Statement interface + ToSql func() (query string, attrs []interface{}, err error) + type Table interface + C func(name string) Column + Columns func() []Column + FullOuterJoin func(Table, Condition) Table + InnerJoin func(Table, Condition) Table + LeftOuterJoin func(Table, Condition) Table + Name func() string + Option func() *TableOption + RightOuterJoin func(Table, Condition) Table + func NewTable(name string, option *TableOption, column_configs ...ColumnConfig) Table + type TableOption struct + Unique [][]string + type UpdateStatement struct + func (b *UpdateStatement) Limit(limit int) IUpdateStatement + func (b *UpdateStatement) Offset(offset int) IUpdateStatement + func (b *UpdateStatement) OrderBy(desc bool, columns ...Column) IUpdateStatement + func (b *UpdateStatement) Set(col Column, val interface{}) IUpdateStatement + func (b *UpdateStatement) ToSql() (query string, args []interface{}, err error) + func (b *UpdateStatement) Where(cond Condition) IUpdateStatement