This class of asserts will compare whole tables, parts of tables, views or targeted record sets for a specified conditions

N - Netezza
O - Oracle
S - SQL Server

Assert Procedure N O S Description
Asserting Values in Multiple Records
DBTD_ASSERT_IS_EXPECTED_COUNT + + + Checks that table has expected number of records, report failure if actual number of records counted base on supplied condition is not equal to expected value.
DBTD_ASSERT_IS_NOT_EXPECTED_COUNT + + + Checks that table does not have unexpected number of records, report failure if actual number of records, counted base on supplied condition, is equal to expected value.
DBTD_ASSERT_TABLE_HAS_RECORDS + + + Checks that table has records, report failure if table is empty.
DBTD_ASSERT_TABLE_HAS_NO_RECORDS + + + Checks that table does not have any records, report failure if table is not empty.
DBTD_ASSERT_IS_COLUMN_VALUE_UNIQUE + + + Assert verifies that all values on the column are unique. Will fails if any duplicate values are found in the column.
DBTD_ASSERT_COLUMN_HAVE_VALUE + + + Assert verifies that given value with provided data type exist in the specified column. Will fails if value could not been found. 
DBTD_ASSERT_COLUMN_HAS_NO_VALUE + + + Assert verifies that given value does not exist in provided column. Will fails if value has been found. 
DBTD_ASSERT_SAME_NUMBER_OF_ROWS + + + Assert validates that both provided tables have same number of rows. Assert will fail if tables have different row counts.
DBTD_ASSERT_TABLES_ARE_EQUAL     + Assert validates that both provided tables (actual and expected) have same columns, same number of rows, and same values all the rows. Assert will fail if tables signatures are different, row counts are different or when at list one value is the different across all table rows.
DBTD_ASSERT_ROWSETS_ARE_EQUAL     + In a way similar to the DBTD_ASSERT_TABLES_ARE_EQUAL logic assert validates two tables or row sets (actual and expected) that might have similar signatures. Assertion can performed in one of the two ways: based on the Actual table columns; or based on the Expected table columns. Allowing users to check only required columns. 
DBTD_ASSERT_COLUMN_HAVE_NULLS     + Assert verifies that specified column have NULLs in at list one of its records. Will fail if NULL value could not been found.
DBTD_ASSERT_COLUMN_HAS_NO_NULLS     + Assert verifies that specified column does not have a NULL in any records. Will fail if NULL value could has been found.
Assert Procedure N O S Description

N - Netezza
O - Oracle
S - SQL Server

 

Assert procedures should not be altered.