ajX ddlZddlZddlmZmZddlmZdZdZejejjeedZ ejeZ ejeZee j!dj#e d<ee j!d j#e d <e j!d j%de d <e j!d j%de d<ee j!dj#e d<eej!dj#e d<ej!dj%de d<ej!dj%de d<ej!dj%de d<de d<edj'ej(e dddzd d!d"e d#d!d$d!gZee dj-Dcgc]\}}d%|d&|d'c}}z Zegd(z Zed!d)d!d*e dd'd+e dd'd,e dd'gz Zed-j'dj/edzed.j'dj/edzeej(e ddycc}}w)/N)datetimetimezone)Pathz?/opt/struktur/obsidian-knowledge-pipeline/knowledge_pipeline.dbz//opt/struktur/knowledge-curator/review_pilot.db) generated_at pipeline_db review_dbz8select status,count(*) from review_items group by statuspipeline_statusz^select new_status,count(*) from audit where phase='backlog_classification' group by new_statuspipeline_audit_classificationsz?select count(*) from review_items where status='pending_review'pipeline_pendingz!select count(*) from review_itemspipeline_review_itemsz0select status,count(*) from jobs group by status pipeline_jobsz@select decision,count(*) from review_decisions group by decisionreview_decisionsz select count(*) from review_runs review_runszJselect count(*) from review_decisions where reviewer!='pipeline-optimizer'historical_human_decisionszIselect count(*) from review_decisions where reviewer='pipeline-optimizer'system_backlog_decisionsT no_auto_truthzC/opt/struktur/knowledge-curator/review-backlog-migration-final.jsonF) ensure_asciiindent u-# Review-Backlog-Migration – Abschlussauditz Erzeugt: rz ## Statusz- `z`: **z**)rz## Sicherheitsnachweisrz4- Keine Neo4j-Schreibung durch die Backlogmigration.z-- Keine Truth-Items erzeugt oder freigegeben.uD- Historische menschliche Reviewentscheidungen nicht überschrieben.z/- Systemklassifikationen append-only auditiert.z;- Sensible und unklare Kandidaten bleiben `pending_review`.z## Reviewdatenbankz,- Historische menschliche Entscheidungen: **z.- Automatische technische Klassifikationen: **u- Review-Läufe: **z\/opt/struktur/knowledge-curator/Knowledge-Pipeline-Review-Backlog-Optimization-2026-07-22.mdz_/opt/obsidian-vault/Systemstruktur/Knowledge-Pipeline-Review-Backlog-Optimization-2026-07-22.md)jsonsqlite3rrpathlibrPRnowutc isoformatoutconnectcrdictexecutefetchallfetchone write_textdumpsmditemsjoinprint)kvs006/opt/struktur/knowledge-curator/backlog_final_audit.pyr1s&CGxQ HLL.88:WXY'//!*aAII&`ajjlm&*1996V,W,`,`,b'c$% "cdmmopqrYY'JKTTVWXY!))$VW``bcOQYY'ijssuv99?@IIKANM"#)),x"y#C#C#EFG#H ! ! *u v  !BCD!EOJKVVWaW[WaWabesxABXCDHXHI3B3~CVBW7XY[\ghjkc*;&<&B&B&DEsqQCuQCrEEKKr %QRUVrRsQttv#w{ijmnHjIiJJLyMPcdghudvcwwyNz{{cdooptpypyz|p}CqCDfgrrsws|s|}tABFtFGjdjj%q12 FsK