Handoff: API Arjan Phase 6

Status: IN PROGRESS

Goal

Phase 6 cross-cutting concerns:

• 6.1 Structured logging + request ID middleware (loguru)
• 6.2 DB-backed UIGen guest token store
• 6.3 slowapi documentation comment

Steps Completed

• [ ] 6.1.1 Add loguru to requirements.txt
• [ ] 6.1.2 Implement api/core/logging.py
• [ ] 6.1.3 Create api/core/middleware.py
• [ ] 6.1.4 Update api/main.py to use logging + middleware
• [ ] 6.2.1 Create Alembic migration 0006_uigen_tokens_table.py
• [ ] 6.2.2 Add UigenToken ORM model to api/db/models.py
• [ ] 6.2.3 Create api/services/uigen_tokens.py
• [ ] 6.2.4 Refactor api/routers/uigen.py to use DB service
• [ ] 6.2.5 Update tests to work with DB-backed tokens
• [ ] 6.3 Add slowapi comment to api/core/limiter.py
• [ ] Run tests
• [ ] Commit on refactor/api-arjan-phase6

Key Notes

• Worktree: C:\Users\srely\Repos\portfolio.claude\worktrees\agent-aa9d0500f57a54caf
• Last migration: 0005_project_phases_table.py (revision 0005)
• Next migration: 0006_uigen_tokens_table.py
• Tests heavily reference _guest_tokens dict directly — must update tests when refactoring uigen.py
• The in-memory dict approach is preserved for no-DB environments (when db is None)
• Settings has no "environment" field — use database_url presence or add env field