var express = require('express');
var bodyParser = require('body-parser');
var pg = require ('pg');
var app = express();
const conf = require('../obiwanBackEnd/config');

//database connections
const config = conf.config1;
const config2 = conf.config2;

console.log('database config : ', config);
app.set('port', process.env.PORT || 5050);
app.listen(5050);
console.log('Listening to port 5050');

//middlewares
app.use(bodyParser.json());
app.use(function(req, res, next) {
    res.header("Access-Control-Allow-Origin", "*");
    //res.header("Access-Control-Allow-Methods: 'HEAD, GET, POST, PUT, PATCH, DELETE'");
    res.header("Access-Control-Allow-Headers", "Origin, X-Requested-With, Content-Type, Accept");
    next();
});

// DATABASE
app.post('/api/v1/authorization', function(req,res){
    console.log('request login', req.body.username, ' URL : ',req.headers.origin);
    var client = new pg.Client(config);
    client.connect();
    var username = req.body.username.toString().toLowerCase();
    var password = req.body.password.toString();
    var queryString ="SELECT * FROM obiwan.account_management WHERE username = '" + username +"'" + ' and password = ' + "'" + password + "';";
    var query = client.query(queryString);
    query.on('row', function (row,result){
        result.addRow(row);
    });
    query.on('end',function(result){
        client.end();
        var json = JSON.parse(JSON.stringify(result));
        var userRole = json.rows;
        if(json.rowCount > 0){
            res.status(200).send(userRole);
            console.log('username : ',userRole[0].username, ' role : ',userRole[0].role);
        }else{
            res.status(201).send();
            console.log('incorrect credentials');
        }
    });
    query.on('error', function(err){
        console.log(err);
        res.status(500).send();
    });
});