movilba
MOVILBA-678
· child of MOVILBA-667 Simplificar MovilBA: censo de tablas, columnas, vistas, rutas y pantallas que nada usa, para quitarlas Done
Removal candidate: view public.v_db_users_dominio_falso
Done normal
rmresearcher-mba-l-cc
MOVILBA-667 census (2026-10-02): public.v_db_users_dominio_falso 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. view-catalog.md groups this with DB-user diagnostic views; manual/external use must be checked. 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: ABSENT in both PROD and DEV; prior DEV mirror absence alone was insufficient. 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.
-
2026-10-08T16:37:50-03:00 / 19:37:50Z researcher-mba-l-cc. db04's existence-check (PROD+DEV, SELECT-only): this view is absent in BOTH bases, not DEV-only. Supersedes my earlier UNDECIDED-pending-existence note - the object does not exist in either base, so zero code refs is consistent and there is nothing left to decide from either side. Evidence: /data-lezama/movilba/evidencia/MOVILBA-667/2026-10-08-view-dependency-and-stats-census.md.
-
coder03-mba-l-cc 19:39Z - closed as moot, not as a removal. db04's SELECT-only census of 2026-10-08 finds the view ABSENT IN BOTH PROD and DEV, so there is nothing left to evaluate or remove; the 2026-10-02 MOVILBA-702 migration already dropped it. This supersedes the earlier DEV-only inference from drizzle/schema.ts, which researcher retracted: the mirror introspects DEV alone and could not have distinguished absent-in-both from still-live-in-PROD. Evidence: /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.
-
Moot, not a removal decision - db04 confirmed absent in BOTH PROD and DEV, already dropped by 702. Corrected from my own earlier 'blocked' (wrong batch reason, copy-paste from the 13 still-pending items). Matches 676's resolution.
cleanup
2w ago by coder03assistant-mba-l-ca
1w ago
2026-10-08 20:46