Websites/test-results/api/results.php

   1 <?php
   2
   3 require_once('../include/json-shared.php');
   4 require_once('../include/test-results.php');
   5
   6 $db = connect();
   7
   8 require_existence_of($_GET, array('test' => '/[A-Za-z0-9\._\- ]+/'));
   9
  10 $test = $db->select_first_row('tests', NULL, array('name' => $_GET['test']));
  11 if (!$test)
  12     exit_with_error('TestNotFound');
  13
  14 $result_rows = $db->query_and_fetch_all(
  15 'SELECT results.*, builds.*, array_agg((build_revisions.repository, build_revisions.value, build_revisions.time)) AS revisions
  16     FROM results, builds, build_revisions
  17     WHERE build_revisions.build = builds.id AND results.build = builds.id AND results.test = $1
  18     GROUP BY results.id, builds.id', array($test['id']));
  19 if (!$result_rows)
  20     exit_with_error('ResultsNotFound');
  21
  22 exit_with_success(format_result_rows($result_rows));
  23
  24 ?>