builds
1 row where job_id = 86
This data as json, CSV (advanced)
id ▼ | timestamp | time | build_id | url | repo | branch | sha | host | job_id |
---|---|---|---|---|---|---|---|---|---|
16631 | 1703892504836 | 225577.0 | 3 | https://integration.wikimedia.org/ci/job/quibble-vendor-sqlite-php74-docker/3/ | mediawiki/skins/WikimediaApiPortal | master | e159d3225d0023e2f91fc47d081d913fc21d2735 | integration-agent-docker-1047 | quibble-vendor-sqlite-php74-docker 86 |
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);