const express = require('express');
const router = express.Router();
const mysql = require('mysql')

/*
--------------------------------------
This will handel all get requests
--------------------------------------
*/
/*
//sqlInteractuin test
const SqlDataGetter = require('../../sqlInteraction/GetData');
//import  SqlDataGetter  from "./sqlInteraction/GetData";
let SqlGetter = new SqlDataGetter
*/

class SqlDataGetter {
  constructor()
  {
    this.con = mysql.createConnection({
      host: "localhost",
      user: "XXX",
      password: "XXX",
      database: "APP"
    });
  }

  GetClients()
  {
    let con = mysql.createConnection({
      host: "localhost",
      user: "XXX",
      password: "AAA",
      database: "APP"
    });
      let resultFromSql = null;
      con.connect(function(err) {
          if (err) throw err;
          let sql_querry = "SELECT * FROM contacts"
          con.query(sql_querry , function (err, result, fields) {
              if (err) throw err;
              //console.log(fields);
              console.log(result);
              resultFromSql =  result;
          });
          return resultFromSql;
      });
  }
  Tester()
  {
      //return this.con
      //console.log(this.con)
      return 'hello world'
  }

}



router.get('/' , async (req , res) =>
{
    //Need to make an obj that take the data and do all the querys
    res.status(200).send("DataBack");
});

router.get('/Clients' , async (req , res) =>
{
  let sql_getter = new SqlDataGetter();
  const Clients = sql_getter.GetClients();
  console.log(Clients);
  SqlDataGetter.GetClients()
  res.status(200);
  res.send({ respond : Clients});
});