postgres-liquibase-tests

Name: postgres-liquibase-tests
Author: ALTEN-group

Generate or update a SQL test file under tests/db for a Liquibase/Postgres schema area. Use when the user wants tests for a changelog SQL file, a selection, or a db/ path.

by ALTEN-group(0) 0 installs

Free

Free account. Installing gives you the manifest plus copy-paste snippets.

See reviews

About

Prompt file imported from ALTEN-group/Foxnox (.github/prompts/postgres-liquibase-tests.prompt.md). Copyright stays with the author.

Slash command for the Unit Tester agent on one PostgreSQL / Liquibase schema area.

Resolve the target

Use the first that is schema (not tests/db/):

A db/**/*.sql (or changelog xml/yml) path in this message
The current selection
The currently open file

If none of those is under db/, ask which schema area to test. Do not guess.

Map db/liquibase/<service>/… → tests/db/<service>/<area>.sql (create missing directories). Path layout and execution are owned by the installed PostgreSQL / Liquibase test instructions — follow them; do not restate or override them.

Run

Hand the resolved schema path and mapped test file to Unit Tester. Verify with the narrowest project command, executed per those instructions.

Use it

Copy one of these into your project. Installing also returns the manifest and these snippets.

Slash command for the **Unit Tester** agent on one PostgreSQL / Liquibase schema area.

## Resolve the target

Use the first that is schema (not `tests/db/`):

1. A `db/**/*.sql` (or changelog xml/yml) path in this message
2. The current selection
3. The currently open file

If none of those is under `db/`, ask which schema area to test. Do not guess.

Map `db/liquibase/<service>/…` → `tests/db/<service>/<area>.sql` (create missing directories). Path layout and execution are owned by the installed PostgreSQL / Liquibase test instructions — follow them; do not restate or override them.

## Run

Hand the resolved schema path and mapped test file to Unit Tester. Verify with the **narrowest** project command, executed per those instructions.

Manifest

The prompt text and its fill-in variables. Copy it or fetch it by URL from your own code.

alten-group-foxnox-postgres-liquibase-tests-prompt.prompt.jsonjson

{
  "prompt": "Slash command for the **Unit Tester** agent on one PostgreSQL / Liquibase schema area.\n\n## Resolve the target\n\nUse the first that is schema (not `tests/db/`):\n\n1. A `db/**/*.sql` (or changelog xml/yml) path in this message\n2. The current selection\n3. The currently open file\n\nIf none of those is under `db/`, ask which schema area to test. Do not guess.\n\nMap `db/liquibase/<service>/…` → `tests/db/<service>/<area>.sql` (create missing directories). Path layout and execution are owned by the installed PostgreSQL / Liquibase test instructions — follow them; do not restate or override them.\n\n## Run\n\nHand the resolved schema path and mapped test file to Unit Tester. Verify with the **narrowest** project command, executed per those instructions.",
  "variables": [],
  "notes": "Generate or update a SQL test file under tests/db for a Liquibase/Postgres schema area. Use when the user wants tests for a changelog SQL file, a selection, or a db/ path. Arguments: optional path, e.g. db/liquibase/myservice/versions/04-view/01-users.sql.",
  "metadata": {
    "source": {
      "provider": "github-prompts",
      "repository": "https://github.com/ALTEN-group/Foxnox",
      "path": ".github/prompts/postgres-liquibase-tests.prompt.md",
      "ref": "174cd9770e4441220422509bfce7d111c176a3a5",
      "url": "https://github.com/ALTEN-group/Foxnox/blob/174cd9770e4441220422509bfce7d111c176a3a5/.github/prompts/postgres-liquibase-tests.prompt.md",
      "key": "ALTEN-group/Foxnox/.github/prompts/postgres-liquibase-tests.prompt.md"
    }
  }
}

Fetch it by URL: GET /api/v1/registry/alten-group-foxnox-postgres-liquibase-tests-prompt/manifest?version=1.0.0

About

Resolve the target

Run

Use it

Manifest

Reviews