Skip to main content

Workflow Database Testing

Summary​

The Workflow smoke script exercises persistence through the running API, including migration/seed expectations and canonical/operational records. No mapping, migration, repository or isolated database test project was found.

Testing architecture​

Implemented coverage​

The smoke path verifies that core authoring/execution records and operational feeds can be persisted and read in an integrated environment.

Missing coverage​

No isolated tests validate mappings, migration up/down, foreign keys, indexes, tenant filters, administrative bypass, concurrency, outbox filter gaps, seed idempotency or retention.

Recommended work includes model/migration consistency, repository queries, tenant matrices, concurrent decisions and outbox lifecycle tests. These are recommendations only.

Requires Confirmation​

CI database provisioning, migration-test ownership, isolation strategy and acceptance thresholds require confirmation.

Source References​

  • microservices/scripts/smoke-workflow.ps1
  • microservices/scripts/run-v1-regression.ps1
  • microservices/src/workflow-service/Infrastructure/Migrations/20260706165438_InitialWorkflowSchema.cs

See Also​

Keywords​

Workflow database, EF Core, Workflow schema.

Revision Information​

  • Status: Draft
  • Last reviewed: 2026-07-20
  • Next review: 2026-10-20