[BE-110] End-to-end API tests against a real Postgres

[yusuftomilola]

Overview

Unit tests mock repositories, so migrations, constraints, and cascade behaviour go unverified. With the schema being rebuilt from scratch, migration correctness matters more than usual.

Tasks

• Add @testcontainers/postgresql and boot a throwaway Postgres per E2E run.
• Run real migrations against it — this alone catches broken migrations.
• Cover the critical journeys: register → login → create asset → assign → request transfer → approve → verify history.
• Cover authorization: an EMPLOYEE cannot approve transfers or read another branch's assets.
• Truncate tables between tests for isolation.
• Add a CI job running E2E on pull requests.

Acceptance Criteria

• npm run test:e2e passes locally with only Docker required.
• A deliberately broken migration fails the job.
• Authorization tests fail if a guard is removed.

Dependencies

Blocked by [BE-74], [BE-80], [BE-86], [BE-92].

Notes for Contributors

The backend is being rebuilt from a clean NestJS skeleton — backend/src/ currently contains only app.module.ts, app.controller.ts, app.service.ts, and main.ts. Follow standard NestJS module structure (module / controller / service / dto / entities) and register your module in app.module.ts. Comment below to be assigned.

[Adeyinka0123]

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

Hi Maintainer, I've gone through the issue details and understand the requirements. I would love to work on this. Could you please assign it to me?

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

[jaymhorsh]

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

kindly assign

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

[drips-wave]

Congratulations, @jaymhorsh! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on July 30, 2026.

🧑‍💻 @jaymhorsh: 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 🌊