routing

routing.js

const express = require("express");
const router = express.Router();
const db = require("../mysql");

router.get("/", (req, res) => {
  db.query("SELECT id, email, name FROM user", (err, results) => {
    if (err) {
      res.status(500).json({
        error: err.message,
        sql: err.sql,
      });
    } else {
      res.json(results);
    }
  });
});

router.get("/:id", (req, res) => {
  const userId = req.params.id;
  db.query(
    "SELECT id, email, name FROM user WHERE id = ?",
    [userId],
    (err, results) => {
      if (err) {
        res.status(500).send("An error occured :", err);
      }
      if (results.length === 0) {
        return res.status(404).send("User not found");
      } else {
        res.status(200).json(results[0]);
      }
    }
  );
});

router.put("/:name", (req, res) => {
  const nameUser = req.params.name;
  const formData = req.body;

  db.query(
    "UPDATE user SET ? WHERE name = ?",
    [formData, nameUser],
    (err, results) => {
      if (err) {
        return res.status(500).json({
          error: err.message,
          sql: err.sql,
        });
      }

      return res.status(200).json("hey, my name is " + formData.name + " !");
    }
  );
});

router.delete("/:id", (req, res) => {
  const idUser = req.params.id;

  db.query("DELETE FROM user WHERE id=?", [idUser], (err, results) => {
    if (err) {
      return res.status(500).json({
        error: err.message,
        sql: err.sql,
      });
    }

    return res.status(200).json("Hey it's a DELETE ID " + idUser + " !");
  });
});

module.exports = router;



// pour info : index.js  //
  
const express = require("express");
const app = express();
const port = 3000;
const bodyParser = require("body-parser");

app.use(bodyParser.urlencoded({ extended: false }));
app.use(bodyParser.json());

const indexRouter = require("./routes/index");
const usersRouter = require("./routes/users");

app.use("/", indexRouter);
app.use("/users", usersRouter);

app.listen(port, () => {
  console.log(`App listening at http://localhost:${port}`);
});