server.js

"use strict";

require('dotenv').config();

const PORT        = process.env.PORT || 8080;
const ENV         = process.env.ENV || "development";
const express     = require("express");
const bodyParser  = require("body-parser");
const sass        = require("node-sass-middleware");
const app         = express();

const knexConfig  = require("./knexfile");
//const knex        = require("knex")(knexConfig[ENV]);
const morgan      = require('morgan');
const knexLogger  = require('knex-logger');

const knex = require('knex')({
  client: 'pg',
  connection: process.env.DATABASE_URL + '?ssl=true',
  searchPath: 'knex,public'
});

// Seperated Routes for each Resource
const indexRoutes = require("./routes/index");
const adminRoutes = require("./routes/admin");
const userRoutes = require("./routes/user");

// Load the logger first so all (static) HTTP requests are logged to STDOUT
// 'dev' = Concise output colored by response status for development use.
//         The :status token will be colored red for server error codes, yellow for client error codes, cyan for redirection codes, and uncolored for all other codes.
app.use(morgan('dev'));

// Log knex SQL queries to STDOUT as well
app.use(knexLogger(knex));

app.set("view engine", "ejs");
app.use(bodyParser.urlencoded({ extended: true }));
app.use("/styles", sass({
  src: __dirname + "/styles",
  dest: __dirname + "/public/styles",
  debug: true,
  outputStyle: 'expanded'
}));
app.use(express.static("public"));

//Runs routes when called, passes knex
app.all('/', indexRoutes(knex));
app.get('/admin/:admin', adminRoutes(knex));
app.get('/user/:userID', userRoutes(knex));
app.post('/user', userRoutes(knex));

//Submitted route doesn't get its own route file due to small size
app.get("/submitted", (req, res) => {
  res.render("submitted");
  });

app.listen(PORT, () => {
  console.log("Example app listening on port " + PORT);
});