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

v1

v1.1.5

May 4, 2019

v1.1.4

Mar 24, 2019

v1.1.3

Feb 27, 2019

v1.1.2

Dec 24, 2018

v1.1.1

Oct 2, 2018

v1.1.0

Sep 16, 2018

Changes in this version

type SelectStmt

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

v1.0.0

Sep 4, 2018

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) QueryInt(colName string) (int64, error)

+ func (stmt *SelectStmt) QueryObj(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/v2

github.com/issue9/orm/v3

github.com/issue9/orm/v4

github.com/issue9/orm/v5

github.com/issue9/orm/v6