var express = require('express');
var mysql = require('mysql');
var app = express();

var conn = mysql.createConnection({
    host: "94.24.54.192",
    user: "pharm_practica18",
    password: "Qwerty098765",
    database: "pharm_orar"
});

app.use(express.json());
app.use(express.urlencoded({extended: true}));

app.use('/test', function(request, response){
  console.log(request.body);      // your JSON
   response.send(request.body);    // echo the result back
});

function getRowsFromDisciplina(callback) {
    conn.query("SELECT * FROM Discipline ORDER BY 'Anul in care se studiaza'", function(err, result){
        callback(err, result);
    });
  }

  app.use("/discipline/listeaza", function(req, res){
    getRowsFromDisciplina(function(err, result){
        if(err) {
            res.send(err);
        } else {
            res.send(result);
        }
    });
});

app.listen(3000);