blob: 6124e314d4e7b5b67c8abc9adbaf5759917833ac (
plain)
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
|
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()
}
|
