環(huán)境：python2.7?

1、安裝jira庫

            
              pip install jira
            
          

2、python連接jira服務(wù)器

            
              #coding: UTF-8
from jira import JIRA

username = raw_input('請輸入用戶名: ')
password = raw_input('輸入密碼: ')

options = {
        'verify': False,
        'server': 'https://jira.XXXXXXX.com'}

jira = JIRA(options, basic_auth=(username, password))


            
          

3、查詢issue

Jira 通過?JQL（JIRA Query Language，Jira 查詢語言）進行搜索，語法類似于 SQL。可以通過 JQL 搜索符合條件的 issues，如通過? assignee = currentUser() ?查找經(jīng)辦人為當前用戶的 issues。

            
              def searchIssues(jql, max_results=100):
    ''' Search issues
    @param jql: JQL, str
    @param max_results: max results, int, default 100
    @return issues: result, list
    '''
    try:
        issues = jira.search_issues(jql, maxResults=max_results)
        return issues
    except Exception as e:
        print(e)

jql = '''
    assignee = currentUser()
'''
issues = searchIssues(jql)

for issue in issues:
    print('{0}: {1}'.format(issue.key, issue.fields.summary))
            
          

4、獲取jira待修復(fù)缺陷數(shù)據(jù)

            
              issues = jira.search_issues('project = XXX AND status = 待修復(fù)', maxResults=1000,
                                fields='assignee,summary,customfield_10121')

# 獲取缺陷信息
for u in issues:
     # print u #打印缺陷的key值
     issue = jira.issue(u)  # 根據(jù)key獲取缺陷
     ass = issue.fields.assignee  # 獲取缺陷經(jīng)辦人
     print ass
     sec = issue.fields.customfield_10121  # 獲取缺陷嚴重性
     print sec
     sum = issue.fields.summary  # 獲取缺陷摘要
     print sum
            
          

獲取的待修復(fù)缺陷數(shù)據(jù)可以保存到excel文件中

            
              #coding: UTF-8
from jira import JIRA
import xlwt
import os
path=os.getcwd()

#輸入jira賬號和密碼
def input_user():
    # 主流程開始
    username = raw_input('請輸入用戶名: ')
    password = raw_input('輸入密碼: ')

    if (username == '' or password == ''):
        print('用戶名和密碼不能為空')
        exit

    return username,password

#########################獲取jira待修復(fù)缺陷數(shù)據(jù)
def  jira_data_repair():
    options = {
        'verify': False,
        'server': 'https://jira.XXXXX.com'}
    jira = JIRA(options, basic_auth=(username, password))

    issues = jira.search_issues('project = XXXXX AND status = 待修復(fù)', maxResults=1000,
                                fields='assignee,summary,customfield_10121')

    # 寫excel
    workbook = xlwt.Workbook(encoding='utf-8')
    worksheet = workbook.add_sheet('test')
    total = 0

    # 獲取缺陷信息
    for u in issues:
        # print u #打印缺陷的key值
        issue = jira.issue(u)  # 根據(jù)key獲取缺陷
        ass = issue.fields.assignee  # 獲取缺陷經(jīng)辦人
        sec = issue.fields.customfield_10121  # 獲取缺陷嚴重性
        sum = issue.fields.summary  # 獲取缺陷摘要
        # 寫入內(nèi)容
        worksheet.write(total, 0, str(u))
        worksheet.write(total, 1, str(ass))
        worksheet.write(total, 2, str(sec))
        total = total + 1

    # 保存excel
    workbook.save(path+'/output_data\\repair.xls')

if __name__ == '__main__':
    username,password=input_user()
    jira_data_repair()
            
          

?