Why Go
- Case Studies
  
  Common problems companies solve with Go
- Use Cases
  
  Stories about how and why companies use Go
- Security
  
  How Go can help keep you secure by default
Learn
Docs
- Effective Go
  
  Tips for writing clear, performant, and idiomatic Go code
- Go User Manual
  
  A complete introduction to building software with Go
- Standard library
  
  Reference documentation for Go's standard library
- Release Notes
  
  Learn what's new in each Go release
Packages
Community
- Recorded Talks
  
  Videos from prior events
- Meetups
  
  Meet other local Go developers
- Conferences
  
  Learn and network with Go developers from around the world
- Go blog
  
  The Go project's official blog.
- Go project
  
  Get help and stay informed from Go
- Get connected

sqlbuilder

package

Go to main page

Versions in this module

v2

v2.1.1

Jun 10, 2019

v2.1.0

Jun 9, 2019

v2.0.0

May 20, 2019

Changes in this version

+ var ErrArgsNotMatch = errors.New("列与值的数量不匹配")

+ var ErrColumnsIsEmpty = errors.New("未指定列")

+ var ErrDupColumn = errors.New("重复的列名")

+ var ErrTableIsEmpty = errors.New("表名为空")

+ var ErrValueIsEmpty = errors.New("值为空")

+ type CreateIndexStmt struct

+ func CreateIndex(e Engine) *CreateIndexStmt

+ func (stmt *CreateIndexStmt) Columns(col ...string) *CreateIndexStmt

+ func (stmt *CreateIndexStmt) Exec() (sql.Result, error)

+ func (stmt *CreateIndexStmt) ExecContext(ctx context.Context) (sql.Result, error)

+ func (stmt *CreateIndexStmt) Name(col string) *CreateIndexStmt

+ func (stmt *CreateIndexStmt) Prepare() (*sql.Stmt, error)

+ func (stmt *CreateIndexStmt) PrepareContext(ctx context.Context) (*sql.Stmt, error)

+ func (stmt *CreateIndexStmt) Reset()

+ func (stmt *CreateIndexStmt) SQL() (string, []interface{}, error)

+ func (stmt *CreateIndexStmt) Table(tbl string) *CreateIndexStmt

+ type DeleteStmt struct

+ func Delete(e Engine) *DeleteStmt

+ func (stmt *DeleteStmt) And(cond string, args ...interface{}) *DeleteStmt

+ func (stmt *DeleteStmt) Exec() (sql.Result, error)

+ func (stmt *DeleteStmt) ExecContext(ctx context.Context) (sql.Result, error)

+ func (stmt *DeleteStmt) Or(cond string, args ...interface{}) *DeleteStmt

+ func (stmt *DeleteStmt) Prepare() (*sql.Stmt, error)

+ func (stmt *DeleteStmt) PrepareContext(ctx context.Context) (*sql.Stmt, error)

+ func (stmt *DeleteStmt) Reset()

+ func (stmt *DeleteStmt) SQL() (string, []interface{}, error)

+ func (stmt *DeleteStmt) Table(table string) *DeleteStmt

+ func (stmt *DeleteStmt) Where(cond string, args ...interface{}) *DeleteStmt

+ func (stmt *DeleteStmt) WhereStmt() *WhereStmt

+ type Dialect interface

+ LastInsertID func(table, col string) (sql string, append bool)

+ LimitSQL func(limit interface{}, offset ...interface{}) (string, []interface{})

+ type DropTableStmt struct

+ func DropTable(e Engine) *DropTableStmt

+ func (stmt *DropTableStmt) Exec() (sql.Result, error)

+ func (stmt *DropTableStmt) ExecContext(ctx context.Context) (sql.Result, error)

+ func (stmt *DropTableStmt) Prepare() (*sql.Stmt, error)

+ func (stmt *DropTableStmt) PrepareContext(ctx context.Context) (*sql.Stmt, error)

+ func (stmt *DropTableStmt) Reset()

+ func (stmt *DropTableStmt) SQL() (string, []interface{}, error)

+ func (stmt *DropTableStmt) Table(table string) *DropTableStmt

+ type Engine interface

+ Exec func(query string, args ...interface{}) (sql.Result, error)

+ ExecContext func(ctx context.Context, query string, args ...interface{}) (sql.Result, error)

+ Prepare func(query string) (*sql.Stmt, error)

+ PrepareContext func(ctx context.Context, query string) (*sql.Stmt, error)

+ Query func(query string, args ...interface{}) (*sql.Rows, error)

+ QueryContext func(ctx context.Context, query string, args ...interface{}) (*sql.Rows, error)

+ QueryRow func(query string, args ...interface{}) *sql.Row

+ QueryRowContext func(ctx context.Context, query string, args ...interface{}) *sql.Row

+ type InsertStmt struct

+ func Insert(e Engine, d Dialect) *InsertStmt

+ func (stmt *InsertStmt) Columns(cols ...string) *InsertStmt

+ func (stmt *InsertStmt) Exec() (sql.Result, error)

+ func (stmt *InsertStmt) ExecContext(ctx context.Context) (sql.Result, error)

+ func (stmt *InsertStmt) KeyValue(col string, val interface{}) *InsertStmt

+ func (stmt *InsertStmt) LastInsertID(table, col string) (int64, error)

+ func (stmt *InsertStmt) LastInsertIDContext(ctx context.Context, table, col string) (int64, error)

+ func (stmt *InsertStmt) Prepare() (*sql.Stmt, error)

+ func (stmt *InsertStmt) PrepareContext(ctx context.Context) (*sql.Stmt, error)

+ func (stmt *InsertStmt) Reset()

+ func (stmt *InsertStmt) SQL() (string, []interface{}, error)

+ func (stmt *InsertStmt) Table(table string) *InsertStmt

+ func (stmt *InsertStmt) Values(vals ...interface{}) *InsertStmt

+ type SQLBuilder bytes.Buffer

+ func New(str string) *SQLBuilder

+ func (b *SQLBuilder) Bytes() []byte

+ func (b *SQLBuilder) Len() int

+ func (b *SQLBuilder) Reset() *SQLBuilder

+ func (b *SQLBuilder) String() string

+ func (b *SQLBuilder) TruncateLast(n int) *SQLBuilder

+ func (b *SQLBuilder) WriteByte(c byte) *SQLBuilder

+ func (b *SQLBuilder) WriteString(str string) *SQLBuilder

+ type SQLer interface

+ Reset func()

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

+ type SelectStmt struct

+ func Select(e Engine, d Dialect) *SelectStmt

+ func (stmt *SelectStmt) And(cond string, args ...interface{}) *SelectStmt

+ func (stmt *SelectStmt) Asc(col ...string) *SelectStmt

+ func (stmt *SelectStmt) Count(expr string) *SelectStmt

+ func (stmt *SelectStmt) Desc(col ...string) *SelectStmt

+ func (stmt *SelectStmt) Distinct() *SelectStmt

+ func (stmt *SelectStmt) ForUpdate() *SelectStmt

+ func (stmt *SelectStmt) From(table string) *SelectStmt

+ func (stmt *SelectStmt) Group(col string) *SelectStmt

+ func (stmt *SelectStmt) Having(expr string, args ...interface{}) *SelectStmt

+ func (stmt *SelectStmt) Join(typ, table, on string) *SelectStmt

+ func (stmt *SelectStmt) Limit(limit interface{}, offset ...interface{}) *SelectStmt

+ func (stmt *SelectStmt) Or(cond string, args ...interface{}) *SelectStmt

+ func (stmt *SelectStmt) Prepare() (*sql.Stmt, error)

+ func (stmt *SelectStmt) PrepareContext(ctx context.Context) (*sql.Stmt, error)

+ func (stmt *SelectStmt) Query() (*sql.Rows, error)

+ func (stmt *SelectStmt) QueryContext(ctx context.Context) (*sql.Rows, error)

+ func (stmt *SelectStmt) QueryFloat(colName string) (float64, error)

+ func (stmt *SelectStmt) QueryInt(colName string) (int64, error)

+ func (stmt *SelectStmt) QueryObject(strict bool, objs interface{}) (int, error)

+ func (stmt *SelectStmt) Reset()

+ func (stmt *SelectStmt) SQL() (string, []interface{}, error)

+ func (stmt *SelectStmt) Select(cols ...string) *SelectStmt

+ func (stmt *SelectStmt) Where(cond string, args ...interface{}) *SelectStmt

+ func (stmt *SelectStmt) WhereStmt() *WhereStmt

+ type UpdateStmt struct

+ func Update(e Engine) *UpdateStmt

+ func (stmt *UpdateStmt) And(cond string, args ...interface{}) *UpdateStmt

+ func (stmt *UpdateStmt) Decrease(col string, val interface{}) *UpdateStmt

+ func (stmt *UpdateStmt) Exec() (sql.Result, error)

+ func (stmt *UpdateStmt) ExecContext(ctx context.Context) (sql.Result, error)

+ func (stmt *UpdateStmt) Increase(col string, val interface{}) *UpdateStmt

+ func (stmt *UpdateStmt) OCC(col string, val interface{}) *UpdateStmt

+ func (stmt *UpdateStmt) Or(cond string, args ...interface{}) *UpdateStmt

+ func (stmt *UpdateStmt) Prepare() (*sql.Stmt, error)

+ func (stmt *UpdateStmt) PrepareContext(ctx context.Context) (*sql.Stmt, error)

+ func (stmt *UpdateStmt) Reset()

+ func (stmt *UpdateStmt) SQL() (string, []interface{}, error)

+ func (stmt *UpdateStmt) Set(col string, val interface{}) *UpdateStmt

+ func (stmt *UpdateStmt) Table(table string) *UpdateStmt

+ func (stmt *UpdateStmt) Where(cond string, args ...interface{}) *UpdateStmt

+ func (stmt *UpdateStmt) WhereStmt() *WhereStmt

+ type WhereStmt struct

+ func Where() *WhereStmt

+ func (stmt *WhereStmt) And(cond string, args ...interface{}) *WhereStmt

+ func (stmt *WhereStmt) AndWhere(w *WhereStmt) *WhereStmt

+ func (stmt *WhereStmt) Or(cond string, args ...interface{}) *WhereStmt

+ func (stmt *WhereStmt) OrWhere(w *WhereStmt) *WhereStmt

+ func (stmt *WhereStmt) Reset()

+ func (stmt *WhereStmt) SQL() (string, []interface{}, error)

+ type WhereStmter interface

+ WhereStmt func() *WhereStmt

Other modules containing this package

github.com/issue9/orm

github.com/issue9/orm/v3

github.com/issue9/orm/v4

github.com/issue9/orm/v5

github.com/issue9/orm/v6