Pagination in footprints

[jamesjwarren]

Integrate pagination into the FootprintService.find method using bookshelf's fetchPage method. To support queries like: ?limit=10&page=1

[jamesjwarren]

I've noticed in the FootprintService limit is being passed into bookshelf's .query(criteria) method in the criteria object. Trying to use this returns the following error:

error: column "limit" does not exist

Bookshelf doesn't appear to support this and instead the query should be built with the following knex query:

.query((qb) => {
  qb.where(criteria)
  db.limit(10).offset(0)
}

Or alternatively using the pagination plugin with the fetchPage method instead.