@utilis/pagination

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
    return {
        data: dataResults,
        pagination: pageHelper.build(total),
        // optionally, return extra utility meta info
        paginationMeta: pageHelper.computeMeta()
    } as PagedList;
}

Change Logs

v0.0.9

• Include optional paginationMeta in PaginatedData<T> properties.
• (rename) PaginatedData<T> -> PagedList<T>

v0.0.7

• (rename) PagedResult<T> -> 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