domverse/photoanalyzer
1
0
Fork 0
Code Issues 5 Pull Requests Actions Packages Projects 1 Releases Wiki Activity

US01-02 — Establish Application and Database Foundation #2

New Issue
Closed
opened 2026-07-13 13:10:36 +02:00 by domverse · 3 comments
domverse commented 2026-07-13 13:10:36 +02:00
Owner
Copy Link

Source specification: delivery_backlog/stories/US01-02-app-database-foundation.md

US01-02 — Establish Application and Database Foundation

Epic: E01

As an operator, I want the API, worker configuration, and database lifecycle to start
consistently so later services share one durable foundation.

Acceptance criteria

  • FastAPI factory, typed configuration, SQLAlchemy sessions, Alembic, WAL, foreign
    keys, structured logging, and readiness are configured.
  • Stable asset IDs, path occurrences, versions, and audit timestamps have migrations.
  • Secrets are referenced through configuration and never returned or logged.
  • Startup and shutdown leave no leaked worker or database resources.

Automated tests

  • Migrations pass from an empty database and supported legacy schema snapshots.
  • Process-level integration tests verify readiness, restart, WAL, foreign keys, and
    clean shutdown.

Dependencies

  • US01-01
Source specification: [delivery_backlog/stories/US01-02-app-database-foundation.md](https://git.domverse-berlin.eu/domverse/photoanalyzer/src/branch/main/delivery_backlog/stories/US01-02-app-database-foundation.md) # US01-02 — Establish Application and Database Foundation Epic: [E01](https://git.domverse-berlin.eu/domverse/photoanalyzer/src/branch/main/delivery_backlog/E01-shared-identity-inventory.md) As an operator, I want the API, worker configuration, and database lifecycle to start consistently so later services share one durable foundation. ## Acceptance criteria - FastAPI factory, typed configuration, SQLAlchemy sessions, Alembic, WAL, foreign keys, structured logging, and readiness are configured. - Stable asset IDs, path occurrences, versions, and audit timestamps have migrations. - Secrets are referenced through configuration and never returned or logged. - Startup and shutdown leave no leaked worker or database resources. ## Automated tests - Migrations pass from an empty database and supported legacy schema snapshots. - Process-level integration tests verify readiness, restart, WAL, foreign keys, and clean shutdown. ## Dependencies - US01-01
domverse added this to the E01 — Shared Identity and Inventory milestone 2026-07-13 13:10:36 +02:00
domverse added the type/featurearea/databasearea/backendpriority/normal labels 2026-07-13 13:10:36 +02:00
domverse added a new dependency 2026-07-13 13:11:14 +02:00
#1 US01-01 — Inventory and Characterize Donor Code
domverse added a new dependency 2026-07-13 13:11:14 +02:00
#3 US01-03 — Discover and Reconcile Stable Assets
domverse added a new dependency 2026-07-13 13:11:15 +02:00
#7 US01-07 — Automate Phase A End-to-End Acceptance
domverse added this to the Photo Analyzer Delivery project 2026-07-13 13:19:43 +02:00
domverse added the status/backlog label 2026-07-13 13:52:43 +02:00
domverse added status/in-progress and removed status/backlog labels 2026-07-15 16:16:30 +02:00
domverse self-assigned this 2026-07-15 16:16:30 +02:00
domverse commented 2026-07-15 16:16:31 +02:00
Author
Owner
Copy Link

Claimed for implementation on branch us/US01-02-establish-application-and-database-foundation.

Claimed for implementation on branch `us/US01-02-establish-application-and-database-foundation`.
domverse added status/review and removed status/in-progress labels 2026-07-15 16:30:31 +02:00
domverse commented 2026-07-15 16:30:32 +02:00
Author
Owner
Copy Link

Submitted for review: #47

Tests passed:

  • work_item/scripts/python -m unittest discover -s work_item/tests -v
  • work_item/scripts/python -m pytest tests -q
  • work_item/scripts/python -m pytest tests/unit tests/integration -q
Submitted for review: https://git.domverse-berlin.eu/domverse/photoanalyzer/pulls/47 Tests passed: - `work_item/scripts/python -m unittest discover -s work_item/tests -v` - `work_item/scripts/python -m pytest tests -q` - `work_item/scripts/python -m pytest tests/unit tests/integration -q`
domverse added status/done and removed status/review labels 2026-07-15 16:33:28 +02:00
domverse commented 2026-07-15 16:33:29 +02:00
Author
Owner
Copy Link

Completed and merged via PR #47.

Completed and merged via PR #47.
domverse moved this to Done in Photo Analyzer Delivery on 2026-08-16 11:58:01 +02:00
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
area/backend
Backend services, jobs, or API
 area/database
Schema, persistence, migration, or queries
 area/filesystem
Filesystem identity, mutation, or storage
 area/frontend
Browser UI and client-side application
 area/integration
External tools or provider integrations
 area/testing
Automated test suites, fixtures, and tooling
 priority/critical
Release-blocking safety or correctness
 priority/high
Important phase outcome
 priority/normal
Normal planned work
 status/backlog
Awaiting dependency eligibility or prioritization
 status/blocked
Cannot proceed without an explicit resolution
 status/done
Merged, tested, and completed
 status/in-progress
Currently being implemented
 status/ready
Eligible to be claimed
 status/review
Submitted in a pull request for review
 type/feature
User-facing or domain capability
 type/hardening
Security, resilience, operations, or release hardening
 type/migration
Donor extraction, migration, or legacy consolidation
 type/test
Automated test infrastructure or acceptance coverage
No Label area/backend area/database priority/normal status/done type/feature
Milestone
No items
No Milestone E01 — Shared Identity and Inventory
Projects
Clear projects
No project Photo Analyzer Delivery
Assignees
Clear assignees
domverse
No Assignees domverse
1 Participants
Notifications
Due Date
No due date set.
Blocks
#3 US01-03 — Discover and Reconcile Stable Assets
domverse/photoanalyzer
#7 US01-07 — Automate Phase A End-to-End Acceptance
domverse/photoanalyzer
Depends on
#1 US01-01 — Inventory and Characterize Donor Code
domverse/photoanalyzer
Reference: domverse/photoanalyzer#2
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?