Benjamin_Boenisch/breakpilot-compliance
1
1
Fork 0
Code Issues 24 Pull Requests Actions Packages Projects Releases Wiki Activity

fix(db): dedupe doc_check_controls 3x + unique constraint #28

Closed
Benjamin_Boenisch wants to merge 0 commits from feat/dedup-doc-check-controls into main
pull from: feat/dedup-doc-check-controls
merge into: Benjamin_Boenisch:main
Conversation 0 Commits - Files Changed -
Benjamin_Boenisch commented 2026-06-20 13:03:45 +00:00
Owner
Copy Link
Copy Source

Codifies migration 158 (bereits auf prod + in _migration_history; idempotent). 5622->1874 + UNIQUE(doc_type,control_id). [migration-approved]

Codifies migration 158 (bereits auf prod + in _migration_history; idempotent). 5622->1874 + UNIQUE(doc_type,control_id). [migration-approved]
Benjamin_Boenisch added 1 commit 2026-06-20 13:03:46 +00:00
fix(db): dedupe doc_check_controls 3x + unique constraint
CI / detect-changes (pull_request) Failing after 5s
Details
CI / branch-name (pull_request) Successful in 1s
Details
CI / guardrail-integrity (pull_request) Failing after 2s
Details
CI / secret-scan (pull_request) Failing after 5s
Details
CI / dep-audit (pull_request) Failing after 12s
Details
CI / sbom-scan (pull_request) Failing after 3s
Details
CI / build-sha-integrity (pull_request) Failing after 3s
Details
CI / validate-canonical-controls (pull_request) Failing after 1s
Details
CI / loc-budget (pull_request) Has been skipped
Details
CI / go-lint (pull_request) Has been skipped
Details
CI / python-lint (pull_request) Has been skipped
Details
CI / nodejs-lint (pull_request) Has been skipped
Details
CI / nodejs-build (pull_request) Has been skipped
Details
CI / test-go (pull_request) Has been skipped
Details
CI / iace-gt-coverage (pull_request) Has been skipped
Details
CI / test-python-backend (pull_request) Has been skipped
Details
CI / test-python-document-crawler (pull_request) Has been skipped
Details
CI / test-python-dsms-gateway (pull_request) Has been skipped
Details
CI / detect-changes (push) Successful in 10s
Details
CI / branch-name (push) Has been skipped
Details
CI / secret-scan (push) Has been skipped
Details
CI / dep-audit (push) Has been skipped
Details
CI / guardrail-integrity (push) Has been skipped
Details
CI / sbom-scan (push) Has been skipped
Details
CI / build-sha-integrity (push) Successful in 8s
Details
CI / validate-canonical-controls (push) Successful in 6s
Details
CI / loc-budget (push) Successful in 19s
Details
CI / go-lint (push) Has been skipped
Details
CI / python-lint (push) Has been skipped
Details
CI / nodejs-lint (push) Has been skipped
Details
CI / nodejs-build (push) Has been skipped
Details
CI / test-go (push) Has been skipped
Details
CI / iace-gt-coverage (push) Has been skipped
Details
CI / test-python-backend (push) Successful in 25s
Details
CI / test-python-document-crawler (push) Has been skipped
Details
CI / test-python-dsms-gateway (push) Has been skipped
Details
76d1dc5e00 
compliance.doc_check_controls war auf prod historisch trippliziert
(Dump-Artefakt ohne PK/Unique: jede (doc_type, control_id)-Zeile 3x,
5622 statt 1874 ueber alle 8 doc_types). Die Migration dedupt idempotent
(kleinste ctid behalten) und setzt UNIQUE(doc_type, control_id), damit
sich die Triplikation nicht wiederholen kann.

Auf prod bereits direkt angewandt und in _migration_history registriert
(read-only verifiziert: 1874, alle doc_types total=distinct, Constraint
aktiv); dieser Commit codifiziert die Migration in der Deploy-Kette,
damit ein Restore aus einem aelteren Dump sie automatisch re-appliziert.

[migration-approved]

Co-Authored-By: Claude Opus 4.7 <noreply@anthropic.com>
Some checks are pending
CI / detect-changes (pull_request) Failing after 5s
Details
CI / branch-name (pull_request) Successful in 1s
Details
CI / guardrail-integrity (pull_request) Failing after 2s
Details
CI / secret-scan (pull_request) Failing after 5s
Details
CI / dep-audit (pull_request) Failing after 12s
Details
CI / sbom-scan (pull_request) Failing after 3s
Details
CI / build-sha-integrity (pull_request) Failing after 3s
Details
CI / validate-canonical-controls (pull_request) Failing after 1s
Details
CI / loc-budget (pull_request) Has been skipped
Details
CI / go-lint (pull_request) Has been skipped
Details
CI / python-lint (pull_request) Has been skipped
Details
CI / nodejs-lint (pull_request) Has been skipped
Details
CI / nodejs-build (pull_request) Has been skipped
Details
CI / test-go (pull_request) Has been skipped
Details
CI / iace-gt-coverage (pull_request) Has been skipped
Details
CI / test-python-backend (pull_request) Has been skipped
Details
CI / test-python-document-crawler (pull_request) Has been skipped
Details
CI / test-python-dsms-gateway (pull_request) Has been skipped
Details
CI / detect-changes (push) Successful in 10s
Details
CI / branch-name (push) Has been skipped
Details
CI / secret-scan (push) Has been skipped
Details
CI / dep-audit (push) Has been skipped
Details
CI / guardrail-integrity (push) Has been skipped
Details
CI / sbom-scan (push) Has been skipped
Details
CI / build-sha-integrity (push) Successful in 8s
Details
CI / validate-canonical-controls (push) Successful in 6s
Details
CI / loc-budget (push) Successful in 19s
Details
CI / go-lint (push) Has been skipped
Details
CI / python-lint (push) Has been skipped
Details
CI / nodejs-lint (push) Has been skipped
Details
CI / nodejs-build (push) Has been skipped
Details
CI / test-go (push) Has been skipped
Details
CI / iace-gt-coverage (push) Has been skipped
Details
CI / test-python-backend (push) Successful in 25s
Details
CI / test-python-document-crawler (push) Has been skipped
Details
CI / test-python-dsms-gateway (push) Has been skipped
Details

Pull request closed

Please reopen this pull request to perform a merge.
Sign in to join this conversation.
Reviewers
No Reviewers
Labels
Clear labels
config
Env vars, secrets management, startup validation
 data-integrity
Transactions, indexes, pagination
 frontend
Next.js, client-side concerns
 observability
Logging, audit trails, health checks
 reliability
Error handling, retries, circuit breakers
 security
Auth, secrets, injection, tenant isolation
 severity: critical
System-level risk, data breach or full outage
 severity: high
Significant risk, must fix before go-live
 severity: medium
Important but not blocking go-live
 testing
Test coverage, integration tests
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
sharang (Sharang Parnerkar) Benjamin_Boenisch
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: Benjamin_Boenisch/breakpilot-compliance#28
Delete Branch "feat/dedup-doc-check-controls"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?