var express = require('express');
var mysql = require('mysql');
var cookieParser = require('cookie-parser');
var bodyParser = require('body-parser');


var app = express();

app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: false }));

var connection = mysql.createConnection({
	host: "localhost",
	user: "root",
	password:"root",
	database: "testDb"
});


app.get("/employees", function(req, res) {
  //Can we add some pagination?
  connection.query('SELECT * from employees',
    function(err, rows, fields) {
    if (err) {
      res.status(500).json(err);
    } else {
      var responseData = {
        total: rows.length,
        data: rows
      };
      res.status(200).json(responseData);
    }
  });
});


connection.connect(function(err) {
  if (!err) {
    console.log("successfully connected");
  } else {
 throw err;
  }
});

app.listen(3000);