ProofedMesh/db/trust/migrations
CTO (Paperclip) 0ae29ae342
Some checks failed
validate / Rego (opa fmt + opa test) (push) Successful in 16s
validate / JSON Schema (ajv) (push) Successful in 20s
build-images / signing-service image (push) Successful in 24s
validate / DB (migrate up/down dry-run) (push) Failing after 26s
validate / Go (vet + test) (push) Successful in 1m16s
verification-service: Phase-1 two-stage chain verifier (approval -> transform) (DEV-612)
Adds services/verification-service exposing POST /api/v1/verify/chain
for sink:dummy-sink. The handler runs the six hard-coded chain checks
described in DEV-612 and reserves decision_id in a new
`verification_decisions` table so a replayed sink delivery is refused
without recomputing signatures.

- DSSE signature verification against configurable approval + transform
  signer key_ids, loaded from VERIFICATION_SIGNER_KEYS (pem/hex/b64/b64u)
- RFC 6962 inclusion-proof verifier (shared leaf/node hashing with
  services/transparency-log/pkg/backend)
- Content binding: subject.digest.sha256 must match predicate.content_hash
  (approval) and request.payload_hash (transform)
- Hard-coded coverage of allowed_transformations / allowed_sinks /
  expires_at predicates (OPA deferred to Phase 2 per the subtask)
- Replay guard via new db/trust/migrations/0005_verification_decisions
  (in-memory store ships; Postgres skeleton mirrors sibling pattern)
- Dockerfile mirrors signing-service pattern (distroless static + nonroot)
- README documents endpoint, reason-code taxonomy, required predicate
  fields, and the Phase-2 non-scope

Tests: happy path + 7 negatives (bad signature, missing inclusion proof,
hash drift, sink not allowed, expired, replay, operation not allowed).

Co-Authored-By: Paperclip <noreply@paperclip.ing>
2026-10-25 20:35:35 +00:00
..
0001_per_diem_rates.down.sql db: add ADR-0004 (golang-migrate), db/ layout, 0001_per_diem_rates migration (up+down) with EXCLUDE constraint and immutability trigger 2026-10-25 17:28:00 +00:00
0001_per_diem_rates.up.sql db: add ADR-0004 (golang-migrate), db/ layout, 0001_per_diem_rates migration (up+down) with EXCLUDE constraint and immutability trigger 2026-10-25 17:28:00 +00:00
0002_agents.down.sql db+ci: Agent Registry schema (agents + agent_keys), Phase-1 seed, migrate up/down CI (DEV-607) 2026-10-25 19:23:20 +00:00
0002_agents.up.sql db+ci: Agent Registry schema (agents + agent_keys), Phase-1 seed, migrate up/down CI (DEV-607) 2026-10-25 19:23:20 +00:00
0003_agent_keys.down.sql db+ci: Agent Registry schema (agents + agent_keys), Phase-1 seed, migrate up/down CI (DEV-607) 2026-10-25 19:23:20 +00:00
0003_agent_keys.up.sql db+ci: Agent Registry schema (agents + agent_keys), Phase-1 seed, migrate up/down CI (DEV-607) 2026-10-25 19:23:20 +00:00
0004_approval_sessions.down.sql approval-service: Phase-1 content-binding approval service (DEV-608) 2026-10-25 19:42:06 +00:00
0004_approval_sessions.up.sql approval-service: Phase-1 content-binding approval service (DEV-608) 2026-10-25 19:42:06 +00:00
0005_verification_decisions.down.sql verification-service: Phase-1 two-stage chain verifier (approval -> transform) (DEV-612) 2026-10-25 20:35:35 +00:00
0005_verification_decisions.up.sql verification-service: Phase-1 two-stage chain verifier (approval -> transform) (DEV-612) 2026-10-25 20:35:35 +00:00