Add docker-compose integration test harness

[Miracle656]

Background

Unit tests mock the database. Real bugs (migrations, index usage, transaction isolation) surface only against a real Postgres. A docker-compose-based integration suite that spins up Postgres + the Wraith API and runs end-to-end queries catches those.

What to build

A docker-compose.test.yml that brings up Postgres + Wraith, a tests/integration/ directory with Vitest specs that hit the running API, and a CI job that runs them on every PR.

Key files

• New: docker-compose.test.yml
• New: tests/integration/
• .github/workflows/ci.yml

Suggested execution

git checkout -b test/integration-harness

1. docker-compose.test.yml brings up Postgres on a deterministic port + the Wraith API
2. Add a tests/integration/setup.ts that seeds known fixtures
3. Write specs that hit /transfers, /accounts/:address/summary etc.
4. CI job: docker compose -f docker-compose.test.yml up -d, then npm run test:integration
5. Teardown step

Example commit message:
test(integration): add docker-compose harness and integration test suite

Acceptance criteria

• docker compose -f docker-compose.test.yml up brings up the stack
• npm run test:integration runs cleanly on a fresh machine
• CI runs the suite on every PR
• Fixtures cover at least 3 representative scenarios

---

Drips Wave · Complexity: Medium · 150 points
Comment below to request assignment. PR must include Closes #[this issue].

[codefather2026]

@codefather2026 has applied to work on this issue as part of the Stellar Wave Program's 5th wave.

Hi maintainer, i will like to solve this issue

ℹ️ Repo Maintainers: To accept this application, review their application or assign @codefather2026 to this issue.

[drips-wave]

Congratulations, @codefather2026! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 2, 2026.

🧑‍💻 @codefather2026: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊