1---2name: planning-oracle-to-postgres-migration-integration-testin-23description: Create an integration testing plan for one .NET project during Oracle-to-PostgreSQL migration. Use when planning coverage for repositories, DAOs, stored procedure callers, CRUD service layers, Oracle-specific behavior, seed data, or migration validation cases before writing integration tests.4---56# Planning integration testing for Oracle-to-PostgreSQL migration78Analyze one .NET target project for database-touching artifacts, rank Oracle-to-PostgreSQL migration risk, and write a concrete integration testing plan that captures Oracle behavior as the golden source.910## When to invoke1112- "Plan integration tests for this Oracle-to-PostgreSQL migrated project."13- "Find data access methods that need migration validation tests."14- "Create the TARGET_PROJECT integration testing plan."15- "Prioritize Oracle-specific repository behavior for PostgreSQL migration."16- "List seed data and test cases for DAOs and stored procedure callers."1718## Scope rules1920| Boundary | Rule |21| --- | --- |22| Single project scope | Plan only artifacts inside the target project; do not include neighboring applications. |23| Database interactions only | Include repositories, DAOs, stored procedure callers, and service layers performing CRUD operations. Skip business logic with no database touchpoint. |24| Oracle golden source | Tests capture Oracle's expected behavior first, then compare PostgreSQL behavior against it. |25| No multi-connection harnessing | Migrated applications are copied and renamed, for example `MyApp.Postgres`; each instance targets one database. |26| Output path | Write the plan to `.github/oracle-to-postgres-migration/Reports/{TARGET_PROJECT} Integration Testing Plan.md`. |2728## Risk classification2930| Priority | Database behavior | Examples |31| --- | --- | --- |32| P0 | Oracle-specific semantics likely to differ on PostgreSQL. | refcursors, `TO_CHAR`, implicit type coercion, `NO_DATA_FOUND`, sequence/default behavior, date truncation. |33| P1 | Complex CRUD or query composition with joins, filters, pagination, transactions, or concurrency. | Repository search methods, DAO batch writes, service-layer write flows. |34| P2 | Simple CRUD with straightforward mappings. | Single-row insert, update, read, delete with no Oracle-specific functions. |35| Excluded | No direct database interaction. | Pure calculation, formatting, validation, or orchestration without persistence. |3637## Required test-case themes3839| Theme | Include cases |40| --- | --- |41| Text parameters | Empty string and `NULL`/missing values; verify Oracle empty-string-as-null differences when relevant. |42| Datetime/timezone | Round-trip and comparison behavior; include explicit timezone-application expectations. |43| PostgreSQL timestamp targets | Destination columns using `timestamp without time zone` or `timestamp(0)`; verify precision and timezone semantics. |44| Oracle exceptions | `NO_DATA_FOUND` and equivalent no-row behavior in PostgreSQL. |45| Formatting and coercion | `TO_CHAR`, implicit numeric/text/date coercion, and formatting-sensitive comparisons. |46| Seed data | Minimal deterministic rows for each method, including boundary and no-match cases. |4748## Procedure49501. Identify data access artifacts in the target project: repositories, DAOs, stored procedure callers, and service layers that perform CRUD operations.512. Record method signatures and database touchpoints for each artifact.523. Classify each artifact and method by migration risk using the priority table.534. Define recommended integration test cases, seed data, and expected Oracle behavior for every included database touchpoint.545. Add known Oracle→PostgreSQL behavioral differences to validate, especially text, datetime/timezone, `TO_CHAR`, implicit coercion, and `NO_DATA_FOUND` cases.556. Write the markdown plan to `.github/oracle-to-postgres-migration/Reports/{TARGET_PROJECT} Integration Testing Plan.md`.5657## Plan contents5859| Section | Required detail |60| --- | --- |61| Target project | Project name, path, and scope exclusions. |62| Testable artifacts | Classes and method signatures that touch the database. |63| Priority map | P0/P1/P2 classification with reason. |64| Recommended cases | Positive, no-row, null/empty, boundary, formatting, timezone, and error-path cases as applicable. |65| Seed data | Required tables/entities, rows, and cleanup/rollback assumptions. |66| Oracle→PostgreSQL differences | Behavior that must be asserted during migration validation. |67| Coverage mapping | Every database touchpoint has at least one test case, or high-risk methods have justified multiple cases. |6869## Output template7071```markdown72# <TARGET_PROJECT> Integration Testing Plan7374**Status:** planned | blocked75**Target project:** `<path/to/project.csproj>`76**Output path:** `.github/oracle-to-postgres-migration/Reports/{TARGET_PROJECT} Integration Testing Plan.md`7778## Testable artifacts79| Artifact | Method signature | Database touchpoint | Priority | Reason |80| --- | --- | --- | --- | --- |81| `<class>` | `<method>` | `<table/procedure/query>` | P0/P1/P2 | `<migration risk>` |8283## Recommended test cases84| Artifact method | Case | Seed data | Oracle behavior to capture | PostgreSQL difference to validate |85| --- | --- | --- | --- | --- |86| `<method>` | `<case name>` | `<rows>` | `<expected Oracle result>` | `<difference>` |8788## Coverage mapping89| Database touchpoint | Covered by | Gap or justification |90| --- | --- | --- |91| `<touchpoint>` | `<test case>` | `<none or reason>` |92```9394## Quality gate9596- [ ] Only one target project is in scope.97- [ ] Every repository, DAO, stored procedure caller, and CRUD service layer in scope was considered.98- [ ] Business logic without database interaction was excluded.99- [ ] Oracle-specific features such as refcursors, `TO_CHAR`, implicit type coercion, and `NO_DATA_FOUND` are prioritized.100- [ ] Text parameter cases include empty string and `NULL`/missing values.101- [ ] Datetime/timezone cases include round-trip and comparison behavior.102- [ ] `timestamp without time zone` and `timestamp(0)` destinations include timezone-application expectations.103- [ ] Every database touchpoint has coverage or a documented justification.104- [ ] The plan is written to `.github/oracle-to-postgres-migration/Reports/{TARGET_PROJECT} Integration Testing Plan.md`.
paulasilvatech