Ultimate Guillotine

Ultimate Guillotine is the shared home for the fantasy football league website, authoritative rules and contracts, historical records, private league-member data, automation agents, and maintenance scripts.

Workspace layout

apps/web/                  React and Vite website
agents/                    Agent prompts and shared league rules
packages/league-automation/ Python automation, League Agent, and CLI
hermes/guillotine-league/   Isolated League Agent profile
data/private/              Local-only member and contact data
docs/contracts/            Contract reference documents
docs/rules/                Authoritative league rules
history/contracts/         Historical contract workbooks by season
history/league/            Sanitized league history
scripts/                   Imports and future scheduled operations

The League Agent answers league questions through read-only tools. Setup, authentication, dry-run commands, and the self-test promotion gates are in the Mac mini runbook. Live acceptance remains incomplete; offline checks do not enable the listener.

Website

Install dependencies and run the existing site from the repository root:

pnpm install
pnpm dev

Production and static checks:

pnpm build
pnpm lint

The root commands delegate to the @ultimate-guillotine/web workspace in apps/web.

League records

The tracked workbook at history/league/ultimate-guillotine-records.xlsx contains the non-private historical sheets. The old 2022 registration sheet is deliberately excluded because it contains member contact and registration information.

To regenerate both outputs from an original workbook:

python3 -m pip install -r scripts/requirements.txt
python3 scripts/import_league_records.py \
  "/path/to/Ultimate Guillotine Records.xlsx" \
  --sanitized-output history/league/ultimate-guillotine-records.xlsx \
  --private-output data/private/league-members.json

Run the automated importer tests and privacy check:

pnpm test:records
pnpm check:records

Privacy

data/private/league-members.json contains real names, contact information, payment status, and registration responses. It is ignored by Git and must never be copied into public website assets, committed prompts, fixtures, logs, or generated recaps.

Use data/private/league-members.example.json for development that does not need real league data.

2026 dues tracker

Launch the private commissioner dues page:

pnpm dues

The tracker opens at http://127.0.0.1:8765, shows the latest roster, and saves Venmo handles, paid status, timestamps, and notes to ignored data/private/dues-2026.json. It is available only on the local Mac unless you deliberately build a separate authenticated remote-access layer.

League automation

The packages/league-automation workspace contains Python agents and automation scripts for the Ultimate Guillotine league.

Local database setup

Start Docker Desktop and the local Supabase stack:

open -a Docker
supabase start

Reset the database and run database tests:

supabase db reset
supabase test db

Repository tests (via pnpm test:agents) read the TEST_DATABASE_URL environment variable to connect to the local database. Tests are skipped when the environment variable is unset. Project credentials (API keys, database passwords) live outside Git in the local .env file or environment variables.

Run pnpm test:agents for the Python test suite and pnpm lint:agents for lint checks.

Mac mini install

See docs/runbooks/mac-mini.md for the full installation runbook: hosted Supabase, BlueBubbles Server, the launchd listener, and the Hermes gateway.

Automation direction

The always-on Mac mini can eventually run scripts and agents for weekly recaps, daily league monitoring, and approved message delivery. Each external integration should begin in dry-run mode, keep secrets outside Git, and separate content generation from the action that sends a message.