const express = require('express')
const app = express();

// dependencies
var mysql =  require("mysql");
// db connection settings
var con = mysql.createConnection({
	host:"localhost",
	user:"root",
	password:"xxx",
	database:"xxxx"
});

app.get('/', (req,res) => {
  // connect to the database
  con.connect(function(err){
    if(err)
      console.log(err)
    else
      var sql = "SELECT * FROM employee";
      con.query(sql, function(err, data){
        if(err){
          console.log(err)
        }
        else{
          data.forEach(function(record){
            //console.log(record.emp_id, record.sex);
            res.send(JSON.stringify(record))
          });
        }
      });
  });
})


app.listen(3000)