home / tests

builds

2 rows where job_id = 23

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ timestamp time build_id url repo branch sha host job_id
681 1631164303317 226356.0 42 https://integration.wikimedia.org/ci/job/quibble-fundraising-ParserFunctions-REL1_35-php73-docker/42/ mediawiki/extensions/ParserFunctions master d9d8672cf94dfbe99b9ab5b42abf87a69012023e integration-agent-docker-1011 quibble-fundraising-ParserFunctions-REL1_35-php73-docker 23
5908 1633412830160 217813.0 43 https://integration.wikimedia.org/ci/job/quibble-fundraising-ParserFunctions-REL1_35-php73-docker/43/ mediawiki/extensions/ParserFunctions master befa3582f0555b51a354504bd15b47337ab53546 integration-agent-docker-1008 quibble-fundraising-ParserFunctions-REL1_35-php73-docker 23

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