@utilis/pagination

import { PaginationHelper } from './PaginationHelper';

function pagedQuery() {
    const pageHelper = new PaginationHelper({ page: 3, size: 10 }); // use `size` as the sql query LIMIT value
    const offset = pageHelper.getOffset(); // use `offset` as the sql query OFFSET value
    const dataResults = []; // get from db using sql OFFSET and LIMIT , .
    const total = 0; // get from db.

    // Return the paged result (PaginationResult)
    return {
        data: dataResults,
        pagination: pageHelper.build(total),
        // optionally, return extra utility meta info
        paginationMeta: pageHelper.computeMeta()
    };
}

Change Logs

v0.0.8

• Include optional paginationMeta in PaginatedData<T> properties.

v0.0.7

• Renamed PagedResult<T> to PaginatedData<T>

v0.0.6

• Return null for previousPage and nextPage when total is zero

v0.0.5

• Return zero for previousPage and nextPage when total is zero