Returns report in the requested format for specified list of Unit Test Suites
Note: At this point this is experimental procedure, we are planning to change it’s signature and return parameters base on the feedback from different databases. Please use DBTD_VW_RPT_TeamCity and DBTD_VW_RPT_Jenkins views to populate reports.
Arguments
-
v_ListOfSuits VARCHAR(MAX) - coma separated list of Unit Test Suites to include into the report, NULL or empty string will include all unit test suites in the report;
-
v_SuiteOwner VARCHAR(128) - suite owner (Reserved)
-
v_Format VARCHAR(128) - report format: JENKINS, TEAMCITY
Return Values
SQL Server
Returns query result with following columns RptLine, SectionOrder, SuiteOrder, TestOrder
Netezza
Returns table with following columns RptLine, SectionOrder, SuiteOrder, TestOrder
Oracle
Returns SYS_REFCURSOR with name v_Report_Cursor that have following data columns RptLine, SectionOrder, SuiteOrder, TestOrder
Note: you must close v_Result_Cursor after consuming repot data
Examples
SQL Server
INSERT INTO tbl_Report (Record, SectionOrder, SuiteOrder, TestOrder)
EXEC DBTD_REPORT 'Suite1,Suite2','', 'TEAMCITY';
SELECT Record
FROM tbl_Report
ORDER BY SectionOrder ASC, SuiteOrder ASC, TestOrder ASC;
Oracle
CALL DBTD_REPORT ('TEST, TEST1','', 'JENKINS', v_Result_Cursor);
LOOP
FETCH v_Result_Cursor
INTO v_Report_Line, v_SectionOrder,v_SuiteOrder, v_TestOrder;
EXIT WHEN v_Result_Cursor%NOTFOUND;
--DBMS_OUTPUT.PUT_LINE(v_Report_Line);
INSERT INTO tmp_Report (Record, SectionOrder, SuiteOrder, TestOrder)
VALUES(v_Report_Line, v_SectionOrder, v_SuiteOrder, v_TestOrder);
END LOOP;
CLOSE v_Result_Cursor;
SELECT Record
FROM tmp_Report
ORDER BY SectionOrder ASC, SuiteOrder ASC, TestOrder ASC;
Netezza
INSERT INTO tmp_Report (Record, SectionOrder, SuiteOrder, TestOrder)
SELECT DBTD_REPORT ('TEST, TEST1 ','', 'TEAMCITY');
SELECT Record
FROM tmp_Report
ORDER BY SectionOrder ASC, SuiteOrder ASC, TestOrder ASC;
See Also