aorm/builder/increment.go

package builder

import "errors"

// Increment 某字段自增
func (b *Builder) Increment(field interface{}, step int) (int64, error) {
	var vars []any
	vars = append(vars, step)
	whereStr, vars, err := b.handleWhere(vars, false)
	if err != nil {
		return 0, err
	}

	if b.table == nil {
		return 0, errors.New("表名不能为空")
	}
	query := "UPDATE " + getTableNameByTable(b.table) + " SET " + getFieldNameByField(field) + "=" + getFieldNameByField(field) + "+?" + whereStr
	return b.execAffected(query, vars...)
}

// Decrement 某字段自减
func (b *Builder) Decrement(field interface{}, step int) (int64, error) {
	var vars []any
	vars = append(vars, step)
	whereStr, vars, err := b.handleWhere(vars, false)
	if err != nil {
		return 0, err
	}

	if b.table == nil {
		return 0, errors.New("表名不能为空")
	}
	query := "UPDATE " + getTableNameByTable(b.table) + " SET " + getFieldNameByField(field) + "=" + getFieldNameByField(field) + "-?" + whereStr
	return b.execAffected(query, vars...)
}