sqlboiler

Documentation

Index

• func AsAliasColumn(alias, colName string) string
• func GetDB(args ...boil.Executor) boil.Executor
• func GetLimitQueryMods(list *protobuf.ListParam) []qm.QueryMod
• 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 WithUpdateTime(cols map[string]any, args ...string) map[string]any
• type MysqlImpl
  • func Mysql() *MysqlImpl
  • func (*MysqlImpl) IfNull(column string, defaultValue any, args ...string) string
  • func (*MysqlImpl) IfNullWithColumn(column string, anotherColumn string, args ...string) string
  • func (*MysqlImpl) JsonValue(jsonColumn string, jsonKey string, defaultValue any) qm.QueryMod
  • func (*MysqlImpl) JsonValueCompare(jsonColumn string, jsonKey string, operator string, compareValue any) qm.QueryMod
  • func (impl *MysqlImpl) SUM(col string, args ...string) string
• type PsqlImpl
  • func Psql() *PsqlImpl
  • func (*PsqlImpl) IfNull(column string, defaultValue any, args ...string) string
  • func (*PsqlImpl) IfNullWithColumn(column string, anotherColumn string, args ...string) string
  • func (*PsqlImpl) JsonValue(jsonColumn string, jsonKey string, defaultValue any) qm.QueryMod
  • func (*PsqlImpl) JsonValueCompare(jsonColumn string, jsonKey string, operator string, compareValue any) qm.QueryMod
  • func (impl *PsqlImpl) SUM(col string, args ...string) string
• 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 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 WithUpdateTime

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

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

Types

type MysqlImpl

type MysqlImpl struct {
}

func Mysql

func Mysql() *MysqlImpl

func (*MysqlImpl) IfNull

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

func (*MysqlImpl) IfNullWithColumn

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

func (*MysqlImpl) JsonValue

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

func (*MysqlImpl) JsonValueCompare

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

func (*MysqlImpl) SUM

func (impl *MysqlImpl) SUM(col string, args ...string) string

type PsqlImpl

type PsqlImpl struct {
}

func Psql

func Psql() *PsqlImpl

func (*PsqlImpl) IfNull

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

func (*PsqlImpl) IfNullWithColumn

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

func (*PsqlImpl) JsonValue

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

func (*PsqlImpl) JsonValueCompare

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

func (*PsqlImpl) SUM

func (impl *PsqlImpl) SUM(col string, args ...string) string

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)