clause

Documentation

Index

• Constants
• func DateBetween(column, dateStart, dateEnd string) clause.Expression
• func List[T any, O request.Ordered](db *gorm.DB, req *request.ListReq[O]) ([]T, error)
• func ListClause[O request.Ordered](req *request.ListReq[O]) []clause.Expression
• func NewClause(field string, op dbi.Operation, args ...interface{}) func(*gorm.DB) *gorm.DB
• func NewWhereClause(field string, op dbi.Operation, args ...interface{}) clause.Expression
• func Page(pageNo, pageSize int) clause.Limit
• func Sort(column string, typ request.SortType) clause.Expression
• func TableName(tx *gorm.DB, name string) *gorm.DB
• type ChainClause
  • func (c ChainClause) ById(id int) ChainClause
  • func (c ChainClause) ByIdNoCheck(id int) ChainClause
  • func (c ChainClause) ByName(name string) ChainClause
  • func (c ChainClause) ByNameNoCheck(name string) ChainClause
  • func (c ChainClause) Exec(db *gorm.DB) *gorm.DB
  • func (c ChainClause) Or(clauses ...ChainClause) ChainClause
• type ChainDB
  • func NewChainDB(ctx context.Context) ChainDB
  • func (c ChainDB) ById(id int) ChainDB
  • func (c ChainDB) ByIdNoCheck(id int) ChainDB
  • func (c ChainDB) ByName(name string) ChainDB
  • func (c ChainDB) ByNameNoCheck(name string) ChainDB
  • func (c ChainDB) List(dest any) ChainDB
• type Clause3
  • func (c Clause3) ByIdNoCheck(id int) Clause3
• type EmptyClause
  • func (receiver *EmptyClause) Build(builder clause.Builder)
  • func (receiver *EmptyClause) ModifyStatement(*gorm.Statement)
• type Expression
  • func (e *Expression) Clause() func(*gorm.DB) *gorm.DB
• type Limit
  • func (limit Limit) Build(builder clause.Builder)
  • func (limit Limit) MergeClause(clause *clause.Clause)
  • func (limit Limit) Name() string
• type ListReq
  • func (req *ListReq[O]) Clause() []clause.Expression
• type PageSortReq
  • func (req *PageSortReq) Clause() []clause.Expression
• type RangeReq
  • func (req *RangeReq[T]) Clause() clause.Expression

Constants

const (
	IDEQUAL   = dbi.ColumnId + dbi.ExprEqual
	NAMEEQUAL = dbi.ColumnName + dbi.ExprEqual
)

Functions

func DateBetween

func DateBetween(column, dateStart, dateEnd string) clause.Expression

func List

func List[T any, O request.Ordered](db *gorm.DB, req *request.ListReq[O]) ([]T, error)

unsupported data,完全不可用 deprecated: 不可用

func ListClause

func ListClause[O request.Ordered](req *request.ListReq[O]) []clause.Expression

func NewClause

func NewClause(field string, op dbi.Operation, args ...interface{}) func(*gorm.DB) *gorm.DB

func NewWhereClause

func NewWhereClause(field string, op dbi.Operation, args ...interface{}) clause.Expression

func Page

func Page(pageNo, pageSize int) clause.Limit

func Sort

func Sort(column string, typ request.SortType) clause.Expression

func TableName

func TableName(tx *gorm.DB, name string) *gorm.DB

Types

type ChainClause

type ChainClause []func(db *gorm.DB) *gorm.DB

func (ChainClause) ById

func (c ChainClause) ById(id int) ChainClause

db.Scope(ById(1),ByName("a")).First(v)

func (ChainClause) ByIdNoCheck

func (c ChainClause) ByIdNoCheck(id int) ChainClause

func (ChainClause) ByName

func (c ChainClause) ByName(name string) ChainClause

func (ChainClause) ByNameNoCheck

func (c ChainClause) ByNameNoCheck(name string) ChainClause

func (ChainClause) Exec

func (c ChainClause) Exec(db *gorm.DB) *gorm.DB

func (ChainClause) Or

func (c ChainClause) Or(clauses ...ChainClause) ChainClause

type ChainDB

type ChainDB func(db *gorm.DB) *gorm.DB

func NewChainDB

func NewChainDB(ctx context.Context) ChainDB

func (ChainDB) ById

func (c ChainDB) ById(id int) ChainDB

func (ChainDB) ByIdNoCheck

func (c ChainDB) ByIdNoCheck(id int) ChainDB

func (ChainDB) ByName

func (c ChainDB) ByName(name string) ChainDB

func (ChainDB) ByNameNoCheck

func (c ChainDB) ByNameNoCheck(name string) ChainDB

func (ChainDB) List

func (c ChainDB) List(dest any) ChainDB

type Clause3

type Clause3 []clause.Interface

func (Clause3) ByIdNoCheck

func (c Clause3) ByIdNoCheck(id int) Clause3

type EmptyClause

type EmptyClause struct {
}

func (*EmptyClause) Build

func (receiver *EmptyClause) Build(builder clause.Builder)

func (*EmptyClause) ModifyStatement

func (receiver *EmptyClause) ModifyStatement(*gorm.Statement)

type Expression

type Expression dbi.FilterExpr

func (*Expression) Clause

func (e *Expression) Clause() func(*gorm.DB) *gorm.DB

type Limit

type Limit struct {
	Limit  int
	Offset int
}

Limit limit clause

func (Limit) Build

func (limit Limit) Build(builder clause.Builder)

Build build where clause

func (Limit) MergeClause

func (limit Limit) MergeClause(clause *clause.Clause)

MergeClause merge order by clauses

func (Limit) Name

func (limit Limit) Name() string

Name where clause name

type ListReq

type ListReq[T request.Ordered] request.ListReq[T]

func (*ListReq[O]) Clause

func (req *ListReq[O]) Clause() []clause.Expression

type PageSortReq

type PageSortReq request.PageSortReq

func (*PageSortReq) Clause

func (req *PageSortReq) Clause() []clause.Expression

type RangeReq

type RangeReq[T request.Ordered] request.RangeReq[T]

func (*RangeReq[T]) Clause

func (req *RangeReq[T]) Clause() clause.Expression