ICPI Setup (SRF Source)

1. Preconditions

• PostgreSQL running on 127.0.0.1:5432
• API services running (services/api and services/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.json
• tmp/outputs/icpi_build_report.json

4. Upsert into ICPI API

npm run icpi:upsert

Dry run (validation only):

npm run icpi:upsert -- --dry-run

Retry-safe upsert (recommended):

npm run icpi:upsert -- --chunkSize 200 --retries 3 --retryDelayMs 500

Default URL:

• http://localhost:4001/api/v1/icpi/upsert

Override URL:

npm run icpi:upsert -- --url http://localhost:4020/icpi/upsert

5. Verify data

curl "http://localhost:4001/api/v1/icpi/prices?limit=20"
curl "http://localhost:4001/api/v1/icpi/latest/CEMENT_M400?region=GE"
curl "http://localhost:4001/api/v1/icpi/estimate?itemCode=CEMENT_M400&quantity=100&region=GE"

6. Run end-to-end smoke check (upsert + query + estimate)

npm run icpi:smoke