[Backend] Implement Database Seeding and Test Data

[gelluisaac]

Overview

Implement database seeding and test data generation for development and testing.

Current State

• No seeding system
• Manual test data creation
• No consistent test data
• No seed data management

Requirements

1. Seeding Features

   • Seed data scripts
   • Environment-specific seeds
   • Seed data versioning
   • Seed data dependencies
   • Seed data validation

2. Test Data

   • Realistic test data
   • Test data factories
   • Random data generation
   • Relationship handling
   • Data consistency

3. Seed Management

   • Seed CLI commands
   • Seed reset functionality
   • Seed data documentation
   • Seed data updates
   • Seed data backup

4. Integration

   • Prisma seed
   • Faker for data generation
   • Test database setup
   • CI/CD integration
   • Development workflow

Technical Details

• Use Prisma seed functionality
• Use Faker for realistic data
• Create seed data factories
• Add seed CLI commands

Files to Create/Modify

• backend/prisma/seed.ts (enhance)
• backend/src/seeds/ (create seed files)
• backend/src/factories/ (create data factories)
• backend/src/scripts/seed.ts (create)
• backend/src/utils/seedUtils.ts (create)

Acceptance Criteria

• Seed scripts work
• Test data is realistic
• Relationships are handled
• Seeds are versioned
• CLI commands work
• Documentation is complete
• CI/CD integration works
• Data is consistent

References

• Prisma seed: https://www.prisma.io/docs/guides/database/seed-database
• Faker: https://fakerjs.dev/
• Seed data best practices: https://www.laraveldaily.com/seed-database-in-laravel/

[maramina]

hi am a software developer interested in solving this issue please assign me

[grantfox-oss]

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

Next steps:

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

Good luck! Track your progress on GrantFox.