home / tests

builds

2 rows where job_id = 2

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ timestamp time build_id url repo branch sha host job_id
31 1620067135610 455706.0 17 https://integration.wikimedia.org/ci/job/integration-quibble-apache-fullrun/17/ integration/quibble master 0ecb4b04b240cfab8b95db11da07da0c94143ab8 integration-agent-docker-1002 integration-quibble-apache-fullrun 2
14543 1641362014998 178869.0 21 https://integration.wikimedia.org/ci/job/integration-quibble-apache-fullrun/21/ integration/quibble master 78b0ac48fb201bb0f9f43291a1a4806c0a472eb6 integration-agent-docker-1016 integration-quibble-apache-fullrun 2

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