Database state not cleaned between integration test runs — tests are order-dependent

[hman38705]

Labels: testing, database

Priority: High

Description

Integration tests in tests/ do not clean up database state after each test. Tests that insert rows leave data that can affect subsequent tests, causing intermittent failures depending on test execution order.

Acceptance Criteria

• Add a test fixture that wraps each test in a database transaction and rolls back after the test
• Alternatively, truncate relevant tables in a setup/teardown hook
• Add a CI assertion that runs tests in random order twice and verifies results are identical
• Document the fixture pattern in CONTRIBUTING.md

[khanavi272-spec]

@khanavi272-spec has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

I would like to work on this issue

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

[rindicomfort]

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

Hello Maintainer,

Please I’d love to take this issue on. I’m a smart contract and full-stack developer with experience across OnlyDust, Drips Waves

My stack includes Rust, Soroban, Cairo, Solidity, and TypeScript. I can deliver a clean, tested, and well-documented solution within 24 hours of assignment.

Happy to start immediately. Thank You

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

[vitalis200]

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

i will like to work on this

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

[drips-wave]

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

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