drizzle-persistence-test

Writes the persistence layer tests of a use case (UC-XXX) for Drizzle repositories: Vitest integration tests against a real PostgreSQL in Testcontainers, test data from the use case's seed file, expected values from the specification and the test data, one describe('UC-XXX: …') per use case and one it per query behaviour. Tests only queries with logic of their own — filters, joins, projections, paging, optimistic locking, transactions that must roll back — not what the integration layer's tests already cover. /use-case-test runs it only to reconcile existing tests, for queries the integration layer cannot reach, or when the persistence layer is named; can be run directly. Use when the user asks to "test the Drizzle repository", "write repository tests for UC-001", "test this query against the database", or mentions Drizzle repository tests or Testcontainers tests of the data access in a project that combines layer plugins.