sqlserver

Documentation

Index

• Constants
• func New(name, prefix string, matcher xdb.TemplateMatcher) xdb.SQLTemplate
• func NewSqlState(placeHolder xdb.Placeholder) xdb.SqlState
• type MssqlSqlState
  • func (s *MssqlSqlState) AppendExpr(propName string, value any) (phName string)
  • func (s *MssqlSqlState) BuildCache(sql string) xdb.ExpressionCache
  • func (s *MssqlSqlState) CanCache() bool
  • func (s *MssqlSqlState) GetNames() []string
  • func (s *MssqlSqlState) GetValues() []any
  • func (s *MssqlSqlState) HasDynamic(dynamicType xdb.DynamicType) bool
  • func (s *MssqlSqlState) Reset()
  • func (s *MssqlSqlState) SetDynamic(dynamicType xdb.DynamicType)
  • func (s *MssqlSqlState) UseExprCache() bool
  • func (s *MssqlSqlState) WithPlaceholder(placeholder xdb.Placeholder)
  • func (s *MssqlSqlState) WithTemplateOptions(tplOpts *xdb.TemplateOptions)
• type MssqlTemplate
  • func (template *MssqlTemplate) GetSQLContext(sqlTpl string, input map[string]any, opts ...xdb.TemplateOption) (query string, args []any, err error)
  • func (template *MssqlTemplate) GetSqlState(tplOpts *xdb.TemplateOptions) xdb.SqlState
  • func (template *MssqlTemplate) HandleExpr(item xdb.SqlState, sqlTpl string, input xdb.DBParam) (sql string, err error)
  • func (template *MssqlTemplate) Name() string
  • func (template *MssqlTemplate) Placeholder() xdb.Placeholder
  • func (template *MssqlTemplate) RegistExpressionMatcher(matchers ...xdb.ExpressionMatcher)
  • func (template *MssqlTemplate) ReleaseSqlState(state xdb.SqlState)

Constants

const ArgumentPrefix = "p_"

const Proto = "sqlserver"

Functions

func New

func New(name, prefix string, matcher xdb.TemplateMatcher) xdb.SQLTemplate

func NewSqlState

func NewSqlState(placeHolder xdb.Placeholder) xdb.SqlState

新建一个SqlState

Types

type MssqlSqlState

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

func (*MssqlSqlState) AppendExpr

func (s *MssqlSqlState) AppendExpr(propName string, value any) (phName string)

func (*MssqlSqlState) BuildCache

func (s *MssqlSqlState) BuildCache(sql string) xdb.ExpressionCache

func (*MssqlSqlState) CanCache

func (s *MssqlSqlState) CanCache() bool

func (*MssqlSqlState) GetNames

func (s *MssqlSqlState) GetNames() []string

func (*MssqlSqlState) GetValues

func (s *MssqlSqlState) GetValues() []any

func (*MssqlSqlState) HasDynamic

func (s *MssqlSqlState) HasDynamic(dynamicType xdb.DynamicType) bool

func (*MssqlSqlState) Reset

func (s *MssqlSqlState) Reset()

func (*MssqlSqlState) SetDynamic

func (s *MssqlSqlState) SetDynamic(dynamicType xdb.DynamicType)

func (*MssqlSqlState) UseExprCache

func (s *MssqlSqlState) UseExprCache() bool

func (*MssqlSqlState) WithPlaceholder

func (s *MssqlSqlState) WithPlaceholder(placeholder xdb.Placeholder)

func (*MssqlSqlState) WithTemplateOptions

func (s *MssqlSqlState) WithTemplateOptions(tplOpts *xdb.TemplateOptions)

type MssqlTemplate

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

MssqlTemplate 模板

func (*MssqlTemplate) GetSQLContext

func (template *MssqlTemplate) GetSQLContext(sqlTpl string, input map[string]any, opts ...xdb.TemplateOption) (query string, args []any, err error)

GetSQLContext 获取查询串

func (*MssqlTemplate) GetSqlState

func (template *MssqlTemplate) GetSqlState(tplOpts *xdb.TemplateOptions) xdb.SqlState

func (*MssqlTemplate) HandleExpr

func (template *MssqlTemplate) HandleExpr(item xdb.SqlState, sqlTpl string, input xdb.DBParam) (sql string, err error)

func (*MssqlTemplate) Name

func (template *MssqlTemplate) Name() string

func (*MssqlTemplate) Placeholder

func (template *MssqlTemplate) Placeholder() xdb.Placeholder

func (*MssqlTemplate) RegistExpressionMatcher

func (template *MssqlTemplate) RegistExpressionMatcher(matchers ...xdb.ExpressionMatcher)

func (*MssqlTemplate) ReleaseSqlState

func (template *MssqlTemplate) ReleaseSqlState(state xdb.SqlState)