summaryrefslogtreecommitdiff
path: root/lib/db/index.js
diff options
context:
space:
mode:
authorJules <jules@asdf.us>2018-03-31 08:56:12 -0400
committerJules <jules@asdf.us>2018-03-31 08:56:12 -0400
commit655b5ddb4aeca5b89d44828e809caa73cdccfd63 (patch)
tree174f1628a44152dbdfea077f174f7b86121d7bda /lib/db/index.js
parentb3c1619d2027939963d4f906e9da40b26e17eee1 (diff)
parenta7eba7c34281e59dcae3a24d4cc73c2148c7d6b7 (diff)
Merge branch 'master' of ghghgh.us:luckyplop
Diffstat (limited to 'lib/db/index.js')
-rw-r--r--lib/db/index.js6
1 files changed, 5 insertions, 1 deletions
diff --git a/lib/db/index.js b/lib/db/index.js
index 93fdd0e..573528d 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)