Create CUBRID CTP SQL testcases with --test/--check markers for HA replication.
npx skills add https://github.com/tw-kang/skills --skill ha-repl-create
Please help me install this Agent Skill. Skill: ha_repl-create Source: https://github.com/tw-kang/skills/tree/main/ha_repl-create Command: npx skills add https://github.com/tw-kang/skills --skill ha-repl-create
This skill helps engineers quickly produce well-formed HA replication CUBRID CTP SQL testcases that follow CTP conventions, enforce commit/check discipline, and ensure master-to-slave consistency checks for new bug fixes or feature tests.
.sql test files annotated with --test: and --check: markers to drive master-only actions and cross-node verification.--test: COMMIT; after DML batches, and recommends deterministic ORDER BY in checks and explicit primary keys.Create a draft ha_repl testcase for CBRD-12345 including header, setup, 3–6 check points, commit discipline, and cleanup.
High-intent search queries and answers about installing and using this skill.
To create HA replication testcases for CUBRID, generate SQL files with --test and --check markers that drive master actions and verify cross-node consistency. Ensure one-statement-per-line, explicit primary keys, and deterministic ORDER BY in checks.
CUBRID CTP replication test scripts require a --test: COMMIT; statement after DML batches to ensure changes are replicated from the master node to slave nodes before executing cross-node verification checks.
Structure the SQL test file by separating master-only actions using --test: markers and cross-node verification using --check: markers, including a header, setup scripts, 3 to 6 check points, and cleanup steps for re-runnable tests.
Yes, you can draft DDL or DDL with data replication scenarios for CBRD bug fixes by following CTP directory conventions, applying per-statement markers, and referencing 3-node infrastructure configurations for cleanup-safe test execution.
HA replication test checks fail deterministically when SQL verification queries lack ORDER BY clauses or explicit primary keys. Enforce deterministic ORDER BY in checks and explicit primary keys during setup to guarantee consistent cross-node verification.
Limitations include strict formatting rules: one-statement-per-line is enforced, DML batches require explicit commit discipline, and tests must reference 3-node infrastructure configurations to properly verify master-to-slave replication consistency.
tw-kangExecute a single CUBRID CDC replication testcase via CTP and report pass/fail.
tw-kangRun a single CUBRID HA replication testcase and report master-slave result match.
tw-kangGenerate CDC replication CTP SQL testcase drafts with CTP file format and CDC markers.
tw-kangGenerate CUBRID CTP SQL testcase files (.sql/.answer from bug descriptions.