index.js

const express = require("express");
const { Pool } = require("pg");
const bodyParser = require("body-parser");
const { v4: uuidv4 } = require("uuid");

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

const pool = new Pool({
  user: "your_db_user",
  host: "localhost",
  database: "volunteer_db",
  password: "your_db_password",
  port: 5432,
});

// GET /api/volunteers - List Volunteers
app.get("/api/volunteers", async (req, res) => {
  try {
    const result = await pool.query("SELECT * FROM volunteers");
    res.status(200).json(result.rows);
  } catch (err) {
    res.status(500).send("Server Error");
  }
});

// POST /api/volunteers - Create a New Volunteer
app.post("/api/volunteers", async (req, res) => {
  const {
    first_name,
    last_name,
    email,
    phone_number,
    date_of_birth,
    address,
    skills,
    availability,
    background_check,
  } = req.body;

  const volunteer_id = uuidv4();
  const date_joined = new Date();

  try {
    const result = await pool.query(
      "INSERT INTO volunteers (volunteer_id, first_name, last_name, email, phone_number, date_of_birth, address, skills, availability, date_joined, background_check) VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11) RETURNING *",
      [
        volunteer_id,
        first_name,
        last_name,
        email,
        phone_number,
        date_of_birth,
        address,
        skills,
        availability,
        date_joined,
        background_check,
      ]
    );
    res.status(201).json(result.rows[0]);
  } catch (err) {
    res.status(500).send("Server Error");
  }
});

// GET /api/volunteers/:volunteerId - Get Volunteer Details
app.get("/api/volunteers/:volunteerId", async (req, res) => {
  const { volunteerId } = req.params;
  try {
    const result = await pool.query(
      "SELECT * FROM volunteers WHERE volunteer_id = $1",
      [volunteerId]
    );
    if (result.rows.length === 0) {
      return res.status(404).send("Volunteer not found");
    }
    res.status(200).json(result.rows[0]);
  } catch (err) {
    res.status(500).send("Server Error");
  }
});

// PUT /api/volunteers/:volunteerId - Update Volunteer Information
app.put("/api/volunteers/:volunteerId", async (req, res) => {
  const { volunteerId } = req.params;
  const {
    first_name,
    last_name,
    email,
    phone_number,
    date_of_birth,
    address,
    skills,
    availability,
    background_check,
  } = req.body;

  try {
    const result = await pool.query(
      "UPDATE volunteers SET first_name = $1, last_name = $2, email = $3, phone_number = $4, date_of_birth = $5, address = $6, skills = $7, availability = $8, background_check = $9 WHERE volunteer_id = $10 RETURNING *",
      [
        first_name,
        last_name,
        email,
        phone_number,
        date_of_birth,
        address,
        skills,
        availability,
        background_check,
        volunteerId,
      ]
    );
    if (result.rows.length === 0) {
      return res.status(404).send("Volunteer not found");
    }
    res.status(200).json(result.rows[0]);
  } catch (err) {
    res.status(500).send("Server Error");
  }
});

// DELETE /api/volunteers/:volunteerId - Delete a Volunteer
app.delete("/api/volunteers/:volunteerId", async (req, res) => {
  const { volunteerId } = req.params;
  try {
    const result = await pool.query(
      "DELETE FROM volunteers WHERE volunteer_id = $1 RETURNING *",
      [volunteerId]
    );
    if (result.rows.length === 0) {
      return res.status(404).send("Volunteer not found");
    }
    res.status(200).send("Volunteer deleted");
  } catch (err) {
    res.status(500).send("Server Error");
  }
});

// Additional Routes
// GET /api/volunteers/:volunteerId/skills
app.get("/api/volunteers/:volunteerId/skills", async (req, res) => {
  const { volunteerId } = req.params;
  try {
    const result = await pool.query(
      "SELECT skills FROM volunteers WHERE volunteer_id = $1",
      [volunteerId]
    );
    if (result.rows.length === 0) {
      return res.status(404).send("Volunteer not found");
    }
    res.status(200).json(result.rows[0].skills);
  } catch (err) {
    res.status(500).send("Server Error");
  }
});

// POST /api/volunteers/:volunteerId/skills - Add new skills
app.post("/api/volunteers/:volunteerId/skills", async (req, res) => {
  const { volunteerId } = req.params;
  const { newSkills } = req.body; // Expecting an array of new skills
  try {
    const result = await pool.query(
      "UPDATE volunteers SET skills = array_cat(skills, $1) WHERE volunteer_id = $2 RETURNING *",
      [newSkills, volunteerId]
    );
    if (result.rows.length === 0) {
      return res.status(404).send("Volunteer not found");
    }
    res.status(200).json(result.rows[0].skills);
  } catch (err) {
    res.status(500).send("Server Error");
  }
});

// DELETE /api/volunteers/:volunteerId/skills/:skillId - Remove a skill
app.delete("/api/volunteers/:volunteerId/skills/:skillId", async (req, res) => {
  const { volunteerId, skillId } = req.params;
  try {
    const result = await pool.query(
      "UPDATE volunteers SET skills = array_remove(skills, $1) WHERE volunteer_id = $2 RETURNING *",
      [skillId, volunteerId]
    );
    if (result.rows.length === 0) {
      return res.status(404).send("Volunteer not found");
    }
    res.status(200).json(result.rows[0].skills);
  } catch (err) {
    res.status(500).send("Server Error");
  }
});

// Start the server
app.listen(3000, () => {
  console.log("Server is running on port 3000");
});