sqlboiler

package module
v0.1.10 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Dec 15, 2025 License: Apache-2.0 Imports: 23 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

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 WithUpdateTime

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

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

Types

type Db added in v0.1.0

type Db interface {
	Copier() DbCopier
	Executor() boil.Executor
}

type DbCopier added in v0.1.0

type DbCopier interface {
	Blacklist(fieldNames ...string) DbCopier                               // 设置黑名单字段
	Whitelist(fieldNames ...string) DbCopier                               // 设置白名单字段
	AutoIncr(fieldNames ...string) DbCopier                                // 设置自增字段
	JSONArray(fieldNames ...string) DbCopier                               // 设置为Json数组的字段
	JSONObject(fieldNames ...string) DbCopier                              // 设置Json字段的处理函数为Json数组
	Copy(destObject any, source any) error                                 // 将source值填入到modelObject中
	CopyForCreate(destObject any, source any, allowFields ...string) error // 创建动作需要的复制
	CopyForEdit(destObject any, source any, allowFields ...string) error   // 创建动作需要的复制
}

type Gdb added in v0.0.8

type Gdb interface {
	Db
}

func NewGdb added in v0.1.0

func NewGdb(ctx biz.Context) Gdb

type JoinClauseBuilder added in v0.0.4

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

func (*JoinClauseBuilder) And added in v0.0.4

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

func (*JoinClauseBuilder) On added in v0.0.4

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

func (*JoinClauseBuilder) Output added in v0.0.4

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

type OrderByHelper added in v0.0.4

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

func (*OrderByHelper) Asc added in v0.0.4

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

func (*OrderByHelper) Desc added in v0.0.4

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

func (OrderByHelper) Output added in v0.0.4

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

type QmBuilder added in v0.0.16

type QmBuilder interface {
	Append(mods ...qm.QueryMod) QmBuilder
	Concat(modSlices []qm.QueryMod) QmBuilder
	Limit(list ...*protobuf.ListParam) QmBuilder
	Output() []qm.QueryMod
}

func NewQmBuilder

func NewQmBuilder(mods ...qm.QueryMod) QmBuilder

type SQLHelper added in v0.0.4

type SQLHelper interface {
	IfNull(column string, defaultValue any, 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
	InnerJoin(joinTable string, args ...string) *JoinClauseBuilder
	LeftJoin(joinTable string, args ...string) *JoinClauseBuilder
	OrderBy() *OrderByHelper
	Quote(s string, splitWord ...bool) string // 默认quote整个字符串,true否则将分割字符串中的单词,每个单词进行quote
	SelectAll(tableColumns any) qm.QueryMod
}

func Mysql added in v0.0.3

func Mysql() SQLHelper

func Psql added in v0.0.3

func Psql() SQLHelper

type Tdb added in v0.0.8

type Tdb interface {
	Db
	Tid() int64 // 获取租户ID接口, 本来可以从ctx中获取,但为了区分Gdb和Tdb,强制实现冗余接口
}

Tdb Tenant db

func NewTdb added in v0.1.0

func NewTdb(ctx biz.Context) Tdb

type Transactor

type Transactor interface {
	Finalize(err error)
}

func NewTransactor

func NewTransactor(ctx biz.Context, logger types.LoggerProvider) (Transactor, error)

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL