builds
2 rows where job_id = 56
This data as json, CSV (advanced)
id ▼ | timestamp | time | build_id | url | repo | branch | sha | host | job_id |
---|---|---|---|---|---|---|---|---|---|
9316 | 1633726792207 | 313617.0 | 11976 | https://integration.wikimedia.org/ci/job/mediawiki-quibble-vendor-postgres-php72-docker/11976/ | mediawiki/core | master | df38f29f9bade2b5ef0adfec5537b900b65b6aa2 | integration-agent-docker-1010 | mediawiki-quibble-vendor-postgres-php72-docker 56 |
12073 | 1634228164237 | 390454.0 | 12035 | https://integration.wikimedia.org/ci/job/mediawiki-quibble-vendor-postgres-php72-docker/12035/ | mediawiki/core | master | 4cef0ca4ba52c8ae6d475472357c8fe77e363025 | integration-agent-docker-1002 | mediawiki-quibble-vendor-postgres-php72-docker 56 |
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);