import express from "express";

const router = express.Router();

router.post("/", (req, res) => {

  const { user_id, stress_level, anxiety_level, title, description } = req.body;

  if (!user_id || !stress_level || !anxiety_level)

    return res.status(400).json({ error: "Campos faltantes" });

  const stmt = req.db.prepare(

    `

      INSERT INTO mood (user_id, stress_level, anxiety_level, title, description)

      VALUES (?, ?, ?, ?, ?)

    `

  );

  const result = stmt.run(

    user_id, stress_level, anxiety_level, title || null, description || null

  );

  res.status(201).json({ id: result.lastInsertRowid });

});

router.get("/:user_id", (req, res) => {

  const stmt = req.db.prepare("SELECT * FROM mood WHERE user_id = ?");

  const rows = stmt.all(req.params.user_id);

  res.json(rows);

});

export default router;