Skip to content

Instantly share code, notes, and snippets.

@bryanthuan

bryanthuan/knex-paginator.js

Forked from ionutmilica/knex-paginator.js
Created April 27, 2019 17:26
Show Gist options
  • Save bryanthuan/bc05cd906d258536ce3c76fa281e182e to your computer and use it in GitHub Desktop.
Save bryanthuan/bc05cd906d258536ce3c76fa281e182e to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. @ionutmilica ionutmilica revised this gist May 20, 2017. No changes.
  2. @ionutmilica ionutmilica created this gist May 20, 2017.
    51 changes: 51 additions & 0 deletions knex-paginator.js
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,51 @@
    module.exports = (knex) => {
    return async (query, options) => {
    const perPage = options.perPage || 10;
    let page = options.page || 1;

    const countQuery = knex.count('* as total').from(query.clone().as('inner'));

    if (page < 1) {
    page = 1;
    }
    const offset = (page - 1) * perPage;

    query.offset(offset);

    if (perPage > 0) {
    query.limit(perPage);
    }

    const [data, countRows] = await Promise.all([
    query,
    countQuery
    ]);

    const total = countRows[0].total;

    return {
    pagination: {
    total: total,
    perPage,
    currentPage: page,
    lastPage: Math.ceil(total / perPage),
    from: offset,
    to: offset + data.length,
    },
    data: data
    };
    };
    };
    /*
    Usage:
    const paginator = require('./knex-paginator.js');
    const ticketsQuery = knex('tickets').select('*').orderBy('created_at', 'ASC');
    paginator(knex)(ticketsQuery, {
    perPage: 1,
    }).then(({ data, pagination }) => {
    console.log(data, pagination);
    }).catch(err => {
    console.log(err);
    });
    */