Unit test runners, core framework procedures, logging, fake object creation, process control and other framework procedures.
N - Netezza
O - Oracle
S - SQL Server
Hint Procedure |
N |
O |
S |
Description |
DBTD_RUNTESTS |
+ |
+ |
+ |
Stored procedure will run all available unit tests in a database. At the beginning this procedure will refresh list of available unit tests in the database and execute global setup process, at the end, when all test are complete it will also run global teardown functions to perform cleanup |
DBTD_RUNTESTSUITE |
+ |
+ |
+ |
Runs all unit tests for a given test suite. |
DBTD_RUNTESTSUITE_EXT |
|
|
+ |
This is an extended version of the DBTD_RUNTESTSUITE procedure, it run all unit tests for a given test suite, and allows user reload test information and run global setup and teardown for this individual suite |
DBTD_RUNONETEST_EXT |
|
|
+ |
This procedure runs single unit tests individually using all available framework functionality. Results of the run will be saved in to the DBTD_TBL_TESTRESULT table and DBTD_TBL_LOG table |
DBTD_REFRESH_TESTSLIST |
+ |
+ |
+ |
Refreshes list of all available unit tests in the database. Procedure will update DBTD_TBL_TESTSLIST table |
DBTD_LOG_MESSAGE |
+ |
+ |
+ |
Saves message with provided type into the DBTD_TBL_LOG log table |
DBTD_LOG_MESSAGE_EXT |
|
|
+ |
Saves message with provided type and source into the DBTD_TBL_LOG log table |
DBTD_ERROR |
+ |
+ |
+ |
Procedure used to report error in a unit test. Saves error into the DBTD_TBL_LOG log table and raises error to the parent process |
DBTD_FAILURE |
+ |
+ |
+ |
Procedure records failure message in the DBTD_TBL_LOG log table and raises exception up to the parent process |
DBTD_RUNGLOBALSETUP |
+ |
+ |
+ |
Procedure used to execute global setup defined by the user |
DBTD_RUNGLOBALTEARDOWN |
+ |
+ |
+ |
Procedure used to execute global teardown defined by the user |
DBTD_GET_UnitTestRunID |
|
|
+ |
Returns currently running unit test identification number. Unit test identification number assigned by the DB Test Driven framework for each unit test run, every time you will run unit test a new run id will be generated |
DBTD_GET_UnitTestName |
|
|
+ |
Returns currently running unit test name. Unit test name is the name of the actual unit test stored procedure |
DBTD_CREATE_STUB_PROCEDURE |
|
|
+ |
STUB is the copy of original procedure that has the same signature and intended to be used side by side with original |
DBTD_CREATE_MOCK_PROCEDURE |
|
|
+ |
MOCK is a replacement of the original stored procedure that allows user to inject-new and override existing functionality without explicitly introducing changes to existing database code |
DBTD_RESTORE_ORIGINAL_PROC |
|
|
+ |
Procedure will try to determine if the target procedure is a MOCK procedure, will restore the code of the original stored procedure and will delete the MOCK and all of its traces from related tables |
DBTD_PRINT_MESSAGE |
|
|
+ |
Prints the message base on the provided verbose settings. Used by test runners to control verbose output |
Hint Procedures |
N |
O |
S |
Description |
N - Netezza
O - Oracle
S - SQL Server