The highest tagged major version is v2.

sqlbuilder

package

v0.3.0 Latest Latest Go to latest Published: May 18, 2020 License: MIT Imports: 2 Imported by: 85

Details

This section is empty.

This section is empty.

This section is empty.

type Query struct {
	// contains filtered or unexported fields
}

Query 查询mysql数据库

func NewQuery(querySQL string) *Query

NewQuery new 实例

func (q *Query) Build() (stmt string, args []interface{})

Build 组件SQL

func (q *Query) Desc() *Query

Desc todo

func (q *Query) Limit(offset int64, limit uint) *Query

Limit 这周Limit

func (q *Query) Order(d string) *Query

Order todo

func (q *Query) Where(stmt string, v ...interface{}) *Query

Where 添加参数

func (q *Query) WhereArgs() []interface{}

WhereArgs where 语句的参数

func (q *Query) WhereStmt() []string

WhereStmt where条件列表

func (q *Query) WithWhere(stmts []string, args []interface{}) *Query

WithWhere 携带条件