home / tests

builds

3 rows where job_id = 49

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ timestamp time build_id url repo branch sha host job_id
5573 1633390340848 149094.0 112138 https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-php72-noselenium-docker/112138/ mediawiki/extensions/GoogleAnalyticsMetrics master d5d70492d3ecdb228254921f7a5367750a03e552 integration-agent-docker-1004 quibble-vendor-mysql-php72-noselenium-docker 49
5909 1633411322768 110866.0 112415 https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-php72-noselenium-docker/112415/ mediawiki/extensions/PageExchange master 80ce5139d663f8813b1bd702787ea18e134328a0 integration-agent-docker-1016 quibble-vendor-mysql-php72-noselenium-docker 49
5987 1633415244275 119669.0 112494 https://integration.wikimedia.org/ci/job/quibble-vendor-mysql-php72-noselenium-docker/112494/ mediawiki/extensions/PipeEscape master 6a8f4bfa0ca729c8c6c411b67b599564a744f8e2 integration-agent-docker-1008 quibble-vendor-mysql-php72-noselenium-docker 49

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