home / tests

builds

7 rows where branch = "debian"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, host

id ▼ timestamp time build_id url repo branch sha host job_id
14526 1692055794404 92321.0 3199 https://integration.wikimedia.org/ci/job/debian-glue-non-voting/3199/ operations/software/acme-chief debian 16fb1d1ac2b787029d43f9b212fbc41fceb0ecd6 integration-agent-pkgbuilder-1001 debian-glue-non-voting 63
15793 1701945743520 65931.0 3217 https://integration.wikimedia.org/ci/job/debian-glue-non-voting/3217/ operations/software/debmonitor debian 28451e6abbd1d730feebed27e3f868d64cdf6d70 integration-agent-pkgbuilder-1001 debian-glue-non-voting 63
17157 1706182085992 75494.0 3257 https://integration.wikimedia.org/ci/job/debian-glue-non-voting/3257/ operations/software/debmonitor-client debian 690142da42c2cb50725148cd499dba4c84b1dca9 integration-agent-pkgbuilder-1002 debian-glue-non-voting 63
17158 1706181931784 52713.0 3256 https://integration.wikimedia.org/ci/job/debian-glue-non-voting/3256/ operations/software/debmonitor-client debian a2953934989fc8a4160fb81983c69e132098efe8 integration-agent-pkgbuilder-1001 debian-glue-non-voting 63
17159 1706119336431 78067.0 3252 https://integration.wikimedia.org/ci/job/debian-glue-non-voting/3252/ operations/software/debmonitor-client debian 8306790a04a055d3376a077947dc19c923350294 integration-agent-pkgbuilder-1001 debian-glue-non-voting 63
18511 1707306085542 85581.0 3268 https://integration.wikimedia.org/ci/job/debian-glue-non-voting/3268/ operations/software/debmonitor-client debian 7202e8299dd06845e06daac638b8ad355d011e36 integration-agent-pkgbuilder-1001 debian-glue-non-voting 63
23828 1723112819782 55953.0 3309 https://integration.wikimedia.org/ci/job/debian-glue-non-voting/3309/ operations/software/debmonitor-client debian 860fd8dfe4a6257fffeae0162c0c89085bbba26a integration-agent-pkgbuilder-1003 debian-glue-non-voting 63

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