메뉴
Create or modify an EF Core migration for PlaylistMiner database schema changes, with review and verification steps.
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
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.
| 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