[TEST]: Build a production-like integration test harness for API and database flows

[grantfox-oss]

Context

The repository has no test script or visible automated suite despite complex role, database, storage, email, and blockchain behavior. Unit-only coverage would not catch route/schema mismatches or transaction failures.

Scope

• Add a test runner and ephemeral PostgreSQL/Supabase-compatible integration environment.
• Create deterministic factories for users, roles, payouts, milestones, applications, and support tickets.
• Exercise route handlers through HTTP with real migrations and database constraints.
• Stub external boundaries (email, storage, Stellar/Trustless Work) through explicit adapters.
• Cover authentication, authorization, lifecycle transitions, concurrency, pagination, and error contracts.
• Isolate tests for parallel execution and provide failure diagnostics.

Acceptance criteria

• npm test (or the documented package-manager equivalent) works from a clean checkout.
• Tests never depend on shared developer or production services.
• Database state is isolated and repeatable across parallel workers.
• Critical payout/application/support happy paths and forbidden paths are covered.
• CI publishes test and coverage results with actionable failure logs.
• Contributor docs explain local prerequisites and focused test commands.

Relevant areas

package.json, src/app/api/**, Prisma schema/client, new tests/integration infrastructure.

[OSEH-svg]

Hello Maintainer,
I’d love to work on this issue. I'm a software developer with 5 years of experience and I’m confident I can deliver a good solution. Please feel free to assign it to me.

[TheDEV111]

Hi! I'd like to work on this issue.

I understand the goal is to establish a reliable integration testing foundation that validates the application's real behavior—not just isolated units—while keeping tests deterministic, reproducible, and suitable for local development and CI.

My implementation would focus on:

• Setting up a dedicated test runner and an ephemeral PostgreSQL/Supabase-compatible environment that can be initialized from a clean checkout without depending on shared infrastructure.
• Creating reusable, deterministic factories for core domain entities such as users, roles, applications, payouts, milestones, and support tickets to keep tests concise and maintainable.
• Exercising API route handlers through HTTP against a real migrated database so request validation, authorization, database constraints, and transaction behavior are verified end-to-end.
• Introducing explicit adapters for external dependencies (email, storage, Stellar/Trustless Work, and similar integrations) so tests remain deterministic while clearly defining integration boundaries.
• Adding representative integration coverage for authentication, authorization, lifecycle transitions, pagination, concurrency-sensitive operations, and documented error contracts, including both successful and forbidden flows.
• Ensuring database state is isolated between tests and supports parallel execution through transactional cleanup or isolated databases, with clear diagnostics when failures occur.
• Configuring the project so npm test (or the documented package manager equivalent) runs the complete suite from a clean environment and integrates cleanly with CI reporting.
• Documenting the local testing workflow, prerequisites, and commands for running the full suite or targeted integration tests to simplify future contributions.

I'll keep the implementation aligned with the existing architecture, emphasize maintainability and fast feedback, and ensure the resulting test infrastructure provides a solid foundation for confidently evolving the application's API and business logic.

I'd be happy to take on this issue.

[grantfox-oss]

🦊 GrantFox — @TheDEV111 has been assigned to this issue as part of the Official Campaign | FWC26 campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #103)
2. Your PR will be reviewed by the Eduvault-stellar maintainers

Good luck! Track your progress on GrantFox.