tpl

package
v0.5.19 Latest Latest
Warning

This package is not in the latest version of its module.

 Go to latest Published: Jul 30, 2024 License: MIT Imports: 11 Imported by: 0

Documentation

Index

Constants

View Source 
const (
	TotalPattern = `` /* 160-byte string literal not displayed */
	// ParamPattern   = `[@]\{\w*[\.]?\w+\}`
	// AndPattern     = `[&]\{\w*[\.]?\w+\}`
	// OrPattern      = `[\|]\{\w*[\.]?\w+\}`
	ReplacePattern = `\$\{\w*[\.]?\w+\}`

	SymbolAt  = "@"
	SymbolAnd = "&"
	SymbolOr  = "|"
)

Variables

View Source 
var GetPropName func(fullKey string) (field, propName, oper string)

根据表达式获取

Functions

func AnalyzeTPLFromCache 

func AnalyzeTPLFromCache(template SQLTemplate, tpl string, input map[string]interface{}, ph Placeholder) (sql string, values []any, err error)

AnalyzeTPLFromCache 从缓存中获取已解析的SQL语句 @表达式，替换为参数化字符如: :1,:2,:3 $表达式，检查值，值为空时返加"",否则直接替换字符 &条件表达式，检查值，值为空时返加"",否则返回: and name=value |条件表达式，检查值，值为空时返回"", 否则返回: or name=value

func DefaultGetPropName added in v0.5.1 

func DefaultGetPropName(fullKey string) (fullField, propName, oper string)

field, tbl.field , tbl.field like , tbl.field >=

func GetPatternRegexp added in v0.5.0 

func GetPatternRegexp(pattern string) *regexp.Regexp

获取模式匹配的正则表达式

func IsNil 

func IsNil(input interface{}) bool

func Register 

func Register(tpl SQLTemplate)

func RegisterOperator added in v0.5.1 

func RegisterOperator(dbProto string, oper Operator) error

RegisterSymbol 给数据库注册语法解析

func RegisterSymbol added in v0.5.0 

func RegisterSymbol(dbProto string, symbol Symbol) error

RegisterSymbol 给数据库注册语法解析

func TransArgs added in v0.1.41 

func TransArgs(args []sql.NamedArg) []interface{}

Types

type DBParam added in v0.1.30 

type DBParam map[string]interface{}

func (DBParam) Get added in v0.1.30 

func (p DBParam) Get(name string, ph Placeholder) (phName string, argVal interface{}, err xdb.MissError)

func (DBParam) GetVal added in v0.1.41 

func (p DBParam) GetVal(name string) (val interface{}, err xdb.MissError)

type FixedContext 

type FixedContext struct {
	// contains filtered or unexported fields
}

FixedContext 模板

func (*FixedContext) AnalyzeTPL 

func (ctx *FixedContext) AnalyzeTPL(tpl string, input map[string]interface{}, ph Placeholder) (sql string, item *ReplaceItem, err error)

func (*FixedContext) GetSQLContext 

func (ctx *FixedContext) GetSQLContext(tpl string, input map[string]interface{}) (query string, args []any, err error)

GetSQLContext 获取查询串

func (FixedContext) Name 

func (ctx FixedContext) Name() string

func (*FixedContext) Placeholder 

func (ctx *FixedContext) Placeholder() Placeholder

func (*FixedContext) RegisterOperator added in v0.5.1 

func (ctx *FixedContext) RegisterOperator(oper Operator) error

func (*FixedContext) RegisterSymbol added in v0.5.0 

func (ctx *FixedContext) RegisterSymbol(symbol Symbol) error

type Operator added in v0.5.1 

type Operator interface {
	Name() string
	Callback(string, string, string) string
}

type OperatorCallback added in v0.5.1 

type OperatorCallback func(string, string, string) string

type OperatorMap added in v0.5.1 

type OperatorMap interface {
	LoadOrStore(name string, callback OperatorCallback) (loaded bool)
	Load(name string) (OperatorCallback, bool)
	Clone() OperatorMap
}
var DefaultOperator OperatorMap

func NewOperatorMap added in v0.5.1 

func NewOperatorMap() OperatorMap

type Placeholder 

type Placeholder interface {
	Get(propName string) (argName string, phName string)
	NamedArg(name string) string
	BuildArgVal(argName string, val interface{}) interface{}
	Clone() Placeholder
}

type ReplaceItem 

type ReplaceItem struct {
	Names       []string
	Values      []interface{}
	NameCache   map[string]string
	Placeholder Placeholder
	HasAndOper  bool
	HasOrOper   bool
}

func DefaultAnalyze 

func DefaultAnalyze(symbols SymbolMap, tpl string, input map[string]interface{}, placeholder Placeholder) (string, *ReplaceItem, error)

func (*ReplaceItem) CanCache added in v0.1.41 

func (p *ReplaceItem) CanCache() bool

func (*ReplaceItem) Clone added in v0.1.41 

func (p *ReplaceItem) Clone() *ReplaceItem

type SQLTemplate 

type SQLTemplate interface {
	Name() string
	Placeholder() Placeholder
	GetSQLContext(tpl string, input map[string]interface{}) (query string, args []any, err error)
	AnalyzeTPL(tpl string, input map[string]interface{}, ph Placeholder) (sql string, item *ReplaceItem, err error)
	RegisterSymbol(symbol Symbol) error
	RegisterOperator(Operator) error
}

Template 模板上下文

func GetDBTemplate 

func GetDBTemplate(name string) (SQLTemplate, error)

GetDBTemplate 获取数据库上下文操作

func NewFixed 

func NewFixed(name, prefix string) SQLTemplate

func NewSeq 

func NewSeq(name, prefix string) SQLTemplate

type SeqContext 

type SeqContext struct {
	// contains filtered or unexported fields
}

SeqContext 参数化时使用@+参数名作为占位符的SQL数据库如:oracle,sql server

func (*SeqContext) AnalyzeTPL 

func (ctx *SeqContext) AnalyzeTPL(tpl string, input map[string]interface{}, ph Placeholder) (sql string, item *ReplaceItem, err error)

func (*SeqContext) GetSQLContext 

func (ctx *SeqContext) GetSQLContext(tpl string, input map[string]interface{}) (sql string, args []any, err error)

GetSQLContext 获取查询串

func (SeqContext) Name 

func (ctx SeqContext) Name() string

func (*SeqContext) Placeholder 

func (ctx *SeqContext) Placeholder() Placeholder

func (*SeqContext) RegisterOperator added in v0.5.1 

func (ctx *SeqContext) RegisterOperator(oper Operator) error

func (*SeqContext) RegisterSymbol added in v0.5.0 

func (ctx *SeqContext) RegisterSymbol(symbol Symbol) error

type Symbol added in v0.5.0 

type Symbol interface {
	Name() string
	GetPattern() string
	Callback(DBParam, string, *ReplaceItem) (string, xdb.MissError)
}

type SymbolCallback 

type SymbolCallback func(DBParam, string, *ReplaceItem) (string, xdb.MissError)

符号回调函数

type SymbolMap added in v0.5.0 

type SymbolMap interface {
	GetPattern() string
	//Store(name string, callback SymbolCallback)
	Register(Symbol) error
	Operator(Operator) error
	LoadOperator(oper string) (OperatorCallback, bool)
	LoadOrStore(name string, callback SymbolCallback) (loaded bool)
	Delete(name string)
	Load(name string) (SymbolCallback, bool)
	Clone() SymbolMap
}

func NewSymbolMap added in v0.5.0 

func NewSymbolMap(operMap OperatorMap) SymbolMap

Source Files

View all Source files

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL
go.dev uses cookies from Google to deliver and enhance the quality of its services and to analyze traffic. Learn more.