ICPI Setup (SRF Source)
1. Preconditions
- PostgreSQL running on
127.0.0.1:5432 - API services running (
services/apiandservices/svc-tenders) - OCR extraction already generated:
tmp/outputs/srf_extracted_tables.json
2. Apply DB migration
npm --prefix services/svc-tenders run migrate
This creates icpi_price_points table.
3. Build upsert payload from OCR JSON
npm run icpi:build-payload -- --year 2026 --quarter Q1 --region GE --sourceVersion "SRF-2026-Q1"
Outputs:
tmp/outputs/icpi_upsert_payload.jsontmp/outputs/icpi_build_report.json