DBTD_ASSERT_FoundUniqueMessage

This is one of the miscellaneous assert procedures that is used to test framework functionality. This assert procedure will execute an assert procedure that is being tested and will verify that tested assert will fail and report the message into the DBTD_TBL_LOG table. If expected log message is not found this assert will fail.

Arguments

v_Test_Name - Name of the unit test that executes this assert, VARCHAR(500)

v_Assert_Name – name of the assert procedure that need to be tested, VARCHAR(500)

v_SQL - the SQL command that call assert without user message, NVARCHAR(MAX). The user message will be generated automatically to ensure uniqueness across all records in the log

v_Verbose - Default value is NULL, when value set to 1 procedure will return a select statement that will pull all relevant log records for troubleshooting purposes. SMALLINT