target-revenue/migrations
tegwick de308f8947 Complete WP-0015: forgejo_hubs migration + closeout (T05/T07)
migrations/0007_forgejo_hubs.sql: table forgejo_hubs, auto-populated
via a BEFORE INSERT trigger on phase_manifests that reads repo_hub/
repo_hub_uri straight out of the manifest JSONB (no top-level columns
needed). ON CONFLICT DO NOTHING -- a hub already seen is left alone;
correcting a URI is a SECURITY DEFINER governance action
(correct_forgejo_hub_uri), not a plain UPDATE, matching every other
governance-action pattern in this project. Thin Python wrappers added
to registry.py.

tests/test_forgejo_hubs.py (6 Docker-gated tests) and
tests/test_reference_docs.py (13 tests, no Docker needed -- smoke-tests
every real specs/policies/specs/profiles/ file, not just the two
exercised incidentally by T03's Control Plane tests).

All seven WP-0015 tasks done; workplan marked finished. Final suite:
94 passing offline, 183 passing under the service extras venv. No
stray Docker containers left running.

Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com>
2026-08-03 23:57:46 +02:00
..
0001_registries.sql Implement hosted Phase/Extension Registry (WP-0006-T03) 2026-07-29 21:03:52 +02:00
0002_ledger.sql Implement hosted Target Ledger append API (WP-0006-T04) 2026-07-29 21:34:27 +02:00
0003_attestations.sql Implement hosted Conversion Attestation publication (WP-0006-T06) 2026-07-29 21:50:02 +02:00
0004_breach_records.sql Implement hosted Breach/Compliance Record publication (WP-0006-T09) 2026-07-29 22:23:41 +02:00
0005_licensor_credentials.sql Extend WP-0006 auth for per-human sub-credentials (WP-0009-T02) 2026-07-30 14:26:33 +02:00
0006_control_plane.sql Implement Control Plane backend: rights enforcement + audit log (WP-0009-T03) 2026-07-30 15:08:59 +02:00
0007_forgejo_hubs.sql Complete WP-0015: forgejo_hubs migration + closeout (T05/T07) 2026-08-03 23:57:46 +02:00