builds
2 rows where job_id = 23
This data as json, CSV (advanced)
id ▼ | timestamp | time | build_id | url | repo | branch | sha | host | job_id |
---|---|---|---|---|---|---|---|---|---|
681 | 1631164303317 | 226356.0 | 42 | https://integration.wikimedia.org/ci/job/quibble-fundraising-ParserFunctions-REL1_35-php73-docker/42/ | mediawiki/extensions/ParserFunctions | master | d9d8672cf94dfbe99b9ab5b42abf87a69012023e | integration-agent-docker-1011 | quibble-fundraising-ParserFunctions-REL1_35-php73-docker 23 |
5908 | 1633412830160 | 217813.0 | 43 | https://integration.wikimedia.org/ci/job/quibble-fundraising-ParserFunctions-REL1_35-php73-docker/43/ | mediawiki/extensions/ParserFunctions | master | befa3582f0555b51a354504bd15b47337ab53546 | integration-agent-docker-1008 | quibble-fundraising-ParserFunctions-REL1_35-php73-docker 23 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE builds ( id INTEGER PRIMARY KEY, timestamp INTEGER NOT NULL, time REAL NOT NULL, build_id INTEGER NOT NULL, url TEXT UNIQUE NOT NULL, repo TEXT NOT NULL, branch TEXT NOT NULL, sha TEXT NOT NULL, host TEXT NOT NULL, job_id INTEGER NOT NULL, UNIQUE(build_id,job_id), FOREIGN KEY(job_id) REFERENCES jobs(id) ); CREATE INDEX build_repo on builds(repo);