Scaffolding Oracle To Postgres Migration Test Project
Scaffold an xUnit integration test project with transaction rollback and seed data before you write Oracle-to-PostgreSQL migration tests in .NET.
Install
npx skills add https://github.com/github/awesome-copilot --skill scaffolding-oracle-to-postgres-migration-test-projectWhat is this skill?
- Five-step workflow: inspect target .csproj, create xUnit project, rollback base class, seed data manager, compile verify
- Matches target .NET and NuGet versions exactly—no silent upgrades
- Single project reference to the app under test plus Oracle-oriented appsettings.json
- Run once per target project before authoring migration integration tests
Adoption & trust: 1.5k installs on skills.sh; 34.6k GitHub stars; 3/3 security scanners passed (skills.sh audits).
Recommended Skills
Agent Browservercel-labs/open-agents
Tddmattpocock/skills
Use My Browserxixu-me/skills
Test Driven Developmentobra/superpowers
Verification Before Completionobra/superpowers
Webapp Testinganthropics/skills
Journey fit
Primary fit
Migration validation belongs in Ship under testing—after the backend exists and before you trust cutover behavior. The skill creates test infrastructure (xUnit, rollback base, seed manager), not application features or production deploy scripts.
Common Questions / FAQ
Is Scaffolding Oracle To Postgres Migration Test Project safe to install?
skills.sh reports 3 of 3 security scanners passed. Review the Security Audits panel on this page before installing in production.
SKILL.md
READMESKILL.md - Scaffolding Oracle To Postgres Migration Test Project
# Scaffolding an Integration Test Project for Oracle-to-PostgreSQL Migration Creates a compilable, empty xUnit test project with transaction management and seed data infrastructure for a single target project. Run once per project before writing tests. ## Workflow ``` Progress: - [ ] Step 1: Inspect the target project - [ ] Step 2: Create the xUnit test project - [ ] Step 3: Implement transaction-rollback base class - [ ] Step 4: Implement seed data manager - [ ] Step 5: Verify the project compiles ``` **Step 1: Inspect the target project** Read the target project's `.csproj` to determine the .NET version and existing package references. Match these versions exactly — do not upgrade. **Step 2: Create the xUnit test project** - Target the same .NET version as the application under test. - Add NuGet packages for Oracle database connectivity and xUnit. - Add a project reference to the target project only — no other application projects. - Add an `appsettings.json` configured for Oracle database connectivity. **Step 3: Implement transaction-rollback base class** - Create a base test class that opens a transaction before each test and rolls it back after. - Catch and handle all exceptions to guarantee rollback. - Make the pattern inheritable by all downstream test classes. **Step 4: Implement seed data manager** - Create a global seed manager for loading test data within the transaction scope. - Do not commit seed data — transactions roll back after each test. - Do not use `TRUNCATE TABLE` — preserve existing database data. - Reuse existing seed files if available. - Establish a naming convention for seed file location that downstream test creation will follow. **Step 5: Verify the project compiles** Build the test project and confirm it compiles with zero errors before finishing. ## Key Constraints - Oracle is the golden behavior source — scaffold for Oracle first. - Keep to existing .NET and C# versions; do not introduce newer language or runtime features. - Output is an empty test project with infrastructure only — no test cases.