home / tests

jobs

1 row where "timestamp" is on date 2022-03-08

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: timestamp (date)

id ▼ name url job_name timestamp duration builtOn result BASE_LOG_PATH ZUUL_PIPELINE ZUUL_UUID LOG_PATH ZUUL_VOTING ZUUL_CHANGE_IDS ZUUL_PATCHSET ZUUL_BRANCH ZUUL_REF ZUUL_COMMIT ZUUL_URL ZUUL_CHANGE ZUUL_CHANGES ZUUL_PROJECT PLIB_PIPELINE DOC_SUBPATH DOC_BASENAME DOC_PROJECT RELEASE_VERSION DISPLAY UUID MW_COMPOSER_MERGE_MW_IN_VENDOR TRIGGERED_SSH_CONNECTION TRIGGERED_JOB_NAME THING_SUBNAME EXT_DEPENDENCIES SKIN_DEPENDENCIES EXT_NAME TRIGGERED_WORKSPACE SERVICE_NAME PUPPETEER_SKIP_CHROMIUM_DOWNLOAD ZUUL_NEWREV ZUUL_REFNAME ZUUL_OLDREV COMPOSER_PROCESS_TIMEOUT BUILD_TIMEOUT BACKPORTS DEB_BUILD_OPTIONS PBUILDER_USENETWORK EXECUTION_TIMEOUT_SECONDS CLEANUP_PERCENTAGE OFFLINE_PERCENTAGE TARGET_NODE SKIN_NAME NUM_THREADS GERRIT_CHANGE_NUMBER GERRIT_PRIVATE_CHANGE_NUMBER LIST_OF_NODES FAIL_FAST COMPILER_MODE projectName WMF_CI_PUB_DEST WMF_CI_PUB_DOCROOT WMF_CI_SRC PUBLISHER_PATH WMF_JENKINS_BEACON_URL MEDIAWIKI_USER MW_SCRIPT_PATH MW_SERVER NPM_CONFIG_cache
81 quibble-vendor-postgres-php74-docker https://integration.wikimedia.org/ci/job/trigger-service-scaffold-node-pipeline-test/81/ trigger-service-scaffold-node-pipeline-test 2022-03-08T17:38:15.243000 214034 contint2001 SUCCESS 44/768044/2 test 12825e0e8ba74d1bab89b9384634e8c6 44/768044/2/test/trigger-service-scaffold-node-pipeline-test/12825e0 1 763723,8 763836,7 763917,1 763948,2 763275,36 768044,2 2 main refs/zuul/main/Zc8da96a361ac4a7281afdfacdb6048c6 38e2edf3198c297f8bd9e26d75ff8eef87cd765f git://contint1001.wikimedia.org 768044 mediawiki/services/service-scaffold-node:main:refs/changes/23/763723/8^mediawiki/services/service-scaffold-node:main:refs/changes/36/763836/7^mediawiki/services/service-scaffold-node:main:refs/changes/17/763917/1^mediawiki/services/service-scaffold-node:main:refs/changes/48/763948/2^mediawiki/services/service-scaffold-node:main:refs/changes/75/763275/36^mediawiki/services/service-scaffold-node:main:refs/changes/44/768044/2 mediawiki/services/service-scaffold-node               1                                                                            

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE jobs (
            id INTEGER PRIMARY KEY,
            name TEXT UNIQUE NOT NULL,
            url TEXT UNIQUE NOT NULL
        , [job_name] TEXT, [timestamp] TEXT, [duration] INTEGER, [builtOn] TEXT, [result] TEXT, [BASE_LOG_PATH] TEXT, [ZUUL_PIPELINE] TEXT, [ZUUL_UUID] TEXT, [LOG_PATH] TEXT, [ZUUL_VOTING] TEXT, [ZUUL_CHANGE_IDS] TEXT, [ZUUL_PATCHSET] TEXT, [ZUUL_BRANCH] TEXT, [ZUUL_REF] TEXT, [ZUUL_COMMIT] TEXT, [ZUUL_URL] TEXT, [ZUUL_CHANGE] TEXT, [ZUUL_CHANGES] TEXT, [ZUUL_PROJECT] TEXT, [PLIB_PIPELINE] TEXT, [DOC_SUBPATH] TEXT, [DOC_BASENAME] TEXT, [DOC_PROJECT] TEXT, [RELEASE_VERSION] TEXT, [DISPLAY] TEXT, [UUID] TEXT, [MW_COMPOSER_MERGE_MW_IN_VENDOR] TEXT, [TRIGGERED_SSH_CONNECTION] TEXT, [TRIGGERED_JOB_NAME] TEXT, [THING_SUBNAME] TEXT, [EXT_DEPENDENCIES] TEXT, [SKIN_DEPENDENCIES] TEXT, [EXT_NAME] TEXT, [TRIGGERED_WORKSPACE] TEXT, [SERVICE_NAME] TEXT, [PUPPETEER_SKIP_CHROMIUM_DOWNLOAD] TEXT, [ZUUL_NEWREV] TEXT, [ZUUL_REFNAME] TEXT, [ZUUL_OLDREV] TEXT, [COMPOSER_PROCESS_TIMEOUT] TEXT, [BUILD_TIMEOUT] TEXT, [BACKPORTS] TEXT, [DEB_BUILD_OPTIONS] TEXT, [PBUILDER_USENETWORK] TEXT, [EXECUTION_TIMEOUT_SECONDS] TEXT, [CLEANUP_PERCENTAGE] TEXT, [OFFLINE_PERCENTAGE] TEXT, [TARGET_NODE] TEXT, [SKIN_NAME] TEXT, [NUM_THREADS] TEXT, [GERRIT_CHANGE_NUMBER] TEXT, [GERRIT_PRIVATE_CHANGE_NUMBER] TEXT, [LIST_OF_NODES] TEXT, [FAIL_FAST] TEXT, [COMPILER_MODE] TEXT, [projectName] TEXT, [WMF_CI_PUB_DEST] TEXT, [WMF_CI_PUB_DOCROOT] TEXT, [WMF_CI_SRC] TEXT, [PUBLISHER_PATH] TEXT, [WMF_JENKINS_BEACON_URL] TEXT, [MEDIAWIKI_USER] TEXT, [MW_SCRIPT_PATH] TEXT, [MW_SERVER] TEXT, [NPM_CONFIG_cache] TEXT);
Powered by Datasette · Queries took 346.675ms