home / tests

builds

2 rows where job_id = 56

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ timestamp time build_id url repo branch sha host job_id
9316 1633726792207 313617.0 11976 https://integration.wikimedia.org/ci/job/mediawiki-quibble-vendor-postgres-php72-docker/11976/ mediawiki/core master df38f29f9bade2b5ef0adfec5537b900b65b6aa2 integration-agent-docker-1010 mediawiki-quibble-vendor-postgres-php72-docker 56
12073 1634228164237 390454.0 12035 https://integration.wikimedia.org/ci/job/mediawiki-quibble-vendor-postgres-php72-docker/12035/ mediawiki/core master 4cef0ca4ba52c8ae6d475472357c8fe77e363025 integration-agent-docker-1002 mediawiki-quibble-vendor-postgres-php72-docker 56

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