koa-pageable-objection-example.js

// @flow
import { IndexablePage, Pageable, Sort, } from '@panderalabs/koa-pageable';
import type { QueryBuilder } from 'objection';

function getData(pageable: Pageable): IndexablePage<number, Person> {
  const pageNumber = pageable.page;
  const pageSize = pageable.size;
  const sort: Sort  = pageable.sort;
 
  const queryBuilder: QueryBuilder = Person.query().where('age', '>=', 21).page(pageNumber, pageSize);
  
  //If there is a sort, add each order element to the query's `orderBy`
  if (sort) {
    sort.forEach((property, direction) => queryBuilder.orderBy(property, direction));
  }  
  const result = await query.execute();
  
  return new IndexablePage(result.results, result.total, pageable); 
}