Coverage statistics sql requests - Tanaguru/KBAccess GitHub Wiki

###Criteria with 0 testcase

SELECT cr.CD_CRITERION, cr.LABEL INTO OUTFILE '/tmp/sql_criterion_no_testcases.csv' FROM criterion cr WHERE cr.ID_CRITERION NOT IN (SELECT tc.ID_CRITERION FROM testcase AS tc) GROUP BY cr.CD_CRITERION;

###Number of testcases per criterion

SELECT cr.CD_CRITERION, cr.LABEL, COUNT(tc.ID_TESTCASE) AS testcaseCount INTO OUTFILE '/tmp/sql_criterion_nb_testcases.csv' FROM criterion cr LEFT JOIN testcase AS tc ON tc.ID_CRITERION = cr.ID_CRITERION GROUP BY cr.ID_CRITERION ORDER BY cr.CD_CRITERION, testcaseCount;

###Number of testcases per test

SELECT t.CD_TEST, t.LABEL, COUNT(tctr.ID_TESTCASE) AS testcaseCount INTO OUTFILE '/tmp/sql_test_nb_testcases.csv' FROM test t LEFT JOIN test_result tr ON t.ID_TEST = tr.ID_TEST LEFT JOIN testcase_test_result tctr ON tctr.ID_TEST_RESULT = tr.ID_TEST_RESULT GROUP BY t.CD_TEST ORDER BY t.CD_TEST;

###Number of testcases per webarchive SELECT wa.URL, COUNT(tc.ID_TESTCASE) AS testcaseCount, GROUP_CONCAT(CONCAT(' ', t.LABEL)) AS tests INTO OUTFILE '/tmp/sql_webarchive_nb_testcases.csv' FROM webarchive wa LEFT JOIN testcase tc ON tc.ID_WEBARCHIVE = wa.ID_WEBARCHIVE JOIN testcase_test_result tctr JOIN test_result tr JOIN test t WHERE tc.ID_TESTCASE = tctr.ID_TESTCASE AND tctr.ID_TEST_RESULT = tr.ID_TEST_RESULT AND tr.ID_TEST = t.ID_TEST GROUP BY wa.ID_WEBARCHIVE ORDER BY testcaseCount DESC

###Webarchives with 0 testcase SELECT wa.ID_WEBARCHIVE, wa.URL INTO OUTFILE '/tmp/sql_webarchive_no_testcases.csv' FROM webarchive wa WHERE wa.ID_WEBARCHIVE NOT IN (SELECT tc.ID_WEBARCHIVE FROM testcase AS tc);