sqlboiler

Documentation

Index

• func AsAliasColumn(alias, colName string) string
• func GetDB(args ...boil.Executor) boil.Executor
• func GetLimitQueryMods(list *protobuf.ListParam) []qm.QueryMod
• func IfNull(column string, defaultValue any, args ...string) string
• func IfNullWithColumn(column string, anotherColumn string, args ...string) string
• func InnerJoin(joinTable string, args ...string) *joinClause
• func JsonValue(jsonColumn string, jsonKey string, defaultValue any) qm.QueryMod
• func JsonValueCompare(jsonColumn string, jsonKey string, operator string, compareValue any) qm.QueryMod
• func LeftJoin(joinTable string, args ...string) *joinClause
• func NewQmBuilder(mods ...qm.QueryMod) *qmBuilder
• func OrderBy() *orderByBuilder
• func SUM(col string, args ...string) string
• func WithUpdateTime(cols map[string]any, args ...string) map[string]any
• type Transaction
  • func NewTransaction(logger intf.LoggerProvider, args ...boil.Transactor) (*Transaction, error)
  • func (t Transaction) CommitOrRollback(err error)
• type Transactor
  • func NewTransactor(logger intf.LoggerProvider) (Transactor, error)

Functions

func AsAliasColumn

func AsAliasColumn(alias, colName string) string

func GetDB

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

func GetLimitQueryMods

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

GetLimitQueryMods 获取Limit相关QueryMods

func IfNull

func IfNull(column string, defaultValue any, args ...string) string

func IfNullWithColumn

func IfNullWithColumn(column string, anotherColumn string, args ...string) string

func InnerJoin

func InnerJoin(joinTable string, args ...string) *joinClause

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 LeftJoin

func LeftJoin(joinTable string, args ...string) *joinClause

func NewQmBuilder

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

func OrderBy

func OrderBy() *orderByBuilder

OrderBy OrderBy字段加入desc

func SUM

func SUM(col string, args ...string) string

func WithUpdateTime

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

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

Types

type Transaction

type Transaction struct {
	Tx boil.Transactor
	// contains filtered or unexported fields
}

func NewTransaction

func NewTransaction(logger intf.LoggerProvider, args ...boil.Transactor) (*Transaction, error)

func (Transaction) CommitOrRollback

func (t Transaction) CommitOrRollback(err error)

type Transactor

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

func NewTransactor

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