Versions in this module Expand all Collapse all v1 v1.0.1 Jul 17, 2019 Changes in this version + type CommonTask struct + func (t *CommonTask) DB() DB + func (t *CommonTask) EmitSuccess() error + func (t *CommonTask) OnSuccess(f func() error) + func (t *CommonTask) SetDB(db DB) + type DeleteTask struct + func NewDeleteTask(q *Delete, db DB) *DeleteTask + func (t *DeleteTask) Exec() (sql.Result, error) + type InsertTask struct + func NewInsertTask(q *Insert, db DB) *InsertTask + func (t *InsertTask) Exec() (sql.Result, error) + type SelectTask struct + func NewSelectTask(q *Select, db DB) *SelectTask + func (t *SelectTask) QueryRow() *sql.Row + func (t *SelectTask) QueryRows() (*sql.Rows, error) + type Task interface + DB func() DB + EmitSuccess func() error + OnSuccess func(func() error) + SetDB func(DB) + type UpdateTask struct + func NewUpdateTask(q *Update, db DB) *UpdateTask + func (t *UpdateTask) Exec() (sql.Result, error) v1.0.0 Jul 10, 2019 Changes in this version + var Debug = false + var DefaultDriver = &EmptyBuilderDriver + var DefaultLogger = func(timestamp int64, cmd string, args []interface{}) + var Logger func(timestamp int64, cmd string, args []interface{}) + var MSSQLDriver = &MSSQLBuilderDriver + var PostgreSQLDriver = &PostgreSQLBuilderDriver + var SqliteDriver = &SqliteBuilderDriver + func RegisterDriver(name string, driver BuilderDriver) + type Builder struct + Driver string + func New() *Builder + func (b *Builder) And(q ...Query) *PlainQuery + func (b *Builder) Between(field string, start interface{}, end interface{}) *PlainQuery + func (b *Builder) Comma(q ...Query) *PlainQuery + func (b *Builder) Concat(q ...Query) *PlainQuery + func (b *Builder) CountField() string + func (b *Builder) Equal(field string, arg interface{}) *PlainQuery + func (b *Builder) EscapeSearch(arg string) string + func (b *Builder) Exec(db DB, q Query) (sql.Result, error) + func (b *Builder) In(field string, args interface{}) *PlainQuery + func (b *Builder) Lines(q ...Query) *PlainQuery + func (b *Builder) LoadDriver() BuilderDriver + func (b *Builder) New(command string, args ...interface{}) *PlainQuery + func (b *Builder) NewDelete(TableName string) *Delete + func (b *Builder) NewDeleteClause(tableName string) *DeleteClause + func (b *Builder) NewFromClause() *FromClause + func (b *Builder) NewGroupByClause() *GroupByClause + func (b *Builder) NewHavingClause() *HavingClause + func (b *Builder) NewInsert(tableName string) *Insert + func (b *Builder) NewInsertClause(tableName string) *InsertClause + func (b *Builder) NewJoinClause() *JoinClause + func (b *Builder) NewLimitClause() *LimitClause + func (b *Builder) NewOrderByClause() *OrderByClause + func (b *Builder) NewSelect() *Select + func (b *Builder) NewSelectClause() *SelectClause + func (b *Builder) NewUpdate(tableName string) *Update + func (b *Builder) NewUpdateClause(tableName string) *UpdateClause + func (b *Builder) NewValueList(data ...interface{}) *PlainQuery + func (b *Builder) NewWhereClause() *WhereClause + func (b *Builder) Or(q ...Query) *PlainQuery + func (b *Builder) QueryRow(db DB, q Query) *sql.Row + func (b *Builder) QueryRows(db DB, q Query) (*sql.Rows, error) + func (b *Builder) Search(field string, arg string) *PlainQuery + type BuilderDriver interface + ConvertQuery func(q Query) (string, []interface{}) + CountField func() string + DeleteArgBuilder func(q *DeleteClause) []interface{} + DeleteCommandBuilder func(q *DeleteClause) string + LimitArgBuilder func(q *LimitClause) []interface{} + LimitCommandBuilder func(q *LimitClause) string + type CommonQueryEvents struct + func (e CommonQueryEvents) AfterDelete() error + func (e CommonQueryEvents) AfterFind() error + func (e CommonQueryEvents) AfterInsert() error + func (e CommonQueryEvents) AfterUpdate() error + func (e CommonQueryEvents) BeforeInsert() error + func (e CommonQueryEvents) BeforeUpdate() error + type DB interface + Exec func(query string, args ...interface{}) (sql.Result, error) + Query func(query string, args ...interface{}) (*sql.Rows, error) + QueryRow func(query string, args ...interface{}) *sql.Row + type DBTable interface + Alias func() string + DB func() *sql.DB + Driver func() string + SetAlias func(string) + TableName func() string + type Delete struct + Builder *Builder + Delete *DeleteClause + Other *PlainQuery + Where *WhereClause + func (d *Delete) Query() *PlainQuery + type DeleteClause struct + Builder *Builder + Prefix *PlainQuery + TableName string + func (q *DeleteClause) QueryArgs() []interface{} + func (q *DeleteClause) QueryCommand() string + type EmptyBuilderDriver struct + func (d *EmptyBuilderDriver) CountField() string + func (d *EmptyBuilderDriver) DeleteArgBuilder(q *DeleteClause) []interface{} + func (d *EmptyBuilderDriver) DeleteCommandBuilder(q *DeleteClause) string + func (d *EmptyBuilderDriver) LimitArgBuilder(q *LimitClause) []interface{} + func (d *EmptyBuilderDriver) LimitCommandBuilder(q *LimitClause) string + func (d EmptyBuilderDriver) ConvertQuery(q Query) (string, []interface{}) + type Field struct + Data interface{} + Field string + func NewField() *Field + type Fields []*Field + func NewFields() *Fields + func (f *Fields) Set(field string, data interface{}) *Fields + type FromClause struct + Buidler *Builder + Tables [][2]string + func (q *FromClause) Add(tableName string) *FromClause + func (q *FromClause) AddAlias(alias string, tableName string) *FromClause + func (q *FromClause) QueryArgs() []interface{} + func (q *FromClause) QueryCommand() string + type GroupByClause struct + Buidler *Builder + Fields []string + func (q *GroupByClause) Add(fields ...string) *GroupByClause + func (q *GroupByClause) QueryArgs() []interface{} + func (q *GroupByClause) QueryCommand() string + type HavingClause struct + Buidler *Builder + Condition *PlainQuery + func (q *HavingClause) QueryArgs() []interface{} + func (q *HavingClause) QueryCommand() string + type Insert struct + Builder *Builder + Insert *InsertClause + Other *PlainQuery + func (i *Insert) Query() *PlainQuery + type InsertClause struct + Builder *Builder + Data []QueryData + Prefix *PlainQuery + Select *Select + TableName string + func (q *InsertClause) Add(field string, data interface{}) *InsertClause + func (q *InsertClause) AddFields(m *Fields) *InsertClause + func (q *InsertClause) AddRaw(field string, raw string) *InsertClause + func (q *InsertClause) AddSelect(field string, Select *Select) *InsertClause + func (q *InsertClause) QueryArgs() []interface{} + func (q *InsertClause) QueryCommand() string + func (q *InsertClause) WithSelect(s *Select) *InsertClause + type JoinClause struct + Builder *Builder + Data []*JoinData + func (q *JoinClause) InnerJoin() *JoinData + func (q *JoinClause) LeftJoin() *JoinData + func (q *JoinClause) QueryArgs() []interface{} + func (q *JoinClause) QueryCommand() string + func (q *JoinClause) RightJoin() *JoinData + type JoinData struct + Condition *PlainQuery + Table [2]string + Type string + func (d *JoinData) Alias(alias string, tableName string) *JoinData + func (d *JoinData) On(condition *PlainQuery) *JoinData + func (d *JoinData) QueryArgs() []interface{} + func (d *JoinData) QueryCommand() string + type LimitClause struct + Limit *int + Offset *int + func (q *LimitClause) QueryArgs() []interface{} + func (q *LimitClause) QueryCommand() string + func (q *LimitClause) SetLimit(l int) *LimitClause + func (q *LimitClause) SetOffset(o int) *LimitClause + type MSSQLBuilderDriver struct + func (d *MSSQLBuilderDriver) LimitArgBuilder(q *LimitClause) []interface{} + func (d *MSSQLBuilderDriver) LimitCommandBuilder(q *LimitClause) string + type Order struct + Asc bool + Field string + type OrderByClause struct + Orders []Order + func (q *OrderByClause) Add(field string, asc bool) *OrderByClause + func (q *OrderByClause) QueryArgs() []interface{} + func (q *OrderByClause) QueryCommand() string + type PlainQuery struct + Args []interface{} + Builder *Builder + Command string + func (q *PlainQuery) And(qs ...Query) *PlainQuery + func (q *PlainQuery) Exec(db DB) (sql.Result, error) + func (q *PlainQuery) MustExec(db DB) sql.Result + func (q *PlainQuery) Or(qs ...Query) *PlainQuery + func (q *PlainQuery) QueryArgs() []interface{} + func (q *PlainQuery) QueryCommand() string + func (q *PlainQuery) QueryRow(db DB) *sql.Row + func (q *PlainQuery) QueryRows(db DB) (*sql.Rows, error) + type PostgreSQLBuilderDriver struct + func (d PostgreSQLBuilderDriver) ConvertQuery(q Query) (string, []interface{}) + type Query interface + QueryArgs func() []interface{} + QueryCommand func() string + type QueryData struct + Data []interface{} + Field string + Raw string + type ResultScanner interface + Scan func(dest ...interface{}) error + type Select struct + Builder *Builder + From *FromClause + GroupBy *GroupByClause + Having *HavingClause + Join *JoinClause + Limit *LimitClause + OrderBy *OrderByClause + Other *PlainQuery + Select *SelectClause + Where *WhereClause + func (s *Select) Query() *PlainQuery + func (s *Select) QueryArgs() []interface{} + func (s *Select) QueryCommand() string + func (s *Select) QueryRow(db DB) *sql.Row + func (s *Select) QueryRows(db DB) (*sql.Rows, error) + func (s *Select) Result() *SelectResult + type SelectClause struct + Builder *Builder + Fields []string + Prefix *PlainQuery + func (q *SelectClause) Add(fields ...string) *SelectClause + func (q *SelectClause) AddFields(m *Fields) *SelectClause + func (q *SelectClause) AddRaw(fields ...interface{}) *SelectClause + func (q *SelectClause) AddSelect(Select *Select) *SelectClause + func (q *SelectClause) QueryArgs() []interface{} + func (q *SelectClause) QueryCommand() string + func (q *SelectClause) Result() *SelectResult + type SelectResult struct + Fields []string + func NewSelectResult(fields []string) *SelectResult + func (r *SelectResult) Bind(field string, pointer interface{}) *SelectResult + func (r *SelectResult) BindFields(m *Fields) *SelectResult + func (r *SelectResult) Pointers() []interface{} + func (r *SelectResult) ScanFrom(s ResultScanner) error + type SqliteBuilderDriver struct + type Table struct + func NewTable(dbtable DBTable) *Table + func (t *Table) BuildCount() *Select + func (t *Table) Count(Select *Select) (int, error) + func (t *Table) FieldAlias(field string) string + func (t *Table) NewDelete() *Delete + func (t *Table) NewInsert() *Insert + func (t *Table) NewSelect() *Select + func (t *Table) NewUpdate() *Update + func (t *Table) QueryBuilder() *Builder + type Update struct + Builder *Builder + Other *PlainQuery + Update *UpdateClause + Where *WhereClause + func (u *Update) Query() *PlainQuery + func (u *Update) QueryArgs() []interface{} + func (u *Update) QueryCommand() string + type UpdateClause struct + Builder *Builder + Data []QueryData + Prefix *PlainQuery + TableName string + func (q *UpdateClause) Add(field string, data interface{}) *UpdateClause + func (q *UpdateClause) AddFields(m *Fields) *UpdateClause + func (q *UpdateClause) AddRaw(field string, raw string) *UpdateClause + func (q *UpdateClause) AddSelect(field string, Select *Select) *UpdateClause + func (q *UpdateClause) QueryArgs() []interface{} + func (q *UpdateClause) QueryCommand() string + type WhereClause struct + Builder *Builder + Condition *PlainQuery + func (q *WhereClause) QueryArgs() []interface{} + func (q *WhereClause) QueryCommand() string
Go to main page