Python学习（四）：导出jira

from jira import JIRA
from dateutil.parser import parse
import xlwt

outputpath = r'错.xls'

#获取错误内容
def getMyBug():
    jira = JIRA('http://jira/',basic_auth=('user', 'pass'))
    project = jira.projects()
    print(project)
    # project 项目名 assignee 经办人
    # issue = jira.search_issues('project=JIRA')
    # issue = jira.search_issues('assignee=admin')
    issues = jira.search_issues('assignee = currentUser() order by created desc')
    print(len(issues))
    issue = issues[0]
    # print(dir(issue.fields))
    print(issue.key)
    print(issue.fields.summary)
    print(issue.fields.reporter.displayName)
    print(issue.fields.assignee.displayName)
    print(issue.fields.status.name)
    print(parse(issue.fields.created).strftime('%Y-%m-%d %H:%M:%S'))

    return issues

#将BUG导出到Excel
def exportExcel(issues):
    workbook = xlwt.Workbook()
    # cell_overwrite_ok 表示是否可以覆盖单元格
    sheet = workbook.add_sheet('bug' , cell_overwrite_ok=True)

    fields = ['编号','标题','报告人','经办人','状态','创建时间']
    # 写入字段信息 其中的'0-行, 0-列'指定表中的单元，''是向该单元写入的内容
    for i in range(0,len(fields)):
        sheet.write(0,i,fields[i])

    # 写入数据信息
    for r in range(1,len(issues)+1):
        sheet.write(r, 0, issues[r - 1].key)
        sheet.write(r, 1, issues[r - 1].fields.summary)
        sheet.write(r, 2, issues[r - 1].fields.reporter.displayName)
        sheet.write(r, 3, issues[r - 1].fields.assignee.displayName)
        sheet.write(r, 4, issues[r - 1].fields.status.name)
        sheet.write(r, 5, parse(issues[r - 1].fields.created).strftime('%Y-%m-%d %H:%M:%S'))

    workbook.save(outputpath)

#主程序
def main():
    issues = getMyBug()
    exportExcel(issues)

if __name__ == '__main__':
    main()