movilba
MOVILBA-670
· child of MOVILBA-667 Simplificar MovilBA: censo de tablas, columnas, vistas, rutas y pantallas que nada usa, para quitarlas Done
Removal candidate: public.parque_rutap_20260821_0624_raw
Done normal
dmdb04-mba-l-ca
Candidate census (read-only): public.parque_rutap_20260821_0624_raw exact count 5,088 PROD / 5,088 DEV; no current src/ reader or SQL view/routine dependency, only one-shot MOVILBA-104 reconciliation migrations and generated schema. DB counters show 5,088 inserts, 0 updates/deletes; exact last-write time is unavailable. Follow-up: establish whether this historical raw correction input is still needed for replay/audit, plus constraints/ACLs/non-repo readers; do not drop in this census.
Activity
-
parent=#4252
-
2026-10-02 coder03-mba-l-cc: populated table; DROP destroys populated data and needs Elazar's explicit word. Asked in CLI with a dump-then-drop option. No change until he answers.
-
2026-10-02 14:36 ART | Expanded static scan found no references in scripts/, api-external/, docs/reference/parque-movil-api/, or systemd units. PROD/DEV pg_stat counters have NULL stats_reset (unknown observation window): parque_rutap_2025_12_16 seq_scan 1196/196, idx_scan 35/3; parque_rutap_20260821_0624_raw seq_scan 1020/205, idx_scan 3/1; parque_rutap_import_manifest seq_scan 512/170, idx_scan 2/0 (PROD/DEV). Counts indicate historical DB access, not current demand. Populated tables remain pending Elazar's explicit decision; no DROP.
-
Elazar 2026-10-05 (CLI, literal '2b'): drop the table WITHOUT a dump. This is his explicit word for a DROP of populated data. Relayed by coder03-mba-l-cc.
-
db04-mba-l-ca / db
-
2026-10-05 Elazar decision 2b authorizes DROP without dump. Current exact row counts: PROD 2487/5088/1; DEV 2487/5088/2 for 669/670/671 respectively. rg across src/tools/scripts/api-external/docs/reference/parque-movil-api and importer found no current readers (only generated Drizzle mirrors and historical docs); live pg catalogs show 0 inbound FK, 0 noninternal triggers, 0 dependent views, 0 routine-body references on each table, both bases. One combined guarded draft: /data-lezama/movilba/migration-evidence/2026-10-05-movilba-669-670-671-drop-obsolete-tables-PROD-Y-DEV.sql. ROLLBACK rehearsals PROD and DEV passed all pre/post checks and restored tables. No DB write committed. Audit requested before apply.
-
audit pass: DDL structural review only, combined script, destructive no-dump DROP per Elazar decision 2b (bwi: 2026-10-05 decision event)
payload
{"scope":"DDL structural review only, combined script, destructive no-dump DROP per Elazar decision 2b (bwi: 2026-10-05 decision event)","outcome":"pass","evidence":"RESTRICT not CASCADE; owner/shape/0-FK/0-trigger/0-view-dep/0-routine-ref checks under lock, exact row-count assertion (2487/5088/1-or-2) before drop, postcheck confirms removal. Grep confirms 0 runtime readers in src/scripts/tools/api-external/docs/reference/parque-movil-api","reportRef":null} -
2026-10-05 audit PASS bound to combined SQL SHA256 f07c67fb. Applied exact instrument PROD first then DEV with -v apply=true; both COMMIT and post-COMMIT to_regclass checks show all three targets absent. Removed counts: PROD 2487 + 5088 + 1 = 7576; DEV 2487 + 5088 + 2 = 7577. No dump created, per Elazar decision 2b. Repository artifact docs/migrations/2026-10-05-movilba-669-670-671-drop-obsolete-tables-PROD-Y-DEV.sql matches applied SHA. Awaiting SHIP.
-
coder03-mba-l-cc 2026-10-05: applied PROD then DEV by db04 with audit PASS; SQL, README row and regenerated drizzle mirror (audit PASS) shipped as v5.6.151 on PROD and DEV; pod push requested from proxy-mba-w-cc.
cleanup
2w ago by coder03assistant-mba-l-ca
1w ago
2026-10-05 15:23