j` ddlZddlZejdZhdZhdZhdZejeZejd ejdejdDchc]}|d c}Z gd Z e D]!\Z Z e e vs ejd e d e #ejd ejd ejdejdejdejddjdZedk7r edeejddejdjddk7redej#edejdjddejdjdej'ycc}w#ej'wxYw)N> BESTÄTIGTWIDERSPRÜCHLICHUNSICHER GESICHERT PLAUSIBEL>LEGACYPENDINGAPPROVEDREJECTED NEEDS_REVIEW>GOLDNONEREVOKED CANDIDATEzPRAGMA foreign_keys=ONzBEGIN IMMEDIATEz"PRAGMA table_info(knowledge_units)))source_locatorTEXT)evidence_classu~TEXT NOT NULL DEFAULT 'UNSICHER' CHECK(evidence_class IN ('UNSICHER','PLAUSIBEL','BESTÄTIGT','GESICHERT','WIDERSPRÜCHLICH')))confidence_reasonz@TEXT NOT NULL DEFAULT 'legacy_placeholder_not_quality_validated') review_statezpTEXT NOT NULL DEFAULT 'PENDING' CHECK(review_state IN ('PENDING','APPROVED','REJECTED','NEEDS_REVIEW','LEGACY'))) gold_statezWTEXT NOT NULL DEFAULT 'NONE' CHECK(gold_state IN ('NONE','CANDIDATE','GOLD','REVOKED')))legacy_placeholderz=INTEGER NOT NULL DEFAULT 0 CHECK(legacy_placeholder IN (0,1))z'ALTER TABLE knowledge_units ADD COLUMN  aCREATE TABLE IF NOT EXISTS knowledge_unit_provenance( id INTEGER PRIMARY KEY, knowledge_unit_id INTEGER NOT NULL REFERENCES knowledge_units(id) ON DELETE RESTRICT, source_identity TEXT NOT NULL, source_version TEXT NOT NULL, source_locator TEXT NOT NULL, representation_type TEXT NOT NULL, created_at TEXT NOT NULL, UNIQUE(knowledge_unit_id,source_identity,source_version,source_locator) )acCREATE TABLE IF NOT EXISTS knowledge_unit_review_audit( id INTEGER PRIMARY KEY, knowledge_unit_id INTEGER NOT NULL UNIQUE REFERENCES knowledge_units(id) ON DELETE RESTRICT, verdict TEXT NOT NULL CHECK(verdict IN ('PASS','TEILWEISE','FAIL')), reason TEXT NOT NULL, reviewer TEXT NOT NULL, reviewed_at TEXT NOT NULL )zjCREATE INDEX IF NOT EXISTS idx_ku_prov_source ON knowledge_unit_provenance(source_identity,source_version)zOCREATE INDEX IF NOT EXISTS idx_ku_review_state ON knowledge_units(review_state)zKCREATE INDEX IF NOT EXISTS idx_ku_gold_state ON knowledge_units(gold_state)z;SELECT count(*) FROM knowledge_units WHERE statement LIKE ?)zKnowledge unit from %z-expected exact 17 legacy placeholders, found zUPDATE knowledge_units SET review_state='REJECTED',gold_state='NONE',legacy_placeholder=1,confidence_reason='historical_placeholder_not_quality_validated' WHERE statement LIKE ?z?SELECT count(*) FROM knowledge_units WHERE legacy_placeholder=1zlegacy marker count mismatch migration_okz$SELECT count(*) FROM knowledge_unitslegacy)sqlite3sysargvDBVALID_EVALID_RVALID_Gconnectcexecutecols additionsnamedeclfetchoneph RuntimeErrorcommitprintclose)rs0#/opt/struktur/AA-043-P34-migrate.pyr3s88A;LA-'//"qyy!9:(II  "FG H1!A$ HDI` T t QYY)PQUPVVWX\W]'^_`II   II  IIz{II_`II[\yyNOijssuvwxB Rx|&STVSW$XYYIIBC]^yyRS\\^_`aeggo{}[p\j\HHJ .#IJSSUVWXYabcbkbkmncocxcxcz{|c}~ M IL s%$G, G8G D;GGG/