devServer.js

var path = require('path');
var express = require('express');
var session = require('express-session');
var cookieParser = require('cookie-parser');

//Extras
var bodyParser = require('body-parser');
var db = require('./server/config/dbOperations.js');
var User = require('./server/controllers/userController.js');
var passport = require('passport');

//Webpack
var webpack = require('webpack');
var config = require('./webpack.config.dev');
var compiler = webpack(config);

var app = express();

//Body Parser
app.use(bodyParser.urlencoded({extended: true}));
app.use(bodyParser.json());
app.use(cookieParser());
app.use(session({
  secret: 'FOOD1234567890BOT',
  resave: false,
  saveUninitialized: false
}));
// use passport
app.use( passport.initialize());
// store passport authentication in the session
app.use( passport.session());


//Hot Reloading
app.use(require('webpack-dev-middleware')(compiler, {
  noInfo: true,
  publicPath: config.output.publicPath
}));

app.use(require('webpack-hot-middleware')(compiler));

app.use(express.static(__dirname + '/dist'));

require('./server/config/routes.js')(app, express);

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

app.get('*', function(req, res) {
  res.sendFile(path.join(__dirname, 'index.html'));
});

app.listen(3000, function(err) {
  if (err) {
    console.log(err);
    return;
  }
  console.log('Listening at http://localhost:3000');
});

//postgres set up
var pg = require('pg');
var connectionString = process.env.DATABASE_URL || 'postgresql://localhost/foodbot';

var client = new pg.Client(connectionString);
client.connect();

//create db tables

var createUsersTable = client.query(db.createUsersTable);

var createRecipeSourcesTable = client.query(db.createRecipeSourcesTable);

var createRecipesTable = client.query(db.createRecipesTable);

var createGroceriesTable = client.query(db.createGroceryPriceTable);

var createIngredientsTable = client.query(db.createIngredientsTable);

var createRecipeIngredientsTable = client.query(db.createRecipeIngredientsTable);

var createProfilesTable = client.query(db.createProfilesTable);

var createUserRecipesTable = client.query(db.createUserRecipesTable);

var createMatchesQueueTable = client.query(db.createMatchesQueueTable);

var createUserPhotosTable = client.query(db.createUserPhotosTable);

var createOrdersTable = client.query(db.createOrdersTable);

var createRecipeCostTable = client.query(db.createRecipeCostTable);

var createRecipeSourcesTable = client.query(db.createRecipeSourcesTable);
var seedRecipeSourcesTable = client.query("SELECT * from RecipeSources", db.checkForSourceIds);

var createRecipeSearchTerms = client.query(db.createRecipeSearchTerms);
var seedRecipeSearchTerms = client.query('Select * from RecipeSearchTerms', db.checkForSeededResults);

// client.end();

module.exports = app;