Testing utilities

SQL

nulls_in_columns(client, cols, product)

Check if any column has NULL values, returns bool

distinct_values_in_column(client, col, product)

Get distinct values in a column

duplicates_in_column(client, col, product)

Check if a column (or group of columns) has duplicated values

range_in_column(client, col, product)

Get range for a column

exists_row_where(client, criteria, product)

Check whether at least one row exists matching the criteria