From f768ab296c07ce93efe9f2507cdf4b795aa10013 Mon Sep 17 00:00:00 2001
From: Jules Laplace <jules@okfoc.us>
Date: Thu, 3 Sep 2015 13:52:20 -0400
Subject: pull in app skeleton from asdf-yt

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

(limited to 'lib/db/index.js')

diff --git a/lib/db/index.js b/lib/db/index.js
new file mode 100644
index 0000000..e820758
--- /dev/null
+++ b/lib/db/index.js
@@ -0,0 +1,47 @@
+var db = module.exports
+
+var connection = require("./bookshelf")
+var bookshelf = connection.bookshelf
+var knex = connection.knex
+
+/* MODELS */
+
+var User = db.User = bookshelf.Model.extend({
+  tableName: 'users',
+  hasTimestamps: true,
+})
+var Thread = db.Thread = bookshelf.Model.extend({
+  tableName: 'threads',
+  hasTimestamps: true,
+})
+var Comment = db.Comment = bookshelf.Model.extend({
+  tableName: 'comments',
+  hasTimestamps: true,
+})
+var File = db.File = bookshelf.Model.extend({
+  tableName: 'files',
+  hasTimestamps: true,
+})
+var Keyword = db.Keyword = bookshelf.Model.extend({
+  tableName: 'keywords',
+  hasTimestamps: true,
+})
+var Mailbox = db.Mailbox = bookshelf.Model.extend({
+  tableName: 'boxes',
+  hasTimestamps: true,
+})
+var Message = db.Message = bookshelf.Model.extend({
+  tableName: 'messages',
+  hasTimestamps: true,
+})
+
+/* 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