juliaheller · March 15, 2020 20:05
diff --git a/Express 5 - DELETE method and data deletion b/Express 5 - DELETE method and data deletion
 const express = require("express");
 const app = express();
 const port = 3008;
 const connection = require("./conf");
 const bodyParser = require("body-parser");
 // Support JSON-encoded bodies
 app.use(bodyParser.json());
 // Support URL-encoded bodies
 app.use(
  bodyParser.urlencoded({
    extended: true
  })
 );

 app.get("/", (request, response) => {
  response.send("You are on the Homepage");
 });

 app.get("/api/movies", (request, response) => {
  connection.query("SELECT * FROM movie", (err, results) => {
    if (err) {
      response.status(500).send(err);
    } else {
      response.json(results);
    }
  });
 });

 app.get("/api/movies/names", (request, response) => {
  connection.query("SELECT name FROM movie", (err, results) => {
    if (err) {
      response.status(500).send(err);
    } else {
      response.json(results);
    }
  });
 });

 app.post("/api/movies", (request, response) => {
  const formData = request.body;
  response.send(request.body);
  connection.query("INSERT INTO movies SET ?", formData, (err, results) => {
    console.log(formData);
    if (err) {
      console.log(err);
      response.status(500).send("Error saving a movie");
    } else {
      response.sendStatus(200);
    }
  });
 });

 app.put("/api/movies/:id", (request, response) => {
  const movie_id = request.params.id;
  const formData = request.body;
  console.log(movie_id);
  console.log(formData);
  connection.query(
    "UPDATE movie SET ? WHERE id = ?",
    [formData, movie_id],
    err => {
      if (err) {
        console.log(err);
        response.status(500).send("Error editing the movie");
      } else {
        response.sendStatus(200);
      }
    }
  );
 });

 app.delete("/api/movies/:id", (request, response) => {
  const movie_id = request.params.id;
  connection.query("DELETE FROM movie WHERE id = ?", [movie_id], err => {
    if (err) {
      // If an error has occurred, then the user is informed of the error
      console.log(err);
      response.status(500).send("Error deleting the movie");
    } else {
      // If everything went well, we send a status "ok".
      response.sendStatus(200);
    }
  });
 });



 app.listen(port, err => {
  if (err) {
    throw new Error("Something bad happened...");
  }

  console.log(`Server is listening on ${port}`);
 });
No results found