app.js

var express = require('express');
var path = require('path');
var bodyParser = require('body-parser');
var dotenv = require('dotenv');
var async = require('async');

var port = process.env.PORT || 2014;

dotenv.load();
var pg = require('pg');
var conString = process.env.DB_CREDENTIALS;
var knex = exports.knex = require('knex')({
	client: 'pg',
	connection: conString
});

var routes = require('./routes/index');
var app = express();


// view engine setup
app.set('views', path.join(__dirname, 'views'));
app.set('view engine', 'jade');

// middleware to automatically parse form data
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(express.static(path.join(__dirname, 'public')));

// middleware that calls ./routes/index.js whenever we hit the '/' endpoint
app.use('/', routes);

// catch 404 and forward to error handler
app.use(function(req, res, next) {
    var err = new Error('Not Found');
    err.status = 404;
    next(err);
});

// set port to number provided from user or defaults to 3000
app.set('port', process.env.PORT || 3000);

var server = app.listen(app.get('port'), function() {
  console.log('Express server listening on port ' + server.address().port);
});

module.exports = app;