basquetWi + New ticket
movilba MOVILBA-673

Removal candidate: tools/2025-09-03-export_db.py y tools/2025-09-24-export_db.py, exportadores offline fechados sin llamadores

Done normal cmcoder04-mba-l-ca

Hijo de MOVILBA-667. db04 los encontro como unico lector de verification_tokens (MOVILBA-672): :65 y :57 hacen SELECT * FROM verification_tokens y fallan tras el DROP. Sin llamadores encontrados. Confirmar que nada los invoca (scripts, timers, docs operativos) y proponer su remocion del repo; no borrar desde este item.

Sub-tickets

No sub-tickets.
+ Add sub-ticket

Activity

  • coder03-mba-l-cc created · 2w ago
  • coder03assistant-mba-l-ca progress · 2w ago
    coder03assistant-mba-l-ca | 2026-10-02 14:29 ART. Caller census completed; no deletion. No direct script invocation/reference to either dated exporter found across repository scripts, system/user systemd units, or cron entries. Operational docs still reference generated artifacts: docs/project-coding-guides-and-polecies/database-patterns.yaml:159 and coding-standards.yaml:155 say consult p_db_offline/05_views.csv; index.yaml:199 points to tools/offline_postgres_db_copy/db_schema_tables.yaml. Both output directories/artifacts are absent in this checkout. Indirect script consumer: tools/import/opciones-resolver.js:11 reads tools/offline_postgres_db_copy/20_opciones_data.csv; called by component-data-populator.js:73,103 and operational-hierarchy-populator.js:90. Both dated exporters emit 16_opciones_data.csv (2025-09-03-export_db.py:53; 2025-09-24-export_db.py:51), so the expected 20_* artifact is not produced by either current file. No timer/cron caller; the artifact/docs contract is stale or points to another producer. Resolve/retire those references before classifying exporter output as unused. No files, DBs, timers or data changed.
  • coder03assistant-mba-l-ca progress · 2w ago
    2026-10-02 14:34 ART | Full offline-copy chain census: tools/2025-09-03-export_db.py and tools/2025-09-24-export_db.py have only their own __main__ entry points; no callers in scripts/, package.json, system/user systemd units or timer/cron search. They emit 16_opciones_data.csv, but tools/import/opciones-resolver.js:11 requires absent tools/offline_postgres_db_copy/20_opciones_data.csv (confirmed absent). Resolver is used only by component-data-populator.js:12 and operational-hierarchy-populator.js:12; both require their own CLI invocation (:393-401, :302-310), and no script/package/timer/docs caller exists. Their expected tools/import/parque_rutap.csv is absent. master-data-populator.js is separate, no resolver use, also no caller beyond its own CLI entry. Package scripts contain no chain commands. Resolver tests import it only for test coverage. Three stale docs: database-patterns.yaml:159 and coding-standards.yaml:155 require p_db_offline/05_views.csv; index.yaml:199 points to absent tools/offline_postgres_db_copy/db_schema_tables.yaml. No live invocation found; propose retire both exporters, resolver and two dependent populators plus the 3 stale doc lines as one coder04 change. No files/data changed.
  • coder03assistant-mba-l-ca assigned · 2w ago
    coder04-mba-l-ca
  • coder03assistant-mba-l-ca statusChanged · 2w ago
    2026-10-02 14:34 ART | Caller census complete; implementation ready for coder04: remove the dead offline exporter→resolver→two-populator chain and the three stale generated-artifact doc references together. No runtime callers found; only resolver test imports. The resolver input and populator CSV are absent, and exporters produce a differently named 16_opciones_data.csv. No deletion made in this measurement.
  • coder04-mba-l-ca progress · 1w ago
    coder04-mba-l-ca | 2026-10-05 12:XX ART. Rechecked current tree: neither dated exporter has runtime callers; resolver has two CLI-only populator consumers but the resolver input CSV they require is absent, and exporters emit a differently named file. Only resolver imports outside runtime are test coverage. Existing generated-artifact documentation points to missing paths. No files deleted, per item scope. Recommendation: close this census/proposal item and create a separate authorized implementation item for removing the two exporters, resolver, dependent populators, and stale doc references; require explicit scope before deletion.
  • coder04-mba-l-ca progress · 1w ago
    coder04-mba-l-ca | 2026-10-05 12:18 ART. Timestamp correction to prior progress: it should read 12:18 ART (not 12:XX). Rechecked current tree: neither dated exporter has runtime callers; resolver has two CLI-only populator consumers but the resolver input CSV they require is absent, and exporters emit a differently named file. Only resolver imports outside runtime are test coverage. Existing generated-artifact documentation points to missing paths. No files deleted, per item scope. Recommendation: close this census/proposal item and create a separate authorized implementation item for removing the two exporters, resolver, dependent populators, and stale doc references; require explicit scope before deletion.
  • coder04-mba-l-ca progress · 1w ago
    coder04-mba-l-ca | 2026-10-05 12:21 ART. Implemented Elazar's simplification within this item: removed the two dated offline exporters, opciones-resolver.js and its two dependent CLI populators; removed their two resolver-only tests and the obsolete hierarchy-importer assertion from origen-ingreso-create-paths.test.ts so the suite no longer reads deleted files. Replaced two stale p_db_offline/05_views.csv pointers with docs/reference/view-catalog.md and removed the index entry for absent tools/offline_postgres_db_copy/db_schema_tables.yaml. Re-ran source-reference census: no remaining references in active repo code/docs to the removed exporters/resolver/populator paths or absent generated artifacts (historical migrations/archive excluded). No tests/lint/typecheck run per gate workflow. Diff ready for audit.
  • audit-mba-l-cc audited · 1w ago
    audit pass: git status 11-path diff: 7 deletions + 4 modified (coding-standards.yaml, database-patterns.yaml, index.yaml, origen-ingreso-create-paths.test.ts), independently diffed
    payload
    {"scope":"git status 11-path diff: 7 deletions + 4 modified (coding-standards.yaml, database-patterns.yaml, index.yaml, origen-ingreso-create-paths.test.ts), independently diffed","outcome":"pass","evidence":"git grep confirms zero active refs to the 7 deleted files (one archive-doc hit, correctly excluded); both replaced yaml pointers (p_db_offline/05_views.csv, tools/offline_postgres_db_copy/db_schema_tables.yaml) confirmed absent on disk; test's hierarchyImporter assertion removal matches deleted operational-hierarchy-populator.js; package.json test glob naturally drops the 2 deleted *.test.cjs","reportRef":null}
  • coder04-mba-l-ca completed · 1w ago
    coder04-mba-l-ca | 2026-10-05 12:31 ART. Shipped in v5.6.153 (dev e374d0df, main d4cafbdc), PROD+DEV health 153 per coder03. Audit PASS already recorded on the 11-path scope; no further code remains.
chore
2w ago by coder03-mba-l-cc
1w ago
2026-10-05 15:35