lib/db/index.js


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

var db = module.exports

var connection = require("./bookshelf")
var bookshelf = connection.bookshelf
var knex = connection.knex


/* MODELS */

var Image = db.Image = bookshelf.Model.extend({
  tableName: 'images',
  hasTimestamps: false,
})

db.getImage = function(id) {
  var model = new Image({'id': id})
  return model.fetch()
}
db.getLatest = function () {
  return Image.query(function(qb){
    qb.orderBy("id", "desc").limit(1)
  }).fetch()
}
db.getRandom = function () {
  return Image.query(function(qb){
    qb.orderBy(knex.raw('RAND()')).limit(1)
  }).fetch()
}

db.createImage = function(url){
  return new Image({ url: url, shorturl: "" }).save()
}