builds
2 rows where job_id = 48
This data as json, CSV (advanced)
id ▼ | timestamp | time | build_id | url | repo | branch | sha | host | job_id |
---|---|---|---|---|---|---|---|---|---|
5008 | 1633350081272 | 145458.0 | 38189 | https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-php74-noselenium-docker/38189/ | mediawiki/extensions/CategoryTree | master | 1325c4e0a63b9f59539b900b2cf930dc67b417da | integration-agent-docker-1013 | quibble-vendor-mysql-php74-noselenium-docker 48 |
10046 | 1633780442231 | 122582.0 | 39334 | https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-php74-noselenium-docker/39334/ | mediawiki/extensions/UserThrottle | master | 4e52a8037f1614dab25ce1947f9d9e6dfd1a00ea | integration-agent-docker-1005 | quibble-vendor-mysql-php74-noselenium-docker 48 |
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);