sqlbuilder

package module

Go to main page

Versions in this module

v1

v1.1.2

Aug 9, 2026

v1.1.1

Aug 9, 2026

v1.1.0

Jun 14, 2024

Changes in this version

+ func GetColumnError(c Column) (err error)

+ func IsColumnError(c Column) bool

+ func SameColumn(a, b Column) (same bool)

type Buildable

+ Dialect func() Dialect

+ NewTable func(name string, option *TableOption, column_configs ...ColumnConfig) (t Table)

type Column

+ NotIn func(values ...interface{}) Condition

+ NotLike func(right string) Condition

type ColumnConfig

+ func TimeColumn(name string, opt *ColumnOption) ColumnConfig

+ Describe func() (output string)

type ColumnList

+ func (c ColumnList) Describe() (output string)

type ColumnOption

+ func (c ColumnOption) Describe() (output string)

type Condition

+ Describe func() (output string)

type Dialect

+ Name func() string

+ type DropTableBuilder interface

+ ToSql func() (query string, args []interface{}, err error)

type SelectBuilder

+ Describe func() (output string)

type Table

+ Describe func() (output string)

type TableOption

+ func (t TableOption) Describe() (output string)

+ type TestingDialect struct

+ func (td TestingDialect) BindVar(i int) string

+ func (td TestingDialect) ColumnOptionToString(co *ColumnOption) (string, error)

+ func (td TestingDialect) ColumnTypeToString(cc ColumnConfig) (string, error)

+ func (td TestingDialect) Name() string

+ func (td TestingDialect) QuerySuffix() string

+ func (td TestingDialect) QuoteField(field interface{}) string

+ func (td TestingDialect) TableOptionToString(to *TableOption) (string, error)

+ type UpdateBuilder interface

+ Limit func(limit int) UpdateBuilder

+ Offset func(offset int) UpdateBuilder

+ OrderBy func(desc bool, columns ...Column) UpdateBuilder

+ Set func(col Column, val interface{}) UpdateBuilder

+ ToSql func() (query string, args []interface{}, err error)

+ Where func(cond Condition) UpdateBuilder

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

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