Skip to content

Instantly share code, notes, and snippets.

@MikeLing
Created February 6, 2016 05:23
Show Gist options
  • Save MikeLing/4f6a1c54e9177c8a39b9 to your computer and use it in GitHub Desktop.
Save MikeLing/4f6a1c54e9177c8a39b9 to your computer and use it in GitHub Desktop.
temporary script trying to query jobs
import sys
from mozci.query_jobs import TreeherderApi
from mozci.errors import TreeherderError
from argparse import ArgumentParser
SUCCESS, WARNING, FAILURE, SKIPPED, EXCEPTION, RETRY, CANCELLED = range(7)
def parse_args(argv=None):
parser = ArgumentParser()
parser.add_argument("-r", "--revision",
dest="rev",
type=str,
help="It's the revision we need to query job")
parser.add_argument("-repo", "--repo_name",
dest="repo",
type=str,
help="It's the repo name of revision")
options = parser.parse_args(argv)
return options
def main():
options = parse_args()
repo_name = options.repo
revision = options.rev
success_jobs = []
failed_jobs = []
query_api = TreeherderApi()
jobs = query_api.get_all_jobs(repo_name, revision)
for job in jobs:
try:
job_status = query_api.get_job_status(job)
except TreeherderError:
continue
if job_status == SUCCESS:
success_jobs.append(job)
elif job_status == FAILURE:
failed_jobs.append(job)
print success_jobs
print "+++++++++++++++++++++++++++++++++++++++++++++"
print failed_jobs
if __name__ == "__main__":
try:
main()
except KeyboardInterrupt:
sys.tracebacklimit = 0
sys.exit(0)
@MikeLing
Copy link
Author

MikeLing commented Feb 6, 2016

We can use it like

python mozci/scripts/temp.py --repo_name mozilla-inbound --revision 0c45f4062075

and I can got data like:

[{u'submit_timestamp': 1454729578, u'build_system_type': u'taskcluster', u'machine_name': u'i-a136d713', u'job_group_symbol': u'?', u'job_group_name': u'unknown', u'platform_option': u'opt', u'job_type_description': u'', u'signature': u'870c4af58f366405c43e1a9c5469dd7a9e90d625', u'result_set_id': 26417, u'result': u'success', u'machine_platform_os': u'-', u'ref_data_name': u'870c4af58f366405c43e1a9c5469dd7a9e90d625', u'machine_platform_architecture': u'-', u'end_timestamp': 1454729651, u'build_platform': u'gecko-decision', u'job_guid': u'06ed4474-b75b-4242-a945-cd081fbc8266/0', u'job_type_name': u'Initial decision task for mozilla-inbound specific graphs', u'id': 21192442, u'platform': u'gecko-decision', u'state': u'completed', u'job_type_id': 1106, u'build_os': u'-', u'option_collection_hash': u'102210fe594ee9b33d82058545b1ed14f4c8206e', u'who': u'mozilla-taskcluster-maintenance@mozilla.com', u'failure_classification_id': 1, u'job_type_symbol': u'D', u'reason': u'scheduled', u'job_group_description': u'fill me', u'tier': 1, u'job_coalesced_to_guid': None, u'running_eta': 209, u'start_timestamp': 1454729583, u'build_architecture': u'-', u'last_modified': u'2016-02-06T03:34:13', u'build_platform_id': 107, u'job_group_id': 2}, ........]
++++++++++++++++++++++++
[{u'submit_timestamp': 1454729629, u'build_system_type': u'taskcluster', u'machine_name': u'i-73e1b2f6', u'job_group_symbol': u'Nexus 4 KK', u'job_group_name': u'Nexus 4 Kitkat Device Image', u'platform_option': u'opt', u'job_type_description': u'', u'signature': u'f4b4a113954ca1520d57063c0ee1f2abe3f057b1', u'result_set_id': 26417, u'result': u'testfailed', u'machine_platform_os': u'-', u'ref_data_name': u'f4b4a113954ca1520d57063c0ee1f2abe3f057b1', u'machine_platform_architecture': u'-', u'end_timestamp': 1454730277, u'build_platform': u'b2g-device-image', u'job_guid': u'4e5c8e68-e757-4209-bda8-0276874284b3/0', u'job_type_name': u'[TC] B2G Nexus 4 KK User', u'id': 21192458, u'platform': u'b2g-device-image', u'state': u'completed', u'job_type_id': 3765, u'build_os': u'-', u'option_collection_hash': u'102210fe594ee9b33d82058545b1ed14f4c8206e', u'who': u'mozilla-taskcluster-maintenance@mozilla.com', u'failure_classification_id': 1, u'job_type_symbol': u'B', u'reason': u'scheduled', u'job_group_description': u'fill me', u'tier': 3, u'job_coalesced_to_guid': None, u'running_eta': 440, u'start_timestamp': 1454729836, u'build_architecture': u'-', u'last_modified': u'2016-02-06T03:44:39', u'build_platform_id': 92, u'job_group_id': 156}, {u'submit_timestamp': 1454729629, u'build_system_type': u'taskcluster', u'machine_name': u'i-3ae0b3bf', u'job_group_symbol': u'Nexus 4 KK', u'job_group_name': u'Nexus 4 Kitkat Device Image', u'platform_option': u'opt', u'job_type_description': u'', u'signature': u'3456ac8d07704802bb81abbb17a42104cf5ed207', u'result_set_id': 26417, u'result': u'testfailed', u'machine_platform_os': u'-', u'ref_data_name': u'3456ac8d07704802bb81abbb17a42104cf5ed207', u'machine_platform_architecture': u'-', u'end_timestamp': 1454730262, u'build_platform': u'b2g-device-image', u'job_guid': u'1857ee3d-aaa1-4740-baa9-269a8ca96250/0', u'job_type_name': u'[TC] B2G Nexus 4 KK Eng', u'id': 21192464, u'platform': u'b2g-device-image', u'state': u'completed', u'job_type_id': 3764, u'build_os': u'-', u'option_collection_hash': u'102210fe594ee9b33d82058545b1ed14f4c8206e', u'who': u'mozilla-taskcluster-maintenance@mozilla.com', u'failure_classification_id': 1, u'job_type_symbol': u'Be', u'reason': u'scheduled', u'job_group_description': u'fill me', u'tier': 3, u'job_coalesced_to_guid': None, u'running_eta': 570, u'start_timestamp': 1454729836, u'build_architecture': u'-', u'last_modified': u'2016-02-06T03:44:24', u'build_platform_id': 92, u'job_group_id': 156},...]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment