const express = require("express");
const app = express();
const bodyParser = require("body-parser");
const mysql = require("mysql");

const connection = mysql.createConnection({
  host: "localhost",
  user: "****",
  password: "*****",
  database: "sqlquests"
});

connection.connect();
app.use(bodyParser.json());
app.use(
  bodyParser.urlencoded({
    extended: true
  })
);

app.put("/api/movies/:id", (req, res) => {

  const idMovie = req.params.id;
  const formData = req.body;
  connection.query(
    "UPDATE movie SET ? WHERE id = ?",
    [formData, idMovie,
    err => {
      if (err) {
        console.log(err);
        res.status(500).send("Erreur lors de la modification d'un film");
      } else {

        res.sendStatus(200);
      }
    }
  );
});
connection.end();
const port = process.env.PORT || 4000;
app.listen(port, () => console.log(`test ${port}`));