Cookbook

Common recipes based on the SQL contract requirements you can copy‑paste and adapt to your project.

Example Assertion Templates

• No NULLs in key column

SELECT MY_COL
FROM MY_TABLE
WHERE MY_COL IS NULL;

• No duplicates in key column

SELECT MY_COL
FROM MY_TABLE
GROUP BY MY_COL
HAVING COUNT(*) > 1;

• Aggregate value equals total expectation

SELECT *
FROM (
  SELECT SUM(AMOUNT) AS total
  FROM MY_TABLE
  WHERE DATE_COL = CURRENT_DATE - INTERVAL '1 DAY'
)
WHERE total <> 123.45;

Export Reports for CI Pipelines

es run -e dev --junitxml reports/junit.xml

Run a Subsuite Only

Organize tests into subdirectories and filter using es view for discovery, or simply commit only the subsuite you want to run in a branch.

Listing a subsuite:

es view tests --suite smoke

Investigate a Single Test

es view test integrity/no_duplicate_orders