分享一个搬砖工具: 动态 SQL 查询条件构造器

仓库地址: https://github.com/lxzan/fi

动态 SQL 查询条件构造器, 默认跳过空指针和类型零值

反射模式

package main

import (
	"github.com/lxzan/fi"
)

type Request struct {
	StartTime int64  `filter:"cmp=gte"`
	EndTime   int64  `filter:"cmp=lt"`
	Name      string `filter:"cmp=eq"`
}

func main() {
	v := &Request{StartTime: 1, Name: "aha"}
	f := fi.GetFilter(v)
	println(f.GetExpression())
}

`start_time` >= ? AND `name` = ?

手动模式:

func (c *Request) GetFilter() *fi.Filter {
	return fi.
		NewFilter().
		Gte("start_time", c.StartTime).
		Lt("end_time", c.EndTime).
		Eq("name", c.Name)
}

性能测试 (10 个字段)

go test -benchmem -run=^$ -bench ^Benchmark github.com/lxzan/fi
goos: darwin
goarch: arm64
pkg: github.com/lxzan/fi
BenchmarkGetFilterReflect-8               501673              2374 ns/op            1376 B/op         37 allocs/op
BenchmarkGetFilterNoReflect-8            1650524               721.8 ns/op          1104 B/op         18 allocs/op
PASS
ok      github.com/lxzan/fi     4.035s