builds
1 row where job_id = 57
This data as json, CSV (advanced)
id ▼ | timestamp | time | build_id | url | repo | branch | sha | host | job_id |
---|---|---|---|---|---|---|---|---|---|
10045 | 1633780442082 | 123455.0 | 40820 | https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-php73-noselenium-docker/40820/ | mediawiki/extensions/UserThrottle | master | 4e52a8037f1614dab25ce1947f9d9e6dfd1a00ea | integration-agent-docker-1009 | quibble-vendor-mysql-php73-noselenium-docker 57 |
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);