From c3d17983b398b5c5b2c2c62dd8fff478b5f02b4d Mon Sep 17 00:00:00 2001
From: Jules Laplace <julescarbon@gmail.com>
Date: Mon, 22 Jan 2018 12:49:38 +0100
Subject: api

---
 lib/db/index.js | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'lib/db/index.js')

diff --git a/lib/db/index.js b/lib/db/index.js
index 9720235..b2ea59c 100644
--- a/lib/db/index.js
+++ b/lib/db/index.js
@@ -30,6 +30,12 @@ db.getRandom = function () {
     qb.orderBy(knex.raw('RAND()')).limit(1)
   }).fetch()
 }
+db.getIndex = function(limit, offset) {
+  return Image.query(function(qb){
+    qb.orderBy("id", "desc").limit(limit)
+    if (offset) qb.offset(offset)
+  }).fetch()
+}
 db.createImage = function(url){
   return new Image({ url: url }).save()
 }
-- 
cgit v1.2.3-70-g09d2