UnifestBestellBot

Telegram bot for stalls at the Karlsruhe Unifest to order supplies (change money, cups, beer, cocktail materials, helpers, ...). Includes a small live dashboard for the orga groups handling tickets.

Stack

• aiogram v3 (async Telegram bot)
• SQLModel + SQLite (single file, create_all at startup, no migrations)
• FastAPI + SSE for the dashboard (no MQTT broker)
• uv for dependency management

Quick start

# 1. Install uv
curl -LsSf https://astral.sh/uv/install.sh | sh

# 2. Install dependencies
uv sync

# 3. Configure secrets
cp .env.example .env        # then edit
cp config.yaml.example config.yaml   # then edit for the year's structure

# 4. Run
uv run unifestbestellbot

The bot polls Telegram and serves the dashboard at http://0.0.0.0:8000. Open http://<host>:8000/?group=Finanz (or ?group=BiMi, etc.) on a TV to see live tickets for one orga group.

Tests

uv run pytest
uv run ruff check

136 tests covering: config validation, repo CRUD + audit, the /register flow, the full /request FSM end-to-end per category, all orga commands + inline pickers, Engelsystem summary rendering, dashboard endpoints, and the event bus.

Documentation

• docs/REWRITE_PLAN.md — the architecture and why each decision was made
• docs/IMPLEMENTATION.md — detailed module layout, schemas, and code sketches
• docs/OPERATIONS.md — deploy, backup, restore, common fixes
• docs/MIGRATION.md — observable behaviour and config differences vs. the legacy bot