builds

2 rows where job_id = 81

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ timestamp time build_id url repo branch sha host job_id
15221 1674179240654 133044.0 1 https://integration.wikimedia.org/ci/job/quibble-vendor-postgres-php74-docker/1/ mediawiki/skins/WikimediaApiPortal master 397ae048b0657d887218d52cb0d44c6117ec3f8a integration-agent-docker-1024 quibble-vendor-postgres-php74-docker 81
16630 1704225382212 221695.0 4 https://integration.wikimedia.org/ci/job/quibble-vendor-postgres-php74-docker/4/ mediawiki/skins/Vector master f8ffcd20d246003fb1de9ca891f9602d23f13a92 integration-agent-docker-1044 quibble-vendor-postgres-php74-docker 81

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);