sqlserver

Documentation

Index

• Constants
• Variables
• func New(name, prefix string, matcher xdb.TemplateMatcher, ...) xdb.SQLTemplate
• func NewSqlState(placeHolder xdb.Placeholder) xdb.SqlState
• type MssqlSqlState
  • func (s *MssqlSqlState) AppendExpr(exprName xdb.ExprName, value any) (phName string)
  • func (s *MssqlSqlState) BuildCache(sql string) xdb.ExpressionCache
  • func (s *MssqlSqlState) CanCache() bool
  • func (s *MssqlSqlState) GetNames() []xdb.ExprName
  • 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) RegistStmtDbTypeHandler(handler ...xdb.StmtDbTypeHandler)
  • func (template *MssqlTemplate) ReleaseSqlState(state xdb.SqlState)
  • func (template *MssqlTemplate) StmtDbTypeWrap(fieldName string, param any, fv reflect.Value, tagOpts xdb.TagOptions) (any, error)

Constants

const (
	Proto          = "sqlserver"
	Proto2         = "mssql"
	ArgumentPrefix = "p_"
)

Variables

var (
	DefaultDbTypeHandler = []xdb.StmtDbTypeHandler{
		&varcharHandler{},
		&varcharMaxHandler{},
		&nvarcharMaxHandler{},
		&tvpHandler{},
		&contribxdb.StmtDbTypeOutputHandler{},
	}
)

Functions

func New

func New(name, prefix string, matcher xdb.TemplateMatcher, stmtProcessor xdb.StmtDbTypeProcessor) 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(exprName xdb.ExprName, 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() []xdb.ExprName

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

func (template *MssqlTemplate) RegistStmtDbTypeHandler(handler ...xdb.StmtDbTypeHandler)

func (*MssqlTemplate) ReleaseSqlState

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

func (*MssqlTemplate) StmtDbTypeWrap

func (template *MssqlTemplate) StmtDbTypeWrap(fieldName string, param any, fv reflect.Value, tagOpts xdb.TagOptions) (any, error)