[Backend] backend/prisma/seed.ts has no idempotency guard, so re-running it against a populated dev DB creates duplicate rows or throws unique-constraint errors

[grantfox-oss]

Join our community: https://t.me/+DOylgFv1jyJlNzM0

Why this matters

backend/prisma/seed.ts presumably inserts demo users/streams for local development. If it uses create() rather than upsert(), running npx prisma db seed a second time against an already-seeded database will either duplicate rows (if IDs aren't unique-constrained) or crash with a constraint violation, making the seed script unsafe to re-run, which is a common local-dev workflow.

Acceptance criteria

• Audit seed.ts for create() calls that should be upsert()
• Make the script safe to run repeatedly against the same database
• Note the idempotency guarantee in backend/README.md

Files to touch

• backend/prisma/seed.ts
• backend/README.md

Out of scope

• Changing the seed data content
• Adding a db reset wrapper script

[TheShnider]

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

Hi. I would like to work on this

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

[Killerjunior]

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

Hi maintainer, I have read and understood the issue requirements and checked the necessary documentation. I’m confident I can work on this task effectively and deliver a proper solution.

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

[alade-dev]

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

Hi, I would love to work on this issue.

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

[Enemuo-debug]

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

Can I please work on this?

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

[Michvista]

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

Please assign to me

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

[Seunfunmi-319509]

@Seunfunmi-319509 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 @Seunfunmi-319509 to this issue.

[Ajibose]

@Ajibose 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 @Ajibose to this issue.

[OpensrcLord]

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

Hello @maintainer, I’d like to work on this issue. I have experience handling similar tasks and can start immediately. And I will deliver at the shortest possible time.

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