Feature: Add Isolated Integration Test Database Lifecycle

[3m1n3nc3]

Description

Provide safe isolated PostgreSQL setup, migrations, factories, cleanup, and parallelism for integration tests.

File Location

learnault-api/tests/setup.ts, learnault-api/tests/integration/, test DB scripts, and Vitest config

Design Reference

API Roadmap Phase 0: Add Isolated Integration Test Database Lifecycle.

Dependencies

• Status: Blocked
• Blocked by: Feature: Repair Clean Install and Prisma Generation; Feature: Add Local Docker Compose Development Stack
• Blocks: Feature: Add Complete Backend CI Quality Gates; API Phase 1 tests

Tasks

• Use a dedicated test database URL with production-target safeguards
• Apply migrations once per run
• Provide factories and isolated suite/transaction state
• Define safe parallel execution and teardown
• Remove developer-local and network timing dependencies
• Add isolation, cleanup, and failure-recovery self-tests

Acceptance Criteria

• Unsafe database targets are rejected
• Tests pass in any order
• Tests do not leak records across cases
• Cleanup survives failures
• Self-tests pass

Verification Evidence

• Attach shuffled/repeated test output and database safety-guard proof

Difficulty

Advanced

[Menjay7]

Hi! I’m a full-stack developer with a strong blockchain background. I’d love to handle this issue and can deliver a clean, reliable solution. Kindly assign it to me.

[jaynomyaro]

Hi! I came across this issue and would love to work on it. I have experience with similar tasks and I'm confident I can investigate, implement a clean solution, and thoroughly test it before submitting a PR. If the issue is still open, I would appreciate it if you could assign it to me. Thank you!

[grantfox-oss]

🦊 GrantFox — @ciynthia 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 #70)
2. Your PR will be reviewed by the learnault maintainers

Good luck! Track your progress on GrantFox.