builds
2 rows where job_id = 47
This data as json, CSV (advanced)
id ▼ | timestamp | time | build_id | url | repo | branch | sha | host | job_id |
---|---|---|---|---|---|---|---|---|---|
4785 | 1633337270195 | 119859.0 | 18323 | https://integration.wikimedia.org/ci/job/quibble-composer-mysql-php73-noselenium-docker/18323/ | mediawiki/extensions/BlueSpiceBookshelf | master | c10233caadd605eb9758c14cfea1c5f67204168b | integration-agent-docker-1004 | quibble-composer-mysql-php73-noselenium-docker 47 |
5693 | 1633396184802 | 160813.0 | 18469 | https://integration.wikimedia.org/ci/job/quibble-composer-mysql-php73-noselenium-docker/18469/ | mediawiki/extensions/LDAPProvider | master | 49dc377c322cdb3dbd7b3d71a13f65eab03d12e2 | integration-agent-docker-1020 | quibble-composer-mysql-php73-noselenium-docker 47 |
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);