From a7b2a2c8929ec1d17939f2527ac6033beeaea9b7 Mon Sep 17 00:00:00 2001
From: Jules Laplace <julescarbon@gmail.com>
Date: Sat, 31 Mar 2018 14:52:57 +0200
Subject: ascii view

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

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

diff --git a/lib/db/index.js b/lib/db/index.js
index b2ea59c..ffd8c27 100644
--- a/lib/db/index.js
+++ b/lib/db/index.js
@@ -4,7 +4,6 @@ var connection = require("./bookshelf")
 var bookshelf = connection.bookshelf
 var knex = connection.knex
 
-
 /* MODELS */
 
 var Image = db.Image = bookshelf.Model.extend({
@@ -30,6 +29,11 @@ db.getRandom = function () {
     qb.orderBy(knex.raw('RAND()')).limit(1)
   }).fetch()
 }
+db.getRandomAscii = function () {
+  return ShaderImage.query(function(qb){
+    qb.where("tag", "=", "ascii").orderBy(knex.raw('RAND()')).limit(1)
+  }).fetch()
+}
 db.getIndex = function(limit, offset) {
   return Image.query(function(qb){
     qb.orderBy("id", "desc").limit(limit)
-- 
cgit v1.2.3-70-g09d2