paginate

README

GORM Paginate

Query Params

type PaginationDefault struct {
	Page   int               `query:"page" minimum:"1" default:"1"`
	Size   int               `query:"size" minimum:"1" default:"10"`
	Sort   string            `query:"sort" description:"1. asc: **id**\n2. desc: **-id**\n3. multi: **id,created_at**"`
	Search string            `query:"search"`
	Filter map[string]string `query:"filter" description:"1. Comparison Operators: **eq**, **ne**, **like**, **contain**, **gt**, **gte**, **lt**, **lte**, **in**\n2. Usage: \"field**[:op]**\":value"`
}

Filter

1. Comparison Operators: eq, ne, like, contain, gt, gte, lt, lte, in
2. Usage: "field[:op]":value

Sort

1. asc: id
2. desc: -id
3. multi: id,created_at

Example

exmaples

Documentation

Index

• func OrderByScope(model any, sort string) func(db *gorm.DB) *gorm.DB
• func Paginate[T any](db *gorm.DB, p Pagination, out *[]T, query ...func(db *gorm.DB) *gorm.DB) (int64, error)
• type Pagination
• type PaginationDefault
  • func (p *PaginationDefault) GetFilter() map[string]string
  • func (p *PaginationDefault) GetPage() int
  • func (p *PaginationDefault) GetSearch() string
  • func (p *PaginationDefault) GetSize() int
  • func (p *PaginationDefault) GetSort() string
  • func (p *PaginationDefault) SetDefaultSort(sort string) Pagination

Functions

func OrderByScope

func OrderByScope(model any, sort string) func(db *gorm.DB) *gorm.DB

func Paginate

func Paginate[T any](db *gorm.DB, p Pagination, out *[]T, query ...func(db *gorm.DB) *gorm.DB) (int64, error)

Types

type Pagination

type Pagination interface {
	GetPage() int
	GetSize() int
	GetSort() string
	GetSearch() string
	GetFilter() map[string]string
}

type PaginationDefault

type PaginationDefault struct {
	Page   int               `query:"page" minimum:"1" default:"1"`
	Size   int               `query:"size" minimum:"1" default:"10"`
	Sort   string            `query:"sort" description:"1. asc: **id**\n2. desc: **-id**\n3. multi: **id,created_at**"`
	Search string            `query:"search"`
	Filter map[string]string `` /* 169-byte string literal not displayed */
}

func (*PaginationDefault) GetFilter

func (p *PaginationDefault) GetFilter() map[string]string

func (*PaginationDefault) GetPage

func (p *PaginationDefault) GetPage() int

func (*PaginationDefault) GetSearch

func (p *PaginationDefault) GetSearch() string

func (*PaginationDefault) GetSize

func (p *PaginationDefault) GetSize() int

func (*PaginationDefault) GetSort

func (p *PaginationDefault) GetSort() string

func (*PaginationDefault) SetDefaultSort

func (p *PaginationDefault) SetDefaultSort(sort string) Pagination