egg-mysql-paginator
Paginator for egg-mysql
Install
$ npm i egg-mysql-paginator --save
Usage
// {app_root}/config/plugin.jsexportsmysqlPaginator = enable: true package: 'egg-mysql-paginator';
Example
// queryconst results = await appmysqlPaginator;// result pagination: total: 21 size: 10 currentPage: 1 lastPage: 3 from: 0 to: 10 data: ...
Fuzzy query
const results = await appmysqlPaginator;
Customized order by
const results = await appmysqlPaginator;