Menu
Create or modify an EF Core migration for PlaylistMiner database schema changes, with review and verification steps.
Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.
Baseado na classificação ocupacional SOC
| name | ef-migration |
| description | Create or modify an EF Core migration for PlaylistMiner database schema changes, with review and verification steps. |
Create a new migration after modifying entities or DbContext.
Verify changes:
git diff src/PlaylistMiner.Core/Models/
git diff src/PlaylistMiner.Infrastructure/Data/
Create migration (use descriptive name like AddVideoStatusColumn, CreateSearchIndexes):
dotnet ef migrations add <Name> --project src/PlaylistMiner.Infrastructure --startup-project src/PlaylistMiner.Api
Review generated migration — check for data loss, verify indexes (especially pg_trgm GIN indexes)
Apply locally:
dotnet ef database update --project src/PlaylistMiner.Infrastructure --startup-project src/PlaylistMiner.Api
Run integration tests to verify schema:
dotnet test tests/PlaylistMiner.IntegrationTests
dotnet ef migrations remove # Remove last unapplied
dotnet ef database update <PreviousMigration> # Rollback applied
Debug why a PlaylistMiner video was categorized incorrectly or not categorized, by tracing through all 3 pipeline layers.
Implement a .NET feature using strict Red-Green-Refactor TDD with xUnit, FluentAssertions, and Moq for PlaylistMiner backend.
Implement a Next.js component or page using TDD with Jest, React Testing Library, and Playwright for PlaylistMiner frontend.
Debug why a video was categorized incorrectly or not categorized at all in PlaylistMiner.
Create or modify an Entity Framework Core migration for PlaylistMiner database schema changes.
Write a new feature using Red-Green-Refactor TDD with xUnit and FluentAssertions for PlaylistMiner .NET backend.