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.

Was this article helpful?
0 out of 0 found this helpful