db

Documentation

Index

• Constants
• func ConvertParams(v interface{}, escaper 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
• func TableName(name string, id uint64) string
• type Config
• 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 (
	Mysql    = "mysql"
	Postgres = "postgres"
	Sqlite   = "sqlite"
)

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

func TableName

func TableName(name string, id uint64) string

Types

type Config

type Config struct {
	Type, Charset, Database, TimeZone string
	Host                              string `flag:"name:db_host;usage:数据库host"`
	User, Password                    string
	TimeFormat                        string
	MaxIdleConns, MaxOpenConns        int
	Port                              int32
}

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