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