A Database Query Builder

Feature

1. Support Mysql, Pgsql, Sqlite, Oracle and easy to support more database
2. Clear Interface
3. Just Compile Sql, Can Use With All database/sql

API go query builder

Sample

simple query example

import (
    . "yang-zzhong/go-querybuilder"
)

users := NewBuilder(&MysqlPlaceholder{}).From("users")
users.Select("name", "id", "age")
users.Where("name", LIKE, "%Frank%")
users.Quote(func (users *Builder) {
    users.WhereIn("id", []string{"1", "2", "3"})
    users.Or().Where("age", GT, "15")
})

// open db
db.Query(users.ForQuery(), users.Params()...)

query with another table example

users := NewBuilder(&MysqlPlaceholder{}).From("users")
users.Select("id")
users.Where("name", LIKE, "%Frank%")

articles := builder.New().From("articles")
articles.WhereIn("author_id", users)
articles.OrderBy("created_at", DESC).Limit(10)

// open db
db.Query(articles.ForQuery(), articles.Params()...)

update example

users := NewBuilder(&MysqlPlaceholder{}).From("users")
users.WhereIn("name", []string{"Stiff", "Chunch"})

data := make(map[string]string)
data["age"] = "50"
data["name"] = "No Name"

// open db
db.Exec(users.ForUpdate(data), users.Params()...)

remove example

users := NewBuilder(&MysqlPlaceholder{}).From("users")
user.WhereIn("id", []string{"1", "2", "3"})

// open db
db.Exec(users.ForRemove(), users.Params()...)