Sequelize Pagination
Add a method on a sequelize model for pagination queries
The project is inspired by sequelize-simple-pagination
Quick start
Define a sequelize model and add a pagination method:
// Define a modelconst withPagination = ; const Counter = sequelize; const options = methodName: 'paginate' // the name of the pagination method primaryKey: 'id' // the primary key field of the model; // Add a pagination method for the modelCounter;
Call the paginate
(default method name) method:
Counter
The paginate
method returns a promise with resolve data of SequelizePaginationResult
type.
Use examples
Predefine pagination
Counter;
example/PredefinePagination.js
Custom pagination
Create a pagination with orderBy, order options
{ const orderBy order ...others = options; const result = await Counter; return orderBy order ...result;}
example/CustomPagination-OrderBy.js
API
withPagination(options) - for adding pagination method
withPagination()
is a function generator for remember pagination configuration.
options
is a object with following properties:
- methodName: the name of the pagination method. Default:
paginate
- primaryKey: the primary key field of the model. Default:
id
- oneBaseIndex: page index base. Pag index starts from 0 if
oneBaseIndex
isfalse
. Page index starts from 1 ifoneBaseIndex
istrue
. Default:false
- pageSize: Default: 1
- where: the query applied to findAll and pass value directly to where
- array: the query applied to findAll and add a primary key to order
- attributes: the query applied to findAll and pass value directly to attributes
- include: the query applied to findAll and pass value directly to include
options.methodName
is paginate
)
paginate(options) - execute a pagination query (suppose options
is a object with following properties:
- primaryDesc: primary key desc order. Default: false
- pageSize: Default: 1
- pageIndex: Pag index starts from 0 if oneBaseIndex is
false
. Page index starts from 1 if oneBaseIndex istrue
. - where: the query applied to findAll and pass value directly to where
- array: the query applied to findAll and add a primary key to order
- attributes: the query applied to findAll and pass value directly to attributes
- include: the query applied to findAll and pass value directly to include
return a promise with resolve data of SequelizePaginationResult
type.
SequelizePaginationResult - pagination resolve data
SequelizePaginationResult
is a object type with following properties:
- entities the results of the query
- pageIndex page index
- pageCount page count(total page amount)
- pageSize page size for one page
- count all entities for a model
- where the
where
parameter offindAll
- orders the
orders
parameter offindAll
- attributes the
attributes
parameter offindAll
- include the
include
parameter offindAll
Run tests
npm run test