Establish a clean, reproducible database state for development and verification.
[!IMPORTANT] DATABASE STRATEGY: Skip this skill if the modernization strategy is to use the existing legacy database directly. This tool is only for cases where you need a fresh dataset to test in isolation.
Objective
Generate a script that populates the modern database with sample records (Primary and Sub-resources) that satisfy the Zod validation rules and established relational integrity.
Workflow
- Analyze Schemas: Read the modern schemas (e.g.,
src/lib/models/schema.ts) to identify required fields, data types, and default values. - Generate Realistic Samples: Create a set of sample data that covers:
- Primary Resources: Users, Accounts, or root entities.
- Sub-resources: Related items linked via
ObjectId. - Edge Cases: Empty strings, long text, and various tag/category combinations.
- Implement Seeder: Create the seeder script (e.g.,
src/lib/db/seeder.ts).- Invariants: The script MUST clear existing collections before insertion to ensure a deterministic state.
- Security: Hash passwords and sanitize inputs using the project's utility functions.
- Execute & Verify: Run the seeder (e.g.,
npm run db:seed) and confirm the records exist in the database with the correct structure.
Output
A functional seeding command and a populated database ready for Phase 5 verification.