home / tests

builds

2 rows where job_id = 48

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ timestamp time build_id url repo branch sha host job_id
5008 1633350081272 145458.0 38189 https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-php74-noselenium-docker/38189/ mediawiki/extensions/CategoryTree master 1325c4e0a63b9f59539b900b2cf930dc67b417da integration-agent-docker-1013 quibble-vendor-mysql-php74-noselenium-docker 48
10046 1633780442231 122582.0 39334 https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-php74-noselenium-docker/39334/ mediawiki/extensions/UserThrottle master 4e52a8037f1614dab25ce1947f9d9e6dfd1a00ea integration-agent-docker-1005 quibble-vendor-mysql-php74-noselenium-docker 48

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);
Powered by Datasette · Queries took 440.893ms