README
¶
go-sqlbuilder
(unfinished) a very simple sql builder for golang.
TODO
-
dialect support for mysql/postgresql/sqlite etc... Only support mysql now. (escape character and placeholder were hard coded)
- escape character (mysql:`) (postgres:")
- placeholder for params binding (mysql:?) (postgres:$index)
- etc...
-
more statement support (group/having/join etc...)
-
more examples (you could find some in test file now)
-
more helpful usages
-
Long-term planning:
Maybe this package could be a micro ORM？Or add a simple scanner or DAO adapter?
I have already done a veeeeeery simple and crude demo but it's too simple.
In general, I hope this package as simple as possible. Waiting for above unitl I have enough free time (long after...).
Installation
go get -u github.com/DropFan/go-sqlbuilder
Usage (unfinished)
// TODO
Click here to get examples.
import (
builder "github.com/DropFan/go-sqlbuilder"
)
var (
b = builder.New()
q *Query
)
b.Select(fields...).
From("user").
Where(ageGT1, nameInNames).
And(sexEqFemale).
And().
Or(ageBetweenCond).
Or(nameEqCoder).
OrderBy(ageDesc, nameAsc).
Limit(0, 100)
q, err = b.Build()
Contacts
Author: Tiger(DropFan)
Email: DropFan@Gmail.com
Wechat: DropFan
Telegram: DropFan
License
Documentation
¶
Index ¶
- Constants
- type Builder
- func (b *Builder) And(conditions ...*Condition) *Builder
- func (b *Builder) Append(s string, args ...interface{}) *Builder
- func (b *Builder) AppendPre(s string, args ...interface{}) *Builder
- func (b *Builder) Build(queries ...interface{}) (q *Query, err error)
- func (b *Builder) Clear() *Builder
- func (b *Builder) Delete(tableName string) *Builder
- func (b *Builder) From(tables ...string) *Builder
- func (b *Builder) Insert(tableName string, fields ...string) *Builder
- func (b *Builder) Into(fields ...string) *Builder
- func (b *Builder) LastQueries() []*Query
- func (b *Builder) Limit(limitOffset ...int) *Builder
- func (b *Builder) Or(conditions ...*Condition) *Builder
- func (b *Builder) OrderBy(conditions ...*Condition) *Builder
- func (b *Builder) Query() string
- func (b *Builder) QueryArgs() []interface{}
- func (b *Builder) Raw(s string, args ...interface{}) *Builder
- func (b *Builder) Replace(tableName string, fields ...string) *Builder
- func (b *Builder) Select(fields ...string) *Builder
- func (b *Builder) Set(fvals ...*FieldValue) *Builder
- func (b *Builder) Update(tableName string, fvals ...*FieldValue) *Builder
- func (b *Builder) Values(valsGroup ...[]interface{}) *Builder
- func (b *Builder) Where(conditions ...*Condition) *Builder
- type Condition
- func And(field string, op string, values ...interface{}) *Condition
- func Asc(field string) *Condition
- func Desc(field string) *Condition
- func NewConditionGroup(conds ...*Condition) (cg []*Condition)
- func Or(field string, op string, values ...interface{}) *Condition
- func OrderBy(conds ...*Condition) (by []*Condition)
- type FieldValue
- type Query
- type SQLType
- type Values
Constants ¶
const ( // RawSQL ... RawSQL = iota + 1 // SelectSQL ... SelectSQL // InsertSQL ... InsertSQL // UpdateSQL ... UpdateSQL // DeleteSQL ... DeleteSQL )
Variables ¶
This section is empty.
Functions ¶
This section is empty.
Types ¶
type Builder ¶
type Builder struct {
ErrList []error
// contains filtered or unexported fields
}
Builder ...
func (*Builder) LastQueries ¶
LastQueries return last queries
func (*Builder) QueryArgs ¶
func (b *Builder) QueryArgs() []interface{}
QueryArgs return current query args
type Condition ¶
type Condition struct {
Field string // field name
Asc bool // true for `ASC`, false for `DESC`
AndOr bool // true for `AND`, false for `OR`
Operator string // where operator
Values []interface{} // query args
}
Condition for Where & Order Cluse
func NewConditionGroup ¶
NewConditionGroup ...
type FieldValue ¶
type FieldValue struct {
Name string
Value interface{}
}
FieldValue ...
func NewFieldValue ¶
func NewFieldValue(name string, value interface{}) *FieldValue
NewFieldValue ...
Source Files