<?php // Copyright 2014 Peter Beverloo. All rights reserved. // Use of this source code is governed by the MIT license, a copy of which can // be found in the LICENSE file. require_once __DIR__ . '/../../services/framework/Database.php'; require_once __DIR__ . '/../RssWriter.php'; $feed = new RssWriter(); $feed->setTitle('Chromium DevTools'); $feed->setDescription('Contains all revisions to the Chromium and Blink repositories mentioning "DevTools".'); $feed->setFeedLink('https://feeds.peter.sh/chrome-devtools/'); $feed->setLink('https://commits.peter.sh/'); $database = new Database(); $revisions = $database->query(' SELECT tracking_devtools.revision_sha, UNIX_TIMESTAMP(tracking_revisions.revision_date) AS revision_date, tracking_revisions.message, tracking_authors.author_name, tracking_projects.project_name, tracking_projects.repository_view FROM tracking_devtools LEFT JOIN tracking_revisions ON tracking_revisions.project_id = tracking_devtools.revision_project_id AND tracking_revisions.revision_sha = tracking_devtools.revision_sha LEFT JOIN tracking_authors ON tracking_authors.author_id = tracking_revisions.author_id LEFT JOIN tracking_projects ON tracking_projects.project_id = tracking_revisions.project_id ORDER BY