一面睛、寫在前面

公司每天早晨站立會時絮蒿，都需要測試人員報告一下目前的bug情況，包括待辦叁鉴、測試中土涝、完成的數(shù)量，以及各個開發(fā)端：ios幌墓、android但壮、api....的情況。

于是測試人員每天早晨到公司后都需要做這樣的事：統(tǒng)計一下到今天早晨為止常侣，bug的情況蜡饵。這樣的事做一次還好，如果每天都做胳施，真是一件費時的事......

如果能寫一個程序溯祸，每天只需要運行一下程序，就能把想要的數(shù)據(jù)統(tǒng)計好舞肆，這樣會不會更好些呢焦辅？

這次要說的是使用python統(tǒng)計jira上的bug數(shù)據(jù)

二、程序運行結(jié)果

程序運行后出現(xiàn)了我想要的統(tǒng)計結(jié)果椿胯，如下圖所示筷登。

簡單介紹一下統(tǒng)計的內(nèi)容。內(nèi)容包括了項目的四個部分：ios（APP端）哩盲、android（APP端）前方、api（后端）、shuri（前端）廉油，其中30(0-0-15-15-0)镣丑，表示ios端有30個bug待辦，從左到右表示bug等級從Highest娱两、High莺匠、Medium、Low十兢、Lowest這五個等級對應(yīng)的bug的數(shù)量

bug統(tǒng)計結(jié)果

三趣竣、jira包下載

使用以下命令安裝jira包

pip install jira

四摇庙、JQL語句的使用

程序使用JQL對bug數(shù)據(jù)進行查詢和統(tǒng)計

看到這里，各位不要慌額遥缕。我弄這個的時候原本以為需要把JQL的相關(guān)語法從頭到尾的學習一遍呢卫袒，其實并不需要

jira中能將你的查詢用JQL表示出來，見下圖单匣，在圖中前面部分的查詢條件中填寫好你需要查詢的條件夕凝，然后點擊高級，就能將你的查詢的語句轉(zhuǎn)化為JQL語句

jira簡單查詢

下圖是jira中高級查詢的JQL語句户秤，是不是很棒呀

jira高級查詢

五码秉、編寫代碼

給出程序源碼

#coding=utf-8
from jira import JIRA

jira_server = 'http://jira.com'  #jira地址
jira_username = 'username' #用戶名
jira_password = 'password' #密碼

jira = JIRA(basic_auth=(jira_username, jira_password), options = {'server': jira_server})

#print(jira.user(jira.current_user()))#當前用戶

#
done = jira.search_issues('project = "test" AND issuetype = 故障 AND status = Done  ',maxResults=100000)

testing = jira.search_issues('project = "test" AND issuetype = 故障 AND status = 測試中  ',maxResults=100000)

toDo = jira.search_issues('project = "test" AND issuetype = 故障 AND status = "To Do"  ',maxResults=100000)


#ios

ios_done = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = Done AND text ~ "ios"  ',maxResults=100000)

ios_testing = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = 測試中 AND text ~ "ios"  ',maxResults=100000)

ios_toDo = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND text ~ "ios" ',maxResults=100000)

ios_Highest = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Highest AND text ~ "ios" ',maxResults=100000)
ios_High = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = High AND text ~ "ios" ',maxResults=100000)
ios_Medium = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Medium AND text ~ "ios" ',maxResults=100000)
ios_Low = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Low AND text ~ "ios" ',maxResults=100000)
ios_Lowest = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Lowest AND text ~ "ios" ',maxResults=100000)

#android

android_done = jira.search_issues('project = "test" AND issuetype = 故障 AND status = Done AND text ~ "android"  ',maxResults=100000)

android_testing = jira.search_issues('project = "test" AND issuetype = 故障 AND status = 測試中 AND text ~ "android"  ',maxResults=100000)

android_toDo = jira.search_issues('project = "test" AND issuetype = 故障 AND status = "To Do" AND text ~ "android"  ',maxResults=100000)

android_Highest = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Highest AND text ~ "android" ',maxResults=100000)
android_High = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = High AND text ~ "android" ',maxResults=100000)
android_Medium = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Medium AND text ~ "android" ',maxResults=100000)
android_Low = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Low AND text ~ "android" ',maxResults=100000)
android_Lowest = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Lowest AND text ~ "android" ',maxResults=100000)

#api：

api_done = jira.search_issues('project = "test" AND issuetype = 故障 AND status = Done AND text ~ "api"   ',maxResults=100000)

api_testing = jira.search_issues('project = "test" AND issuetype = 故障 AND status = 測試中  AND text ~ "api" ',maxResults=100000)

api_toDo = jira.search_issues('project = "test" AND issuetype = 故障 AND status = "To Do" AND text ~ "api"  ',maxResults=100000)

api_Highest = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Highest AND text ~ "api" ',maxResults=100000)
api_High = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = High AND text ~ "api" ',maxResults=100000)
api_Medium = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Medium AND text ~ "api" ',maxResults=100000)
api_Low = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Low AND text ~ "api" ',maxResults=100000)
api_Lowest = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Lowest AND text ~ "api" ',maxResults=100000)

#shuri

shuri_done = jira.search_issues('project = "test" AND issuetype = 故障 AND status = Done  AND text ~ "shuri" ',maxResults=100000)

shuri_testing = jira.search_issues('project = "test" AND issuetype = 故障 AND status = 測試中 AND text ~ "shuri"  ',maxResults=100000)

shuri_toDo = jira.search_issues('project = "test" AND issuetype = 故障 AND status = "To Do"  AND text ~ "shuri" ',maxResults=100000)

shuri_Highest = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Highest AND text ~ "shuri" ',maxResults=100000)
shuri_High = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = High AND text ~ "shuri" ',maxResults=100000)
shuri_Medium = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Medium AND text ~ "shuri" ',maxResults=100000)
shuri_Low = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Low AND text ~ "shuri" ',maxResults=100000)
shuri_Lowest = jira.search_issues('project = RRPK AND issuetype = 故障 AND status = "To Do" AND priority = Lowest AND text ~ "shuri" ',maxResults=100000)



print ('\n\n        待辦          測試中     已完成')
print ('總：'+'       '+str(len(toDo))+'          '+str(len(testing))+'       '+str(len(done)))
print ('ios：        '+str(len(ios_toDo))+'('+str(len(ios_Highest))+'-'+str(len(ios_High))+'-'+str(len(ios_Medium))+'-'+str(len(ios_Low))+'-'+str(len(ios_Lowest))+')        '+str(len(ios_testing))+'       '+str(len(ios_done)))
print ('android：    '+str(len(android_toDo))+'('+str(len(android_Highest))+'-'+str(len(android_High))+'-'+str(len(android_Medium))+'-'+str(len(android_Low))+'-'+str(len(android_Lowest))+')        '+str(len(android_testing))+'       '+str(len(android_done)))
print ('api：        '+str(len(api_toDo))+'('+str(len(api_Highest))+'-'+str(len(api_High))+'-'+str(len(api_Medium))+'-'+str(len(api_Low))+'-'+str(len(api_Lowest))+')        '+str(len(api_testing))+'       '+str(len(api_done)))
print ('shuri：      '+str(len(shuri_toDo))+'('+str(len(shuri_Highest))+'-'+str(len(shuri_High))+'-'+str(len(shuri_Medium))+'-'+str(len(shuri_Low))+'-'+str(len(shuri_Lowest))+')        '+str(len(shuri_testing))+'     '+str(len(shuri_done)))

六、寫在最后

這個程序?qū)懙牟皇呛芎眉牛\行速度也比較慢转砖，總體上來說還可以，畢竟可以使用并且能達到我想要的需求

在這里只是為大家提供一個方向鲸伴，分享一下我學習這塊遇到的一些問題府蔗，希望對你有所幫助 ^ _ ^