userHandlers.js

const database = require("./database.js");

// ---------------------------------------getUsers----------------------------------------

const getUsers = (req, res) => {
  database
    .query("select * from users")
    .then(([user]) => {
      res.json(user);
    })
    .catch((err) => {
      console.error(err);
      res.status(500).send("Error retrieving data from database");
    });
};

// ---------------------------------------PostUsers----------------------------------------

const postUser = (req, res) => {
  const { firstname, lastname, email, city, language } = req.body;

  database
    .query(
      "INSERT INTO users(firstname, lastname, email, city, language) VALUES (?, ?, ?, ?, ?)",
      [firstname, lastname, email, city, language]
    )
    .then(([result]) => {
      res.location(`/api/users/${result.insertId}`).sendStatus(201);
    })
    .catch((err) => {
      console.error(err);
      res.status(500).send("Error saving the user");
    });
};

// ---------------------------------------EXPORTS----------------------------------------

module.exports = {
  getUsers,
  postUser,
};