Package ASI database schema, migrations, initial data and recovery procedure

Sub-tickets

Activity

• coder03-mba-l-ca created · 11h ago
  parent=#4648
• coder03-mba-l-ca descriptionChanged · 11h ago
  was: With db and ASI operations, distinguish first load from incremental migrations and decide whether a DEV dump is requested. The mirror strips source/docs migrations and normally includes a DEV dump. Deliver agreed schema/migration and data steps, prerequisites, ordering, backup, postchecks and rollback ownership. No import, restore or data modification in this item. Done after disposable rehearsal and ASI review.
• coder03-mba-l-ca descriptionChanged · 11h ago
  was: Prepare a database handoff for ASI only after MOVILBA-826 defines the target. Inventory existing ASI DB state against required target state; distinguish bootstrap from incremental change. Provide exact ordered schema/migrations and data steps, roles/grants/extensions, catalog ID fidelity linked to MOVILBA-797, approved data/PII scope and dump handling, named operator, backup, rehearsed restore/rollback and verification. Historical migration files are not assumed replayable. No import or PROD DB write is authorized by this BWI.
• coder03-mba-l-ca descriptionChanged · 11h ago
  was: Prepare a DB handoff only after MOVILBA-826 defines ASI's target. Inventory existing-state to target-state; distinguish bootstrap from incremental change. Provide exact ordered migration bundle and approved initial data, roles/grants/extensions, catalog ID fidelity linked to MOVILBA-797, data/PII and dump authorization, named operator, backup, rehearsed restore/rollback and postchecks. Do not default to a DEV dump or routine RUTAP import; historical migrations are not automatically replayable. This BWI authorizes no DB write.
• coder03-mba-l-ca assigned · 9h ago
  db04-mba-l-ca / db
• coder03-mba-l-ca statusChanged · 9h ago
  Read-only QA DB inventory started; exact migration selection awaits QA baseline, while conditional handoff can be prepared now.
• coder03-mba-l-ca progress · 9h ago
  db04 read-only finding 2026-10-16: QA route documented as permisos-movilba-qa.gcba.gob.ar, but /api/health was 503 and oc identity unauthorized from this lane. Accessible records contain no QA DATABASE_URL, DB name, schema inventory or migration ledger. April ASI email says DB already existed and DEV dump only if manual restore requested; not a standing QA dump request. Current DEV 5.6.253 has 70 tables, 90 views and app_period_closures. Candidate code may depend on applied 796 and 803 DB changes, but exact QA migration set requires read-only QA baseline; do not replay historical SQL blindly. Prepare source/SQL hashes, expected object/role/catalog signatures, conditional migration worksheet, backup/rollback and smoke checks now. No DB write/import/restore.
• coder03-mba-l-ca progress · 9h ago
  db04 finalized conditional QA DB handoff at /data-lezama/movilba/evidencia/MOVILBA-822/2026-10-16-conditional-qa-db-handoff.md SHA256 3b95e184c2437afb361779b8c7fd9aa2fd5c3c5df761839ff64c5d4a5c7a1739 (supersedes prior draft). Clarified April existing DB statement was ASI DEV only, not proof of current QA DB. No QA SQL selected until read-only QA baseline and named DB operator; no dump/tag push/deploy.
• audit-mba-l-ca audited · 9h ago
  audit pass: audit-mba-l-ca | 2026-10-16 ART. Docs-only at0512bc88: UPGRADE-QA1d017511 and QA-DB-HANDOFF32d78931 exact pins. Static content/reference review; no runtime/DB/build/deploy. Typecheck/tests NOT EXERCISED for docs. Conditional plan only, NOT TAG READY.
  payload

  {"scope":"audit-mba-l-ca | 2026-10-16 ART. Docs-only at0512bc88: UPGRADE-QA1d017511 and QA-DB-HANDOFF32d78931 exact pins. Static content/reference review; no runtime/DB/build/deploy. Typecheck/tests NOT EXERCISED for docs. Conditional plan only, NOT TAG READY.","outcome":"pass","evidence":"Root UPGRADE references delivered DB-HANDOFF; no Lezama-only path, secret value or personal record found. Names identify handoff owners. QA baseline/operator STOP, conditional no-migration versus QA-specific SQL, nonportable796/803, no dump/import presumption, Ricci deployment and QA assessment before HML/PRD are explicit. APP_ENV qa rejection matches committed0512bc88 origen-ingreso.ts, NOT newer uncommitted code (now adds qa); refresh this sentence if that code joins candidate. No baseline, SQL rehearsal, credential effectiveness, data authority or QA readiness certified. Both document hashes rechecked; diff check clean. PASS does not complete either item.","reportRef":null}

• audit-mba-l-ca audited · 9h ago
  audit pass: audit-mba-l-ca | 2026-10-16 ART. Final docs pair UPGRADE33ee3dae/DB-HANDOFF630e2f64, full hashes checked. Conditional QA operator-plan review only. No DB/runtime/build; typecheck/tests NOT EXERCISED docs-only. NOT TAG READY; not item completion.
  payload

  {"scope":"audit-mba-l-ca | 2026-10-16 ART. Final docs pair UPGRADE33ee3dae/DB-HANDOFF630e2f64, full hashes checked. Conditional QA operator-plan review only. No DB/runtime/build; typecheck/tests NOT EXERCISED docs-only. NOT TAG READY; not item completion.","outcome":"pass","evidence":"Reviewed both texts together: root DB-HANDOFF reference accessible by packaging contract; baseline/operator STOP;796/803 require QA-specific reviewed SQL, not historical replay; qa/app_qa and six-CHECK preflight; no assumed dump/import. Import/reconcile hard STOP explicitly preserves separate policy work: expanding CHECKs does not protect app history. Ricci owns deployment; QA assessment then HML/PRD. No secret values or Lezama-only reference found. Six validated PROD/DEV CHECK assertion is db04-reported, not independently measured here. Candidate code/docs integration and actual QA DB baseline remain release gates. Confirmed final pins supersede earlier document hashes.","reportRef":null}

• coder03-mba-l-ca commit · 9h ago
  Conditional QA DB handoff committed in source commit a20ca849dab2ded5e58f4521d66f4b64f4dee595. docs/asi/QA-DB-HANDOFF.md SHA256 630e2f64a2db4ad493a7f2d4464ebb4b64b280b7eec48d5f0f3a79809f62c3da; docs-only audit PASS. QA baseline and named DB operator remain missing; no QA SQL selected or applied.