brietsparks / knex-relay-cursor-pagination Goto Github PK

  const pagination = createPagination({
    from: 'user',
    sortColumn: 'first_name',
    sortDirection: 'desc',
    cursorColumn: 'id',
    first: 10,
  });

  const rows = databaseConnection
    .select(
      'user.id',
      'user.email',
      'user.first_name',
      'user.last_name',
    )
    .from('user')
    .where(
      pagination.where.column,
      pagination.where.comparator,
      pagination.where.value,
    )
    .orderBy(pagination.orderBy.column, pagination.orderBy.direction)
    .limit(pagination.limit);

  return pagination.getPage(rows);

 databaseConnection
    .select(
      'user.id',
      'user.email',
      'user.first_name',
      'user.last_name',
    )
    .from('user')