mysql_expr

Documentation

Index

• Variables
• type ConditionFn
• type Executor
  • func New(fnMap map[string]map[token.Token]ConditionFn, keyMap map[string]string) *Executor
  • func (e *Executor) DoAst(ast *expression.AstNode, prefix, suffix string) (sqls string, params []any, keys []string)
  • func (e *Executor) DoExpr(expr string, prefix, suffix string) (sqls string, params []any, keys []string, err error)
  • func (e *Executor) DoTerm(term *expression.AstNode, prefix, suffix string) (sql string, params []any, keys []string)

Variables

var DefaultFnMap = map[string]map[token.Token]ConditionFn{
	"==": {
		token.NUM:    equal[float64],
		token.BOOL:   equal[bool],
		token.STRING: equal[string],
	},
	"!=": {
		token.NUM:    unEqual[float64],
		token.BOOL:   unEqual[bool],
		token.STRING: unEqual[string],
	},
	">=": {
		token.NUM:    gte[float64],
		token.STRING: gte[string],
	},
	"<=": {
		token.NUM:    lte[float64],
		token.STRING: lte[string],
	},
	">": {
		token.NUM:    gt[float64],
		token.STRING: lt[string],
	},
	"<": {
		token.NUM:    lt[float64],
		token.STRING: lt[string],
	},
	"contains": {
		token.STRING: contains,
	},
	"unContains": {
		token.STRING: unContains,
	},
	"startsWith": {
		token.STRING: startsWith,
	},
	"unStartsWith": {
		token.STRING: unStartsWith,
	},
	"endsWith": {
		token.STRING: endsWith,
	},
	"unEndsWith": {
		token.STRING: unEndsWith,
	},
	"reg": {
		token.STRING: reg,
	},
	"in": {
		token.STRING: in,
	},
	"notIn": {
		token.STRING: notIn,
	},
	"containsBit": {
		token.NUM:    containsBit,
		token.STRING: containsBit,
	},
	"unContainsBit": {
		token.NUM:    unContainsBit,
		token.STRING: unContainsBit,
	},
	"&": {},
	"|": {},
}

var StdExecutor = New(nil, nil)

Types

type ConditionFn

type ConditionFn func(key string, value any) (sqls string, params []any)

type Executor

type Executor struct {
	FnMap map[string]map[token.Token]ConditionFn

	// KeyMap 字段映射
	// 	存在映射 => key 转换为映射值
	KeyMap map[string]string
}

func New

func New(fnMap map[string]map[token.Token]ConditionFn, keyMap map[string]string) *Executor

func (*Executor) DoAst

func (e *Executor) DoAst(ast *expression.AstNode, prefix, suffix string) (sqls string, params []any, keys []string)

DoAst 执行 ast

func (*Executor) DoExpr

func (e *Executor) DoExpr(expr string, prefix, suffix string) (sqls string, params []any, keys []string, err error)

DoExpr 执行表达式

func (*Executor) DoTerm

func (e *Executor) DoTerm(term *expression.AstNode, prefix, suffix string) (sql string, params []any, keys []string)

DoTerm 执行 term