// Loading HTTP module
var http = require('http');
var url  = require('url');

//Creating constant relating to DB mysql
const mysql = require('mysql');

//Creating db object
const db = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: 'jaime',
    database: 'pbe'
});


const port = 3000;

function find_student(uid){
 //db.connect(function(err) {
    return new Promise( ( resolve, reject ) => {
           db.query("SELECT idstudents FROM students WHERE uid = '" + uid + "'", function (err, result) {
                if ( err )
                    return reject( err );
                var json = JSON.stringify(result);
                var idstudent = json.substring(json.indexOf(":") + 2 , json.length - 3 );
                resolve( idstudent );
            });
    });
}

var server = http.createServer(function(request, response){
  if(request.url.includes("/favicon")){
    return 0;
  }

  var q = url.parse(request.url,true).query;
  find_student(q.uid).then(idstudent =>response.end(idstudent) );

  //response.end(resultado);
});

server.listen(port);