movilba
MOVILBA-687
· child of MOVILBA-667 Simplificar MovilBA: censo de tablas, columnas, vistas, rutas y pantallas que nada usa, para quitarlas Done
Removal candidate: view rutap.v_rutap_latest_empresas
Done normal
rmresearcher-mba-l-cc
MOVILBA-667 census (2026-10-02): rutap.v_rutap_latest_empresas exists in PROD and DEV. Static scan found no src/ or tools/ reader by relation name or generated Drizzle symbol; pg_depend view graph has zero dependent views; installed routine-body scan has no name reference in either base. RUTAP import/operator workflows outside current source may consume it; verify those before removal. Candidate only; no drop authorization.
Activity
-
parent=#4252
-
2026-10-02 14:36 ART | Expanded static consumer scan found no references in scripts/, api-external/, docs/reference/parque-movil-api/, or systemd unit files. Prior PROD+DEV checks: view installed, zero dependent views, zero installed routine-body references, no src/tools direct or generated-symbol reader. External/manual SQL consumers and runtime usage remain unmeasured; candidate evidence is not drop authorization.
-
researcher-mba-l-cc / solo
-
2026-10-08T16:33:53-03:00 / 19:33:53Z researcher-mba-l-cc. Code-side census: zero readers in src/ or tools/ in either snake_case or Drizzle camelCase form. UNDECIDED (no third bucket - absence of a reader is not the same as unused; DB-side view-depends-on-view and pg_stat checks are a separate db-lane ask). Full 17-item table with per-view schema.ts location and caveats on MOVILBA-674.
-
2026-10-08 DB-side SELECT-only census: exists both; 0 direct dependent views; 0 directly referenced base relations. Ordinary views have no own pg_stat_user_tables/pg_statio_user_tables row; base-table counters do NOT attribute reads to this view, and stats_reset is NULL. No DROP; code-side UNDECIDED remains. Exact query and per-view report: /data-lezama/movilba/evidencia/MOVILBA-667/2026-10-08-view-dependency-and-stats-census.md.
-
Blocked on Elazar - packaged by coder03 as ONE decision for all 13 unresolvable removal-candidate views (674,675,677,680,681,683-690) plus 700 (moot, already dropped by 702). db04's PROD+DEV existence/pg_depend census is terminal; code side found zero readers in either naming form. No further instrument changes this without the external/manual-consumer evidence class nobody here can observe.
-
researcher-mba-l-cc 2026-10-08 19:13 ART / 22:13 UTC - collapsed into the single brief on MOVILBA-674 per coder03. See 674's note for this item's row, the full table of 14, and the one question for Elazar. Not re-measured separately here.
-
db03 2026-10-09 17:21:35Z PROD / 17:21:43Z DEV. Pre-apply pg_depend check both bases: zero dependent views. Rehearsed under ROLLBACK, then DROP VIEW applied (SUPERUSER_ELAZAR_URL, superuser elazar, PROD first) and DEV (movilba_user). to_regclass confirmed NULL both bases post-drop. Elazar GO via coder03, MOVILBA-674 batch.
cleanup
2w ago by coder03assistant-mba-l-ca
1w ago
2026-10-09 17:22