一个简单的生成SQL where语句的pkg

安装

go get github.com/wuyunhua1987/query-builder

Usage

import "github.com/wuyunhua1987/query-builder/builder"

b := builder.New()

b.And(
    b.Equal("id", 1),
    b.Like("name", "a", true, true),
    b.In("status", "1,2"),
    b.NULL("delete"),
    b.Or(
        b.NotEqual("email", "[email protected]"),
        b.NotIn("state", "2,3"),
        b.And(
            b.NotNULL("phone"),
            b.Equal("tel", "01"),
        ),
        b.Equal("del", 0),
    ),
)

sql, values := b.Parse()
fmt.Println(sql, values)
// `id` = ? AND `name` like ? AND `status` IN (?,?) AND `delete` IS NULL AND (`email` <> ? OR `state` NOT IN (?,?) OR (`phone` IS NOT NULL AND `tel` = ?) OR `del` = ?) [1 %a% 1 2 [email protected] 2 3 01 0]

有时候不需要and、or，可以使用Single()

b := New()
b.Single(
    b.Equal("id", 1),
)
cond, val := b.Parse()
t.Log(cond)
t.Log(val)
// `id` = ? [1]

扩展

如果满足不了你的需求，可以很方便的在自己的项目里扩展这个包

1. 首先定义你自己的where条件，实现Parse() (string, interface{})接口

// 假设这里有个位计算的操作
type BitBuilder struct {
	col string
	val interface{}
}

func (b *BitBuilder) Parse() (string, interface{}) {
	return fmt.Sprintf("%s & 0b01111 = ?", b.col), b.val
}

2. 使用

b := builder.New()

b.And(
    b.Equal("id", 1),
    b.Like("name", "a", true, true),
    b.In("status", 1, 2),
    b.NULL("delete"),
    b.Or(
        b.NotEqual("email", "[email protected]"),
        b.NotIn("state", 2, 3),
        b.And(
            b.NotNULL("phone"),
            b.Equal("tel", "01"),
        ),
        b.Equal("del", 0),
    ),
    &BitBuilder{"status", 0x1111}, // <======= 在这里使用用自定义的
)

sql, values := b.Parse()
fmt.Println(sql, values)
// `id` = ? AND `name` like ? AND `status` IN (?,?) AND `delete` IS NULL AND (`email` <> ? OR `state` NOT IN (?,?) OR (`phone` IS NOT NULL AND `tel` = ?) OR `del` = ?) [1 %a% 1 2 [email protected] 2 3 01 0]

3. 如果要扩展操作也是一样的，只需要实现Operate()接口和Parse() (string, interface{})接口即可