菜单
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