python实现提取jira bug列表的方法示例

Habiba ·

更新时间:2024-11-13

· 1401 次阅读

公司要求内部每日整理jira bug发邮件，手动执行了一段时间，想着用自动化的方式实现，故用了3天的时间做出了此脚本。

第一版基础版


# -*- coding:utf-8 -*-
import requests
import re
from bs4 import BeautifulSoup as bs
import time
import os
jql = "project = SDP and parent = SDP-13330 AND issuetype in (standardIssueTypes(), subTaskIssueTypes(), BUG) AND status in (新建, 解决中, 重新打开) AND priority in (P0, P1, P2) AND reporter in (membersOf(SDP_Tester)) ORDER BY priority DESC"
username = "robin.li"
password = "a12345678"
tempfilepath = r"f:\bug_list.csv"
outbuglist = r"f:\bug_out" + time.strftime("%Y%m%d", time.localtime()) + ".csv"
parentid = "SDP-13330"
bugs_list = []
def findall_data(data,LB="",RB=""):
    '''    关联函数左右边界提取数取    '''
    rule=LB + r"(.+?)" + RB
    datalist=re.findall(rule,data)
    return  datalist
def get_bugs_list():
    '''根据规则提取bug列表'''
    if os.path.exists(outbuglist):  # 如果文件存在
        os.remove(outbuglist)
    with open(r"f:\bug_list.csv", 'r') as f:
        content = str(f.readlines())[1:-1]
        bug = []
        soup = bs(content, features='html.parser')
        for tr in soup.select('tr'):
            for td in tr.select('td'):
                bug.append(str(td.text).strip(r''))
            bugs_list.append(bug)
            bug = []
        for bug in bugs_list:
            clear_list = str(bug[1:-2]).replace("\\n", "").replace("\'", "").replace(" ", "").replace("\,", "").replace("\\xa0", "").replace(parentid, "").replace("[", "").replace("]", "")
            print(clear_list)
            try:
                with open(outbuglist, 'a') as f:
                    f.write(clear_list + "\n")
            except PermissionError:
                print("\033[31m请关闭已经打开的bug列表")
                return 0
        else:
            print("\n \033[31mbug列表输出地址：" + outbuglist + "\n" + "-"*50 + "-----bug内容如上：--------\n")
def login_bugwriter(username, password, jql, tempfilepath):
    """
    login_bugwriter(username='str',password='str', jql='str')
    登录jira提取bug列表写入文件
    username:登录Jira的帐号
    password:密码
    jql:jira过滤的语法
    tempfilepath:过滤的bug文件临时存储目录文件
    """
    ''''''
    data = {'os_username': username, 'os_password': password, 'login': '登录'}
    res = requests.get("https://jira.clouddeep.cn/secure/Dashboard.jspa")
    if res.status_code == 200:
        print("可以访问Jira，开始提取数据")
        jsession = requests.Session()
        cookie_jar = jsession.post("https://jira.clouddeep.cn/login.jsp",data=data).cookies
        login_cookie = requests.utils.dict_from_cookiejar(cookie_jar)
        print("登录成功，整理列表")
        headers={
            "User-Agent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36",
            "Sec-Fetch-Dest": "document",
            "Sec-Fetch-Mode": "navigate",
            "Sec-Fetch-Site": "none",
            "Sec-Fetch-User": "?1",
            "Upgrade-Insecure-Requests": "1",
        }
        r=requests.get("https://jira.clouddeep.cn/browse/SDP-13330",headers=headers, cookies=login_cookie)
        #print(r.text)
        jql_url="https://jira.clouddeep.cn/issues/SDP-13330/?jql=" + jql
        print("请确认过滤条件：==>" + jql_url + "\n" + "-"*30)
        bug_list = requests.get(jql_url ,headers=headers, cookies=login_cookie)
        with open(tempfilepath,'w') as f:
            f.write(bug_list.text)
    else:
        print("jira无法访问，请检查网络。")
if __name__ == '__main__':
    login_bugwriter(username, password, jql, tempfilepath)
    get_bugs_list()

第二版基础版添加日期相差功能


# -*- coding:utf-8 -*-
import requests
import re
from bs4 import BeautifulSoup as bs
import time
import os
from datetime import datetime
jql = "project = SDP and parent = SDP-13330 AND issuetype in (standardIssueTypes(), subTaskIssueTypes(), BUG) AND status in (新建, 解决中, 重新打开) AND priority in (P0, P1, P2) AND reporter in (membersOf(SDP_Tester)) ORDER BY priority DESC"
username = "a.li@rc.cn"
password = "Rc123456"
tempfilepath = r"f:\bug_list.csv"
outbuglist = r"f:\bug_out" + time.strftime("%Y%m%d", time.localtime()) + ".csv"
parentid = "SDP-13330"
bugs_list = []
def trans_month(date):
    ch_date_dict = {'一': '01', '二': '02', '三': '03', '四': '04', '五': '05', '六': '06', '七': '07', '八': '08', '九': '09', '十': '10', '十一': '11', '十二': '12', }
    old_date = date.split('/')
    ch_date = str(old_date[1])[0]
    if ch_date in ch_date_dict:
        old_date[1]=ch_date_dict[ch_date]
        new_date = "/".join(str(i) for i in old_date)
        return new_date
    else:
        print('日期格式错误')
def diff_date(d1, d2):
    d1 = datetime.strptime(d1,'%d/%m/%y').date()
    return (d2 - d1).days
def findall_data(data,LB="",RB=""):
    '''    关联函数左右边界提取数取    '''
    rule=LB + r"(.+?)" + RB
    datalist=re.findall(rule,data)
    return  datalist
def get_bugs_list():
    '''根据规则提取bug列表'''
    if os.path.exists(outbuglist):  # 如果文件存在
        os.remove(outbuglist)
    with open(r"f:\bug_list.csv", 'r') as f:
        content = str(f.readlines())[1:-1]
        bug = []
        soup = bs(content, features='html.parser')
        for tr in soup.select('tr'):
            for td in tr.select('td'):
                if td.text != " \\n":
                    print('2==',len(bug))
                    bug.append(str(td.text).strip(""))
                if "<img" in str(td):  #提取日期
                    get_date = tr.time.text  # 09:30:45'
                    d1 = trans_month(get_date)
                    d2 = datetime.now().date()
                    diff_days = diff_date(d1, d2)
                    s = str(td.img['alt'])
                    print('1==',len(bug))
                    bug.insert(len(bug),str(diff_days))
　　　　　　　　　　　　bug.append(s)
#print('1',bug) #print('2',bug)  bugs_list.append(bug) #bugs_list = [i for i in bugs_list if i != ''] #print('3',bugs_list) bug = [] for bug in bugs_list: #ps = bug # print(len(bug)) # if len(bug) != 0: clear_list = str(bug[:-2]).replace("\\n", "").replace("\'", "").replace(" ", "").replace("\,", "").replace("\\xa0", "").replace(parentid, "").replace("[", "").replace("]", "") #print(clear_list) #clear_list = clear_list.split(",") #clear_list = [i for i in clear_list if i !=''] print(clear_list) try: with open(outbuglist, 'a') as f: f.write(str(clear_list) + "\n") except PermissionError: print("\033[31m请关闭已经打开的bug列表") return 0 else: print("\n \033[31mbug列表输出地址：" + outbuglist + "\n" + "-"*50 + "-----bug内容如上：--------\n") def login_bugwriter(username, password, jql, tempfilepath): """ login_bugwriter(username='str',password='str', jql='str') 登录jira提取bug列表写入文件 username:登录Jira的帐号 password:密码 jql:jira过滤的语法 tempfilepath:过滤的bug文件临时存储目录文件 """ '''''' data = {'os_username': username, 'os_password': password, 'login': '登录'} res = requests.get("https://jira.clouddeep.cn/secure/Dashboard.jspa") if res.status_code == 200: print("可以访问Jira，开始提取数据") jsession = requests.Session() cookie_jar = jsession.post("https://jira.clouddeep.cn/login.jsp",data=data).cookies login_cookie = requests.utils.dict_from_cookiejar(cookie_jar) print("登录成功，整理列表") headers={ "User-Agent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36", "Sec-Fetch-Dest": "document", "Sec-Fetch-Mode": "navigate", "Sec-Fetch-Site": "none", "Sec-Fetch-User": "?1", "Upgrade-Insecure-Requests": "1", } r=requests.get("https://jira.clouddeep.cn/browse/SDP-13330",headers=headers, cookies=login_cookie) #print(r.text) jql_url="https://jira.clouddeep.cn/issues/SDP-13330/?jql=" + jql print("请确认过滤条件：==>" + jql_url + "\n" + "-"*30) bug_list = requests.get(jql_url ,headers=headers, cookies=login_cookie) with open(tempfilepath,'w') as f: f.write(bug_list.text) else: print("jira无法访问，请检查网络。") if __name__ == '__main__': #login_bugwriter(username, password, jql, tempfilepath) get_bugs_list()

第三版优化了提取器，实现一键提取bug

实现的代码


# -*- coding:utf-8 -*-
import requests
import re
from bs4 import BeautifulSoup as bs
import time
import os
from datetime import datetime
parentid = "SDP-15642"   #bug汇总 jira号
#查询条件
jql = "project = SDP and parent = " + parentid +" AND issuetype in (standardIssueTypes(), subTaskIssueTypes(), BUG) AND status in (新建, 解决中, 重新打开,解决中) AND priority in (P0, P1, P2) AND reporter in (membersOf(SDP_Tester)) ORDER BY priority DESC"
tr_title = "JIRA链接,详细描述,BUG等级,经办人,报告人,JIRA状态,JIRA创建时间,bug持续时间"#["JIRA链接","详细描述","BUG等级","经办人","报告人","JIRA状态","JIRA创建时间","bug持续时间"]
username = "aa.li@ss.cn"
password = "ss2018()"
tempfilepath = r"./bug_list.csv"
outbuglist = r"./bug_out" + time.strftime("%Y%m%d", time.localtime()) + ".csv"
# orderbuglist = r"./order_bug_out" + time.strftime("%Y%m%d", time.localtime()) + ".csv"
bugs_list = []
def trans_month(date):
    ch_date_dict = {'一': '01', '二': '02', '三': '03', '四': '04', '五': '05', '六': '06', '七': '07', '八': '08', '九': '09', '十': '10', '十一': '11', '十二': '12', }
    old_date = date.split('/')
    ch_date = str(old_date[1])[0]
    if ch_date in ch_date_dict:
        old_date[1]=ch_date_dict[ch_date]
        new_date = "/".join(str(i) for i in old_date)
        return new_date
    else:
        print('日期格式错误')
def diff_date(d1, d2):
    d1 = datetime.strptime(d1,'%d/%m/%y').date()
    return (d2 - d1).days
def findall_data(data,LB="",RB=""):
    '''    关联函数左右边界提取数取    '''
    rule=LB + r"(.+?)" + RB
    datalist=re.findall(rule,data)
    return  datalist
def get_bugs_list():
    '''根据规则提取bug列表'''
    # if os.path.exists(outbuglist):  # 如果文件存在
    #     os.remove(outbuglist)
    with open(r"f:\bug_list.csv", 'r') as f:
        content = str(f.readlines())[1:-1]
        bug = []
        soup = bs(content, features='html.parser')
        for tr in soup.select('tr'):
            for td in tr.select('td'):
                str1 =  re.sub(r"[\\n'\s]","",str(td.text))
                str2 = re.sub("[\s ,\r\n]{1,99}", ",", str1)
                if str2 != "":
                    bug.append(str(str2).strip(""))
                if "<img" in str(td):  #提取日期
                    get_date = tr.time.text  # 09:30:45'
                    d1 = trans_month(get_date)
                    d2 = datetime.now().date()
                    diff_days = diff_date(d1, d2)
                    s = str(td.img['alt'])
                    bug.insert(len(bug),str(diff_days))
                    bug.append(s)
            bugs_list.append(bug)
            bug = []
        else:
            print("\n \033[31mbug列表输出地址：" +  "\n" + "-"*50 + "-----bug内容如上：--------\n")
    return bugs_list
def login_bugwriter(username, password, jql, tempfilepath):
    """
    login_bugwriter(username='str',password='str', jql='str')
    登录jira提取bug列表写入文件
    username:登录Jira的帐号
    password:密码
    jql:jira过滤的语法
    tempfilepath:过滤的bug文件临时存储目录文件
    """
    ''''''
    data = {'os_username': username, 'os_password': password, 'login': '登录'}
    res = requests.get("https://jira.clouddeep.cn/secure/Dashboard.jspa")
    if res.status_code == 200:
        print("可以访问Jira，开始提取数据")
        jsession = requests.Session()
        cookie_jar = jsession.post("https://jira.clouddeep.cn/login.jsp",data=data).cookies
        login_cookie = requests.utils.dict_from_cookiejar(cookie_jar)
        print("登录成功，整理列表")
        headers={
            "User-Agent": "Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/84.0.4147.125 Safari/537.36",
            "Sec-Fetch-Dest": "document",
            "Sec-Fetch-Mode": "navigate",
            "Sec-Fetch-Site": "none",
            "Sec-Fetch-User": "?1",
            "Upgrade-Insecure-Requests": "1",
        }
        r=requests.get("https://jira.clouddeep.cn/browse/" + parentid,headers=headers, cookies=login_cookie)
        jql_url="https://jira.clouddeep.cn/issues/" + parentid + "/?jql=" + jql
        print("请确认过滤条件：==>" + jql_url + "\n" + "-"*30)
        bug_list = requests.get(jql_url ,headers=headers, cookies=login_cookie)
        with open(tempfilepath,'w') as f:
            f.write(bug_list.text)
    else:
        print("jira无法访问，请检查网络。")
def order_buglist(buglist):
    with open(outbuglist,'w') as f:
        f.write(tr_title + '\n')
        print(tr_title)
        for l in buglist:
            if len(l) <= 1:
                print("列表长度小于1")
            else:
                s = l[3:4] + str(l[4:5]).split(",")[2:3] +l[2:3] + l[9:11] + l[5:6] + l[8:9] + l[1:2]
                s2 = re.sub(r"'","",str(s)[3:-1])
                s3 = re.sub(r"[, ]{1,8}",",",s2)
                f.write("https://jira.clouddeep.cn/browse/" + str(s3) + '\n')
                print('out>>',s3)
    print("bug列表输出地址：\n",outbuglist)
　　if os.path.exists(tempfilepath):
    　　os.remove(tempfilepath)
　　else:
    　　print("no such file: %s" %tempfilepath)
if __name__ == '__main__': login_bugwriter(username, password, jql, tempfilepath) bug = get_bugs_list() order_buglist(bug)

实现一键提取：

编写2个bat文件：

init_env.bat #初始化环境，安装所需的库


pip install requests 
pip install  bs4

get_jira_bugs.bat #调用主程序实现bug列表生成一个csv文件。


@ECHO OFF
python ./jiraCollection.py
echo  run success!
pause

到此这篇关于python实现提取jira bug列表的方法示例的文章就介绍到这了,更多相关python提取jira bug列表内容请搜索软件开发网以前的文章或继续浏览下面的相关文章希望大家以后多多支持软件开发网！

jira 示例方法 Python

1024 个赞

需要登录后方可回复, 如果你还没有账号请注册新账号

HTML 字符集

Kamiisa 2020-04-27

703

Laravel 中使用简单的方法跟踪用户是否在线(推荐)

Serwa 2020-03-20

874

ubuntu修改terminal终端的主机名的实现方法

Kita 2021-05-26

748

页面背景图片的拉伸实现代码

Bree 2020-05-16

802

docker-compose中启动镜像失败的几种解决方法

Hana 2023-08-08

725

Windows服务器默认IE浏览器无法下载文件的解决方法

Cybill 2023-08-08

1355

Windows服务器长时间保持远程桌面不被自动断开的方法

Elsa 2023-08-08

1249

Python 对象拷贝及深浅拷贝区别的详细教程示例

Miette 2023-08-09

488

使用Python对接OpenAi API实现智能QQ机器人的方法

Miette 2023-08-28

1874

python进阶学习实时目标跟踪示例详解

Serafina 2023-08-28

1732

Python人工智能语音合成实现案例详解

Rhea 2023-08-28

744

python Tkinter实例详解

Malinda 2023-08-28

1999

Python人工智能构建简单聊天机器人示例详解

Kathy 2023-08-28

1370

Python ttkbootstrap的介绍与使用教程

Nora 2023-08-28

1592

python中os模块和sys模块的使用详解

Pandora 2023-08-28

600

Python中的QPixmap用法详解

Tani 2023-08-28

951

pytorch SummaryWriter保存日志的方法

Tanisha 2023-08-28

1486

python人工智能算法之线性回归实例

Diane 2023-08-28

527

python人工智能算法之随机森林流程详解

Tricia 2023-08-28

1552

Python lambda（匿名函数）

Miette 2023-11-01

850

我要提问

致谢

帮助他人，成就自己。

人生最大成功就是伸出热情而温暖的双手，尽自己所能去帮助身边的每一个人，只要无私的奉献，就会收获到美好的生活。

1024问感谢每一位朋友的帮助和支持。

软件开发网提供编程的基础软件技术培训教程,软件开发编程实例讲解Go,Node,HTML,CSS,Javascript,Python,Java,Ruby,C,PHP,MySQL等软件开发编程语言以及数据开发的基础知识，也提供大量的软件开发在线实例、从入门到精通就在1024问。

育儿网微养生全球行美食街育儿菜谱大全海南旅游女性养狗百科星座