var express    = require("express");
var login = require('./routes/loginroutes');
var bodyParser = require('body-parser');
var app = express();
app.use(bodyParser.urlencoded({ extended: true }));
app.use(bodyParser.json());
app.use(function(req, res, next) {
res.header("Access-Control-Allow-Origin", "*");
res.header("Access-Control-Allow-Headers", "Origin, X-Requested-With,
Content-Type, Accept");
next();
});
var router = express.Router();
// test route
router.get('/', function(req, res) {
res.json({ message: 'welcome to our upload module apis' });
});
//route to handle user registration

router.post('/login',login.login)
app.use('/api', router);
app.listen(5000);

var mysql      = require('mysql');
var connection = mysql.createConnection({
host     : 'localhost',
user     : 'root',
password : '',
database : 'mynodedb',
port:3307
});
connection.connect(function(err){
if(!err) {
console.log("Database is connected ... nn");
} else {
console.log("Error connecting database ... nn");
}
});




exports.login = function(req,res){
var username= req.body.username;
var password = req.body.password;
connection.query('SELECT * FROM users WHERE username = ?',[username],
function (error, results, fields) {
if (error) {
// console.log("error ocurred",error);
res.send({
"code":400,
"failed":"error ocurred"
})
}else{
// console.log('The solution is: ', results);
console.log(username);
if(results.length >0){
if([0].password == password){
res.send({
      "code":200,
      "success":"login sucessfull"
        });
  }
  else{
    res.send({
      "code":204,
      "success":"Email and password does not match"
        });
  }
}
else{
  res.send({
    "code":204,
    "success":"Email does not exits"
      });
}
}
});
}