Contains one row for each available Unit Test in the database.
This table is used by test runners.
To update the list of available tests run DBTD_REFRESH_TESTSLIST framework procedure.
Column Name |
Data Type |
Description |
Owner |
VARCHAR(128) |
Unit Test Owner |
TestName |
VARCHAR(128) |
Unit Test stored procedure name |
Suite |
VARCHAR(128) |
Unit Test Suite |
HasSetup |
BIT (SQL Server)
BOOLEAN (Netezza)
CHAR(1) (Oracle)
|
Have setup procedure:
1 - SQL Server value
TRUE - Netezza value
Y - Oracle value
Do not have setup procedure:
0 - SQL Server value
FALSE - Netezza value
N - Oracle value
|
HasTeardown |
BIT (SQL Server)
BOOLEAN (Netezza)
CHAR(1) (Oracle)
|
Have teardown procedure:
1 - SQL Server value
TRUE - Netezza value
Y - Oracle value
Do not have teardown procedure:
0 - SQL Server value
FALSE - Netezza value
N - Oracle value
|
Ignore |
BIT (SQL Server)
BOOLEAN (Netezza)
CHAR(1) (Oracle) |
Test runner will ignore this test:
1 - SQL Server value
TRUE - Netezza value
Y - Oracle value
Test runner will run this test:
0 - SQL Server value
FALSE - Netezza value
N - Oracle value
|
IgnoreReason |
VARCHAR(500) (Netteza and SQL Server)
VARCHAR2(500) (Oracle)
|
The reason why this test is ignored by framework. |
UseTransaction |
BIT (SQL Server)
BOOLEAN (Netezza)
CHAR(1) (Oracle) |
Test runner will wrap test execution in to a transaction and will rollback transaction at the end of the test execution:
1 - SQL Server value
TRUE - Netezza value
Y - Oracle value
Test runner will NOT wrap test execution in to a transaction and will NOT rollback transaction at the end of the test execution:
0 - SQL Server value
FALSE - Netezza value
N - Oracle value
In case when column value is set to NULL the Test Runner will use (or will not NOT use) transaction base on its own discretion.
Note: This column is reserved in Netezza, because Netezza does not support transactions
|
SuiteSetupName |
VARCHAR(128) |
Name of the suite setup stored procedure |
SuiteTeardownName |
VARCHAR(128) |
Name of the suite teardown stored procedure |
SuiteSetupRunOnce |
BIT (SQL Server)
BOOLEAN (Netezza)
CHAR(1) (Oracle) |
Test runner will run setup stored procedure only once for the suite:
1 - SQL Server value
TRUE - Netezza value
Y - Oracle value
Test runner will run setup stored before every unit test in the suite:
0 - SQL Server value
FALSE - Netezza value
N - Oracle value
|
SuiteTeardownRunOnce |
BIT (SQL Server)
BOOLEAN (Netezza)
CHAR(1) (Oracle) |
Test runner will run teardown stored procedure only once for the suite:
1 - SQL Server value
TRUE - Netezza value
Y - Oracle value
Test runner will run teardown stored before every unit test in the suite:
0 - SQL Server value
FALSE - Netezza value
N - Oracle value
|
CompatibilityLevel |
INT |
Unit tests compatibility level as identified by framework when parsing stored procedure |
See Also