scaffolding

1 files changed, 26 insertions, 0 deletions

diff --git a/db/index.js b/db/index.js
new file mode 100644
index 0000000..6124e31
--- /dev/null
+++ b/db/index.js
@@ -0,0 +1,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()
+}
+
+