rhys-vdw · March 8, 2016 16:07 · Jun 17, 2015 · Jun 17, 2015 · Jun 17, 2015
diff --git a/paginate → paginate.coffee b/paginate → paginate.coffee
diff --git a/gistfile1.coffee → paginate b/gistfile1.coffee → paginate
diff --git a/gistfile1.coffee b/gistfile1.coffee
@@ -0,0 +1,45 @@
+Promise = require 'bluebird'
+
+defaultPageSize = 20
+
+paginate = (knex) -> (query, paginationOptions, options) ->
+
+  if query.fetchAll?
+    model = query
+    query = model.query()
+
+  # Store original query.
+  totalQuery = knex.count().from query.clone().as 'inner'
+  totalPromise = totalQuery.then (rows) -> rows[0].count
+
+  # Extract options
+  { page, pageSize, offset, limit } = paginationOptions
+
+  # Set defaults
+  pageSize   ?= defaultPageSize
+  offset     ?= 0
+  page        = 1 if not page? or page < 1
+
+  # Update vars based on interplay between limit/offset and pagination.
+  page       += offset // pageSize
+
+  # Calculate actual limit and offset to be used in query. (Note that the
+  # natural concept of a page starts from 1 rather than 0.)
+  limit   = limit ? pageSize
+  offset += (page - 1) * pageSize
+
+  query.offset offset
+  query.limit limit if limit > 0
+
+  return Promise.all([
+    model?.fetchAll(options) or query
+    totalPromise
+  ]).spread (data, total) -> {
+    pagination: {
+      total, pageSize, offset, limit, page,
+      pageCount: Math.ceil(total / pageSize)
+    },
+    data
+  }
+
+module.exports = paginate
No results found