sqlgenerator

Documentation

Index

• type Reserved
  • func GetReserved(dialect constants.DIALECT) (Reserved, error)
• type SQL
• type SQLGenerator
  • func GetGenerator(dialect constants.DIALECT) (SQLGenerator, error)
• type SQLParam

Types

type Reserved

type Reserved interface {
	IsReserved(word string) bool
	CheckReserved(word string) string
}

func GetReserved

func GetReserved(dialect constants.DIALECT) (Reserved, error)

type SQL

type SQL struct {
	TableName                string
	Columns                  []string
	SelectFields             []string
	ParamPlaceHolder         []string
	Params                   []*SQLParam
	Where                    string
	WhereParams              []*SQLParam
	ReturnAutoincrPrimaryKey string // insert 时是否返回自增主键
	OrderAndGroup            string
}

type SQLGenerator

type SQLGenerator interface {
	Reserved
	Insert(sql *SQL) (string, []*SQLParam)
	Update(sql *SQL) (string, []*SQLParam, []*SQLParam)
	Delete(sql *SQL) (string, []*SQLParam)
	Query(sql *SQL) (string, []*SQLParam)
	Truncate(sql *SQL) string
	IsReturnAutoincrPrimaryKeyUseQuery() bool
	IsParamDollar() bool
	GetParamTag() string
}

func GetGenerator

func GetGenerator(dialect constants.DIALECT) (SQLGenerator, error)

type SQLParam

type SQLParam struct {
	VarName           string
	JSON              bool
	Time              bool
	Blob              bool // 实现了 BlobReadWriter
	SQLType           string
	VarAlias          string
	TimeProp          *dbutil.TimePropDesc
	SQLParamName      string // 从 SQL 语句中分析出来的参数名称，不作任何改变
	SQLParamFieldName string

	IsInOperator       bool
	InParamPlaceHolder string // in 操作符占位字符串
}