home / tests

builds

2 rows where job_id = 47

✎ View and edit SQL

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

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 287.434ms