From f2215b36f3e1844ac058e7e7cfef6a53083efef9 Mon Sep 17 00:00:00 2001
From: Jules Laplace <jules@okfoc.us>
Date: Thu, 24 Sep 2015 11:58:36 -0400
Subject: nav view

---
 lib/db/bookshelf.js | 24 ++++++++++++++++++++++++
 lib/db/index.js     | 13 +++++++++++++
 2 files changed, 37 insertions(+)
 create mode 100644 lib/db/bookshelf.js
 create mode 100644 lib/db/index.js

(limited to 'lib/db')

diff --git a/lib/db/bookshelf.js b/lib/db/bookshelf.js
new file mode 100644
index 0000000..69157cc
--- /dev/null
+++ b/lib/db/bookshelf.js
@@ -0,0 +1,24 @@
+var knex = require('knex')({
+  client: 'mysql2',
+  connection: {
+    host     : process.env.DB_HOST,
+    user     : process.env.DB_USER,
+    password : process.env.DB_PASS,
+    database : process.env.DB_NAME,
+    charset  : 'utf8',
+    typecast : function (field, next) {
+      console.log(field.type)
+      if (field.type == 'BLOB') {
+        return field.string()
+      }
+      return next()
+    }
+  }
+})
+
+var bookshelf = require('bookshelf')(knex)
+
+module.exports = {
+  bookshelf: bookshelf,
+  knex: knex,
+}
diff --git a/lib/db/index.js b/lib/db/index.js
new file mode 100644
index 0000000..33beae9
--- /dev/null
+++ b/lib/db/index.js
@@ -0,0 +1,13 @@
+var db = module.exports
+
+var connection = require("./bookshelf")
+var bookshelf = connection.bookshelf
+var knex = connection.knex
+
+
+/* MODELS */
+
+var Image = db.Image = bookshelf.Model.extend({
+  tableName: 'images',
+  hasTimestamps: false,
+})
-- 
cgit v1.2.3-70-g09d2