tpl

Documentation

Index

• Constants
• func AnalyzeTPLFromCache(template SQLTemplate, tpl string, input map[string]interface{}, ph Placeholder) (sql string, values []any, err error)
• func GetPatternRegexp(pattern string) *regexp.Regexp
• func GetPropName(fullKey string) (propName string)
• func IsNil(input interface{}) bool
• func Register(tpl SQLTemplate)
• func RegisterSymbol(dbProto string, symbol Symbol) error
• func TransArgs(args []sql.NamedArg) []interface{}
• type DBParam
  • func (p DBParam) Get(name string, ph Placeholder) (phName string, argVal interface{}, err xdb.MissParamError)
  • func (p DBParam) GetVal(name string) (val interface{}, err xdb.MissParamError)
• type FixedContext
  • func (ctx *FixedContext) AnalyzeTPL(tpl string, input map[string]interface{}, ph Placeholder) (sql string, item *ReplaceItem, err error)
  • func (ctx *FixedContext) GetSQLContext(tpl string, input map[string]interface{}) (query string, args []any, err error)
  • func (ctx FixedContext) Name() string
  • func (ctx *FixedContext) Placeholder() Placeholder
  • func (ctx *FixedContext) RegisterSymbol(symbol Symbol) error
• type Placeholder
• type ReplaceItem
  • func DefaultAnalyze(symbols SymbolMap, tpl string, input map[string]interface{}, ...) (string, *ReplaceItem, error)
  • func (p *ReplaceItem) CanCache() bool
  • func (p *ReplaceItem) Clone() *ReplaceItem
• type SQLTemplate
  • func GetDBTemplate(name string) (SQLTemplate, error)
  • func NewFixed(name, prefix string) SQLTemplate
  • func NewSeq(name, prefix string) SQLTemplate
• type SeqContext
  • func (ctx *SeqContext) AnalyzeTPL(tpl string, input map[string]interface{}, ph Placeholder) (sql string, item *ReplaceItem, err error)
  • func (ctx *SeqContext) GetSQLContext(tpl string, input map[string]interface{}) (sql string, args []any, err error)
  • func (ctx SeqContext) Name() string
  • func (ctx *SeqContext) Placeholder() Placeholder
  • func (ctx *SeqContext) RegisterSymbol(symbol Symbol) error
• type Symbol
• type SymbolCallback
• type SymbolMap
  • func NewSymbolMap() SymbolMap

Constants

const (
	TotalPattern = `[@]\{\w*[\.]?\w+\}|[&]\{\w*[\.]?\w+\}|[\|]\{\w*[\.]?\w+\}`
	// ParamPattern   = `[@]\{\w*[\.]?\w+\}`
	// AndPattern     = `[&]\{\w*[\.]?\w+\}`
	// OrPattern      = `[\|]\{\w*[\.]?\w+\}`
	ReplacePattern = `\$\{\w*[\.]?\w+\}`
)

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 GetPatternRegexp

func GetPatternRegexp(pattern string) *regexp.Regexp

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

func GetPropName

func GetPropName(fullKey string) (propName string)

func IsNil

func IsNil(input interface{}) bool

func Register

func Register(tpl SQLTemplate)

func RegisterSymbol

func RegisterSymbol(dbProto string, symbol Symbol) error

RegisterSymbol 给数据库注册语法解析

func TransArgs

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

Types

type DBParam

type DBParam map[string]interface{}

func (DBParam) Get

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

func (DBParam) GetVal

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

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) RegisterSymbol

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

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

func (p *ReplaceItem) CanCache() bool

func (*ReplaceItem) Clone

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
}

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) RegisterSymbol

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

type Symbol

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

type SymbolCallback

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

type SymbolMap

type SymbolMap interface {
	GetPattern() string
	Store(name string, callback SymbolCallback)
	Register(symbol Symbol) error
	LoadOrStore(name string, callback SymbolCallback) (loaded bool)
	Delete(name string)
	Load(name string) (SymbolCallback, bool)
	Clone() SymbolMap
}

func NewSymbolMap

func NewSymbolMap() SymbolMap