[index] [test runs] [test cases] [failed tests]
query($sql); if ($q) { foreach ($q as $row) { $tests[$row['test']] = $row['description']; } } $sql = "SELECT test, COUNT(*) AS num, SUM(LIKE(result, 'PASS')) AS pass, SUM(LIKE(result, 'FAIL')) AS fail FROM results GROUP BY test ORDER BY test"; $q = $db->query($sql); if (!$q) die("Test cases names could not be fetched"); echo "\n"; echo "\n"; $prev = ""; $alt = false; foreach ($q as $row) { if ($alt) echo ''; else echo ''; $alt = !$alt; echo '"; $pass = intval($row['pass']); $fail = intval($row['fail']); if ($pass + $fail == 0) echo ""; else { $rate = 100 * $pass / ($pass + $fail); if ($rate > 95) echo '"; } echo '"; echo ""; echo "\n"; } echo "
testpass ratecountdescription
' . $row['test'] . "N/A 50) echo '' . (int) (100 * $pass / ($pass + $fail)) . " %' . $row['num'] . ""; if (array_key_exists($row['test'], $tests)) echo $tests[$row['test']]; echo "
\n"; ?>