const express = require("express");
const mysql = require("mysql");
const app = express();

function connectToDB() {
  const con = mysql.createConnection({
    host: "mysql27.mydevil.net",
    user: "m1093_letscode",
    password: "8DfyhJg37DqvU0AYrTYI",
    database: "m1093_letscode"
  });
  con.connect(err => {
    if (err) throw err;
    console.log("Succesfully connected to database");
  });
  return con;
}

app.use((req, res, next) => {
  res.append("Access-Control-Allow-Origin", ["*"]);
  res.append("Access-Control-Allow-Methods", "GET,PUT,POST,DELETE");
  res.append("Access-Control-Allow-Headers", "Content-Type");
  next();
});

app.get("/", (req, res) => {});
app.get("/restaurants", (req, res) => {
  const con = connectToDB();

  const sql = /*sql*/ `
    SELECT * FROM restaurants
    `;

  con.query(sql, (err, result) => {
    if (err) throw err;
    console.log(result.affectedRows);
  });
});

const port = 5000;
app.listen(port, err => {
  if (err) throw err;
  console.log(`listening on port ${port}...`);
});