j SrSSKJr SSKrSSKrSSKrSSKJr \"\5R5Rr \"\RRS5=(d \ S- 5rSrS Sjr\S :Xa\R$"\"55 gg) u ERGON F8 migration - Tabla `documentos` + indices. Schema del prompt Sesion F §4.2: documentos (id, obra_id FK, categoria enum(8), titulo, tags CSV, blob_path, mime_type, size_bytes, sha256, fecha_doc, subido_por, notas, created_at) idx_docs_obra_cat (obra_id, categoria) idx_docs_sha (sha256) Idempotente: CREATE TABLE IF NOT EXISTS + chequeo por pragma. Se puede re-correr multiples veces sin efectos secundarios. Uso: python db/migrate_f8.py ) annotationsN)Path DATABASE_PATHzergon.dbaO CREATE TABLE IF NOT EXISTS documentos ( id INTEGER PRIMARY KEY AUTOINCREMENT, obra_id INTEGER NOT NULL REFERENCES obras(id) ON DELETE CASCADE, categoria TEXT NOT NULL CHECK (categoria IN ('plano','contrato','certificado','acta', 'orden_pago','informe','foto','garantia')), titulo TEXT NOT NULL, tags TEXT, blob_path TEXT NOT NULL, mime_type TEXT NOT NULL, size_bytes INTEGER NOT NULL CHECK (size_bytes >= 0), sha256 TEXT NOT NULL, fecha_doc TEXT, subido_por TEXT, notas TEXT, created_at TEXT NOT NULL DEFAULT (datetime('now')) ); CREATE INDEX IF NOT EXISTS idx_docs_obra_cat ON documentos (obra_id, categoria); CREATE INDEX IF NOT EXISTS idx_docs_sha ON documentos (sha256); c[R5(d8[S[3[RS9 [S[RS9 g[ R "[[55nUR[5 UR5 URS5nUR5(d*[S[RS9 UR5 gURS5R5SnURS 5R5n[S U55n[S US S R!U535 UR5 g![ R"a5n[SU3[RS9 SnAUR5 gSnAff=f!UR5 f=f)Nz[ERROR] DB no existe: )filezCorra db/init_db.py primero.zGSELECT name FROM sqlite_master WHERE type='table' AND name='documentos'z#[ERROR] tabla documentos no se creozSELECT COUNT(*) FROM documentosrzKSELECT name FROM sqlite_master WHERE type='index' AND tbl_name='documentos'c3`# UH$oSRS5(aMUSv M& g7f)rsqlite_N) startswith).0rs /app/db/migrate_f8.py main..Fs#TA19S41Q4s. .z$ [migrate_f8] OK tabla documentos (z filas). Indices: z, z[ERROR] migration fallo: )DB_PATHexistsprintsysstderrsqlite3connectstr executescript MIGRATION_SQLcommitexecutefetchoneclosefetchallsortedjoinError)conncurcntidx_rows idx_nameses rmainr)2sf >>   &wi0szzB ,3::> ??3w< (D =) ll U ||~~ 7cjj I ll<=FFHK<< Y (* TTT  4SE:))I./1 2 == )!-CJJ?  s26A#E0+A3E00F9F4F<4F99F<<G__main__)returnint)__doc__ __future__rosrrpathlibr__file__resolveparentHEREenvirongetrrr)__name__exitrr;s} #   H~&& rzz~~o.E4*3D F .> zHHTVr: