[Testing] No test asserts @@unique([transactionHash,eventType]) dedup, and repository COMPLETED branch is untested

[grantfox-oss]

Telegram (ask questions / claim the issue here first): https://t.me/+DOylgFv1jyJlNzM0

Why this matters

The worker's restart-safety depends on @@unique([transactionHash,eventType]), but no test inserts a duplicate (transactionHash,eventType) against a real DB and asserts the dedup behavior; tests/stream.repository.test.ts only covers CANCELLED/ACTIVE/PAUSED for updateStatus and never exercises the COMPLETED branch.

Acceptance criteria

• Add an integration test asserting a duplicate (transactionHash,eventType) insert is rejected/deduped
• Add a unit test for updateStatus('COMPLETED') mapping to isActive=false

Files to touch

• backend/tests/stream.repository.test.ts
• backend/tests/integration/stream-lifecycle.test.ts
• backend/prisma/schema.prisma

Out of scope

• General coverage-threshold work

[Caneryy]

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

Hello, can I work on this issue?

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

[drips-wave]

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

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

[grantfox-oss]

🦊 GrantFox — @Caneryy has been assigned to this issue!

Next steps:

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

Good luck! Track your progress on GrantFox.

[grantfox-oss]

🎉 This issue has been marked as completed on GrantFox!

@Caneryy's PR #929 was approved and merged by @ogazboiz.

🏆 @Caneryy: You earned 35 FoxPoints for this contribution! Your current tier: Explorer (818 total points). Track your full progress on GrantFox.

👏 Great work, @Caneryy! Keep contributing to LabsCrypt.