home / tests

builds

11 rows where job_id = 62

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: repo, branch, host

id ▼ timestamp time build_id url repo branch sha host job_id
13235 1637066039611 94665.0 2099 https://integration.wikimedia.org/ci/job/debian-glue/2099/ operations/software/tools-webservice master 20fc379fae373840ea89737d50f3b4e722365e56 integration-agent-pkgbuilder-1001 debian-glue 62
14516 1694550117415 2159891.0 2338 https://integration.wikimedia.org/ci/job/debian-glue/2338/ operations/debs/trafficserver master 6dd77a386f5f2055ef9f89bc5d98b937e313574a integration-agent-pkgbuilder-1001 debian-glue 62
14517 1694526183659 2191491.0 2337 https://integration.wikimedia.org/ci/job/debian-glue/2337/ operations/debs/trafficserver master 7461a8104c5afb8c51986f93c08b08a1bc0dfadb integration-agent-pkgbuilder-1001 debian-glue 62
14518 1694455875241 2184213.0 2336 https://integration.wikimedia.org/ci/job/debian-glue/2336/ operations/debs/trafficserver master 2c68eaa7ccd7cca4921087c148cf2443a4fc1aed integration-agent-pkgbuilder-1001 debian-glue 62
14519 1694007362207 165447.0 2335 https://integration.wikimedia.org/ci/job/debian-glue/2335/ operations/software/varnish/libvmod-re2 debian-6.0 13cd85ed19f22f994b3f7127e223465eacfb2521 integration-agent-pkgbuilder-1001 debian-glue 62
14520 1693966211724 162732.0 2334 https://integration.wikimedia.org/ci/job/debian-glue/2334/ operations/software/varnish/libvmod-re2 debian-6.0 06ca9eaa0a8798892422000a611c375f56cf0ea0 integration-agent-pkgbuilder-1002 debian-glue 62
15791 1698860560755 825398.0 2348 https://integration.wikimedia.org/ci/job/debian-glue/2348/ operations/debs/dnsdist master 576e80be496244c6ee06bb3e9e89fe975a6c30ae integration-agent-pkgbuilder-1001 debian-glue 62
23825 1722342472267 2075045.0 2351 https://integration.wikimedia.org/ci/job/debian-glue/2351/ operations/debs/trafficserver master b44acc5d3adb977bdd49263692fe24c523e6fa5b integration-agent-pkgbuilder-1003 debian-glue 62
23826 1722342466343 2078387.0 2350 https://integration.wikimedia.org/ci/job/debian-glue/2350/ operations/debs/trafficserver master f58c185cc5e47431a97df75a9911002115309b3f integration-agent-pkgbuilder-1004 debian-glue 62
25229 1743685982095 2686082.0 2367 https://integration.wikimedia.org/ci/job/debian-glue/2367/ operations/debs/trafficserver master 2761217f07d6d219649d4b5d2d5175a439725a61 integration-agent-pkgbuilder-1003 debian-glue 62
25230 1743628662048 2370085.0 2366 https://integration.wikimedia.org/ci/job/debian-glue/2366/ operations/debs/trafficserver master d783722b37519bb01947b709ba8ba46691d3b942 integration-agent-pkgbuilder-1004 debian-glue 62

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