creating-oracle-to-postgres-migration-integration-tests by github/awesome-copilot
npx skills add https://github.com/github/awesome-copilot --skill creating-oracle-to-postgres-migration-integration-tests为单个目标项目中的数据访问构件生成集成测试用例。测试用于验证在 Oracle 或 PostgreSQL 上运行时行为的一致性。
测试创建:
- [ ] 步骤 1:了解测试项目的约定
- [ ] 步骤 2:识别可测试的数据访问构件
- [ ] 步骤 3:创建种子数据
- [ ] 步骤 4:编写测试用例
- [ ] 步骤 5:审查确定性
步骤 1:了解测试项目的约定
阅读基测试类、种子数据管理器和项目文件,以理解继承模式、事务管理和种子文件约定。
步骤 2:识别可测试的数据访问构件
范围仅限于目标项目。列出与数据库交互的数据访问方法——存储库、DAO、存储过程调用器、查询构建器。
步骤 3:创建种子数据
TRUNCATE TABLE —— 保持现有数据库数据完整。步骤 4:编写测试用例
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
重新检查每个针对非空值的断言。确认每个断言对于已播种的数据都是确定性的。修复任何依赖于测试控制之外的数据库状态的断言。
每周安装量
507
代码仓库
GitHub 星标数
27.0K
首次出现
2026年3月11日
安全审计
安装于
codex452
gemini-cli452
opencode441
cursor437
github-copilot434
kimi-cli433
Generates integration test cases for data access artifacts in a single target project. Tests validate behavior consistency when running against Oracle or PostgreSQL.
Test Creation:
- [ ] Step 1: Discover the test project conventions
- [ ] Step 2: Identify testable data access artifacts
- [ ] Step 3: Create seed data
- [ ] Step 4: Write test cases
- [ ] Step 5: Review determinism
Step 1: Discover the test project conventions
Read the base test class, seed manager, and project file to understand inheritance patterns, transaction management, and seed file conventions.
Step 2: Identify testable data access artifacts
Scope to the target project only. List data access methods that interact with the database — repositories, DAOs, stored procedure callers, query builders.
Step 3: Create seed data
TRUNCATE TABLE — keep existing database data intact.Step 4: Write test cases
Step 5: Review determinism
Re-examine every assertion against non-null values. Confirm each is deterministic against the seeded data. Fix any assertion that depends on database state outside the test's control.
Weekly Installs
507
Repository
GitHub Stars
27.0K
First Seen
Mar 11, 2026
Security Audits
Gen Agent Trust HubPassSocketPassSnykPass
Installed on
codex452
gemini-cli452
opencode441
cursor437
github-copilot434
kimi-cli433
Google Slides 演示文稿创建与共享自动化教程 - 使用 Google Workspace CLI
6,500 周安装