Skip to content

Database governance built for humans and agents — controlling changes and access across every major database.

2.0 KB
Raw Blame

Backend integration tests

Public v1 API tests backed by real PostgreSQL live here. Cross-Project collision tests use setupCollidingProjects plus snapshotProject / assertProjectUnchanged from collision_helper_test.go (see docs/pre-pr-checklist.md step 3 for the full contract).

plan_webhook_delivery collision coverage

plan_webhook_delivery has no public gRPC read API, so collision coverage reads the table directly from the metadata DB. Two extra requirements apply to any test for a writer of this table:

  • Delivery rows are claimed asynchronously after rollout completion. Wait for the project's delivery row set to stabilize before taking the baseline snapshot, and again before the post-operation snapshot.
  • assertProjectUnchanged intentionally does NOT compare PlanWebhookDeliveries. The test must assert those rows separately with its own stabilized comparison.

TestCollision_PlanWebhookDeliveryWrite demonstrates both requirements. Without them, a raw-row snapshot that only calls assertProjectUnchanged produces false-positive coverage: a cross-project write to this composite-PK table would go undetected.

sheet_blob_ref collision coverage

sheet_blob_ref also has no public gRPC read API (sheets are content-addressed and nothing enumerates them), so the snapshot reads it directly from the metadata DB via listSheetBlobRefs. Unlike plan_webhook_delivery, refs are written synchronously on the create paths (CreateSheet, CreateRelease, task creation), so no stabilization wait is needed and assertProjectUnchanged compares the SheetBlobRefs field directly. TestCollision_SheetWrite is the dedicated writer test: identical content in two projects shares one blob while each project holds its own (project, sha256) ref row.

Sheet scoping always enforces: a project reads a sheet only when it holds a sheet_blob_ref for its hash. Every legitimate flow in the suite therefore proves it holds the refs it needs, and the cross-project tests assert real denials.