var express = require('express');
var path = require('path');
var favicon = require('serve-favicon');
var logger = require('morgan');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');
var mysql = require('mysql');

var connection = mysql.createConnection({
  host     : 'foxzy-us-east-2b.cal8xyu9vlxb.us-east-2.rds.amazonaws.com',
  user     : 'aleksa_95',
  password : 'password',
  port     : '3306',
  database : 'foxzy'
});

connection.connect(function(err) {
  if (err) {
    console.error('Database connection failed: ' + err.stack);
    return;
  }
  console.log('Connected to database.');

});


connection.query('SELECT * FROM users', (err,rows) => {
  if (err) {
    console.error(err.stack);
    return;
  }

  console.log('Data received from users');
  console.log(rows);
});

connection.query('SELECT * FROM articles', (err,rows) => {
  if (err) {
    console.error(err.stack);
    return;
  }

  console.log('Data received from articles');
  console.log(rows);
});

//Number 1 represents what article user select.
//It can be any no. In this case it's 1
var user_id=1; //Get user id

connection.query('SELECT * FROM articles WHERE ArticleId=1', (err,rows) => {
  if (err) {
    console.error(err.stack);
    return;
  }

  console.log('Data received from selected article');
  console.log(rows);
  user_id=rows[0].UserId;
});

console.log("User Id: "+user_id);
//Get user info from selected article
connection.query('SELECT * FROM users WHERE UserId='+user_id, (err,rows) => {
  if (err) {
    console.error(err.stack);
    return;
  }

  console.log('User information for current article');
  console.log(rows);
});


connection.end();

var index = require('./routes/index');
var users = require('./routes/users');

var app = express();

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

// 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('/', index);
app.use('/users', users);

// 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 handler
app.use(function(err, req, res, next) {
  // set locals, only providing error in development
  res.locals.message = err.message;
  res.locals.error = req.app.get('env') === 'development' ? err : {};

  // render the error page
  res.status(err.status || 500);
  res.render('error');
});

module.exports = app;