var express = require('express');
const ngrok = require('ngrok');
//var routes = require("./routes/routes.js")
var routes2 = require("./routes/routes2.js");
var bodyParser = require("body-parser");
var mysql = require('mysql');
var app = express();

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

const startNgrok = async function(a, b) {
  const url = await ngrok.connect();
  console.log(url);
}

conn.connect(function(err) {
  if(err) throw err;
  console.log('Connected!');
  startNgrok();
});

app.use(bodyParser.json());
app.use(bodyParser.urlencoded({ extended: true}));
//app.use('/discipline', routes);
routes2(app);

var server = app.listen(3000, function () {
    console.log("App running on port:", server.address().port);
});

app.use('/discipline/creeaza', 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);
      }
  });
});