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: 'plops',
  hasTimestamps: true,
})
var ShaderImage = db.ShaderImage = bookshelf.Model.extend({
  tableName: 'im_cmd',
  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 }).save()
}
db.createShaderImage = function(data){
  return new ShaderImage(data).save()
}