api

1 files changed, 6 insertions, 0 deletions

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()
 }