江苏龙网

  1. 主页 > 生活百科 > >

提效工具-python解析xmind文件及xmind用例统计

Python

前言每个公司都有一个维护测试case的系统 ， 有自研的也有买的 ， 比如QC, 禅道等等 ， QA往往习惯使用xmind等思维导图工具来编写测试用例 。
因为思路清晰 ， 编写方便 ， 那么这就有一个问题 ， 大多数公司要求所有的case都要导入到系统统一维护 ， 然而系统对xmind的支持并不友好 ， 或者根本不支持 ， 就我们目前的情况来说 ， 系统支持导入xmind文件导入 ， 但是导入后所有的用例都是乱的 ， 而且没有测试步骤 ， 没有预期结果等等问题 ， 因此针对这一痛点 ， 便诞生了今天的小工具 ， 虽然这个工具只能解决我的问题 ， 但是里面有大家可以学习参考的地方 ， 希望对你有帮助 ， 那么我的目的就达到了 。

提效工具-python解析xmind文件及xmind用例统计

文章插图
 
一、工具源码"""import tkinter as tkfrom tkinter import filedialog, messageboximport xmindimport osfrom xmindparser import xmind_to_dictclass ParseXmind(object):def __init__(self, root):self.count = 0self.case_fail = 0self.case_success = 0self.case_block = 0self.case_priority = 0# total汇总用self.total_cases = 0self.total_success = 0self.total_fail = 0self.total_block = 0self.toal_case_priority = 0# GUIroot.title('Xmind用例个数统计及文件解析')width = 760height = 600xscreen = root.winfo_screenwidth()yscreen = root.winfo_screenheight()xmiddle = (xscreen - width) / 2ymiddle = (yscreen - height) / 2root.geometry('%dx%d+%d+%d' % (width, height, xmiddle, ymiddle))# 窗口默认大小# 3个frameself.frm1 = tk.Frame(root)self.frm2 = tk.Frame(root)self.frm3 = tk.Frame(root)#布局self.frm1.grid(row = 1, padx = '20', pady = '20')self.frm2.grid(row = 2, padx = '30', pady = '30')self.frm3.grid(row = 0, padx = '40', pady = '40')self.lable = tk.Label(self.frm3, text = "Xmind文件完整路径")self.lable.grid(row = 0, column = 0, pady = '5')self.file_path = tk.Entry(self.frm3, bd = 2)self.file_path.grid(row = 0, column = 1, pady = '5')def get_full_file_path_text():"""获取xmind文件完整路径:return:"""full_xmind_path = self.file_path.get()# 获取文本框内容#简单对输入内容做一个校验if full_xmind_path == "" or "xmind" not in full_xmind_path:messagebox.showinfo(title = "warning", message = "xmind文件路径错误!")try:self.create_new_xmind(full_xmind_path)except FileNotFoundError:passelse:xmind_file = full_xmind_path[:-6].split("/")[-1]# xmind文件名 ， 不带后缀path_list = full_xmind_path[:-6].split("/")# xmind文件用/分割后的一个列表path_list.pop(0)path_list.pop(-1)path_full = "/" + "/".join(path_list)# xmind文件的目录new_xmind_file = "{}/{}_new.xmind".format(path_full, xmind_file)# 新的xmind文件完整路径messagebox.showinfo(title = "success", message = "已生成新的xmind文件:{}".format(new_xmind_file))#页面的一些空间的布局self.button = tk.Button(self.frm3, text = "提交", width = 10, command = get_full_file_path_text, bg = '#dfdfdf')self.button.grid(row = 0, column = 2, pady = '5')self.but_upload = tk.Button(self.frm1, text = '上传xmind文件', command = self.upload_files, bg = '#dfdfdf')self.but_upload.grid(row = 0, column = 0, pady = '10')self.text = tk.Text(self.frm1, width = 55, height = 10, bg = '#f0f0f0')self.text.grid(row = 1, column = 0)self.but2 = tk.Button(self.frm2, text = "开始统计", command = self.new_lines, bg = '#dfdfdf')self.but2.grid(row = 0, columnspan = 6, pady = '10')self.label_file = tk.Label(self.frm2, text = "文件名", relief = 'groove', borderwidth = '2', width = 25,bg = '#FFD0A2')self.label_file.grid(row = 1, column = 0)self.label_case = tk.Label(self.frm2, text = "用例数", relief = 'groove', borderwidth = '2', width = 10,bg = '#FFD0A2').grid(row = 1, column = 1)self.label_pass = tk.Label(self.frm2, text = "成功", relief = 'groove', borderwidth = '2', width = 10,bg = '#FFD0A2').grid(row = 1, column = 2)self.label_fail = tk.Label(self.frm2, text = "失败", relief = 'groove', borderwidth = '2', width = 10,bg = '#FFD0A2').grid(row = 1, column = 3)self.label_block = tk.Label(self.frm2, text = "阻塞", relief = 'groove', borderwidth = '2', width = 10,bg = '#FFD0A2').grid(row = 1, column = 4)self.label_case_priority = tk.Label(self.frm2, text = "p0case", relief = 'groove', borderwidth = '2',width = 10, bg = '#FFD0A2').grid(row = 1, column = 5)def count_case(self, li):"""统计xmind中的用例数:param li::return:"""for i in range(len(li)):if li[i].__contains__('topics'):# 带topics标签意味着有子标题 ， 递归执行方法self.count_case(li[i]['topics'])else:# 不带topics意味着无子标题 ， 此级别既是用例if li[i].__contains__('makers'):# 有标记成功或失败时会有makers标签for mark in li[i]['makers']:if mark == "symbol-right":# 成功self.case_success += 1elif mark == "symbol-wrong":# 失败self.case_fail += 1elif mark == "symbol-attention":# 阻塞self.case_block += 1elif mark == "priority-1":# 优先级self.case_priority += 1self.count += 1# 用例总数def new_line(self, filename, row_number):"""用例统计表新增一行:param filename::param row_number::return:"""# 调用Python中xmind_to_dict方法,将xmind转成字典sheets = xmind_to_dict(filename)# sheets是一个list ， 可包含多sheet页；for sheet in sheets:print(sheet)my_list = sheet['topic']['topics']# 字典的值sheet['topic']['topics']是一个list# print(my_list)self.count_case(my_list)# 插入一行统计数据lastname = filename.split('/')self.label_file = tk.Label(self.frm2, text = lastname[-1], relief = 'groove', borderwidth = '2', width = 25)self.label_file.grid(row = row_number, column = 0)self.label_case = tk.Label(self.frm2, text = self.count, relief = 'groove', borderwidth = '2', width = 10)self.label_case.grid(row = row_number, column = 1)self.label_pass = tk.Label(self.frm2, text = self.case_success, relief = 'groove', borderwidth = '2',width = 10)self.label_pass.grid(row = row_number, column = 2)self.label_fail = tk.Label(self.frm2, text = self.case_fail, relief = 'groove', borderwidth = '2', width = 10)self.label_fail.grid(row = row_number, column = 3)self.label_block = tk.Label(self.frm2, text = self.case_block, relief = 'groove', borderwidth = '2', width = 10)self.label_block.grid(row = row_number, column = 4)self.label_case_priority = tk.Label(self.frm2, text = self.case_priority, relief = 'groove', borderwidth = '2',width = 10)self.label_case_priority.grid(row = row_number, column = 5)self.total_cases += self.countself.total_success += self.case_successself.total_fail += self.case_failself.total_block += self.case_blockself.toal_case_priority += self.case_prioritydef new_lines(self):"""用例统计表新增多行:return:"""lines = self.text.get(1.0, tk.END)# 从text中获取所有行row_number = 2for line in lines.splitlines():# 分隔成每行if line == '':breakprint(line)self.new_line(line, row_number)row_number += 1# total汇总行self.label_file = tk.Label(self.frm2, text = 'total', relief = 'groove', borderwidth = '2', width = 25)self.label_file.grid(row = row_number, column = 0)self.label_case = tk.Label(self.frm2, text = self.total_cases, relief = 'groove', borderwidth = '2', width = 10)self.label_case.grid(row = row_number, column = 1)self.label_pass = tk.Label(self.frm2, text = self.total_success, relief = 'groove', borderwidth = '2',width = 10)self.label_pass.grid(row = row_number, column = 2)self.label_fail = tk.Label(self.frm2, text = self.total_fail, relief = 'groove', borderwidth = '2', width = 10)self.label_fail.grid(row = row_number, column = 3)self.label_block = tk.Label(self.frm2, text = self.total_block, relief = 'groove', borderwidth = '2',width = 10)self.label_block.grid(row = row_number, column = 4)self.label_case_priority = tk.Label(self.frm2, text = self.toal_case_priority, relief = 'groove',borderwidth = '2',width = 10)self.label_case_priority.grid(row = row_number, column = 5)def upload_files(self):"""上传多个文件 ， 并插入text中:return:"""select_files = tk.filedialog.askopenfilenames(title = "可选择1个或多个文件")for file in select_files:self.text.insert(tk.END, file + 'n')self.text.update()@staticmethoddef parse_xmind(path):"""xmind变为一个字典:param path::return:"""dic_xmind = xmind_to_dict(path)xmind_result = dic_xmind[0]return xmind_resultdef create_new_xmind(self, path):"""用原xmind内容新建一个xmind文件:param path::return:"""xmind_result = self.parse_xmind(path)new_xmind_result = self.dict_result(xmind_result)xmind_file = path[:-6].split("/")[-1]path_list = path[:-6].split("/")path_list.pop(0)path_list.pop(-1)path_full = "/" + "/".join(path_list)new_xmind_file = "{}/{}_new.xmind".format(path_full, xmind_file)print(new_xmind_file)if os.path.exists(new_xmind_file):os.remove(new_xmind_file)xmind_wb = xmind.load(new_xmind_file)new_xmind_sheet = xmind_wb.getSheets()[0]new_xmind_sheet.setTitle(new_xmind_result["sheet_topic_name"])root_topic = new_xmind_sheet.getRootTopic()root_topic.setTitle(new_xmind_result["sheet_topic_name"])for k, v in new_xmind_result["data"].items():topic = root_topic.addSubTopic()topic.setTitle(k)for value in v:new_topic = topic.addSubTopic()new_topic.setTitle(value)xmind.save(xmind_wb)def dict_result(self, xmind_result):"""使用原xmind数据构造new_xmind_result:param xmind_result::return:"""sheet_name = xmind_result['title']sheet_topic_name = xmind_result['topic']['title']# 中心主题名称new_xmind_result = {'sheet_name': sheet_name,'sheet_topic_name': sheet_topic_name,'data': {}}title_list = []for i in xmind_result['topic']['topics']:title_temp = i['title']title_list.Append(title_temp)result_list = self.chain_data(i)new_xmind_result['data'][title_temp] = result_listreturn new_xmind_result@staticmethoddef chain_data(data):"""原xmind的所有topic连接成一个topic:param data::return:"""new_xmind_result = []def calculate(s, prefix):prefix += s['title'] + '->'for t in s.get('topics', []):s1 = calculate(t, prefix)if s1 is not None:new_xmind_result.append(s1.strip('->'))if not s.get('topics', []):return prefixcalculate(data, '')return new_xmind_resultif __name__ == '__main__':r = tk.Tk()ParseXmind(r)r.mainloop()


推荐阅读


上一篇：RustDesk - 免费开源的远程控制软件，流畅不限速，代替TeamViewer

下一篇：小心AI病毒Deepfake：看到的不一定都是真的