Adding pagination to knex.js

knex-pagination.js

const config = require('./config')
const knex = require('knex')(config.db)

const QueryBuilder = require('knex/lib/query/builder')

QueryBuilder.prototype.paginate = function ({ limit = 10, page = 1 }) {
  const offset = (page - 1) * limit
  return Promise.all([
    this.clone().count('* as count').first(),
    this.offset(offset).limit(limit)
  ])
    .then(([count, data]) => {
      const total = count.count
      return {
        total,
        limit,
        offset,
        from: offset + 1,
        to: offset + data.length,
        page,
        lastPage: Math.ceil(total / limit),
        data
      }
    })
}

knex.queryBuilder = function () {
  return new QueryBuilder(knex.client)
}

module.exports = knex