pagination

Documentation

Index

• Constants
• type Pagination
  • func New(page, pageSize int64, args ...int64) *Pagination
  • func (p *Pagination) GetSQLClause(total int64) string
  • func (p *Pagination) Paging(data interface{}) (int64, []interface{})

Constants

const DefaultPageSize = 10

Types

type Pagination

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

func New

func New(page, pageSize int64, args ...int64) *Pagination

New pagination args[0] is default page size

func (*Pagination) GetSQLClause

func (p *Pagination) GetSQLClause(total int64) string

GetSQLClause 获取翻页SQL查询语句

1. 假如前端没有传过来last_pk, 那么返回值是 last_pk, LIMIT子句(LIMIT offset, pageSize) e,g: 0, "LIMIT 20, 10" => 在数据库查询时可能会被组装成 WHERE pk > 0 ... LIMIT 20, 10

2. 假如前端传过来了last_pk, 那么返回值是 last_pk, LIMIT子句(LIMIT pageSize) e,g: 123,"LIMIT 10" => 在数据库查询时可能会被组装成 WHERE pk > 123 ... LIMIT 10

func (*Pagination) Paging

func (p *Pagination) Paging(data interface{}) (int64, []interface{})

Paging 分页 @return total @return []interface{} 分页后的数据