欢迎关注【无量测试之道】公众号
Python编程学习资源干货、
Python+Appium框架APP的UI自动化、
Python+Selenium框架Web的UI自动化、
Python+Unittest框架API自动化、
文章下方有公众号二维码，可直接微信扫一扫关注即可。
今天分享的文章主要讲解如何从邮件里面提取用户返回的线上问题内容并做解析，通过拿到的数据信息进行分析整理，然后进行封装请求禅道里的接口进行提交，提交请求过程中会对数据库中是否存在进行一次判断处理，如果没有存在的就提交，如果数据库中存在就不用再提交，基于这个思路来看下今天的分享。
基础信息准备
1 import imaplib, email,re,requests,time,pymysql 2 imapserver = 'smtp.office365.com' 3 emailuser = "qa.notice@qq.com" 4 emailpasswd = "test123" 5 6 #beta环境禅道地址 7 beta_loginhost="http://zen.beta.com/index.php?m=user&f=login" 8 beta_add_bughost="http://zen.beta.com/index.php?m=bug&f=create&productID=10&branch=0&extra=moduleID=0" 9 10 #live环境禅道地址 11 live_loginhost="https://zen.live.com/index.php?m=user&f=login" 12 live_add_bughost="https://zen.live.com/index.php?m=bug&f=create&productID=10&branch=0&extra=moduleID=0" 13 14 envs="live" #定义使用的环境
数据库连接信息
1
2 #连接数据库相关的信息：
3 beta_dicts={
4 "HOST" : '10.8.2.3',
5 "PORT" : 3306,
6 "USER": 'zentao',
7 "PASSWORD" : 'test123',
8 "NAME":"zentao"
9 }
10 live_dicts={
11 "HOST" : '10.7.1.7',
12 "PORT" : 3306,
13 "USER": 'zentao',
14 "PASSWORD" : 'test123',
15 "NAME":"zentao"
16 }
数据库查询
1
2 #数据库查询操作
3 def executesql(query,envs):
4 try:
5 if(envs=="beta"):
6 conn = pymysql.connect(beta_dicts['HOST'], beta_dicts['USER'], beta_dicts['PASSWORD'], beta_dicts['NAME'], int(beta_dicts['PORT']),charset='utf8')
7 print(beta_dicts)
8 else:
9 conn = pymysql.connect(live_dicts['HOST'], live_dicts['USER'], live_dicts['PASSWORD'], live_dicts['NAME'], int(live_dicts['PORT']),charset='utf8')
10 print(live_dicts)
11 cursor = conn.cursor()
12 cursor.execute(query)
13 result =cursor.fetchall()
14 print("execute successfully!!!")
15 if(len(result)==0):
16 return 0
17 else:
18 return result[0][0]
19 except Exception as e:
20 print(e)
21 print("execute failed")
22 finally:
23 cursor.close()
24 conn.close()
建立连接与检索
1
2 #建立连接与检索匹配的邮件
3 def search():
4 print("start to connect")
5 conn = imaplib.IMAP4_SSL(imapserver)
6 conn.login(emailuser, emailpasswd)
7 conn.select('INBOX') # 选择收件箱（默认）
8 print(conn)
9 now = time.localtime()
10 nowt = time.strftime("%d-%b-%Y", now)
11 print(nowt)
12 results , data = conn.search(None,'(FROM "Liang.Wu")','(ON "'+str(nowt)+'")')
13 mailidlist = data[0].split()
14 print(mailidlist)
15 try:
16 for id in mailidlist:
17 print(id)
18 resultss, data = conn.fetch(id, '(RFC822)') # 通过邮件id获取邮件，data是fetch到的邮件具体内容
19 e = email.message_from_bytes(data[0][1])
解释说明与Print
1 '''
2 Header()类：
3 email.header.Header(s=None, charset=None, maxlinelen=None, header_name=None, continuation_ws=' ', errors='strict')
4 其中参数的含义理解如下：
5 s：标头的值，也就是对应 From、To、Subject 的值；
6 charset：字符集格式，默认是 ASCII，但是一般指定 UTF-8 格式以兼容更多字符；
7 header_name:标头名，就是 From、To、Subject、Time 等；
8 '''
9 subject = email.header.make_header(email.header.decode_header(e['SUBJECT']))
10 mail_from = email.header.make_header(email.header.decode_header(e['From']))
11 print("邮件的subject是%s" % subject)
12 print("邮件的发件人是%s" % mail_from)
13 body = str(get_body(e), encoding='ISO-8859-1') # utf-8 gb2312 GB18030解析中文日文英文
14 print("邮件内容是%s" % body)
15 parse1(body)
16 print("good job")
17 except Exception as e:
18 print("we catch an error!!!",e)
19 finally:
20 print("logout is success")
21 print("the finally of operation!!!")
22 conn.logout()
获取邮件主体信息
1 #获取邮件主体信息 2 def get_body(msg): 3 if msg.is_multipart ():#Return True if the message’s payload is a list of sub-Message objects, otherwise return False. When is_multipart() returns False, the payload should be a string object. 4 return get_body(msg.get_payload(0)) 5 else: 6 '''Return the current payload, which will be a list of Message objects when is_multipart() is True, 7 or a string when is_multipart() is False. If the payload is a list and you mutate the list object, 8 you modify the message’s payload in place.''' 9 return msg.get_payload(None , decode=True)
解析邮件内容并提交禅道
1
2 # 解析邮件内容并调用禅道提交（上一篇文章结合来看）
3 def parse1(body):
4 pattern = re.compile('Dear Colleagues,<br>(.*?)Thanks and Regards,<br>', re.S)
5 pattern1 = re.compile('black">(.*?)<o:p>', re.S)
6 pattern2=re.compile(';">\r(.*?);\r<',re.S)
7 lists = re.findall(pattern, body)
8 print("*"*10)
9 lists = str(lists[0]).replace("\n", "").split("<br>")
10 print(lists)
11 resultlist = []
12 for i in range(len(lists)):
13 if (len(lists[i]) > 1):
14 resultlist.append(lists[i])
15 print(resultlist)
16 id = resultlist[1]
17 ids=str(str(resultlist[1]).split(":")[1]).lstrip()
18 Subject = resultlist[2]
19 Subjects="[FeedBack-"+str(str(resultlist[1]).split(":")[1]).lstrip() + "]--"+str(str(resultlist[2]).split(":")[1])
20 Creator = resultlist[3]
21 Creators = str(str(resultlist[3]).split(":")[1])
22 Category = resultlist[4]
23 IssueCategory = resultlist[5]
24 if ("Low" in resultlist[6]):
25 Severity = "4"
26 Severity_desc = "Severity: Low (Limited business impact)"
27 if ("Medium" in resultlist[6]):
28 Severity = "3"
29 Severity_desc = "Severity: Medium (Functional but impact operations)"
30 if ("High" in resultlist[6]):
31 Severity = "2"
32 Severity_desc = "Severity: High (Major system outage)"
33 Module = resultlist[7]
34 if('black">' in resultlist[8] and '<o:p>' in resultlist[8]):
35 Details = str(re.findall(pattern1, resultlist[8])[0]).replace(""", "\"")
36 if(';">\r' in resultlist[8] and ';\r<' in resultlist[8]):
37 Details = str(re.findall(pattern2, resultlist[8])[0]).replace(""", "\"")
38 link = resultlist[9]
39 steps = id + "<br>" + Subject + "<br>" + Creator + "<br>" + Category + "<br>" + IssueCategory + "<br>" + Severity_desc + "<br>" + Module + "<br>" + Details + "<br>" + link
40 print(steps.replace("<br>", "\n"))
41 sql="SELECT * FROM zt_bug WHERE title LIKE \"[FeedBack-"+str(ids)+"%\""
42 print(sql)
43 if(executesql(sql,envs)>=1):
44 print("there is an record exists!!!")
45 #add_bug(Subjects, Creators, Severity, steps,envs)
46 else:
47 add_bug(Subjects,Creators,Severity,steps,envs)
提交bug至禅道
1 #提交bug到禅道的方法 2 def add_bug(a,b,c,d,e): #此方法可以与上一遍文章结合在一起提交到禅道 3 pass
以上内容就是今天分享的全部内容，这个最后的方法也是空着的，所以这里也就回答了上一篇文章中大家提到的疑问—->自动提交bug到禅道的使用场景会是怎么样的。
备注：我的个人公众号已正式开通，致力于测试技术的分享，包含：大数据测试、功能测试，测试开发，API接口自动化、测试运维、UI自动化测试等，微信搜索公众号：“无量测试之道”，或扫描下方二维码：
添加关注，让我们一起共同成长！
