Home
Download
Blog
Support
Getting Started Guide
Documentation
Overview
Unit Tests
Unit Test Suites
Running Unit Tests
Fake Objects, Mocks and Stubs
Installation
Reference
Framework Procedures
DBTD_RUNTESTS
DBTD_RUNTESTSUITE
DBTD_RUNTESTSUITE_EXT
DBTD_REFRESH_TESTSLIST
DBTD_LOG_MESSAGE
DBTD_LOG_MESSAGE_EXT
DBTD_ERROR
DBTD_FAILURE
DBTD_RUNGLOBALSETUP
DBTD_RUNGLOBALTEARDOWN
DBTD_RUNONETEST_EXT
DBTD_GET_UnitTestRunID
DBTD_GET_UnitTestName
DBTD_PRINT_MESSAGE
Mocking
DBTD_CREATE_STUB_PROCEDURE
DBTD_CREATE_MOCK_PROCEDURE
DBTD_RESTORE_ORIGINAL_PROC
Assert Procedures
Asserting Singular Values
DBTD_ASSERT_ARE_EQUAL
DBTD_ASSERT_ARE_NOT_EQUAL
DBTD_ASSERT_INT_ARE_EQUAL
DBTD_ASSERT_IS_LESS_OR_EQUAL
DBTD_ASSERT_IS_GREATER
DBTD_ASSERT_DATETIME_IS_GREATER
DBTD_ASSERT_DATETIME_IS_GREATER_OR_EQUAL
DBTD_ASSERT_IS_TRUE
DBTD_ASSERT_IS_NOT_NULL
DBTD_ASSERT_IS_NOT_NULL_OR_EMPTY
DBTD_ASSERT_IS_NULL
DBTD_ASSERT_IS_NULL_OR_EMPTY
DBTD_ASSERT_MONEY_ARE_EQUAL
DBTD_ASSERT_DATETIME_ARE_EQUAL
DBTD_ASSERT_DATE_ARE_EQUAL
DBTD_ASSERT_FLOAT_ARE_EQUAL
DBTD_ASSERT_HIERARCHYID_ARE_EQUAL
DBTD_ASSERT_SQLVARIANT_ARE_EQUAL
DBTD_ASSERT_STRING_CONTAINS
DBTD_ASSERT_STRING_NOT_CONTAIN
DBTD_ASSERT_IS_GREATER_OR_EQUAL
Asserting Values in Multiple Records
DBTD_ASSERT_ROWSETS_ARE_EQUAL
DBTD_ASSERT_IS_EXPECTED_COUNT
DBTD_ASSERT_IS_NOT_EXPECTED_COUNT
DBTD_ASSERT_TABLE_HAS_RECORDS
DBTD_ASSERT_TABLE_HAS_NO_RECORDS
DBTD_ASSERT_IS_COLUMN_VALUE_UNIQUE
DBTD_ASSERT_COLUMN_HAVE_VALUE
DBTD_ASSERT_COLUMN_HAS_NO_VALUE
DBTD_ASSERT_SAME_NUMBER_OF_ROWS
DBTD_ASSERT_TABLES_ARE_EQUAL
DBTD_ASSERT_COLUMN_HAVE_NULLS
DBTD_ASSERT_COLUMN_HAS_NO_NULLS
Asserting results of Mocks or Stubs executions
DBTD_ASSERT_MOCK_EXISTS
DBTD_ASSERT_MOCK_NOT_EXISTS
DBTD_ASSERT_MOCK_NUMBER_OF_CALLS
DBTD_ASSERT_MOCK_CALLED_MORE_THAN
DBTD_ASSERT_MOCK_CALLED_LESS_THAN
DBTD_ASSERT_MOCK_CALLED
DBTD_ASSERT_MOCK_NOT_CALLED
DBTD_ASSERT_MOCK_CALLED_WITH_PARAM
DBTD_ASSERT_MOCK_NOT_CALLED_WITH_PARAM
DBTD_ASSERT_MOCK_CALLED_WITH_PARAMS
DBTD_ASSERT_STUB_EXISTS
DBTD_ASSERT_STUB_NOT_EXISTS
DBTD_ASSERT_STUB_NUMBER_OF_CALLS
DBTD_ASSERT_STUB_CALLED_MORE_THAN
DBTD_ASSERT_STUB_CALLED
DBTD_ASSERT_STUB_NOT_CALLED
DBTD_ASSERT_STUB_CALLED_LESS_THAN
DBTD_ASSERT_STUB_CALLED_WITH_PARAM
DBTD_ASSERT_STUB_NOT_CALLED_WITH_PARAM
DBTD_ASSERT_STUB_CALLED_WITH_PARAMS
DBTD_ASSERT_MOCK_NUMBER_OF_CALLS_SINCE_TIME
DDL Assertions
DBTD_ASSERT_TABLE_EXISTS
DBTD_ASSERT_TABLE_NOT_EXISTS
DBTD_ASSERT_VIEW_EXISTS
DBTD_ASSERT_VIEW_NOT_EXISTS
DBTD_ASSERT_TABLE_OR_VIEW_EXISTS
DBTD_ASSERT_PROC_NOT_EXISTS
DBTD_ASSERT_PROC_EXISTS
DBTD_ASSERT_COLUMN_EXISTS
DBTD_ASSERT_COLUMN_NOT_EXISTS
DBTD_ASSERT_COLUMN_IS_NULLABLE
DBTD_ASSERT_COLUMN_IS_NOT_NULLABLE
DBTD_ASSERT_COLUMN_TYPE
DBTD_ASSERT_COLUMN_TYPE_AND_PRECISION
DBTD_ASSERT_DB_EXISTS
DBTD_ASSERT_DB_NOT_EXISTS
DBTD_ASSERT_TRIGGER_EXISTS
DBTD_ASSERT_TRIGGER_NOT_EXISTS
DBTD_ASSERT_INDEX_EXISTS
DBTD_ASSERT_INDEX_NOT_EXISTS
DBTD_ASSERT_INDEX_CLUSTERED
DBTD_ASSERT_INDEX_NOT_CLUSTERED
DBTD_ASSERT_INDEX_UNIQUE
DBTD_ASSERT_INDEX_NOT_UNIQUE
DBTD_ASSERT_FUNC_NOT_EXISTS
DBTD_ASSERT_FUNC_EXISTS
DBTD_ASSERT_SYNONYM_NOT_EXISTS
DBTD_ASSERT_SYNONYM_EXISTS
DBTD_ASSERT_OBJECT_EXISTS
DBTD_ASSERT_OBJECT_NOT_EXISTS
DBTD_ASSERT_DEFAULT_CONSTRAINT
DBTD_ASSERT_INDEX_FILTERED
DBTD_ASSERT_INDEX_XML
DBTD_ASSERT_INDEX_SPATIAL
DBTD_ASSERT_INDEX_FULLTEXT
DBTD_ASSERT_INDEX_COLUMNSTORE
DBTD_ASSERT_PARAMETER_EXISTS
Permissions and Security Assertions
DBTD_ASSERT_USER_EXISTS
DBTD_ASSERT_USER_NOT_EXISTS
DBTD_ASSERT_ROLE_EXISTS
DBTD_ASSERT_ROLE_NOT_EXISTS
DBTD_ASSERT_LOGIN_EXISTS
DBTD_ASSERT_LOGIN_NOT_EXISTS
Miscellaneous Asserts
DBTD_ASSERT_WILL_FAIL
DBTD_ASSERT_WILL_SUCCEED
DBTD_ASSERT_FoundUniqueMessage
DBTD_ASSERT_NOTFoundUniqueMessage
Hint Procedures
DBTD_UNIT_TEST
DBTD_NOT_A_UNIT_TEST
DBTD_IGNORE
DBTD_RUN_ONCE
DBTD_USE_TRANSACTION
DBTD_DO_NOT_USE_TRANSACTION
DBTD_DO_NOT_USE_TRANSACTION_OVERRIDE
Framework Tables
DBTD_TBL_TESTSLIST
DBTD_TBL_LOG
DBTD_TBL_TESTRESULT
DBTD_TBL_TESTRESULT_DETAILS
DBTD_TBL_PRETEND_OBJECT_LOG
DBTD_TBL_PRETEND_OBJECT
DBTD_TBL_PRETEND_OBJECT_PARAM_LOG
DBTD_TBL_MANUAL_UNITTESTRUNID
DBTD_TBL_ACTIVETEST
Reporting
DBTD_VW_RPT_TeamCity
DBTD_VW_RPT_Jenkins
DBTD_REPORT
Code Coverage
DBTD_Statistics
DBTD_GET_AssertedObjects
DBTD_GET_CoverageDetails
DBTD_GET_CoverageExceptions
DBTD_GET_ExistingDatabaseObjects
DBTD_TBL_CODE_COVERAGE_EXCEPTIONS
DBTD_ADD_CODE_COVERAGE_EXCEPTION
DBTD_CREATE_SCHEMA_UNIT_TEST
DBTD_fnCoveragePercent
DBTD_GET_HTMLCoverageReport
Other Framework Objects
Access Management
DBTD_TBL_SERVER_ACCESS
DBTD_IS_SERVER_ACCESS_ALLOWED
DBTD_INTERFACE.IS_SERVER_ACCESS_ALLOWED
Tools
DBTD_DROP_TABLE_IF_EXISTS
DBTD_DROP_FUNC_IF_EXISTS
DBTD_DROP_VIEW_IF_EXISTS
DBTD_DROP_PROC_IF_EXISTS
DBTD_DROP_SEQUENCE_IF_EXISTS
DBTD_DROP_INDEX_IF_EXISTS
DBTD_DROP_TRIGGER_IF_EXISTS
DBTD_DROP_SCHEMA_IF_EXISTS
DBTD_DROP_SYNONYM_IF_EXISTS
DBTD_SPLIT_FOUR_PART_OBJECT_NAME
DBTD_SP_EXECUTESQL
DBTD_GET_OBJECT_ID
DBTD_PREPARE_FOUR_PART_OBJECT_NAME
DBTD_DROP_FULLTEXT_CATALOG_IF_EXISTS
DBTD_DROP_FULLTEXT_INDEX_IF_EXISTS
DBTD_fnSQLServerMajorProductVersion
DBTD_TBL_COLUMNS
DBTD_TBL_RPTPARAM
DBTD_TBL_RPT_REFTABLE
DBTD_TBL_LoadStatisticsTable
DBTD_SEQUENCE
DBTD_SAVESTATE
DBTD_INITIALIZE
DBTD_FINALIZE
DBTD_ParseRptParam
DBTD_DATATYPE
DBTD_VW_DATATYPE
DBTD_VW_COLUMNS
DBTD_IS_ROLE_FOUND
DBTD_IS_USE_TRAN_SET
DBTD_IS_DO_NOT_USE_TRAN_SET
DBTD_fnReplaceLineBreaksAndTabs
DBTD_fnRemoveFirstLineComment
DBTD_fnRemoveFirstBlockComment
DBTD_fnGetEndOfStringIndexForTheFirstString
DBTD_fnWhoIsFirst
DBTD_fnRemoveCommentsBeforeGivenString
DBTD_fnRemoveClosingBracket
DBTD_fnGetDefaultValue
DBTD_fnGetProcedureSignature
DBTD_fnGetSuiteName
DBTD_fnGetPretendObjectID
DBTD_fnGetFullTypeByID
DBTD_fnGetFullType
DBTD_fnUseDetailCommentMessage
DBTD_GET_OBJECT_DEFINITION
DBTD_GET_PretendObjectNumberOfCalls
DBTD_GET_PretendObjectNumberOfCallsWithParam
DBTD_GET_ParameterLogTable
DBTD_GET_COLUMN_LIST
DBTD_GET_ParameterList
DBTD_CACHE_TESTRESULT_DETAILS
DBTD_ExpectedParameterValues
DBTD_SEARCH_ObjectsDefinition
DBTD_GET_UnitTestIsIgnored
DBTD_CheckIndexExistence
DBTD_fnTeamCityParseEscapedValues
DBTD_CheckIndexExistence
DBTD_CheckIfProcIsPretendObject
Compatibility Pack
DB Test Driven Tool Kit
TestRunner
SetParameters
NZWSQL
NZWLOAD
Samples and Tutorials
Sample 01
Sample 02
Sample 03
Sample 04
Forum
Terms of Service
DB Test Driven
Skip over navigation
Database test driven development for everyone
Getting Started Guide
Documentation
Overview
Unit Tests
Unit Test Suites
Running Unit Tests
Fake Objects, Mocks and Stubs
Installation
Reference
Framework Procedures
DBTD_RUNTESTS
DBTD_RUNTESTSUITE
DBTD_RUNTESTSUITE_EXT
DBTD_REFRESH_TESTSLIST
DBTD_LOG_MESSAGE
DBTD_LOG_MESSAGE_EXT
DBTD_ERROR
DBTD_FAILURE
DBTD_RUNGLOBALSETUP
DBTD_RUNGLOBALTEARDOWN
DBTD_RUNONETEST_EXT
DBTD_GET_UnitTestRunID
DBTD_GET_UnitTestName
DBTD_PRINT_MESSAGE
Mocking
DBTD_CREATE_STUB_PROCEDURE
DBTD_CREATE_MOCK_PROCEDURE
DBTD_RESTORE_ORIGINAL_PROC
Assert Procedures
Asserting Singular Values
DBTD_ASSERT_ARE_EQUAL
DBTD_ASSERT_ARE_NOT_EQUAL
DBTD_ASSERT_INT_ARE_EQUAL
DBTD_ASSERT_IS_LESS_OR_EQUAL
DBTD_ASSERT_IS_GREATER
DBTD_ASSERT_DATETIME_IS_GREATER
DBTD_ASSERT_DATETIME_IS_GREATER_OR_EQUAL
DBTD_ASSERT_IS_TRUE
DBTD_ASSERT_IS_NOT_NULL
DBTD_ASSERT_IS_NOT_NULL_OR_EMPTY
DBTD_ASSERT_IS_NULL
DBTD_ASSERT_IS_NULL_OR_EMPTY
DBTD_ASSERT_MONEY_ARE_EQUAL
DBTD_ASSERT_DATETIME_ARE_EQUAL
DBTD_ASSERT_DATE_ARE_EQUAL
DBTD_ASSERT_FLOAT_ARE_EQUAL
DBTD_ASSERT_HIERARCHYID_ARE_EQUAL
DBTD_ASSERT_SQLVARIANT_ARE_EQUAL
DBTD_ASSERT_STRING_CONTAINS
DBTD_ASSERT_STRING_NOT_CONTAIN
DBTD_ASSERT_IS_GREATER_OR_EQUAL
Asserting Values in Multiple Records
DBTD_ASSERT_ROWSETS_ARE_EQUAL
DBTD_ASSERT_IS_EXPECTED_COUNT
DBTD_ASSERT_IS_NOT_EXPECTED_COUNT
DBTD_ASSERT_TABLE_HAS_RECORDS
DBTD_ASSERT_TABLE_HAS_NO_RECORDS
DBTD_ASSERT_IS_COLUMN_VALUE_UNIQUE
DBTD_ASSERT_COLUMN_HAVE_VALUE
DBTD_ASSERT_COLUMN_HAS_NO_VALUE
DBTD_ASSERT_SAME_NUMBER_OF_ROWS
DBTD_ASSERT_TABLES_ARE_EQUAL
DBTD_ASSERT_COLUMN_HAVE_NULLS
DBTD_ASSERT_COLUMN_HAS_NO_NULLS
Asserting results of Mocks or Stubs executions
DBTD_ASSERT_MOCK_EXISTS
DBTD_ASSERT_MOCK_NOT_EXISTS
DBTD_ASSERT_MOCK_NUMBER_OF_CALLS
DBTD_ASSERT_MOCK_CALLED_MORE_THAN
DBTD_ASSERT_MOCK_CALLED_LESS_THAN
DBTD_ASSERT_MOCK_CALLED
DBTD_ASSERT_MOCK_NOT_CALLED
DBTD_ASSERT_MOCK_CALLED_WITH_PARAM
DBTD_ASSERT_MOCK_NOT_CALLED_WITH_PARAM
DBTD_ASSERT_MOCK_CALLED_WITH_PARAMS
DBTD_ASSERT_STUB_EXISTS
DBTD_ASSERT_STUB_NOT_EXISTS
DBTD_ASSERT_STUB_NUMBER_OF_CALLS
DBTD_ASSERT_STUB_CALLED_MORE_THAN
DBTD_ASSERT_STUB_CALLED
DBTD_ASSERT_STUB_NOT_CALLED
DBTD_ASSERT_STUB_CALLED_LESS_THAN
DBTD_ASSERT_STUB_CALLED_WITH_PARAM
DBTD_ASSERT_STUB_NOT_CALLED_WITH_PARAM
DBTD_ASSERT_STUB_CALLED_WITH_PARAMS
DBTD_ASSERT_MOCK_NUMBER_OF_CALLS_SINCE_TIME
DDL Assertions
DBTD_ASSERT_TABLE_EXISTS
DBTD_ASSERT_TABLE_NOT_EXISTS
DBTD_ASSERT_VIEW_EXISTS
DBTD_ASSERT_VIEW_NOT_EXISTS
DBTD_ASSERT_TABLE_OR_VIEW_EXISTS
DBTD_ASSERT_PROC_NOT_EXISTS
DBTD_ASSERT_PROC_EXISTS
DBTD_ASSERT_COLUMN_EXISTS
DBTD_ASSERT_COLUMN_NOT_EXISTS
DBTD_ASSERT_COLUMN_IS_NULLABLE
DBTD_ASSERT_COLUMN_IS_NOT_NULLABLE
DBTD_ASSERT_COLUMN_TYPE
DBTD_ASSERT_COLUMN_TYPE_AND_PRECISION
DBTD_ASSERT_DB_EXISTS
DBTD_ASSERT_DB_NOT_EXISTS
DBTD_ASSERT_TRIGGER_EXISTS
DBTD_ASSERT_TRIGGER_NOT_EXISTS
DBTD_ASSERT_INDEX_EXISTS
DBTD_ASSERT_INDEX_NOT_EXISTS
DBTD_ASSERT_INDEX_CLUSTERED
DBTD_ASSERT_INDEX_NOT_CLUSTERED
DBTD_ASSERT_INDEX_UNIQUE
DBTD_ASSERT_INDEX_NOT_UNIQUE
DBTD_ASSERT_FUNC_NOT_EXISTS
DBTD_ASSERT_FUNC_EXISTS
DBTD_ASSERT_SYNONYM_NOT_EXISTS
DBTD_ASSERT_SYNONYM_EXISTS
DBTD_ASSERT_OBJECT_EXISTS
DBTD_ASSERT_OBJECT_NOT_EXISTS
DBTD_ASSERT_DEFAULT_CONSTRAINT
DBTD_ASSERT_INDEX_FILTERED
DBTD_ASSERT_INDEX_XML
DBTD_ASSERT_INDEX_SPATIAL
DBTD_ASSERT_INDEX_FULLTEXT
DBTD_ASSERT_INDEX_COLUMNSTORE
DBTD_ASSERT_PARAMETER_EXISTS
Permissions and Security Assertions
DBTD_ASSERT_USER_EXISTS
DBTD_ASSERT_USER_NOT_EXISTS
DBTD_ASSERT_ROLE_EXISTS
DBTD_ASSERT_ROLE_NOT_EXISTS
DBTD_ASSERT_LOGIN_EXISTS
DBTD_ASSERT_LOGIN_NOT_EXISTS
Miscellaneous Asserts
DBTD_ASSERT_WILL_FAIL
DBTD_ASSERT_WILL_SUCCEED
DBTD_ASSERT_FoundUniqueMessage
DBTD_ASSERT_NOTFoundUniqueMessage
Hint Procedures
DBTD_UNIT_TEST
DBTD_NOT_A_UNIT_TEST
DBTD_IGNORE
DBTD_RUN_ONCE
DBTD_USE_TRANSACTION
DBTD_DO_NOT_USE_TRANSACTION
DBTD_DO_NOT_USE_TRANSACTION_OVERRIDE
Framework Tables
DBTD_TBL_TESTSLIST
DBTD_TBL_LOG
DBTD_TBL_TESTRESULT
DBTD_TBL_TESTRESULT_DETAILS
DBTD_TBL_PRETEND_OBJECT_LOG
DBTD_TBL_PRETEND_OBJECT
DBTD_TBL_PRETEND_OBJECT_PARAM_LOG
DBTD_TBL_MANUAL_UNITTESTRUNID
DBTD_TBL_ACTIVETEST
Reporting
DBTD_VW_RPT_TeamCity
DBTD_VW_RPT_Jenkins
DBTD_REPORT
Code Coverage
DBTD_Statistics
DBTD_GET_AssertedObjects
DBTD_GET_CoverageDetails
DBTD_GET_CoverageExceptions
DBTD_GET_ExistingDatabaseObjects
DBTD_TBL_CODE_COVERAGE_EXCEPTIONS
DBTD_ADD_CODE_COVERAGE_EXCEPTION
DBTD_CREATE_SCHEMA_UNIT_TEST
DBTD_fnCoveragePercent
DBTD_GET_HTMLCoverageReport
Other Framework Objects
Access Management
DBTD_TBL_SERVER_ACCESS
DBTD_IS_SERVER_ACCESS_ALLOWED
DBTD_INTERFACE.IS_SERVER_ACCESS_ALLOWED
Tools
DBTD_DROP_TABLE_IF_EXISTS
DBTD_DROP_FUNC_IF_EXISTS
DBTD_DROP_VIEW_IF_EXISTS
DBTD_DROP_PROC_IF_EXISTS
DBTD_DROP_SEQUENCE_IF_EXISTS
DBTD_DROP_INDEX_IF_EXISTS
DBTD_DROP_TRIGGER_IF_EXISTS
DBTD_DROP_SCHEMA_IF_EXISTS
DBTD_DROP_SYNONYM_IF_EXISTS
DBTD_SPLIT_FOUR_PART_OBJECT_NAME
DBTD_SP_EXECUTESQL
DBTD_GET_OBJECT_ID
DBTD_PREPARE_FOUR_PART_OBJECT_NAME
DBTD_DROP_FULLTEXT_CATALOG_IF_EXISTS
DBTD_DROP_FULLTEXT_INDEX_IF_EXISTS
DBTD_fnSQLServerMajorProductVersion
DBTD_TBL_COLUMNS
DBTD_TBL_RPTPARAM
DBTD_TBL_RPT_REFTABLE
DBTD_TBL_LoadStatisticsTable
DBTD_SEQUENCE
DBTD_SAVESTATE
DBTD_INITIALIZE
DBTD_FINALIZE
DBTD_ParseRptParam
DBTD_DATATYPE
DBTD_VW_DATATYPE
DBTD_VW_COLUMNS
DBTD_IS_ROLE_FOUND
DBTD_IS_USE_TRAN_SET
DBTD_IS_DO_NOT_USE_TRAN_SET
DBTD_fnReplaceLineBreaksAndTabs
DBTD_fnRemoveFirstLineComment
DBTD_fnRemoveFirstBlockComment
DBTD_fnGetEndOfStringIndexForTheFirstString
DBTD_fnWhoIsFirst
DBTD_fnRemoveCommentsBeforeGivenString
DBTD_fnRemoveClosingBracket
DBTD_fnGetDefaultValue
DBTD_fnGetProcedureSignature
DBTD_fnGetSuiteName
DBTD_fnGetPretendObjectID
DBTD_fnGetFullTypeByID
DBTD_fnGetFullType
DBTD_fnUseDetailCommentMessage
DBTD_GET_OBJECT_DEFINITION
DBTD_GET_PretendObjectNumberOfCalls
DBTD_GET_PretendObjectNumberOfCallsWithParam
DBTD_GET_ParameterLogTable
DBTD_GET_COLUMN_LIST
DBTD_GET_ParameterList
DBTD_CACHE_TESTRESULT_DETAILS
DBTD_ExpectedParameterValues
DBTD_SEARCH_ObjectsDefinition
DBTD_GET_UnitTestIsIgnored
DBTD_CheckIndexExistence
DBTD_fnTeamCityParseEscapedValues
DBTD_CheckIndexExistence
DBTD_CheckIfProcIsPretendObject
Compatibility Pack
DB Test Driven Tool Kit
TestRunner
SetParameters
NZWSQL
NZWLOAD
Samples and Tutorials
Sample 01
Sample 02
Sample 03
Sample 04
Forum
Terms of Service
Compatibility Pack
Compatibility Pack includes:
Older and obsolete object used to minimize impact to your existing code;
Asserts procedure synonyms;
Add-on framework functional used to simplify migration of the unit tests from one database engine to another;
Home
Site Map
Search
Register
Sign In