var db = module.exports

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

/* MODELS */

var Customer = bookshelf.Model.extend({ tableName: 'cw_customers' })
var OrderSKU = bookshelf.Model.extend({ tableName: 'cw_order_skus' })
var Order = bookshelf.Model.extend({ tableName: 'cw_orders' })
var Product = bookshelf.Model.extend({ tableName: 'cw_products' })
var SKU = bookshelf.Model.extend({ tableName: 'cw_skus' })

/* PICTURES */

db.createUser = function(data){
  return new db.User(data).save()
}
db.getUsers = function (callback) {
  return User.query(function(qb){
    qb.orderBy("id", "desc")
  }).fetchAll()
}