dbquery

Documentation

Index

• func BuildWithDefaultSorter(enabled bool) func(*buildOption)
• func BuildWithLimitPage(start, limit, maxLimit int) func(*buildOption)
• func BuildWithPage(start, limit int) func(*buildOption)
• func BuildWithSortField(field string, other ...string) func(*buildOption)
• func BuildWithSortKeyMappings(mapping map[string]string) func(*buildOption)
• func WithPreloads(preload string, others ...string) func(*option)
• func WithSorts(sort string) func(*option)
• type IFilter
  • func New[T any](filter *T, opts ...func(*option)) IFilter[T]

Functions

func BuildWithDefaultSorter

func BuildWithDefaultSorter(enabled bool) func(*buildOption)

BuildWithDefaultSorter 是否启用默认ID倒序排序。默认启用

func BuildWithLimitPage

func BuildWithLimitPage(start, limit, maxLimit int) func(*buildOption)

BuildWithLimitPage 限制最大条数的分页参数

func BuildWithPage

func BuildWithPage(start, limit int) func(*buildOption)

BuildWithPage 分页参数，默认最大 limit 不超过100

func BuildWithSortField

func BuildWithSortField(field string, other ...string) func(*buildOption)

BuildWithSortField 指定启用排序的数据库字段。需保证和数据库中字段一致

func BuildWithSortKeyMappings

func BuildWithSortKeyMappings(mapping map[string]string) func(*buildOption)

BuildWithSortKeyMappings 指定前端排序字段和数据库字段的映射关系。

func WithPreloads

func WithPreloads(preload string, others ...string) func(*option)

WithPreloads gorm Preload

func WithSorts

func WithSorts(sort string) func(*option)

WithSorts 排序规则 以符号开头，可选符号：(+或空 正序）（- 倒序）（* 自定义复杂排序标识关键词） 多个排序规则按英文逗号隔开

Types

type IFilter

type IFilter[T any] interface {
	pager.IPager[T]

	Preloads() []string

	Build(db *gorm.DB, opts ...func(*buildOption)) *gorm.DB
}

IFilter DB 分页参数

func New

func New[T any](filter *T, opts ...func(*option)) IFilter[T]