sql_builder.go

package yiigo

import (
	"context"
	"database/sql"
	"errors"
	"fmt"
	"reflect"
	"strings"

	"github.com/jmoiron/sqlx"
)

var (
	// ErrSQLDataType 不合法的插入或更新数据类型错误
	ErrSQLDataType = errors.New("invaild data type, expects: struct, *struct, yiigo.X")

	// ErrSQLBatchDataType 不合法的批量插入数据类型错误
	ErrSQLBatchDataType = errors.New("invaild data type, expects: []struct, []*struct, []yiigo.X")
)

// ------------------------------------ TXBuilder ------------------------------------

// TXBuilder 事务构造器
type TXBuilder interface {
	// Wrap 包装查询选项
	Wrap(opts ...SQLOption) SQLWrapper
	// 私有方法
	one(ctx context.Context, dest any, query string, args ...any) error
	all(ctx context.Context, dest any, query string, args ...any) error
	exec(ctx context.Context, query string, args ...any) (sql.Result, error)
}

type txBuilder struct {
	tx  *sqlx.Tx
	log func(ctx context.Context, query string, args ...any)
}

func (b *txBuilder) Wrap(opts ...SQLOption) SQLWrapper {
	wrapper := &sqlWrapper{
		tx:      b,
		columns: []string{"*"},
	}
	for _, f := range opts {
		f(wrapper)
	}
	return wrapper
}

func (b *txBuilder) one(ctx context.Context, dest any, query string, args ...any) error {
	query = sqlx.Rebind(sqlx.BindType(b.tx.DriverName()), query)
	if b.log != nil {
		b.log(ctx, query, args...)
	}
	return b.tx.GetContext(ctx, dest, query, args...)
}

func (b *txBuilder) all(ctx context.Context, dest any, query string, args ...any) error {
	query = sqlx.Rebind(sqlx.BindType(b.tx.DriverName()), query)
	if b.log != nil {
		b.log(ctx, query, args...)
	}
	return b.tx.SelectContext(ctx, dest, query, args...)
}

func (b *txBuilder) exec(ctx context.Context, query string, args ...any) (sql.Result, error) {
	query = sqlx.Rebind(sqlx.BindType(b.tx.DriverName()), query)
	if b.log != nil {
		b.log(ctx, query, args...)
	}
	return b.tx.ExecContext(ctx, query, args...)
}

// ------------------------------------ SQLBuilder ------------------------------------

// SQLBuilder SQL构造器
type SQLBuilder interface {
	TXBuilder
	// Transaction 启用事务
	Transaction(ctx context.Context, f func(ctx context.Context, tx TXBuilder) error) error
}

type sqlBuilder struct {
	db  *sqlx.DB
	log func(ctx context.Context, query string, args ...any)
}

func (b *sqlBuilder) Wrap(opts ...SQLOption) SQLWrapper {
	wrapper := &sqlWrapper{
		tx:      b,
		columns: []string{"*"},
	}
	for _, f := range opts {
		f(wrapper)
	}
	return wrapper
}

func (b *sqlBuilder) Transaction(ctx context.Context, fn func(ctx context.Context, tx TXBuilder) error) error {
	tx, err := b.db.BeginTxx(ctx, nil)
	if err != nil {
		return err
	}

	defer func() {
		if v := recover(); v != nil {
			_ = tx.Rollback()
			panic(v)
		}
	}()

	if err = fn(ctx, &txBuilder{
		tx:  tx,
		log: b.log,
	}); err != nil {
		if rerr := tx.Rollback(); rerr != nil {
			err = fmt.Errorf("%w: rolling back transaction: %v", err, rerr)
		}
		return err
	}
	if err = tx.Commit(); err != nil {
		return fmt.Errorf("committing transaction: %w", err)
	}
	return nil
}

func (b *sqlBuilder) one(ctx context.Context, dest any, query string, args ...any) error {
	query = sqlx.Rebind(sqlx.BindType(b.db.DriverName()), query)
	if b.log != nil {
		b.log(ctx, query, args...)
	}
	return b.db.GetContext(ctx, dest, query, args...)
}

func (b *sqlBuilder) all(ctx context.Context, dest any, query string, args ...any) error {
	query = sqlx.Rebind(sqlx.BindType(b.db.DriverName()), query)
	if b.log != nil {
		b.log(ctx, query, args...)
	}
	return b.db.SelectContext(ctx, dest, query, args...)
}

func (b *sqlBuilder) exec(ctx context.Context, query string, args ...any) (sql.Result, error) {
	query = sqlx.Rebind(sqlx.BindType(b.db.DriverName()), query)
	if b.log != nil {
		b.log(ctx, query, args...)
	}
	return b.db.ExecContext(ctx, query, args...)
}

// NewSQLBuilder 生成SQL构造器
func NewSQLBuilder(db *sqlx.DB, logFn func(ctx context.Context, query string, args ...any)) SQLBuilder {
	return &sqlBuilder{
		db:  db,
		log: logFn,
	}
}

// ------------------------------------ SQLWrapper ------------------------------------

// SQLWrapper SQL包装器
type SQLWrapper interface {
	// One 查询一条数据
	One(ctx context.Context, data any) error
	// All 查询多条数据
	All(ctx context.Context, data any) error
	// Insert 插入数据 (数据类型：`struct`, `*struct`, `yiigo.X`)
	Insert(ctx context.Context, data any) (sql.Result, error)
	// BatchInsert 批量插入数据 (数据类型：`[]struct`, `[]*struct`, `[]yiigo.X`)
	BatchInsert(ctx context.Context, data any) (sql.Result, error)
	// Update 更新数据 (数据类型：`struct`, `*struct`, `yiigo.X`)
	Update(ctx context.Context, data any) (sql.Result, error)
	// Delete 删除数据
	Delete(ctx context.Context) (sql.Result, error)
	// Truncate 清空表
	Truncate(ctx context.Context) (sql.Result, error)
}

// SQLClause SQL语句
type SQLClause struct {
	table   string
	keyword string
	query   string
	binds   []any
}

// SQLExpr 生成一个语句表达式，例如：yiigo.SQLExpr("price * ? + ?", 2, 100)
func SQLExpr(query string, binds ...any) *SQLClause {
	return &SQLClause{
		query: query,
		binds: binds,
	}
}

type sqlWrapper struct {
	tx        TXBuilder
	table     string
	columns   []string
	where     *SQLClause
	joins     []*SQLClause
	groups    []string
	having    *SQLClause
	orders    []string
	offset    int
	limit     int
	returning string
	unions    []*SQLClause
	distinct  bool
	whereIn   bool
}

func (w *sqlWrapper) One(ctx context.Context, dest any) error {
	query, args, err := w.querySQL()
	if err != nil {
		return err
	}
	return w.tx.one(ctx, dest, query, args...)
}

func (w *sqlWrapper) All(ctx context.Context, dest any) error {
	query, args, err := w.querySQL()
	if err != nil {
		return err
	}
	return w.tx.all(ctx, dest, query, args...)
}

func (w *sqlWrapper) Insert(ctx context.Context, data any) (sql.Result, error) {
	query, args, err := w.insertSQL(data)
	if err != nil {
		return nil, err
	}
	return w.tx.exec(ctx, query, args...)
}

func (w *sqlWrapper) BatchInsert(ctx context.Context, data any) (sql.Result, error) {
	query, args, err := w.batchInsertSQL(data)
	if err != nil {
		return nil, err
	}
	return w.tx.exec(ctx, query, args...)
}

func (w *sqlWrapper) Update(ctx context.Context, data any) (sql.Result, error) {
	query, args, err := w.updateSQL(data)
	if err != nil {
		return nil, err
	}
	return w.tx.exec(ctx, query, args...)
}

func (w *sqlWrapper) Delete(ctx context.Context) (sql.Result, error) {
	query, args, err := w.deleteSQL()
	if err != nil {
		return nil, err
	}
	return w.tx.exec(ctx, query, args...)
}

func (w *sqlWrapper) Truncate(ctx context.Context) (sql.Result, error) {
	return w.tx.exec(ctx, w.truncateSQL())
}

func (w *sqlWrapper) querySQL() (sql string, args []any, err error) {
	sql, args = w.subquery()

	// unions
	if l := len(w.unions); l != 0 {
		var builder strings.Builder

		builder.WriteString("(")
		builder.WriteString(sql)
		builder.WriteString(")")

		for _, v := range w.unions {
			builder.WriteString(" ")
			builder.WriteString(v.keyword)
			builder.WriteString(" (")
			builder.WriteString(v.query)
			builder.WriteString(")")

			args = append(args, v.binds...)
		}

		sql = builder.String()
	}

	// where in
	if w.whereIn {
		sql, args, err = sqlx.In(sql, args...)
		if err != nil {
			return
		}
	}

	return
}

func (w *sqlWrapper) subquery() (string, []any) {
	binds := make([]any, 0)

	var builder strings.Builder

	builder.WriteString("SELECT ")
	if w.distinct {
		builder.WriteString("DISTINCT ")
	}

	builder.WriteString(w.columns[0])

	for _, column := range w.columns[1:] {
		builder.WriteString(", ")
		builder.WriteString(column)
	}

	builder.WriteString(" FROM ")
	builder.WriteString(w.table)

	if len(w.joins) != 0 {
		for _, join := range w.joins {
			builder.WriteString(" ")
			builder.WriteString(join.keyword)
			builder.WriteString(" JOIN ")
			builder.WriteString(join.table)

			if len(join.query) != 0 {
				builder.WriteString(" ON ")
				builder.WriteString(join.query)
			}
		}
	}

	if w.where != nil {
		builder.WriteString(" WHERE ")
		builder.WriteString(w.where.query)

		binds = append(binds, w.where.binds...)
	}

	if len(w.groups) != 0 {
		builder.WriteString(" GROUP BY ")
		builder.WriteString(w.groups[0])

		for _, column := range w.groups[1:] {
			builder.WriteString(", ")
			builder.WriteString(column)
		}
	}

	if w.having != nil {
		builder.WriteString(" HAVING ")
		builder.WriteString(w.having.query)

		binds = append(binds, w.having.binds...)
	}

	if len(w.orders) != 0 {
		builder.WriteString(" ORDER BY ")
		builder.WriteString(w.orders[0])

		for _, column := range w.orders[1:] {
			builder.WriteString(", ")
			builder.WriteString(column)
		}
	}

	if w.limit != 0 {
		builder.WriteString(" LIMIT ?")
		binds = append(binds, w.limit)
	}

	if w.offset != 0 {
		builder.WriteString(" OFFSET ?")
		binds = append(binds, w.offset)
	}

	return builder.String(), binds
}

func (w *sqlWrapper) insertSQL(data any) (sql string, args []any, err error) {
	var columns []string

	v := reflect.Indirect(reflect.ValueOf(data))
	switch v.Kind() {
	case reflect.Map:
		x, ok := data.(X)
		if !ok {
			err = ErrSQLDataType
			return
		}
		columns, args = w.insertWithMap(x)
	case reflect.Struct:
		columns, args = w.insertWithStruct(v)
	default:
		err = ErrSQLDataType
		return
	}

	var builder strings.Builder

	builder.WriteString("INSERT INTO ")
	builder.WriteString(w.table)

	if l := len(columns); l != 0 {
		builder.WriteString(" (")
		builder.WriteString(columns[0])

		for _, column := range columns[1:] {
			builder.WriteString(", ")
			builder.WriteString(column)
		}

		builder.WriteString(") VALUES (?")
		for i := 1; i < l; i++ {
			builder.WriteString(", ?")
		}
		builder.WriteString(")")
	}

	if len(w.returning) != 0 {
		builder.WriteString(" RETURNING ")
		builder.WriteString(w.returning)
	}

	sql = builder.String()

	return
}

func (w *sqlWrapper) insertWithMap(data X) (columns []string, binds []any) {
	fieldNum := len(data)

	columns = make([]string, 0, fieldNum)
	binds = make([]any, 0, fieldNum)

	for k, v := range data {
		columns = append(columns, k)
		binds = append(binds, v)
	}

	return
}

func (w *sqlWrapper) insertWithStruct(v reflect.Value) (columns []string, binds []any) {
	fieldNum := v.NumField()

	columns = make([]string, 0, fieldNum)
	binds = make([]any, 0, fieldNum)

	t := v.Type()

	for i := 0; i < fieldNum; i++ {
		fieldT := t.Field(i)
		tag := fieldT.Tag.Get("db")
		if tag == "-" {
			continue
		}

		fieldV := v.Field(i)
		column := fieldT.Name
		if len(tag) != 0 {
			name, opts := parseTag(tag)
			if opts.Contains("omitempty") && isEmptyValue(fieldV) {
				continue
			}
			column = name
		}
		columns = append(columns, column)
		binds = append(binds, fieldV.Interface())
	}

	return
}

func (w *sqlWrapper) batchInsertSQL(data any) (sql string, args []any, err error) {
	v := reflect.Indirect(reflect.ValueOf(data))
	if v.Kind() != reflect.Slice {
		err = ErrSQLBatchDataType
		return
	}
	if v.Len() == 0 {
		err = errors.New("err empty data")
		return
	}

	var columns []string

	e := v.Type().Elem()
	switch e.Kind() {
	case reflect.Map:
		x, ok := data.([]X)
		if !ok {
			err = ErrSQLBatchDataType
			return
		}
		columns, args = w.batchInsertWithMap(x)
	case reflect.Struct:
		columns, args = w.batchInsertWithStruct(v)
	case reflect.Ptr:
		if e.Elem().Kind() != reflect.Struct {
			err = ErrSQLBatchDataType
			return
		}
		columns, args = w.batchInsertWithStruct(v)
	default:
		err = ErrSQLBatchDataType
		return
	}

	var builder strings.Builder

	builder.WriteString("INSERT INTO ")
	builder.WriteString(w.table)

	if l := len(columns); l != 0 {
		builder.WriteString(" (")
		builder.WriteString(columns[0])

		for _, column := range columns[1:] {
			builder.WriteString(", ")
			builder.WriteString(column)
		}

		// 首行
		builder.WriteString(") VALUES (?")
		for i := 1; i < l; i++ {
			builder.WriteString(", ?")
		}
		builder.WriteString(")")

		rows := len(args) / l

		// 其余行
		for i := 1; i < rows; i++ {
			builder.WriteString(", (?")
			for j := 1; j < l; j++ {
				builder.WriteString(", ?")
			}
			builder.WriteString(")")
		}
	}

	sql = builder.String()

	return
}

func (w *sqlWrapper) batchInsertWithMap(data []X) (columns []string, binds []any) {
	dataLen := len(data)
	fieldNum := len(data[0])

	columns = make([]string, 0, fieldNum)
	binds = make([]any, 0, fieldNum*dataLen)

	for k := range data[0] {
		columns = append(columns, k)
	}

	for _, x := range data {
		for _, v := range columns {
			binds = append(binds, x[v])
		}
	}

	return
}

func (w *sqlWrapper) batchInsertWithStruct(v reflect.Value) (columns []string, binds []any) {
	first := reflect.Indirect(v.Index(0))

	dataLen := v.Len()
	fieldNum := first.NumField()

	columns = make([]string, 0, fieldNum)
	binds = make([]any, 0, fieldNum*dataLen)

	t := first.Type()

	for i := 0; i < dataLen; i++ {
		for j := 0; j < fieldNum; j++ {
			fieldT := t.Field(j)

			tag := fieldT.Tag.Get("db")
			if tag == "-" {
				continue
			}

			fieldV := reflect.Indirect(v.Index(i)).Field(j)
			column := fieldT.Name

			if len(tag) != 0 {
				name, opts := parseTag(tag)
				if opts.Contains("omitempty") && isEmptyValue(fieldV) {
					continue
				}

				column = name
			}

			if i == 0 {
				columns = append(columns, column)
			}

			binds = append(binds, fieldV.Interface())
		}
	}

	return
}

func (w *sqlWrapper) updateSQL(data any) (sql string, args []any, err error) {
	var (
		columns []string
		exprs   map[string]string
	)

	v := reflect.Indirect(reflect.ValueOf(data))

	switch v.Kind() {
	case reflect.Map:
		x, ok := data.(X)
		if !ok {
			err = ErrSQLDataType
			return
		}

		columns, exprs, args = w.updateWithMap(x)
	case reflect.Struct:
		columns, args = w.updateWithStruct(v)
	default:
		err = ErrSQLDataType
		return
	}

	var builder strings.Builder

	builder.WriteString("UPDATE ")
	builder.WriteString(w.table)

	if len(columns) != 0 {
		builder.WriteString(" SET ")
		builder.WriteString(columns[0])

		if expr, ok := exprs[columns[0]]; ok {
			builder.WriteString(" = ")
			builder.WriteString(expr)
		} else {
			builder.WriteString(" = ?")
		}

		for _, column := range columns[1:] {
			builder.WriteString(", ")
			builder.WriteString(column)

			if expr, ok := exprs[column]; ok {
				builder.WriteString(" = ")
				builder.WriteString(expr)
			} else {
				builder.WriteString(" = ?")
			}
		}
	}

	if w.where != nil {
		builder.WriteString(" WHERE ")
		builder.WriteString(w.where.query)

		args = append(args, w.where.binds...)
	}

	sql = builder.String()

	if w.whereIn {
		sql, args, err = sqlx.In(sql, args...)
		if err != nil {
			return
		}
	}

	return
}

func (w *sqlWrapper) updateWithMap(data X) (columns []string, exprs map[string]string, binds []any) {
	fieldNum := len(data)

	columns = make([]string, 0, fieldNum)
	exprs = make(map[string]string)
	binds = make([]any, 0, fieldNum)

	for k, v := range data {
		columns = append(columns, k)

		if clause, ok := v.(*SQLClause); ok {
			exprs[k] = clause.query
			binds = append(binds, clause.binds...)

			continue
		}

		binds = append(binds, v)
	}

	return
}

func (w *sqlWrapper) updateWithStruct(v reflect.Value) (columns []string, binds []any) {
	fieldNum := v.NumField()

	columns = make([]string, 0, fieldNum)
	binds = make([]any, 0, fieldNum)

	t := v.Type()

	for i := 0; i < fieldNum; i++ {
		fieldT := t.Field(i)

		tag := fieldT.Tag.Get("db")
		if tag == "-" {
			continue
		}

		fieldV := v.Field(i)
		column := fieldT.Name

		if len(tag) != 0 {
			name, opts := parseTag(tag)
			if opts.Contains("omitempty") && isEmptyValue(fieldV) {
				continue
			}

			column = name
		}

		columns = append(columns, column)
		binds = append(binds, fieldV.Interface())
	}

	return
}

func (w *sqlWrapper) deleteSQL() (sql string, args []any, err error) {
	var builder strings.Builder

	builder.WriteString("DELETE FROM ")
	builder.WriteString(w.table)

	if w.where != nil {
		builder.WriteString(" WHERE ")
		builder.WriteString(w.where.query)

		args = append(args, w.where.binds...)
	}

	sql = builder.String()

	if w.whereIn {
		sql, args, err = sqlx.In(sql, args...)
		if err != nil {
			return
		}
	}

	return
}

func (w *sqlWrapper) truncateSQL() string {
	var builder strings.Builder

	builder.WriteString("TRUNCATE ")
	builder.WriteString(w.table)

	return builder.String()
}

// SQLOption SQL查询选项
type SQLOption func(w *sqlWrapper)

// Table 指定查询表名称
func Table(name string) SQLOption {
	return func(w *sqlWrapper) {
		w.table = name
	}
}

// Select 指定查询字段名
func Select(columns ...string) SQLOption {
	return func(w *sqlWrapper) {
		w.columns = columns
	}
}

// Distinct 指定 `DISTINCT` 子句
func Distinct(columns ...string) SQLOption {
	return func(w *sqlWrapper) {
		w.columns = columns
		w.distinct = true
	}
}

// Join 指定 `INNER JOIN` 子句
func Join(table, on string) SQLOption {
	return func(w *sqlWrapper) {
		w.joins = append(w.joins, &SQLClause{
			table:   table,
			keyword: "INNER",
			query:   on,
		})
	}
}

// LeftJoin 指定 `LEFT JOIN` 子句
func LeftJoin(table, on string) SQLOption {
	return func(w *sqlWrapper) {
		w.joins = append(w.joins, &SQLClause{
			table:   table,
			keyword: "LEFT",
			query:   on,
		})
	}
}

// RightJoin 指定 `RIGHT JOIN` 子句
func RightJoin(table, on string) SQLOption {
	return func(w *sqlWrapper) {
		w.joins = append(w.joins, &SQLClause{
			table:   table,
			keyword: "RIGHT",
			query:   on,
		})
	}
}

// FullJoin 指定 `FULL JOIN` 子句
func FullJoin(table, on string) SQLOption {
	return func(w *sqlWrapper) {
		w.joins = append(w.joins, &SQLClause{
			table:   table,
			keyword: "FULL",
			query:   on,
		})
	}
}

// CrossJoin 指定 `CROSS JOIN` 语句
func CrossJoin(table string) SQLOption {
	return func(w *sqlWrapper) {
		w.joins = append(w.joins, &SQLClause{
			table:   table,
			keyword: "CROSS",
		})
	}
}

// Where 指定 `WHERE` 子句
func Where(query string, binds ...any) SQLOption {
	return func(w *sqlWrapper) {
		w.where = &SQLClause{
			query: query,
			binds: binds,
		}
	}
}

// WhereIn 指定 `WHERE IN` 子句
func WhereIn(query string, binds ...any) SQLOption {
	return func(w *sqlWrapper) {
		w.where = &SQLClause{
			query: query,
			binds: binds,
		}
		w.whereIn = true
	}
}

// GroupBy 指定 `GROUP BY` 子句
func GroupBy(columns ...string) SQLOption {
	return func(w *sqlWrapper) {
		w.groups = columns
	}
}

// Having 指定 `HAVING` 子句
func Having(query string, binds ...any) SQLOption {
	return func(w *sqlWrapper) {
		w.having = &SQLClause{
			query: query,
			binds: binds,
		}
	}
}

// OrderBy 指定 `ORDER BY` 子句
func OrderBy(columns ...string) SQLOption {
	return func(w *sqlWrapper) {
		w.orders = columns
	}
}

// Offset 指定 `OFFSET` 子句
func Offset(n int) SQLOption {
	return func(w *sqlWrapper) {
		w.offset = n
	}
}

// Limit 指定 `LIMIT` 子句
func Limit(n int) SQLOption {
	return func(w *sqlWrapper) {
		w.limit = n
	}
}

// Returning 指定 `RETURNING` 子句；
// 用于 PostgresSQL 和 SQLite(3.35.0) `INSERT` 语句
func Returning(column string) SQLOption {
	return func(w *sqlWrapper) {
		w.returning = column
	}
}

// Union 指定 `UNION` 子句
func Union(wrappers ...SQLWrapper) SQLOption {
	return func(w *sqlWrapper) {
		for _, wrapper := range wrappers {
			v, ok := wrapper.(*sqlWrapper)
			if !ok {
				continue
			}
			if v.whereIn {
				w.whereIn = true
			}
			query, binds := v.subquery()
			w.unions = append(w.unions, &SQLClause{
				keyword: "UNION",
				query:   query,
				binds:   binds,
			})
		}
	}
}

// UnionAll 指定 `UNION ALL` 子句
func UnionAll(wrappers ...SQLWrapper) SQLOption {
	return func(w *sqlWrapper) {
		for _, wrapper := range wrappers {
			v, ok := wrapper.(*sqlWrapper)
			if !ok {
				continue
			}
			if v.whereIn {
				w.whereIn = true
			}
			query, binds := v.subquery()
			w.unions = append(w.unions, &SQLClause{
				keyword: "UNION ALL",
				query:   query,
				binds:   binds,
			})
		}
	}
}

// tagOptions is the string following a comma in a struct field's "json"
// tag, or the empty string. It does not include the leading comma.
type tagOptions string

// Contains reports whether a comma-separated list of opts
// contains a particular substr flag. substr must be surrounded by a
// string boundary or commas.
func (o tagOptions) Contains(optionName string) bool {
	if len(o) == 0 {
		return false
	}

	s := string(o)
	for len(s) != 0 {
		var next string
		i := strings.Index(s, ",")
		if i >= 0 {
			s, next = s[:i], s[i+1:]
		}
		if s == optionName {
			return true
		}
		s = next
	}
	return false
}

// parseTag splits a struct field's json tag into its name and
// comma-separated opts.
func parseTag(tag string) (string, tagOptions) {
	if idx := strings.Index(tag, ","); idx != -1 {
		return tag[:idx], tagOptions(tag[idx+1:])
	}
	return tag, tagOptions("")
}

func isEmptyValue(v reflect.Value) bool {
	switch v.Kind() {
	case reflect.Array, reflect.Map, reflect.Slice, reflect.String:
		return v.Len() == 0
	case reflect.Bool:
		return !v.Bool()
	case reflect.Int, reflect.Int8, reflect.Int16, reflect.Int32, reflect.Int64:
		return v.Int() == 0
	case reflect.Uint, reflect.Uint8, reflect.Uint16, reflect.Uint32, reflect.Uint64, reflect.Uintptr:
		return v.Uint() == 0
	case reflect.Float32, reflect.Float64:
		return v.Float() == 0
	case reflect.Interface, reflect.Ptr:
		return v.IsNil()
	}
	return false
}