const express = require('express');
const pug = require('pug');
const bodyParser = require('body-parser');
const path = require('path');
const mysql = require('mysql');

require('dotenv').config();

const app = express();

app.set('views', path.join(__dirname, './views'));
app.set('view engine', 'pug');
app.use(express.static(path.join(__dirname, 'public')));

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'coolio',
  password: process.env.DB_PASS,
  database: 'routes'
});

app.get('/', function(req, res) {
  const routesQuery = "SELECT route, route_name FROM routes";
  let routeObj = {};
  connection.query(routesQuery, function(err, results) {
    if (err) throw err;
    for (let i = 0; i < results.length; i++) {
      routeObj.route = results[i].route;
      routeObj.routeName = results[i].route_name;
      console.log(routeObj);
    }
  });
});

app.listen(3000, function() {
  console.log("Listening..");
});


Listening..
{ route: 1, routeName: 'Metric/South Congress' }
{ route: 2, routeName: 'Rosewood' }
{ route: 3, routeName: 'Burnet/Manchaca' }
{ route: 4, routeName: 'Montopolis' }
{ route: 5, routeName: 'Woodrow/South 5th' }
{ route: 6, routeName: 'East 12th' }

html
  head
    link(rel='stylesheet', type='text/css', href='stylesheets/normalize.css' )
    link(rel='stylesheet', type='text/css', href='stylesheets/style.css' )
  body
    div.container
      div#test
        p=routeObj