builds
2 rows where job_id = 50
This data as json, CSV (advanced)
id ▼ | timestamp | time | build_id | url | repo | branch | sha | host | job_id |
---|---|---|---|---|---|---|---|---|---|
5680 | 1633397109537 | 106253.0 | 11977 | https://integration.wikimedia.org/ci/job/mediawiki-quibble-vendor-sqlite-php72-docker/11977/ | mediawiki/core | master | efde109e5f0ea1c62824a26b8717cad3c430ee3e | integration-agent-docker-1011 | mediawiki-quibble-vendor-sqlite-php72-docker 50 |
12074 | 1634228163813 | 390794.0 | 12121 | https://integration.wikimedia.org/ci/job/mediawiki-quibble-vendor-sqlite-php72-docker/12121/ | mediawiki/core | master | 4cef0ca4ba52c8ae6d475472357c8fe77e363025 | integration-agent-docker-1012 | mediawiki-quibble-vendor-sqlite-php72-docker 50 |
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);