builds
2 rows where job_id = 2
This data as json, CSV (advanced)
id ▼ | timestamp | time | build_id | url | repo | branch | sha | host | job_id |
---|---|---|---|---|---|---|---|---|---|
31 | 1620067135610 | 455706.0 | 17 | https://integration.wikimedia.org/ci/job/integration-quibble-apache-fullrun/17/ | integration/quibble | master | 0ecb4b04b240cfab8b95db11da07da0c94143ab8 | integration-agent-docker-1002 | integration-quibble-apache-fullrun 2 |
14543 | 1641362014998 | 178869.0 | 21 | https://integration.wikimedia.org/ci/job/integration-quibble-apache-fullrun/21/ | integration/quibble | master | 78b0ac48fb201bb0f9f43291a1a4806c0a472eb6 | integration-agent-docker-1016 | integration-quibble-apache-fullrun 2 |
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);