//app.js
var express = require('C:/Users/aleca/OneDrive/Documents/DavidCode/node_modules/express');
var bodyParser = require('body-parser');
var mysql = require('mysql');
var app = express();

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

app.get('/', function(req, res) {
  console.log('I received a GET request');
  var connection = mysql.createConnection({
    host: '107.170.169.80',
    user: 'david',
    password: 'david!102',
  });
  connection.connect;
  connection.query('SELECT * FROM NCV.contactlist', function(err, docs){
    console.log(docs);
    res.json(docs);
  });
  connection.end();
});


//app.set('views', __dirname+'views');
//app.set('view engine', 'ejs');

app.get('/', function(req, res){
  res.render("index");
});

// uncomment after placing your favicon in /public
//app.use(favicon(path.join(__dirname, 'public', 'favicon.ico')));
app.use(logger('dev'));
app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));
app.use(cookieParser());
app.use(express.static(path.join(__dirname, 'public')));

app.use('/', routes);
app.use('/about', about);
app.use('/db', db);

app.get('/', function(req, res){
  res.send('Hello, World!');
})

app.listen(3000, function(){
  console.log('Example app listening on port 3000!');
});
// catch 404 and forward to error handler
app.use(function(req, res, next) {
  var err = new Error('Not Found');
  err.status = 404;
  next(err);
});

// error handlers

// development error handler
// will print stacktrace
if (app.get('env') === 'development') {
  app.use(function(err, req, res, next) {
    res.status(err.status || 500);
    res.render('error', {
      message: err.message,
      error: err

    });
  });
}

// production error handler
// no stacktraces leaked to user
app.use(function(err, req, res, next) {
  res.status(err.status || 500);
  res.render('error', {
    message: err.message,
    error: {}
  });
});


module.exports = app;