README

Prerequisites

• Java: not required locally (runs inside Docker)
• Docker: installed and running — Get Docker

---

Setup Instructions

1. Create a .env file in the project root with:

DB_NAME=fecamp19_db
DB_USERNAME=fecamp19
DB_PASSWORD=fecamp19
DB_URL=jdbc:postgresql://db-fecamp:5432/fecamp19_db

2. Build and start all services

docker build --platform linux/amd64 -t fecamp-backend:latest .
docker compose up -d

3. Create the S3 bucket (LocalStack)

docker compose exec s3-local awslocal s3 mb s3://fecamp-bucket

4. Seed mock data (after the first run — Hibernate auto-creates the tables on startup)

docker compose exec db-fecamp psql -U fecamp19 -d fecamp19_db < SeedSQL/site_phase.sql
docker compose exec db-fecamp psql -U fecamp19 -d fecamp19_db < SeedSQL/dump_data.sql

5. Test the API

Open http://localhost:8000/api/... in Postman or any API client.

---

Seed Data

File	Description
SeedSQL/site_phase.sql	Seeds site phases: Closed, Pretest, Camp, Posttest, Certificate, Archived
SeedSQL/dump_data.sql	Full mock data dump — truncates and re-inserts all tables

dump_data.sql uses TRUNCATE ... CASCADE so re-running it will wipe and reload all data.

---

Questions? Contact Pao #2 CP