Author: Derick Rethans (derickr) Date: 2023-11-14T13:09:29Z Commit: https://github.com/php/web-qa/commit/19f539b5976b23b1d986eae69e36a60b8d71d588 Raw diff: https://github.com/php/web-qa/commit/19f539b5976b23b1d986eae69e36a60b8d71d588.diff
Fixed trailing whitespace Changed paths: M reports/run_tests.php Diff: diff --git a/reports/run_tests.php b/reports/run_tests.php index 2128c64..b742202 100644 --- a/reports/run_tests.php +++ b/reports/run_tests.php @@ -113,8 +113,8 @@ function outputTestReportsForVersion(string $getVersion) { // Do we add expected failed ? if (($_GET['expect'] ?? 0) == 1) { - $query = 'SELECT \'xfail\' as xfail, test_name,COUNT(expectedfail.id) as cpt,\'-\' as variations, - datetime(date) as date FROM expectedfail,reports WHERE expectedfail.id_report = reports.id + $query = 'SELECT \'xfail\' as xfail, test_name,COUNT(expectedfail.id) as cpt,\'-\' as variations, + datetime(date) as date FROM expectedfail,reports WHERE expectedfail.id_report = reports.id GROUP BY test_name ORDER BY cpt DESC LIMIT :limit'; $stmt = $database->prepare($query); $stmt->bindValue(':limit', $limit, SQLITE3_INTEGER); @@ -126,12 +126,12 @@ function outputTestReportsForVersion(string $getVersion) { } } - $query = 'SELECT failed.test_name,COUNT(failed.id) as cpt,COUNT(DISTINCT failed.diff) as variations, - datetime(reports.date) as date,success.id as success, r2.id as failedci FROM failed, reports + $query = 'SELECT failed.test_name,COUNT(failed.id) as cpt,COUNT(DISTINCT failed.diff) as variations, + datetime(reports.date) as date,success.id as success, r2.id as failedci FROM failed, reports LEFT JOIN success ON success.test_name=failed.test_name LEFT JOIN failed f2 ON (f2.test_name=failed.test_name AND f2.output = "") LEFT JOIN reports r2 ON (f2.id_report = r2.id AND r2.user_email="ciqa") - WHERE failed.id_report = reports.id + WHERE failed.id_report = reports.id GROUP BY failed.test_name ORDER BY cpt DESC LIMIT :limit'; $stmt = $database->prepare($query); $stmt->bindValue(':limit', $limit, SQLITE3_INTEGER);