625178 - buildapi should show which changes have gone through our systems

Status: RESOLVED WORKSFORME

(Release Engineering :: General, defect, P5)

Description

[Armen [:armenzg]]

I would like to see in a page every change that we pick up.

date - HH:MM mozilla-central/9217634f7b9e
date - HH:MM mobile-browser/1234534f7b9e
date - HH:MM l10n-central/ABCDE34f7b9e

Each one of them should have a link to their list of jobs associated to that changeset. Pretty much to send us to the currently existing page we have in buildapi:
> build.m.o/buildapi/revision/try/9eef3607035d

Comment 1

[Nick Thomas [:nthomas] (UTC+12)]

Might be slightly complicated to get the data from the db for this. ie you can use the sourcestamps table but need to exclude 'branches' which are *talos and *unittest (from sendchanges), and deal with duplicated sourcestamps for any revision (more than one poller for branches that trigger mobile builds). Then you can join back to changes (via sourcestamp_changes) to get changes.whentimestamp. IIRC that's the timestamp in hg rather than when we picked it up.

To make this really useful you probably want some sort of green/orange/red/purple counts for each revision. Would add lots more querying and would impact page load time. anamarias knows about this stuff.

Comment 2

[Chris Cooper [:coop] (he/him)]

This sounds like TBPL or treeherder.