sqlboiler

Documentation

Index

• Constants
• func GetDB(args ...boil.Executor) boil.Executor
• func GetLimitQueryMods(list *protobuf.ListParam) []qm.QueryMod
• func JsonValue(jsonColumn string, jsonKey string, defaultValue any) qm.QueryMod
• func JsonValueCompare(jsonColumn string, jsonKey string, operator string, compareValue any) qm.QueryMod
• func MysqlEscape(s string) string
• func NewQmBuilder(mods ...qm.QueryMod) *qmBuilder
• func PsqlEscape(s string) string
• func WithUpdateTime(cols map[string]any, args ...string) map[string]any
• type JoinClauseBuilder
  • func (j *JoinClauseBuilder) And(clause string) *JoinClauseBuilder
  • func (j *JoinClauseBuilder) On(columnOrTableColumn, thatTableColumn string) *JoinClauseBuilder
  • func (j *JoinClauseBuilder) Output(args ...any) qm.QueryMod
• type OrderByHelper
  • func (o *OrderByHelper) Asc(col string) *OrderByHelper
  • func (o *OrderByHelper) Desc(col string) *OrderByHelper
  • func (o OrderByHelper) Output(args ...any) qm.QueryMod
• type SQLHelper
  • func Mysql() SQLHelper
  • func Psql() SQLHelper
• type Transactor
  • func NewTransactor(logger intf.LoggerProvider) (Transactor, error)

Constants

const (
	MysqlIdentifierQuote = "`"
	PsqlIdentifierQuote  = "\""
)

Functions

func GetDB

func GetDB(args ...boil.Executor) boil.Executor

func GetLimitQueryMods

func GetLimitQueryMods(list *protobuf.ListParam) []qm.QueryMod

GetLimitQueryMods 获取Limit相关QueryMods

func JsonValue

func JsonValue(jsonColumn string, jsonKey string, defaultValue any) qm.QueryMod

func JsonValueCompare

func JsonValueCompare(jsonColumn string, jsonKey string, operator string, compareValue any) qm.QueryMod

func MysqlEscape

func MysqlEscape(s string) string

func NewQmBuilder

func NewQmBuilder(mods ...qm.QueryMod) *qmBuilder

func PsqlEscape

func PsqlEscape(s string) string

func WithUpdateTime

func WithUpdateTime(cols map[string]any, args ...string) map[string]any

WithUpdateTime 除了cols中的会更新以外还会更新更新时间字段

Types

type JoinClauseBuilder

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

func (*JoinClauseBuilder) And

func (j *JoinClauseBuilder) And(clause string) *JoinClauseBuilder

func (*JoinClauseBuilder) On

func (j *JoinClauseBuilder) On(columnOrTableColumn, thatTableColumn string) *JoinClauseBuilder

func (*JoinClauseBuilder) Output

func (j *JoinClauseBuilder) Output(args ...any) qm.QueryMod

type OrderByHelper

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

func (*OrderByHelper) Asc

func (o *OrderByHelper) Asc(col string) *OrderByHelper

func (*OrderByHelper) Desc

func (o *OrderByHelper) Desc(col string) *OrderByHelper

func (OrderByHelper) Output

func (o OrderByHelper) Output(args ...any) qm.QueryMod

type SQLHelper

type SQLHelper interface {
	IfNull(column string, defaultValue any, args ...string) string
	IfNullWithColumn(column string, anotherColumn string, args ...string) string
	JsonValue(jsonColumn string, jsonKey string, defaultValue any) qm.QueryMod
	JsonValueCompare(jsonColumn string, jsonKey string, operator string, compareValue any) qm.QueryMod
	SUM(col string, args ...string) string
	AsAliasColumn(alias, colName string) string
	InnerJoin(joinTable string, args ...string) *JoinClauseBuilder
	LeftJoin(joinTable string, args ...string) *JoinClauseBuilder
	OrderBy() *OrderByHelper
}

func Mysql

func Mysql() SQLHelper

func Psql

func Psql() SQLHelper

type Transactor

type Transactor interface {
	Executor() boil.Executor
	Finalize(err error)
}

func NewTransactor

func NewTransactor(logger intf.LoggerProvider) (Transactor, error)