This class of asserts will verify that pretend objects are executing as expected with the specified parameters and in the predefined order 

N - Netezza
O - Oracle
S - SQL Server

Assert Procedure N O S Description
Asserting pretend objects execution results - MOCK objects
DBTD_ASSERT_MOCK_EXISTS     + Checks that mock object exists in the database, checks that it is metadata correctly registered and that it was automatically created by the DBTestDriven Framework
DBTD_ASSERT_MOCK_NOT_EXISTS     + Checks that mock object DOES NOT exists in the database, verifies that that mock WERE NOT automatically created by the DBTestDriven Framework, and verifies that there is no metadata left over in the tables
DBTD_ASSERT_MOCK_NUMBER_OF_CALLS     + Asserts that mock object was called specified number of times within the current unit test execution
DBTD_ASSERT_MOCK_CALLED_MORE_THAN     + Asserts that mock object was called more than specified number of times within the current unit test execution
DBTD_ASSERT_MOCK_CALLED_LESS_THAN     + Asserts that mock object was called less than specified number of times within the current unit test execution
DBTD_ASSERT_MOCK_CALLED     + Asserts that mock object was called within current unit test execution
DBTD_ASSERT_MOCK_NOT_CALLED     + Asserts that mock object WERE NOT called within current unit test execution
DBTD_ASSERT_MOCK_CALLED_WITH_PARAM     + Asserts that mock object was called within current unit test execution with specified parameter value
DBTD_ASSERT_MOCK_NOT_CALLED_WITH_PARAM     + Asserts that mock object within current unit test execution WERE NOT called with specified parameter value
DBTD_ASSERT_MOCK_CALLED_WITH_PARAMS     + Asserts that mock object was called within current unit test execution with specified parameter values and, if needed, in a specified order.
Asserting pretend objects execution results - STUB objects
DBTD_ASSERT_STUB_EXISTS     + Checks that stub object exists in the database, checks that it is metadata correctly registered and that it was automatically created by the DBTestDriven Framework
DBTD_ASSERT_STUB_NOT_EXISTS     + Checks that stub object DOES NOT exists in the database, verifies that stub WERE NOT automatically created by the DBTestDriven Framework, and verifies that there is no metadata left over in the tables
DBTD_ASSERT_STUB_NUMBER_OF_CALLS     + Asserts that stub object was called specified number of times within the current unit test execution
DBTD_ASSERT_STUB_CALLED_MORE_THAN     + Asserts that stub object was called more than specified number of times within the current unit test execution
DBTD_ASSERT_STUB_CALLED     + Asserts that stub object was called within current unit test execution
DBTD_ASSERT_STUB_NOT_CALLED     + Asserts that stub object WERE NOT called within current unit test execution
DBTD_ASSERT_STUB_CALLED_LESS_THAN     + Asserts that stub object was called less than specified number of times within the current unit test execution
DBTD_ASSERT_STUB_CALLED_WITH_PARAM     + Asserts that stub object was called within current unit test execution with specified parameter value
DBTD_ASSERT_STUB_NOT_CALLED_WITH_PARAM     + Asserts that stub object within current unit test execution WERE NOT called with specified parameter value
DBTD_ASSERT_STUB_CALLED_WITH_PARAMS     + Asserts that stub object was called within current unit test execution with specified parameter values and, if needed, in a specified order
Assert Procedure N O S Description

N - Netezza
O - Oracle
S - SQL Server

 

Assert procedures should not be altered.