home / tests

builds

8 rows where job_id = 66

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, sha, host

id ▼ timestamp time build_id url repo branch sha host job_id
14521 1695291124015 212761.0 231 https://integration.wikimedia.org/ci/job/debian-glue-backports/231/ operations/software/purged master 4046402765597ffacbd6f7cbe24a2564ae300f6d integration-agent-pkgbuilder-1001 debian-glue-backports 66
14522 1695283584969 209442.0 230 https://integration.wikimedia.org/ci/job/debian-glue-backports/230/ operations/software/purged master dd0de2842c52afe20351bdcbff494b5bac404de6 integration-agent-pkgbuilder-1001 debian-glue-backports 66
14523 1695233145321 214580.0 229 https://integration.wikimedia.org/ci/job/debian-glue-backports/229/ operations/software/purged master be22330454f436ed35b01b0e92cf1f85bfe3f502 integration-agent-pkgbuilder-1001 debian-glue-backports 66
14524 1695223418380 248372.0 228 https://integration.wikimedia.org/ci/job/debian-glue-backports/228/ operations/software/purged master 41a621a629fc0a9acf7057563177900ca96e0a43 integration-agent-pkgbuilder-1002 debian-glue-backports 66
15792 1696262081708 266715.0 236 https://integration.wikimedia.org/ci/job/debian-glue-backports/236/ operations/software/purged master 06dbaef5dff9530a849f0197129ed2b8967a7b16 integration-agent-pkgbuilder-1002 debian-glue-backports 66
23827 1720792649258 368844.0 238 https://integration.wikimedia.org/ci/job/debian-glue-backports/238/ operations/debs/helm3 master 5991bbe0010cc03401379b054ef97c342ef4a799 integration-agent-pkgbuilder-1001 debian-glue-backports 66
25231 1741335452466 806200.0 263 https://integration.wikimedia.org/ci/job/debian-glue-backports/263/ operations/debs/helmfile master fef47a4d060371166d5023e60c79d919772a1cb9 integration-agent-pkgbuilder-1004 debian-glue-backports 66
25232 1741285380412 797541.0 262 https://integration.wikimedia.org/ci/job/debian-glue-backports/262/ operations/debs/helmfile master fef47a4d060371166d5023e60c79d919772a1cb9 integration-agent-pkgbuilder-1003 debian-glue-backports 66

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