Sprint 1: Project Bootstrap

lmiranda commented

2026-01-11 18:45:57 +00:00

Owner

Sprint 1 Deliverables

Bootstrap

Git repository initialized with 3-branch structure
pyproject.toml with all dependencies from tech stack
.env.example with all required environment variables
Makefile with all standard targets
CLAUDE.md generated from PROJECT_REFERENCE.md
.gitignore (comprehensive)
.python-version (3.11)
.pre-commit-config.yaml (ruff, mypy)

Infrastructure

docker-compose.yml (PostgreSQL 16 + PostGIS)
scripts/ directory structure:
- scripts/db/ - Database scripts
- scripts/docker/ - Docker helpers
- scripts/deploy/ - Deployment scripts
- scripts/dbt/ - dbt runners
- scripts/dev/ - Development utilities

App Foundation

portfolio_app/ directory structure:
- portfolio_app/__init__.py
- portfolio_app/app.py (stub)
- portfolio_app/config.py (stub)
- portfolio_app/assets/
- portfolio_app/pages/
- portfolio_app/pages/toronto/callbacks/
- portfolio_app/components/
- portfolio_app/figures/
- portfolio_app/toronto/parsers/
- portfolio_app/toronto/loaders/
- portfolio_app/toronto/schemas/
- portfolio_app/toronto/models/
- portfolio_app/errors/

Tests

tests/ directory
tests/conftest.py stub
pytest configuration in pyproject.toml

Data Structure

data/toronto/raw/
data/toronto/processed/ (gitignored)
data/toronto/reference/

dbt Structure

dbt/models/staging/
dbt/models/intermediate/
dbt/models/marts/
dbt/tests/
dbt/macros/

Human Tasks (Cannot Automate)

Download TRREB PDFs
START boundary digitization in QGIS (3-4 hours)

Acceptance Criteria

All directories created with appropriate .gitkeep files
All config files valid and syntactically correct
make setup runs without error
make docker-up starts PostgreSQL + PostGIS
Pre-commit hooks install successfully

## Sprint 1 Deliverables ### Bootstrap - [x] Git repository initialized with 3-branch structure - [x] `pyproject.toml` with all dependencies from tech stack - [x] `.env.example` with all required environment variables - [x] `Makefile` with all standard targets - [x] `CLAUDE.md` generated from PROJECT_REFERENCE.md - [x] `.gitignore` (comprehensive) - [x] `.python-version` (3.11) - [x] `.pre-commit-config.yaml` (ruff, mypy) ### Infrastructure - [x] `docker-compose.yml` (PostgreSQL 16 + PostGIS) - [x] `scripts/` directory structure: - `scripts/db/` - Database scripts - `scripts/docker/` - Docker helpers - `scripts/deploy/` - Deployment scripts - `scripts/dbt/` - dbt runners - `scripts/dev/` - Development utilities ### App Foundation - [x] `portfolio_app/` directory structure: - `portfolio_app/__init__.py` - `portfolio_app/app.py` (stub) - `portfolio_app/config.py` (stub) - `portfolio_app/assets/` - `portfolio_app/pages/` - `portfolio_app/pages/toronto/callbacks/` - `portfolio_app/components/` - `portfolio_app/figures/` - `portfolio_app/toronto/parsers/` - `portfolio_app/toronto/loaders/` - `portfolio_app/toronto/schemas/` - `portfolio_app/toronto/models/` - `portfolio_app/errors/` ### Tests - [x] `tests/` directory - [x] `tests/conftest.py` stub - [x] pytest configuration in pyproject.toml ### Data Structure - [x] `data/toronto/raw/` - [x] `data/toronto/processed/` (gitignored) - [x] `data/toronto/reference/` ### dbt Structure - [x] `dbt/models/staging/` - [x] `dbt/models/intermediate/` - [x] `dbt/models/marts/` - [x] `dbt/tests/` - [x] `dbt/macros/` ### Human Tasks (Cannot Automate) - [x] Download TRREB PDFs - [x] START boundary digitization in QGIS (3-4 hours) --- ## Acceptance Criteria - All directories created with appropriate `.gitkeep` files - All config files valid and syntactically correct - `make setup` runs without error - `make docker-up` starts PostgreSQL + PostGIS - Pre-commit hooks install successfully