Replace the placeholder checkpoint test with real coverage #191

Background

src/__tests__/checkpoint.test.ts asserts nothing about behaviour. Every case constructs a TypeScript interface literal and checks the fields it just assigned — it("should define BatchMetadata interface correctly"). It exercises no runtime code.

Meanwhile src/indexer/checkpoint.ts holds the real logic (isBatchProcessed, the transactional commit at :60-140) and has zero importers, so the "exactly-once ingest" feature from closed issue #101 is untested dead code that still counts toward the coverage gate.

Acceptance criteria

• Behavioural tests against a mocked prisma: a fresh batch inserts and advances the checkpoint; a replayed batchId is a no-op; a failed insert rolls back so the checkpoint does not advance
• The vacuous interface-shape cases are removed
• commitBatch and isBatchProcessed are actually executed — visible in the coverage report, where they are currently at zero
• The PR states in one line that the module is still not wired into startIndexer()

Drips Wave · Complexity: Easy · 100 points

How this repo is laid out

Wraith is a Soroban incoming-transfer indexer: it fills the gap Horizon leaves for SAC/SEP-41 token events by recipient address. Roughly 14k lines under src/, REST + GraphQL + WebSocket, Postgres via Prisma, deployed on Render.

• Unit tests are jest (src/**/__tests__, tests/*.test.ts), with a coverage gate.
• Integration tests are vitest (tests/integration/, vitest.integration.config.ts, Docker).
• Don't mix the two runners in one file.

Known state of main before you start

tsc --noEmit and the unit suite are green. The Integration tests CI job is red, and so is Load test — both predate this batch. Open PRs #177 and #178 address them. If the integration job is red when you open a PR, that is not your fault; say so in the PR and carry on.

Four modules are shipped, closed as done, and imported by nothing: src/indexer/checkpoint.ts, src/ingest/reorg.ts, src/middleware/opa.ts, and src/api/candles.ts + src/workers/ohlc-refresh.ts. So the live indexer today has no reorg handling and no atomic checkpointing, despite both features being closed. Two issues below start unpicking that — don't assume a closed issue means a wired feature.

Ground rules

• Every PR needs a test that fails before the change and passes after, unless the issue says otherwise.
• Don't widen a Prometheus label to something unbounded — addresses and contract ids must never become label values.
• Nothing may log or return a raw database error, a connection string, or a provider URL.
• Don't reformat a file you're changing. A diff that is 90% whitespace hides the 10% that matters.

Required: Before submitting, join the contributor Telegram so your work can be tracked and counted toward the Stellar Wave: https://t.me/+fxHXq8f1SwlkZDBk