From f2215b36f3e1844ac058e7e7cfef6a53083efef9 Mon Sep 17 00:00:00 2001 From: Jules Laplace Date: Thu, 24 Sep 2015 11:58:36 -0400 Subject: nav view --- lib/db/bookshelf.js | 24 ++++++++++++++++++++++++ lib/db/index.js | 13 +++++++++++++ lib/index.js | 46 ++++++++++++++++++++++++++++++++++++++++++++++ 3 files changed, 83 insertions(+) create mode 100644 lib/db/bookshelf.js create mode 100644 lib/db/index.js create mode 100644 lib/index.js (limited to 'lib') 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, +}) diff --git a/lib/index.js b/lib/index.js new file mode 100644 index 0000000..0cc00a9 --- /dev/null +++ b/lib/index.js @@ -0,0 +1,46 @@ +require('dotenv').load(); +var fs = require('fs') +var app, express = require('express'); +var http = require('http'); +var https = require('https'); +var bodyParser = require('body-parser') +var cookieParser = require('cookie-parser') +var csurf = require('csurf') +var path = require('path') +var multiparty = require('multiparty') +var ejs = require('ejs') +var passport = require('passport') +var sessionstore = require('sessionstore') +var session = require('express-session') +var multer = require('multer') + +var app, server + +var db = require("./db") + +var site = module.exports = {} +site.init = function(){ + app = express() + app.set('port', 5000) + app.set('view engine', 'ejs') + app.set('views', path.join(__dirname, '../views')) + app.use(express.static(path.join(__dirname, '../public'))) + app.use(bodyParser.json()) + app.use(bodyParser.urlencoded({ extended: false })) + app.use( multer({ dest:'./uploads/' }).single("file") ) + + app.use(express.query()) + + server = http.createServer(app).listen(5000, function () { + console.log('Bucky listening at http://5.k:%s', server.address().port) + }) + + app.get("/p/:id", function(req, res){}) + + app.get("/get/random", function(req, res){ + }) + app.get("/get/latest", function(req, res){ + }) + app.get("/get/:id", function(req, res){ + }) +} \ No newline at end of file -- cgit v1.2.3-70-g09d2