var express = require('express');
var app = express();
var mysql = require('mysql');

var apiController = require('./controller/apiController');
var htmlController = require('./controllers/htmlController');

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

app.use('/assets', express.static(__dirname + '/public'));

app.set(view engine', 'ejs');

app.use('/', function(req, res, next){
  console.log('Request Url:' + req.url);

  var conn = mysql.createConnection({
    host: "localj=host",
    user: "test",
    password: "test",
    database: "addressbook"
  });

  conn.query('select * from table...', function(err, rows){
    if (err) throw err;
    console.log(rows[0].FirstName);
  });

  next();
});

htmlController(app);
apiController(app);


app.listen(port);