Assert SQL Count

Assert record count of result of a SQL query matches provided assertion. Exception thrown when assertion fails.

Syntax

assert count sql(<sql>) <assertion operator> <count>

Parameters

sql

String — SQL query to execute.

assertion operator

String — Operator from following: ==, !=, <=, >=, <, >

count

Integer — The number of rows to assert against.