Title: [210578] trunk/Websites/perf.webkit.org
- Revision
- 210578
- Author
- rn...@webkit.org
- Date
- 2017-01-10 23:53:17 -0800 (Tue, 10 Jan 2017)
Log Message
Another build fix. Always use UTC when expressing commit times in UNIX-epoch timestamps.
* public/api/measurement-set.php:
Modified Paths
Diff
Modified: trunk/Websites/perf.webkit.org/ChangeLog (210577 => 210578)
--- trunk/Websites/perf.webkit.org/ChangeLog 2017-01-11 04:53:53 UTC (rev 210577)
+++ trunk/Websites/perf.webkit.org/ChangeLog 2017-01-11 07:53:17 UTC (rev 210578)
@@ -1,5 +1,11 @@
2017-01-10 Ryosuke Niwa <rn...@webkit.org>
+ Another build fix. Always use UTC when expressing commit times in UNIX-epoch timestamps.
+
+ * public/api/measurement-set.php:
+
+2017-01-10 Ryosuke Niwa <rn...@webkit.org>
+
Fix a typo in the previous commit.
* public/api/measurement-set.php:
Modified: trunk/Websites/perf.webkit.org/public/api/measurement-set.php (210577 => 210578)
--- trunk/Websites/perf.webkit.org/public/api/measurement-set.php 2017-01-11 04:53:53 UTC (rev 210577)
+++ trunk/Websites/perf.webkit.org/public/api/measurement-set.php 2017-01-11 07:53:17 UTC (rev 210578)
@@ -170,8 +170,8 @@
function execute_query($config_id) {
return $this->db->query('
SELECT test_runs.*, build_id, build_number, build_builder, build_time,
- array_agg((commit_id, commit_repository, commit_revision, extract(epoch from commit_time) * 1000)) AS revisions,
- extract(epoch from max(commit_time)) * 1000 AS revision_time, max(commit_order) AS revision_order
+ array_agg((commit_id, commit_repository, commit_revision, extract(epoch from commit_time at time zone \'utc\') * 1000)) AS revisions,
+ extract(epoch from max(commit_time at time zone \'utc\')) * 1000 AS revision_time, max(commit_order) AS revision_order
FROM builds
LEFT OUTER JOIN build_commits ON commit_build = build_id
LEFT OUTER JOIN commits ON build_commit = commit_id, test_runs
_______________________________________________
webkit-changes mailing list
webkit-changes@lists.webkit.org
https://lists.webkit.org/mailman/listinfo/webkit-changes
