Agent Skills › GoogleCloudPlatform/DataflowTemplates › add-integ-tests-gcs-spanner-dv

add-integ-tests-gcs-spanner-dv

GitHub

为GCS-Spanner数据验证模板创建集成测试。需输入目标数据库名和映射文件路径，生成并运行端到端测试，修复代码问题，最终在Cloud Dataflow执行验证。

v2/gcs-spanner-dv/.agents/skills/add-integ-tests-gcs-spanner-dv/SKILL.md GoogleCloudPlatform/DataflowTemplates

Trigger Scenarios

需要为GCS-Spanner-DV模板添加集成测试用户指定目标数据库和参考映射文件路径以运行自动化测试

Install

npx skills add GoogleCloudPlatform/DataflowTemplates --skill add-integ-tests-gcs-spanner-dv -g -y

More Options

Non-standard path

npx skills add https://github.com/GoogleCloudPlatform/DataflowTemplates/tree/main/v2/gcs-spanner-dv/.agents/skills/add-integ-tests-gcs-spanner-dv -g -y

Use without installing

npx skills use GoogleCloudPlatform/DataflowTemplates@add-integ-tests-gcs-spanner-dv

指定 Agent (Claude Code)

npx skills add GoogleCloudPlatform/DataflowTemplates --skill add-integ-tests-gcs-spanner-dv -a claude-code -g -y

安装 repo 全部 skill

npx skills add GoogleCloudPlatform/DataflowTemplates --all -g -y

预览 repo 内 skill

npx skills add GoogleCloudPlatform/DataflowTemplates --list

SKILL.md

Frontmatter

{
    "name": "add-integ-tests-gcs-spanner-dv",
    "description": "Specific runner skill that creates integration tests for the gcs-spanner-dv (Data Validation) template."
}

GCS-Spanner-DV Testing Orchestrator

This is used to add test for the data validation template.

Required Prompt Inputs

Target Source Database Name
Reference Datatype Mapping Matrix File Path

[!IMPORTANT] Initialization Check: If ANY of the required prompt inputs are missing from the user's prompt, or if the environment config file does not exist, you MUST HALT EXECUTION IMMEDIATELY. Ask the user to provide the missing inputs before proceeding.

Please load and execute the v2/spanner-common/.agents/skills/add-source-datatype-integ-test/SKILL.md skill to generate a datatype integration test.

Create tests for the current target similar to the following tests.

com.google.cloud.teleport.v2.templates.endtoend.BulkMigrationAndValidationMySQLAllDataTypesE2EIT
com.google.cloud.teleport.v2.templates.endtoend.BulkMigrationAndValidationPostgreSQLAllDataTypesE2EIT

Run the tests for the target database and fix any issues encountered in the code.

CRITICAL CONSTRAINTS:

Treat the provided Reference Mapping File as your absolute source of truth to derive baseline mapping schemas. You MUST strictly use this matrix to generate testing mappings. Do NOT perform independent type research.
Use the -DdirectRunnerTest flag for iterative testing.Once the DirectRunner loop passes, you MUST perform a final execution directly against Cloud Dataflow (omitting the flag) and ensure that run completely succeeds before generating your final report.
Upon completing your artifact report, ensure RequestFeedback: false is set so your status naturally changes back to idle. Do NOT pause waiting for conversational human feedback.

Example User Prompt

Please run the add-integ-tests-gcs-spanner-dv skill for the MySQL database. 
Use the reference matrix located at v2/gcs-spanner-dv/src/test/resources/mysql/mysql_datatype_mapping_matrix.csv.