Unreviewed. Fixed syntax errors.

* init-database.sql:
* public/api/commits.php:

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

diff --git a/Websites/perf.webkit.org/ChangeLog b/Websites/perf.webkit.org/ChangeLog
index c42213d..75743cf 100644 (file)
--- a/Websites/perf.webkit.org/ChangeLog
+++ b/Websites/perf.webkit.org/ChangeLog
@@ -1,5 +1,12 @@
 2014-11-21  Ryosuke Niwa  <rniwa@webkit.org>
 
+        Unreviewed. Fixed syntax errors.
+
+        * init-database.sql:
+        * public/api/commits.php:
+
+2014-11-21  Ryosuke Niwa  <rniwa@webkit.org>
+
         The dashboard on new perf monitor should be configurable
         https://bugs.webkit.org/show_bug.cgi?id=138994
 

diff --git a/Websites/perf.webkit.org/init-database.sql b/Websites/perf.webkit.org/init-database.sql
index ebc98ad..8f7968c 100644 (file)
--- a/Websites/perf.webkit.org/init-database.sql
+++ b/Websites/perf.webkit.org/init-database.sql
@@ -139,7 +139,7 @@ CREATE TABLE analysis_tasks (
     task_metric integer REFERENCES test_metrics NOT NULL,
     task_start_run integer REFERENCES test_runs,
     task_end_run integer REFERENCES test_runs,
-    CONSTRAINT analysis_task_should_be_unique_for_range UNIQUE(task_start_run, task_end_run)
+    CONSTRAINT analysis_task_should_be_unique_for_range UNIQUE(task_start_run, task_end_run),
     CONSTRAINT analysis_task_should_not_be_associated_with_single_run
         CHECK ((task_start_run IS NULL AND task_end_run IS NULL) OR (task_start_run IS NOT NULL AND task_end_run IS NOT NULL)));
 

diff --git a/Websites/perf.webkit.org/public/api/commits.php b/Websites/perf.webkit.org/public/api/commits.php
index 7679cd2..9f28762 100644 (file)
--- a/Websites/perf.webkit.org/public/api/commits.php
+++ b/Websites/perf.webkit.org/public/api/commits.php
@@ -66,8 +66,10 @@ function fetch_commits_between($db, $repository_id, $first, $second, $keyword =
     $values = array($repository_id);
 
     if ($first && $second) {
-        $first = commit_from_revision($db, $repository_id, $first)['commit_time'];
-        $second = commit_from_revision($db, $repository_id, $second)['commit_time'];
+        $fitrt_commit = commit_from_revision($db, $repository_id, $first);
+        $second_commit = commit_from_revision($db, $repository_id, $second);
+        $first = $fitrt_commit['commit_time'];
+        $second = $second_commit['commit_time'];
         $in_order = $first < $second;
         array_push($values, $in_order ? $first : $second);
         $statements .= ' AND commit_time >= $' . count($values);