server.js

import express from "express";
import bodyParser from "body-parser";
import mysql from "mysql2";
import cors from "cors";
import dotenv from "dotenv";
import path from "path";
import { fileURLToPath } from "url";
dotenv.config();

const __filename = fileURLToPath(import.meta.url);

const __dirname = path.dirname(__filename);

const app = express();
app.use(cors());
app.use(bodyParser.json());

app.use(express.static(path.join(__dirname, "public")));

const db = mysql.createConnection({
  host: process.env.DB_HOST,
  user: process.env.DB_USER,
  password: process.env.DB_PASSWORD,
  database: process.env.DB_DATABASE,
});

db.connect((err) => {
  if (err) throw err;
  console.log("Connected to MySQL database");
});

app.get("/events", (req, res) => {
  db.query("SELECT * FROM events", (err, results) => {
    if (err) throw err;
    res.send(results);
  });
});

app.post("/events", (req, res) => {
  console.log("Received POST request on /events");
  console.log("Received data:", req.body);

  const { title, start, end } = req.body;
  db.query(
    "INSERT INTO events (title, start, end) VALUES (?, ?, ?)",
    [title, start, end],
    (err, result) => {
      if (err) throw err;
      console.log("Event added with ID:", result.insertId);
      res.send({ id: result.insertId });
    }
  );
});

app.put("/events/:id", (req, res) => {
  const { id } = req.params;
  const { start, end } = req.body;
  db.query(
    "UPDATE events SET start = ?, end = ? WHERE id = ?",
    [start, end, id],
    (err, result) => {
      if (err) throw err;
      res.sendStatus(200);
    }
  );
});

app.delete("/events/:id", (req, res) => {
  const { id } = req.params;
  db.query("DELETE FROM events WHERE id = ?", [id], (err, result) => {
    if (err) throw err;
    res.sendStatus(200);
  });
});

const PORT = process.env.PORT || 3000;
app.listen(PORT, () => {
  console.log(`Server running on port ${PORT}`);
});