Backend Challenge Spring 2024

Blueprint Spring 2024 Backend Challenge

This challenge is an opportunity for you to showcase your skills, creativity, and understanding of backend technologies. This challenge was designed to simulate real-world problems that we had to solve in our previous NPO projects. 

Context and Challenge Overview

Backend systems are the backbone of any web application. As a backend developer, your task is to ensure that the server, application, and database communicate with each other safely and efficiently. The core of a successful backend is its ability to perform CRUD (Create, Read, Update, Delete) operations effectively, as these operations are fundamental to interacting with data stored in databases.

Challenge Details

Your task is to develop a CRUD application that adheres to the following specifications and requirements:

Application Overview

Purpose: Create a backend service that Creates, Reads, Updates, and Deletes volunteers from a database. Technology Stack: You are free to choose the technology stack (programming languages, database systems, frameworks) that you are most comfortable with.

CRUD Operations

Create: Implement functionality to add new records to your database. For example, adding a new volunteer. Read: Develop methods to retrieve and display records from the database. This could include listing all volunteers or searching for a specific user. Update: Allow for modifications to existing records, such as updating a volunteer's contact information. Delete: Provide a way to remove records from the database safely.

Volunteers Table

Field Name Data Type Description Example volunteer_id UUID / INT (PK) Unique identifier for each volunteer. 123e4567-e89b-12d3-a456-426614174000 first_name VARCHAR Volunteer's first name. John last_name VARCHAR Volunteer's last name. Doe email VARCHAR Volunteer's email address. john.doe@example.com phone_number VARCHAR Volunteer's phone number. +1234567890 date_of_birth DATE Volunteer's date of birth. 1990-01-01 address VARCHAR Volunteer's address. 123 Main St, Anytown, AS skills VARCHAR / ARRAY List of volunteer's skills. ["First Aid", "Counseling"] availability JSON / VARCHAR Volunteer's availability (could be structured as JSON). {"Monday": ["AM"], "Saturday": ["PM"]} date_joined DATE Date when the volunteer joined. 2024-03-21 background_check BOOLEAN Indicates if a background check has been completed. true / false

Volunteers

List Volunteers

GET /api/volunteers

Retrieves a list of all volunteers, with options for pagination, filtering, and sorting.

Create a New Volunteer

POST /api/volunteers

Creates a new volunteer record.

Get Volunteer Details

GET /api/volunteers/{volunteerId}

Retrieves detailed information about a specific volunteer.

Update Volunteer Information

PUT /api/volunteers/{volunteerId}

Updates an existing volunteer's information.

Delete a Volunteer

DELETE /api/volunteers/{volunteerId}

Deletes a specific volunteer's record.

Volunteer Skills (Optional)

List Skills for a Volunteer

GET /api/volunteers/{volunteerId}/skills

Lists the skills associated with a specific volunteer.

Add Skills to a Volunteer

POST /api/volunteers/{volunteerId}/skills

Adds new skills to a volunteer.

Remove a Skill from a Volunteer

DELETE /api/volunteers/{volunteerId}/skills/{skillId}

Removes a specific skill from a volunteer.

Event Participation (Optional)

List Events a Volunteer Participated In

GET /api/volunteers/{volunteerId}/events

Lists events that a specific volunteer has participated in.

Add Volunteer Participation to an Event

POST /api/events/{eventId}/volunteers/{volunteerId}

Records a volunteer's participation in a specific event.

Remove Volunteer Participation from an Event

DELETE /api/events/{eventId}/volunteers/{volunteerId}

Removes a record of a volunteer's participation in a specific event.