Dashdot Cursors

A simple SQL and Mongo implementation of cursor based pagination

Usage

Inside your Node project directory, run the following:

1npm i --save @dashdot/cursors

Or with Yarn:

1yarn add @dashdot/cursors

API

1import { cursorToSqlQuery } from '@dashdot/cursor'
2import * as tables from './tables'
3
4const user = await tables.users().fist()
5const orderBy = {
6    email: 'ASC'
7    lastName: 'DESC',
8    firstName: 'ASC',
9    id: 'DESC',
10}
11const cursor = createCursor(user, orderBy)
12const [
13    whereQuery,
14    whereValues,
15    orderQuery
16]  = cursorToSqlQuery(cursor, orderBy)
17const nextUser = await tables.users()
18    .whereRaw(whereQuery, whereValues)
19    .orderByRaw(orderQuery)
20    .first()