From 5028ad81845308f3b1954dcc1fde664077fa0fa9 Mon Sep 17 00:00:00 2001
From: Jules Laplace <jules@okfoc.us>
Date: Fri, 21 Apr 2017 12:30:57 -0400
Subject: scaffolding

---
 db/index.js | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 db/index.js

(limited to 'db/index.js')

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()
+}
+
+
-- 
cgit v1.2.3-70-g09d2