sql

Documentation

Index

• Constants
• func ConvertParams(v interface{}, escaper string) string
• func DeleteByIdSQL(tableName string) string
• func DeleteSQL(tableName, column string) string
• func ExistsSQL(tableName, column string, withDeletedAt bool) string
• func ExistsSQLByFilterExprs(tableName string, filters FilterExprs) string
• func ExistsSQLByQuerySQL(qsql string) string
• type FilterExpr
• type FilterExprs
  • func (f FilterExprs) Build() string
  • func (f FilterExprs) BuildSQL() (string, []interface{})
• type Operation
  • func (m Operation) SQL() string
  • func (m Operation) String() string

Constants

const (
	TmFmtWithMS = "2006-01-02 15:04:05.999"
	NullStr     = "NULL"
)

const (
	ColumnDeletedAt = "deleted_at"
	ColumnId        = "id"
	ColumnName      = "name"
)

const (
	ExprEqual    = " = ?"
	ExprNotEqual = " != ?"
	ExprGreater  = " > ?"
)

const (
	Insert    = "INSERT"
	Select    = "SELECT"
	Update    = "UPDATE"
	Delete    = "DELETE"
	LeftJoin  = "LEFT JOIN"
	RightJoin = "RIGHT JOIN"
	InnerJoin = "INNER JOIN"
	Limit     = `LIMIT %d`
	Offset    = `OFFSET %d`
	Limit1    = `LIMIT 1`
)

const (
	NotDeleted     = ColumnDeletedAt + " IS " + NullStr
	WithNotDeleted = ` AND ` + NotDeleted
)

const (
	IdEqual   = ColumnId + ExprEqual
	NameEqual = ColumnName + ExprEqual
)

Functions

func ConvertParams

func ConvertParams(v interface{}, escaper string) string

func DeleteByIdSQL

func DeleteByIdSQL(tableName string) string

func DeleteSQL

func DeleteSQL(tableName, column string) string

func ExistsSQL

func ExistsSQL(tableName, column string, withDeletedAt bool) string

func ExistsSQLByFilterExprs

func ExistsSQLByFilterExprs(tableName string, filters FilterExprs) string

func ExistsSQLByQuerySQL

func ExistsSQLByQuerySQL(qsql string) string

Types

type FilterExpr

type FilterExpr struct {
	Field     string        `json:"field"`
	Operation Operation     `json:"method"`
	Value     []interface{} `json:"value"`
}

type FilterExprs

type FilterExprs []FilterExpr

func (FilterExprs) Build

func (f FilterExprs) Build() string

func (FilterExprs) BuildSQL

func (f FilterExprs) BuildSQL() (string, []interface{})

type Operation

type Operation int

const (
	OperationPlace Operation = iota
	Equal
	NotEqual
	Greater
	Less
	Between
	GreaterOrEqual
	LessOrEqual
	IsNotNull
	IsNull
	In
	NotIn
	LIKE
)

func (Operation) SQL

func (m Operation) SQL() string

func (Operation) String

func (m Operation) String() string