Report run id's in api/runs.php for the new dashboard UI

https://bugs.webkit.org/show_bug.cgi?id=135813

Reviewed by Andreas Kling.

Include run_id in the generated JSON.

* public/api/runs.php:
(fetch_runs_for_config): Don't sort results by time since that has been done in the front end for ages now.
(format_run):

git-svn-id: https://svn.webkit.org/repository/webkit/trunk@172411 268f45cc-cd09-0410-ab3c-d52691b4dbfc

diff --git a/Websites/perf.webkit.org/ChangeLog b/Websites/perf.webkit.org/ChangeLog
index eaaaa84268a99616d2eaf059f36f4dcfaa987600..8daef6469975c7049b0a043f16daf1337feb959d 100644 (file)
--- a/Websites/perf.webkit.org/ChangeLog
+++ b/Websites/perf.webkit.org/ChangeLog
@@ -1,3 +1,16 @@
+2014-08-11  Ryosuke Niwa  <rniwa@webkit.org>
+
+        Report run id's in api/runs.php for the new dashboard UI
+        https://bugs.webkit.org/show_bug.cgi?id=135813
+
+        Reviewed by Andreas Kling.
+
+        Include run_id in the generated JSON.
+
+        * public/api/runs.php:
+        (fetch_runs_for_config): Don't sort results by time since that has been done in the front end for ages now.
+        (format_run):
+
 2014-08-11  Ryosuke Niwa  <rniwa@webkit.org>
 
         Merging platforms mixes baselines and targets into reported data

diff --git a/Websites/perf.webkit.org/public/api/runs.php b/Websites/perf.webkit.org/public/api/runs.php
index 76223c487e71cc7fd0d57e4925574ff997107ad8..7494dc4abe8fb3ebbb6699539bc6910a829b18e5 100644 (file)
--- a/Websites/perf.webkit.org/public/api/runs.php
+++ b/Websites/perf.webkit.org/public/api/runs.php
@@ -35,8 +35,7 @@ function fetch_runs_for_config($db, $config) {
         WHERE run_build = build_id AND run_config = $1
         GROUP BY build_id, build_builder, build_number, build_time, build_latest_revision,
             run_id, run_config, run_build, run_iteration_count_cache,
-            run_mean_cache, run_sum_cache, run_square_sum_cache
-        ORDER BY build_latest_revision, build_time', array($config['config_id']));
+            run_mean_cache, run_sum_cache, run_square_sum_cache', array($config['config_id']));
 
     $formatted_runs = array();
     if (!$raw_runs)
@@ -67,6 +66,7 @@ function parse_revisions_array($postgres_array) {
 
 function format_run($run) {
     return array(
+        'id' => intval($run['run_id']),
         'mean' => floatval($run['run_mean_cache']),
         'iterationCount' => intval($run['run_iteration_count_cache']),
         'sum' => floatval($run['run_sum_cache']),