# -*- coding: utf-8 -*- import logging LOG_FORMAT = "%(asctime)s>%(levelname)s>PID:%(process)d %(thread)d>%(module)s>%(funcName)s>%(lineno)d>%(message)s" logging.basicConfig( level=logging.DEBUG, format=LOG_FORMAT, ) # 是否打印调试信息标志 debug = True if debug: logging.debug("进入主程序，开始导入包...") # 导入常规库 import sys, re, string from pathlib import * # 导入word文档操作库 from win32com.client import DispatchEx from docxtpl import DocxTemplate import docx from docx import Document import shutil import pythoncom # 导入QT组件 from PyQt5 import QtCore from PyQt5.QtWidgets import QMainWindow, QFileDialog, QMessageBox, QDialog, QToolTip from PyQt5.QtCore import pyqtSignal from PyQt5.QtGui import QFont # 导入UI转换PY文件 from need.Ui_GUI import Ui_MainWindow from need import about, zhuan # 导入工具包文件-时间转换 from need.utils import get_current_time, get_current_name, get_current_date, get_current_hour from need.zhuan_tool import IEEE754_16_to_float, IEEE754_float_to_16 # 导入其他线程 from need.threads import create_bujian from need.fpga_record_thrend import create_FPGA_record from need.fpga_JtoS import create_FPGA_JtoS from need.new_JtoS import create_new_JtoS class zhuan_dlg(QDialog, zhuan.Ui_Dialog): def __init__(self): super().__init__() self.setupUi(self) if debug: logging.debug("初始化转换程序:") #linetext信号连接 self.lineEdit.editingFinished.connect(self.shiliu_zhuan) self.lineEdit_2.editingFinished.connect(self.shi_zhuan) # 设置气泡提示信息 QToolTip.setFont(QFont("SansSerif", 12)) self.lineEdit.setToolTip("注意，编辑输入框后需要点击其他控件才进行转换，且格式不正确不转换") self.lineEdit_2.setToolTip("注意，编辑输入框后需要点击其他控件才进行转换，且格式不正确不转换") def shiliu_zhuan(self): #获取当前文字 x = self.lineEdit.text() if len(x) == 8: if self.radioButton.isChecked() == True: #说明选中了32位转换 result = IEEE754_16_to_float(x, 32) self.lineEdit_2.setText(str(result)) elif len(x) == 16: if self.radioButton_2.isChecked() == True: #说明选中了64位转换 result = IEEE754_16_to_float(x, 64) self.lineEdit_2.setText(str(result)) def shi_zhuan(self): #获取当前文字 x = self.lineEdit_2.text() #字符串转浮点数 # if str.isdigit(x): # x = float(x) # elif str.isdigit(x.replace(".","")): try: x = float(x) except: logging.debug('输入的内容无法转换为浮点数') if isinstance(x, float) == True: print('进入转换函数里面') if self.radioButton.isChecked() == True: #说明选中了32位转换 result = IEEE754_float_to_16(x, 32) print(result) self.lineEdit.setText(str(result)) else: result = IEEE754_float_to_16(x, 64) self.lineEdit.setText(str(result)) class userMain(QMainWindow, Ui_MainWindow): #自定义信号和槽 def __init__(self): super().__init__() self.setupUi(self) if debug: logging.debug("初始化主程序:") # 实例化翻译家 self.trans = QtCore.QCoreApplication.translate self.setWindowTitle('测试个人工具') #使用翻译家改变PYQT的空间名字等属性self.label_4.setText(self.trans("MainWindow", "文件名（自动识别）：")) if debug: logging.debug("初始化部分全局变量...") # 存放文件夹路径变量 self.open_dirs_name = '' # 存放文件名称路径变量 self.open_file_name = '' # 读取配置文件 #~~~~~~~~~~~~~~~连接线程函数~~~~~~~~~~~~~~~ ## 连接大纲生成说明函数 self.create_shuoming_trd = create_shuoming(self) self.create_shuoming_trd.sin_out.connect(self.text_display) self.pushButton_2.clicked.connect(self.create_shuoming_btn) ## 连接大纲追溯 self.create_dagang_zhuisu_trd = create_dagang_zhuisu(self) self.create_dagang_zhuisu_trd.sin_out.connect(self.text_display) self.pushButton_5.clicked.connect(self.creat_shuoming_zhuisu_btn) ## 连接说明追踪线程 self.create_shuoming_zhuisu_trd = create_shuoming_zhuisu(self) self.create_shuoming_zhuisu_trd.sin_out.connect(self.text_display) self.pushButton_6.clicked.connect(self.creat_dagang_zhuisu_btn) ## 连接报告追踪 self.create_baogao_zhuisu_trd = create_baogao_zhuisu(self) self.create_baogao_zhuisu_trd.sin_out.connect(self.text_display) self.pushButton_18.clicked.connect(self.create_baogao_zhuisu_btn) ## 连接单元追踪线程 self.create_danyuan_trd = create_danyuan(self) self.create_danyuan_trd.sin_out.connect(self.text_display) self.pushButton_8.clicked.connect(self.creat_danyuan_btn) ## 连接根据测试说明生成记录线程 self.create_jilu_trd = create_jilu(self) self.create_jilu_trd.sin_out.connect(self.text_display) self.pushButton_12.clicked.connect(self.creat_jilu_btn) ## 记录反向生成说明线程 self.create_shuomingfanxiang_trd = create_new_JtoS(self) self.create_shuomingfanxiang_trd.sin_out.connect(self.text_display) self.pushButton_13.clicked.connect(self.creat_shuomingfanxiang_btn) ## 自动填充空白表格线程 self.create_zidong_trd = create_zidong(self) self.create_zidong_trd.sin_out.connect(self.text_display) self.pushButton_15.clicked.connect(self.creat_zidong_btn) ## 清空单元格线程 self.clear_cell_trd = clear_cell(self) self.clear_cell_trd.sin_out.connect(self.text_display) self.pushButton_14.clicked.connect(self.clear_cell_btn) ## 提取表格内容线程 self.get_content_trd = get_content(self) self.get_content_trd.sin_out.connect(self.text_display) self.pushButton_19.clicked.connect(self.get_content_btn) ## 部件测试调用关系表格线程 self.create_bujian_trd = create_bujian(self) self.create_bujian_trd.sin_out.connect(self.text_display) self.pushButton_28.clicked.connect(self.create_bujian_btn) ## FPGA记录填写表格线程 self.create_FPGA_record_trd = create_FPGA_record(self) self.create_FPGA_record_trd.sin_out.connect(self.text_display) self.pushButton_30.clicked.connect(self.create_FPGA_record_btn) ## FPGA记录转为说明线程 self.create_FPGA_JtoS_trd = create_FPGA_JtoS(self) self.create_FPGA_JtoS_trd.sin_out.connect(self.text_display) self.pushButton_32.clicked.connect(self.create_FPGA_JtoS_btn) # 自定义信号连接 # 获取状态栏对象 self.user_statusbar = self.statusBar() # 右下角窗口尺寸调整符号 self.user_statusbar.setSizeGripEnabled(True) self.user_statusbar.setStyleSheet("QStatusBar.item{border:10px}") #~~~~~~~~~~~~~~~按钮连接函数~~~~~~~~~~~~~~~~ ##选择文件按钮连接 self.pushButton.clicked.connect(self.choose_docx_func) self.pushButton_4.clicked.connect(self.choose_docx_func) self.pushButton_7.clicked.connect(self.choose_docx_func) self.pushButton_11.clicked.connect(self.choose_docx_func) self.pushButton_16.clicked.connect(self.choose_docx_func) self.pushButton_17.clicked.connect(self.choose_docx_func) self.pushButton_27.clicked.connect(self.choose_docx_func) self.pushButton_29.clicked.connect(self.choose_docx_func) self.pushButton_31.clicked.connect(self.choose_docx_func) #清空显示区 self.pushButton_9.clicked.connect(self.clear_textEdit_content) #显示帮助 self.pushButton_10.clicked.connect(self.display_help) #~~~~~~~~~~~~~~~导航栏按钮连接函数~~~~~~~~~~~~~~~~ #显示关于本软件的菜单 self.actionAbout.triggered.connect(self.display_about) #打开文件夹 self.actionopen.triggered.connect(self.choose_docx_func) #打开IEEE754转换工具 self.actionIEEE754.triggered.connect(self.open_zhuan_tool) if debug: logging.debug("界面加载完成...") #~~~~~~~~~~~~~~~~~~~~初始化直接运行的函数（也就是起始运行一次）~~~~~~~~~~~~~~~~~~~~~~~~~~ #~~~~~~~~~~~~~~~~~~~~间接按钮函数，用户点击后操作~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ #清空显示区函数 def clear_textEdit_content(self): self.textBrowser.clear() return #显示帮助函数 def display_help(self): txt_path = Path.cwd() / 'need' / 'others' / 'readme.txt' with open(txt_path, 'r', encoding='utf-8') as f: data = f.read() self.textBrowser.append(data) return #显示关于函数 def display_about(self): dlg = QDialog() about_dlg = about.Ui_Dialog() about_dlg.setupUi(dlg) dlg.show() dlg.exec_() print("显示关于界面") return #显示IEEE754转换工具 def open_zhuan_tool(self): dlg_zhuan = zhuan_dlg() #实例化界面 dlg_zhuan.show() dlg_zhuan.exec_() return #~~~~~~~~~~~~~~~~~~~~线程区域函数，用于启动线程~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ #生成测试说明启动函数 def create_shuoming_btn(self): self.create_shuoming_trd.start() self.tabWidget.setEnabled(False) return # 大纲追溯线程启动函数 def creat_dagang_zhuisu_btn(self): self.create_dagang_zhuisu_trd.start() self.tabWidget.setEnabled(False) # 说明追溯线程启动函数 def creat_shuoming_zhuisu_btn(self): self.create_shuoming_zhuisu_trd.start() self.tabWidget.setEnabled(False) # 提取单元格标题右侧内容线程启动函数 def create_baogao_zhuisu_btn(self): self.create_baogao_zhuisu_trd.start() self.tabWidget.setEnabled(False) # 记录反向生成说明线程 def creat_shuomingfanxiang_btn(self): self.create_shuomingfanxiang_trd.start() self.tabWidget.setEnabled(False) # 单元测试报告转换为我们的用例线程 def creat_danyuan_btn(self): self.create_danyuan_trd.start() self.tabWidget.setEnabled(False) # 单元测试报告转换为我们的用例线程 def creat_jilu_btn(self): self.create_jilu_trd.start() self.tabWidget.setEnabled(False) # 自动填充线程 def creat_zidong_btn(self): self.create_zidong_trd.start() self.tabWidget.setEnabled(False) # 清空表格单元格内容 def clear_cell_btn(self): self.clear_cell_trd.start() self.tabWidget.setEnabled(False) # 提取单元格标题右侧内容线程启动函数 def get_content_btn(self): self.get_content_trd.start() self.tabWidget.setEnabled(False) # 部件测试提取调用启动线程函数 def create_bujian_btn(self): self.create_bujian_trd.start() self.tabWidget.setEnabled(False) # FPGA记录填写 def create_FPGA_record_btn(self): self.create_FPGA_record_trd.start() self.tabWidget.setEnabled(False) # FPGA记录转说明 def create_FPGA_JtoS_btn(self): self.create_FPGA_JtoS_trd.start() self.tabWidget.setEnabled(False) #选择文档函数 def choose_docx_func(self): self.open_file_name = QFileDialog.getOpenFileName( self, '选择文件', '.', "Word files(*.docx)") self.textBrowser.append('已选择文件路径：' + self.open_file_name[0]) #关闭线程函数 def stop_shuoming_thread(self): self.tabWidget.setEnabled(True) QMessageBox.warning(self, '处理完毕', '文档处理完毕！') print("停止线程成功！") #~~~~~~~~~~~~~~~~~~~~显示函数~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ def text_display(self, texttmp): if texttmp[:9] == 'stoperror': QMessageBox.warning(self, '处理完毕', '文档处理失败！') self.tabWidget.setEnabled(True) return if texttmp[:11] == 'stopsuccess': self.stop_shuoming_thread() self.tabWidget.setEnabled(True) return if texttmp[:6] == 'total:': cnt = int(texttmp[6:]) self.progressBar.setRange(0, cnt - 1) if texttmp == 'function success': QMessageBox.information(self, '操作成功', '请查看本程序当前文件夹下的相关文档！') self.textBrowser.append('完成！！！') self.tabWidget.setEnabled(True) return if texttmp == '保存文件错': QMessageBox.warning(self, '出错了', '保存文件失败！') self.tabWidget.setEnabled(True) return if texttmp == 'no folder': QMessageBox.information(self, '没有选择文件夹', '还没有选择文件夹，点击"文件"菜单进行选择！') self.tabWidget.setEnabled(True) return if texttmp.find('warning:') != -1: QMessageBox.information(self, 'WARNING', texttmp[8:]) self.tabWidget.setEnabled(True) return if texttmp.find('open failed:') != -1: QMessageBox.warning( self, '打开文件失败', '打开' + texttmp[12:] + '失败' + '请确认文档是否打开或者模板文件存在且后缀名为docx！') self.tabWidget.setEnabled(True) return if texttmp == 'nofile': QMessageBox.information(self, '错误', '还没有选择文件（夹），点击"文件"菜单或者工具栏进行选择！') self.tabWidget.setEnabled(True) return if texttmp.isdigit() == True: self.progressBar.setValue(int(texttmp)) self.tabWidget.setEnabled(True) else: self.textBrowser.append(texttmp) self.tabWidget.setEnabled(True) # 如果前面是all_doned:则进度条填满 if texttmp.find('all_doned:') != -1: self.progressBar.setRange(0, 100) self.progressBar.setValue(100) def closeEvent(self, event): reply = QMessageBox.question(self, '提示', "是否要关闭所有窗口?", QMessageBox.Yes | QMessageBox.No, QMessageBox.No) if reply == QMessageBox.Yes: event.accept() sys.exit(0) # 退出程序 else: event.ignore() ################################################################################## #大纲生成测试说明线程 ################################################################################## class create_shuoming(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent def run(self): #用来储存测试项DC等转换 zhuan_dict = {'DC':'文档审查','SU':'功能测试','CR':'代码审查','SA':'静态分析','AC':'性能测试',\ 'IO':'接口测试','SE':'安全性测试','BT':'边界测试','RE':'恢复性测试','ST':'强度测试',\ 'AT':'余量测试','GUI':'人机交互界面测试','DP':'数据处理测试','JR':'兼容性测试',\ 'LG':'逻辑测试','AZ':'安装性测试','TT':'时序测试','PA':'功耗分析'} self.sin_out.emit("进入军品大纲转说明......") self.sin_out.emit("开始转换......") #如果没有选择路径则退出 if not self.parent.open_file_name: self.sin_out.emit('nofile') self.parent.tabWidget.setEnabled(True) return #告诉windows单线程 pythoncom.CoInitialize() #在用户选择的目录中查找大纲文档 self.sin_out.emit('打开测评大纲文档...') #使用win32com打开-记得关闭 #打开word应用 self.w = DispatchEx('Word.Application') #self.w.visible=True self.w.DisplayAlerts = 0 try: dagangfile = self.w.Documents.Open(self.parent.open_file_name[0]) except: self.sin_out.emit('open failed:选择的文档') self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return self.sin_out.emit('复制测试说明文档模板到本程序所在目录...') curpath = Path.cwd() / 'need' shuoming_path_tmp = curpath / 'document_templates' / '测试说明模板.docx' print(shuoming_path_tmp) if shuoming_path_tmp.is_file(): self.sin_out.emit('已检测到有说明模板文件...') else: self.sin_out.emit('open failed:选择的文档') return #创建一个字典来储存单个用例 data_list = [] #获取表格数量 try: csx_tb_count = dagangfile.Tables.Count self.sin_out.emit('total:' + str(csx_tb_count)) except: self.sin_out.emit('不存在表格！') QMessageBox.warning(self.parent, '出错了', '测试说明文档格式错误或者没有正确表格') try: dagangfile.Close() except: pass self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return #循环表格 yongli_count = 0 #用来储存章节号中的DC、SU等标识，用于章节号判断 is_fire_su = "" #用来储存基本_分割后个数 num_fenge = 3 for i in range(csx_tb_count): self.sin_out.emit(str(i)) if dagangfile.Tables[i].Rows.Count > 2: #注意win32com的Cell从1开始不是从0开始 if dagangfile.Tables[i].Cell(1, 1).Range.Text.find('测试项名称') != -1: #一个用例不变内容获取 dagangfile.Tables[i].Rows.First.Select() zhangjiehao = self.w.Selection.Bookmarks("\headinglevel").\ Range.Paragraphs(1).Range.ListFormat.ListString zhangjieming = self.w.Selection.Bookmarks("\headinglevel").\ Range.Paragraphs(1).Range.Text.rstrip('\r') print("测试项所在章节号：", zhangjiehao) #获取用例标识不加上序号_1 basic_biaoshi = dagangfile.Tables[i].Cell( 1, 4).Range.Text.rstrip()[:-2] print("测试项标识为：", basic_biaoshi) #储存num_fenge的数值，初始化 if yongli_count == 0: num_fenge = len(basic_biaoshi.split("_")) #获取测试用例名称Cell(4,2)整行 info_ceshi_buzhou = dagangfile.Tables[i].Cell(4, 2).Range.Text info_ceshi_yuqi = dagangfile.Tables[i].Cell(9, 2).Range.Text #判断是否只有一行，如果只有一行处理表格 if dagangfile.Tables[i].Cell( 4, 2).Range.Paragraphs.Count <= 1: #缓存一个用例的data填入数据 data = {'zhangjie':'','mingcheng':'','biaoshi':'','is_first':'1', \ 'yueshu':'软件正常工作，环境连接正常', 'yongli_biaoshi':'','renyuan':'陈俊亦',\ 'chushi':'外接设备或软件运行正常','csx_mingcheng':'','is_begin':'0',\ 'zongsu':'',"zuhe":[],'csxbs':""} zuhe_dict = {"buzhou": "", "yuqi": "", "xuhao": "1"} try: #填写一行情况下表格 data['mingcheng'] = dagangfile.Tables[i].Cell( 1, 2).Range.Text.rstrip('\r\x07') #注意word中后面都有2个字符 data['yongli_biaoshi'] = (basic_biaoshi + "_1").replace( 'XQ', 'YL') data['zhangjie'] = zhangjiehao data['csx_mingcheng'] = zhangjieming data['biaoshi'] = basic_biaoshi data['zongsu'] = dagangfile.Tables[i].Cell( 3, 2).Range.Text[:-2] zuhe_dict["buzhou"] = dagangfile.Tables[i].Cell( 4, 2).Range.Text.rstrip('\r\x07') zuhe_dict["yuqi"] = dagangfile.Tables[i].Cell( 9, 2).Range.Text.rstrip('\r\x07') zuhe_dict["xuhao"] = '1' data["zuhe"].append(zuhe_dict) #判断是否为第一个测试类型，如果是修改章节号标识,则将章节号展示，如果和储存相同 #则章节号不展示 #首先获取测试项标识，分割成列表 fenge = data['biaoshi'].split("_") #获取当前测试项分割后的个数 if len(fenge) == 4: if fenge[-2] != is_fire_su: is_fire_su = fenge[-2] data['is_begin'] = "1" data['csxbs'] = zhuan_dict[fenge[-2]] elif len(fenge) == 3: if fenge[-1] == 'DC' or fenge[ -1] == 'CR' or fenge[-1] == 'SA': if fenge[-1] != is_fire_su: is_fire_su = fenge[-1] data['is_begin'] = "1" data['csxbs'] = zhuan_dict[fenge[-1]] else: if fenge[-2] != is_fire_su: is_fire_su = fenge[-2] data['is_begin'] = "1" data['csxbs'] = zhuan_dict[fenge[-2]] else: if fenge[-1] != is_fire_su: is_fire_su = fenge[-1] data['is_begin'] = "1" data['csxbs'] = zhuan_dict[fenge[-1]] if self.parent.lineEdit.text(): data['renyuan'] = self.parent.lineEdit.text() #将data加入data_list data['is_first'] = "1" data_list.append(data) yongli_count += 1 self.sin_out.emit( '###获取用例序号：{}'.format(yongli_count)) self.sin_out.emit('###该用例标识为：{}'.format( data['yongli_biaoshi'])) except: self.sin_out.emit( f'$$$$$$$$$$$$第{str(i+1)}个表格处理失败$$$$$$$$$$$$') pass elif dagangfile.Tables[i].Cell( 4, 2).Range.Paragraphs.Count > 1: try: #下面拆分每行，使用\r（回车）分割 info_buzhou_list = list( filter(lambda x: x != "\x07" and x != "", info_ceshi_buzhou.split('\r'))) info_yuqi_list = list( filter(lambda x: x != "\x07" and x != "", info_ceshi_yuqi.split('\r'))) #去掉括号和以下字符 rule = "[;；。]" #rule为去掉的符号（这个可以改TODO） #初始化去掉rule的列表 buzhou_list = [] yuqi_list = [] for item in info_buzhou_list: index = item.find("(") if index != -1: item = item[index + 1:] index = item.find("（") if index != -1: item = item[index + 1:] index = item.find(")") if index != -1: item = item[index + 1:] index = item.find("）") if index != -1: item = item[index + 1:] buzhou_list.append( re.sub(rule, "", item).lstrip(string.digits)) for item in info_yuqi_list: index = item.find("(") if index != -1: item = item[index + 1:] index = item.find("（") if index != -1: item = item[index + 1:] index = item.find(")") if index != -1: item = item[index + 1:] index = item.find("）") if index != -1: item = item[index + 1:] yuqi_list.append( re.sub(rule, "", item).lstrip(string.digits)) #获取测试项综述-为该循环前不变内容 basic_zongshu = buzhou_list.pop(0).strip() print('获取的测试用例综述是：', data["zongsu"]) #获取字典中的buzhou和yuqi,找冒号 j = -1 #自制列表索引 substrict_list = [] #差值列表 for item in buzhou_list: #先找到冒号所在索引 j = j + 1 if item.find(":") != -1 or item.find( "：") != -1: #现在知道冒号所在行号，现在要确定每个用例几行 substrict_list.append(j) #！！！注意差值计算步骤需要-1才是正确的步骤数量 # self.sin_out.emit("解析测试项序号"+ str(i) + "|检测到冒号所在行号为：" \ # + str(substrict_list)) # self.sin_out.emit("|检测到步骤总行数(序号)：" \ # + str(len(buzhou_list))) #循环用例个数 count_test = len(substrict_list) temp_list = substrict_list temp_list.append(len(buzhou_list)) for item in range(count_test): #初始化data数据,包括步骤和预期、序号dict data = {'zhangjie':'','mingcheng':'','biaoshi':'','is_first':'0', \ 'yueshu':'软件正常工作，环境连接正常', 'yongli_biaoshi':'','renyuan':'陈俊亦',\ 'chushi':'外接设备或软件运行正常','csx_mingcheng':'','is_begin':'0',\ 'zongsu':'',"zuhe":[],'csxbs':""} #这里要求冒号最后一个 data['mingcheng'] = buzhou_list[ substrict_list[item]][:-1] data['yongli_biaoshi'] = ( basic_biaoshi + f'_{item+1}').replace( 'XQ', 'YL') #常规填入 data['zhangjie'] = zhangjiehao data['csx_mingcheng'] = zhangjieming data['biaoshi'] = basic_biaoshi data['zongsu'] = basic_zongshu #步骤填入,首先根据substrict_list获取有几个步骤 #循环行数 for x in range(temp_list[item + 1] - (temp_list[item] + 1)): #循环一个用例步骤预期数 zuhe_dict = { "buzhou": "", "yuqi": "", "xuhao": "" } #把每个步骤和预期都放进zuhe_dict中 zuhe_dict["buzhou"] = buzhou_list[ temp_list[item] + x + 1] zuhe_dict["yuqi"] = yuqi_list[ temp_list[item] + x + 1] zuhe_dict["xuhao"] = str(x + 1) data["zuhe"].append(zuhe_dict) if item == 0: data['is_first'] = '1' #判断是否为SU标题 fenge = data['biaoshi'].split("_") #获取当前测试项分割后的个数 if len(fenge) == 4: if fenge[-2] != is_fire_su: is_fire_su = fenge[-2] data['is_begin'] = "1" data['csxbs'] = zhuan_dict[fenge[-2]] elif len(fenge) == 3: if fenge[-1] == 'DC' or fenge[ -1] == 'CR' or fenge[-1] == 'SA': if fenge[-1] != is_fire_su: is_fire_su = fenge[-1] data['is_begin'] = "1" data['csxbs'] = zhuan_dict[ fenge[-1]] else: if fenge[-2] != is_fire_su: is_fire_su = fenge[-2] data['is_begin'] = "1" data['csxbs'] = zhuan_dict[ fenge[-2]] else: if fenge[-1] != is_fire_su: is_fire_su = fenge[-1] data['is_begin'] = "1" data['csxbs'] = zhuan_dict[fenge[-1]] if self.parent.lineEdit.text(): data[ 'renyuan'] = self.parent.lineEdit.text( ) #加入data_list data_list.append(data) yongli_count += 1 #用例计数加一 self.sin_out.emit( '###获取用例序号：{}'.format(yongli_count)) self.sin_out.emit('###该用例标识为：{}'.format( data['yongli_biaoshi'])) except: self.sin_out.emit( f'$$$$$$$$$$$$第{str(i+1)}个表格处理失败$$$$$$$$$$$$') pass #关闭大纲文档（因为以及提取完毕） try: dagangfile.Close() self.w.Quit() pythoncom.CoUninitialize() except: self.sin_out.emit('function fail') self.w.Quit() pythoncom.CoUninitialize() return #打开模板文件进行渲染，然后就是用docxtpl生成用例 try: tpl_path = Path.cwd( ) / "need" / "document_templates" / "测试说明模板.docx" self.sin_out.emit('导入模板文件路径为：' + str(tpl_path)) tpl = DocxTemplate(tpl_path) #模板导入成功 except: QMessageBox.warning(self.parent, "出错了", "导入模板出错请检查模板文件是否存在或名字不正确") return #开始渲染模板文件-有2层循环 try: context = { "tables": data_list, } tpl.render(context) tpl.save("生成的说明文档.docx") self.sin_out.emit('stopsuccess') except: self.sin_out.emit('stoperror') return ################################################################################## #大纲生成追踪关系 ################################################################################## class create_dagang_zhuisu(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent def run(self): self.sin_out.emit("进入大纲追踪线程......") self.sin_out.emit("开始填写追踪......") #如果没有选择路径则退出 if not self.parent.open_file_name: self.sin_out.emit('nofile') self.parent.tabWidget.setEnabled(True) return #告诉windows单线程 pythoncom.CoInitialize() #在用户选择的目录中查找大纲文档 self.sin_out.emit('打开测评大纲文档...') #使用win32com打开-记得关闭 #打开word应用 self.w = DispatchEx('Word.Application') #self.w.visible=True self.w.DisplayAlerts = 0 try: dagangfile = self.w.Documents.Open(self.parent.open_file_name[0]) except: self.sin_out.emit('open failed:选择的文档') self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return curpath = Path.cwd() / 'need' zhuisu_path_tmp = curpath / 'document_templates' / '大纲追踪模板.docx' print(zhuisu_path_tmp) if zhuisu_path_tmp.is_file(): self.sin_out.emit('已检测到有追溯模板文件...') else: self.sin_out.emit('open failed:选择的文档') return #创建个列表放数据 data_list = [] data2_list = [] try: csx_tb_count = dagangfile.Tables.Count self.sin_out.emit('total:' + str(csx_tb_count)) except: self.sin_out.emit('不存在表格！') QMessageBox.warning(self.parent, '出错了', '测试说明文档格式错误或者没有正确表格') try: dagangfile.Close() except: pass self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return for i in range(csx_tb_count): self.sin_out.emit(str(i)) self.sin_out.emit("正在处理第{}个表格...".format(str(i))) print("正在处理第{}个表格...".format(str(i))) #准备填入的data data = { 'xuqiu': [], 'dg_zhangjie': '', 'mingcheng': '', 'biaoshi': '' } data2 = { 'xuqiu': [], 'dg_zhangjie': '', 'mingcheng': '', 'biaoshi': '' } if dagangfile.Tables[i].Rows.Count > 2: #注意win32com的Cell从1开始不是从0开始 if dagangfile.Tables[i].Cell(1, 1).Range.Text.find('测试项名称') != -1: #一个用例不变内容获取 dagangfile.Tables[i].Rows.First.Select() #获取测试项章节号 zhangjiehao = self.w.Selection.Bookmarks("\headinglevel").\ Range.Paragraphs(1).Range.ListFormat.ListString #获取测试项章节名 zhangjieming = self.w.Selection.Bookmarks("\headinglevel").\ Range.Paragraphs(1).Range.Text.rstrip('\r') biaoshi = dagangfile.Tables[i].Cell( 1, 4).Range.Text.rstrip()[:-2] #获取需规的章节号和描述 if dagangfile.Tables[i].Cell( 2, 1).Range.Text.find("追踪关系") != -1: zhuizong_tmp = dagangfile.Tables[i].Cell( 2, 2).Range.Text[:-2] #由于有/的存在，先判断/和隐含需求 zhuizong_list = zhuizong_tmp.split("\r") print(zhuizong_list) if zhuizong_tmp == "/" or zhuizong_tmp == "隐含需求": xuqiu_dict = { 'xq_zhangjie': '/', 'xq_miaoshu': '/' } data['xuqiu'].append(xuqiu_dict) data2['xuqiu'].append(xuqiu_dict) else: if len(zhuizong_list) >= 1: for item in zhuizong_list: xuqiu_dict = {} if item.find("需求") != -1: try: match_string = re.search( "\d(.\d+)+", item).group() match_ming = item.split( match_string)[-1] xuqiu_dict[ 'xq_zhangjie'] = match_string xuqiu_dict[ 'xq_miaoshu'] = match_ming.lstrip( " ") data['xuqiu'].append(xuqiu_dict) except: self.sin_out.emit( f'$$$$$$$$$$$$第{str(i+1)}个表格无章节号$$$$$$$$$$$$' ) self.sin_out.emit( "转换终止！请检查表格中追踪关系有无章节号") pass else: try: match_string = re.search( "\d(.\d+)+", item).group() match_ming = item.split( match_string)[-1] xuqiu_dict[ 'xq_zhangjie'] = match_string xuqiu_dict[ 'xq_miaoshu'] = match_ming.lstrip( " ") data2['xuqiu'].append(xuqiu_dict) except: self.sin_out.emit( f'$$$$$$$$$$$$第{str(i+1)}个表格无章节号$$$$$$$$$$$$' ) self.sin_out.emit( "转换终止！请检查表格中追踪关系有无章节号") pass #如果追踪关系行数小于1行的情况 else: xuqiu_dict = { 'xq_zhangjie': '/', 'xq_miaoshu': '/' } data['xuqiu'].append(xuqiu_dict) data2['xuqiu'].append(xuqiu_dict) try: data['dg_zhangjie'] = zhangjiehao data['mingcheng'] = zhangjieming data['biaoshi'] = biaoshi data_list.append(data) data2['dg_zhangjie'] = zhangjiehao data2['mingcheng'] = zhangjieming data2['biaoshi'] = biaoshi data2_list.append(data2) except: print("获取追踪出错啦！") self.sin_out.emit( f'$$$$$$$$$$$$第{str(i+1)}个表格追踪处理失败$$$$$$$$$$$$' ) pass #最后关闭文档 try: self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) except: QMessageBox.warning(self.parent, "关闭文档失败", "关闭文档失败！") return try: tpl_path = Path.cwd( ) / "need" / "document_templates" / "大纲追踪模板.docx" self.sin_out.emit('导入模板文件路径为：' + str(tpl_path)) tpl = DocxTemplate(tpl_path) #模板导入成功 except: QMessageBox.warning(self.parent, "出错了", "导入模板出错请检查模板文件是否存在或名字不正确") return #开始渲染模板文件 try: context = { "tables": data_list, "tables2": data2_list, } tpl.render(context) tpl.save("生成的大纲追踪文档.docx") self.sin_out.emit('stopsuccess') except: QMessageBox.warning(self.parent, "生成文档出错", "生成文档错误，请确认模板文档是否已打开或格式错误") self.sin_out.emit('stoperror') return ################################################################################## #单元测试UAS转换 ################################################################################## class create_danyuan(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent def run(self): self.sin_out.emit("进入单元测试SunwiseAUnit转换线程......") self.sin_out.emit("开始填写文档......") #如果没有选择路径则退出 if not self.parent.open_file_name: self.sin_out.emit('nofile') self.parent.tabWidget.setEnabled(True) return #告诉windows单线程 pythoncom.CoInitialize() #在用户选择的目录中查找UAS单位测试报告文档 self.sin_out.emit('打开单元测试原文件...') #使用win32com打开-记得关闭 #打开word应用 self.w = DispatchEx('Word.Application') #self.w.visible=True self.w.DisplayAlerts = 0 try: danyuanfile = self.w.Documents.Open(self.parent.open_file_name[0]) except: self.sin_out.emit('open failed:选择的文档') self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return curpath = Path.cwd() / 'need' danyuan_file_tmp = curpath / 'document_templates' / 'SunwiseAUnit单元测试转换模板.docx' print(danyuan_file_tmp) if danyuan_file_tmp.is_file(): self.sin_out.emit('已检测到有追溯模板文件...') else: self.sin_out.emit('open failed:选择的文档') return #创建个列表放数据-important data_list = [] #try统计表格数量 try: csx_tb_count = danyuanfile.Tables.Count self.sin_out.emit('total:' + str(csx_tb_count)) self.sin_out.emit("正在调用word文档操作接口,可能会有点慢...") except: self.sin_out.emit('不存在表格！') QMessageBox.warning(self.parent, '出错了', '测试说明文档格式错误或者没有正确表格') try: danyuanfile.Close() except: pass self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return #开始处理表格-important #我先统计有多少个生成的表格-即用例有多少个呗 yongli_count = 0 for i in range(csx_tb_count): if danyuanfile.Tables[i].Rows.Count > 2: #注意win32com的Cell从1开始不是从0开始 if danyuanfile.Tables[i].Cell(1, 1).Range.Text.find('用例名称') != -1: yongli_count += 1 #yongli_num指向当前处理的用例 yongli_num = 0 hanshuming = '' hanshuming_duibi = '' wenjian = '' wenjian_duibi = '' for i in range(csx_tb_count): self.sin_out.emit('正在处理的表格序号：' + str(yongli_num + 1)) self.sin_out.emit(str(i)) #准备填入的data data = {'ruanjian_ming':'','ruanjian_biaoshi':'yongli_biaoshi','wenjian_ming':'',\ 'hanshu_ming':'','bianlian_and_canshu':'','zhuang':[],\ 'yuqi_jieguo':'','ceshi_jieguo':'','is_begin':'0','is_wenjian':'0'} #填入用户输入的软件名 try: data['ruanjian_ming'] = self.parent.lineEdit_2.text() data['ruanjian_biaoshi'] = self.parent.lineEdit_3.text() except: QMessageBox.critical(self.parent, "未填入数据", "请先填入软件名和软件标识或.C名称") self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) pass #找到函数名,这里容易出问题 if danyuanfile.Tables[i].Rows.Count > 2: if danyuanfile.Tables[i].Cell(1, 1).Range.Text.find('功能描述') != -1: danyuanfile.Tables[i].Cell(1, 1).Range.Select() self.w.Selection.MoveUp() self.w.Selection.MoveUp() self.w.Selection.MoveUp() s = self.w.Selection.Paragraphs(1).Range.Text[:-1] s1 = s.split(". ")[-1] #放入函数名比对 if s1 != hanshuming_duibi: hanshuming_duibi = s1 #再向上看1行 self.w.Selection.MoveUp() temp2 = self.w.Selection.Paragraphs(1).Range.Text[:-1] s2 = temp2.split("\\")[-1] if '.' in temp2 and '\\' in temp2: print('@@@@@@:', s2) if s2 != wenjian_duibi: #这里有改动 wenjian_duibi = s2 #找章节号 if danyuanfile.Tables[i].Rows.Count > 2: #注意win32com的Cell从1开始不是从0开始 if danyuanfile.Tables[i].Cell(1, 1).Range.Text.find('用例名称') != -1: #TODO：如何找到测试模块？ biaoshi_temp = danyuanfile.Tables[i].Cell( 1, 4).Range.Text[:-2] data['yongli_biaoshi'] = biaoshi_temp #获取表格中参数组合() quanju = danyuanfile.Tables[i].Cell(5, 3).Range.Text[:-2] hcan = danyuanfile.Tables[i].Cell(6, 3).Range.Text[:-2] qitashu = danyuanfile.Tables[i].Cell(7, 3).Range.Text[:-2] if quanju.find('无') != -1: quanju = "" if hcan.find('无') != -1: hcan = "" if qitashu.find('无') != -1: qitashu = "" data['bianlian_and_canshu'] = quanju + hcan + qitashu #将预期结果和测试结果填入 data['yuqi_jieguo'] = danyuanfile.Tables[i].Cell( 8, 2).Range.Text[:-2] data['ceshi_jieguo'] = danyuanfile.Tables[i].Cell( 13, 2).Range.Text[:-2] #函数名获取 if hanshuming_duibi != hanshuming: hanshuming = hanshuming_duibi data['is_begin'] = '1' data['hanshu_ming'] = hanshuming_duibi #文件名获取 if wenjian_duibi != wenjian: wenjian = wenjian_duibi data['is_wenjian'] = '1' data['wenjian_ming'] = wenjian_duibi data_list.append(data) yongli_num += 1 #用例创建加一 elif danyuanfile.Tables[i].Cell(1, 2).Range.Text.find('定义') != -1: #定义个桩函数dict zhuang_dict = {'zhuang_name':'','zhuang_dingyi':'','zhuang_fanhui':'',\ 'zhuang_fuzuoyong':''} zhuang_dict['zhuang_name'] = danyuanfile.Tables[i].Cell( 1, 1).Range.Text[:-2] zhuang_dict['zhuang_dingyi'] = danyuanfile.Tables[i].Cell( 1, 3).Range.Text[:-2] zhuang_dict['zhuang_fanhui'] = danyuanfile.Tables[i].Cell(2, 3).Range.Paragraphs(1).\ Range.Text[:-1] #副作用可能有多行 fuzuoyong_temp = '' for count_fuzuo in range( len(danyuanfile.Tables[i].Cell( 2, 3).Range.Paragraphs) - 2): fuzuoyong_temp = fuzuoyong_temp + ';' + danyuanfile.Tables[i].Cell(2, 3).\ Range.Paragraphs(count_fuzuo + 3).Range.Text[:-2].replace(" ", "") zhuang_dict['zhuang_fuzuoyong'] = fuzuoyong_temp data_list[yongli_num - 1]['zhuang'].append(zhuang_dict) #最后关闭文档 try: self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) except: QMessageBox.warning(self.parent, "关闭文档失败", "关闭文档失败！") return try: tpl_path = Path.cwd( ) / "need" / "document_templates" / "SunwiseAUnit单元测试转换模板.docx" self.sin_out.emit('导入模板文件路径为：' + str(tpl_path)) tpl = DocxTemplate(tpl_path) #模板导入成功 except: QMessageBox.warning(self.parent, "出错了", "导入模板出错请检查模板文件是否存在或名字不正确") return #开始渲染模板文件 try: context = { "tables": data_list, } tpl.render(context) tpl.save("软件单元测试用例记录表.docx") self.sin_out.emit('stopsuccess') except: self.sin_out.emit('stoperror') return ################################################################################## #测试说明追踪以及用例表 ################################################################################## class create_shuoming_zhuisu(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent def run(self): self.sin_out.emit("进入说明追踪线程......") self.sin_out.emit("开始填写说明追踪以及用例表格......") # 如果没有选择文件 if not self.parent.open_file_name: self.sin_out.emit('nofile') self.parent.tabWidget.setEnabled(True) return # 告诉windows单线程 pythoncom.CoInitialize() # 在用户选择的目录中查找大纲文档 self.sin_out.emit('打开测试说明文档...') # 使用win32com打开-记得关闭 # 打开word应用 self.w = DispatchEx('Word.Application') # self.w.visible=True self.w.DisplayAlerts = 0 try: shuomingfile = self.w.Documents.Open(self.parent.open_file_name[0]) except: self.sin_out.emit('open failed:选择的文档') self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return self.sin_out.emit('已正确打开说明文档...') curpath = Path.cwd() / 'need' zhuisu_path_tmp = curpath / 'document_templates' / '说明追踪模板.docx' print("打开追踪模板文件", zhuisu_path_tmp) if zhuisu_path_tmp.is_file(): self.sin_out.emit('已检测到有说明追溯模板文件...') else: self.sin_out.emit('open failed:选择的文档') return # 创建个列表放数据 data_list = [] data2_list = [] #统计整个表格数量用于processbar显示进度 try: tb_count = shuomingfile.Tables.Count self.sin_out.emit('total:' + str(tb_count)) except: self.sin_out.emit('不存在表格！') QMessageBox.warning(self.parent, '出错了', '测试说明文档格式错误或者没有正确表格') try: shuomingfile.Close() except: QMessageBox.warning(self.parent, '错误', "未正确关闭Word文档！") return self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return #遍历循环表格，这里面就要初始化数据dict了 #不能像大纲追踪一样data在循环表格里面 #创建一个大纲测试项索引 csx_name = '' data = { 'dg_zhangjie': '', 'mingcheng': '', 'biaoshi': '', 'yongli': [], 'index': 0 } for i in range(tb_count): self.sin_out.emit(str(i)) #self.sin_out.emit("正在处理第{}个表格...".format(str(i+1))) print("正在处理第{}个表格...".format(str(i + 1))) # 准备填入的data data2 = { 'yongli_ming': '', 'yongli_biaoshi': '', 'yongli_zongsu': '' } yongli_dict = {'yongli_ming': '', 'yongli_biaoshi': ''} yongliming = '' biaoshi = '' zongsu = '' zhui_temp = '' if shuomingfile.Tables[i].Rows.Count > 2: try: # 注意win32com的Cell从1开始不是从0开始 if shuomingfile.Tables[i].Cell(1, 1).Range.Text.find('测试用例名称') != -1 or \ shuomingfile.Tables[i].Cell(2, 1).Range.Text.find('测试用例名称') != -1: #取出cell(1,,1)的数据 table_heard = shuomingfile.Tables[i].Cell(1, 1).Range.Text if table_heard.find("测试用例名称") != -1: yongliming = shuomingfile.Tables[i].Cell( 1, 2).Range.Text.rstrip()[:-2] biaoshi = shuomingfile.Tables[i].Cell( 1, 4).Range.Text.rstrip()[:-2] zongsu = shuomingfile.Tables[i].Cell( 3, 2).Range.Text.rstrip()[:-2] zhui_temp = shuomingfile.Tables[i].Cell( 2, 2).Range.Text.rstrip()[:-2] elif table_heard.find('用例') != -1: yongliming = shuomingfile.Tables[i].Cell( 2, 2).Range.Text.rstrip()[:-2] biaoshi = shuomingfile.Tables[i].Cell( 2, 4).Range.Text.rstrip()[:-2] zongsu = shuomingfile.Tables[i].Cell( 4, 2).Range.Text.rstrip()[:-2] zhui_temp = shuomingfile.Tables[i].Cell( 3, 2).Range.Text.rstrip()[:-2] else: self.sin_out.emit("未找到合适的填写数据，退出处理") print("未找到合适的填写数据") self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return shuomingfile.Tables[i].Rows.First.Select() # 获取测试项章节号 #############################目前模板不用获取用例章节号暂时省去 # zhangjiehao = self.w.Selection.Bookmarks("\headinglevel"). \ # Range.Paragraphs(1).Range.ListFormat.ListString # 获取测试项章节名 ############################################################## zhangjieming = self.w.Selection.Bookmarks("\headinglevel"). \ Range.Paragraphs(1).Range.Text.rstrip('\r') yongli_dict['yongli_ming'] = yongliming yongli_dict['yongli_biaoshi'] = biaoshi data2['yongli_ming'] = yongliming data2['yongli_biaoshi'] = biaoshi data2['yongli_zongsu'] = zongsu data2_list.append(data2) print("当前yongli_dict为：", yongli_dict) # 获取大纲的章节号和用例名，而且data按自己的来 ## 按python行进行分割为列表 zhui_list = zhui_temp.split("\r") if len(zhui_list) == 3: if zhui_list[1].find("需求") != -1: #使用re模块正则表达式 match_string = re.search( "\d(.\d+)+", zhui_list[1]).group() match_ming = zhui_list[1].split( match_string)[-1] #使用re.sub模块替换为空 rules = "[)(）（] " match_ming = re.sub(rules, '', match_ming) if zhui_list[2]: rules = ":" dg_biaoshi_temp = re.sub( rules, '：', zhui_list[2]) dg_biaoshi = dg_biaoshi_temp.split("：")[-1] #判断是否是新的测试项，如果是新的索引index加1，创建新dict进入 if zhangjieming != csx_name: data_list.append(data) data_index = data['index'] + 1 data = { 'dg_zhangjie': '', 'mingcheng': '', 'biaoshi': '', 'yongli': [], 'index': data_index } data['dg_zhangjie'] = match_string data['mingcheng'] = match_ming data['biaoshi'] = dg_biaoshi data['yongli'].append(yongli_dict) csx_name = zhangjieming self.sin_out.emit("已处理第{}个测试项...".format( data['index'])) else: data['yongli'].append(yongli_dict) except: self.sin_out.emit( f'$$$$$$$$$$$$第{str(i+1)}个表格，获取单元格内容不存在$$$$$$$$$$$$') pass # 最后关闭文档 try: self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) except: QMessageBox.warning(self.parent, "关闭文档失败", "关闭文档失败！") return try: tpl_path = Path.cwd( ) / "need" / "document_templates" / "说明追踪模板.docx" self.sin_out.emit('导入模板文件路径为：' + str(tpl_path)) tpl = DocxTemplate(tpl_path) # 模板导入成功 except: QMessageBox.warning(self.parent, "出错了", "导入模板出错请检查模板文件是否存在或名字不正确") return # 开始渲染模板文件 try: context = { "tables": data_list, "tables2": data2_list, } tpl.render(context) tpl.save("说明追踪文档.docx") self.sin_out.emit('stopsuccess') except: self.sin_out.emit('stoperror') return ################################################################################## #根据说明生成测试记录线程 ################################################################################## class create_jilu(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent def run(self): #用来储存章节号转换 zhuan_dict = {'DC':'文档审查','SU':'功能测试','CR':'代码审查','SA':'静态分析','AC':'性能测试',\ 'IO':'接口测试','SE':'安全性测试','BT':'边界测试','RE':'恢复性测试','ST':'强度测试',\ 'AT':'余量测试','GUI':'人机交互界面测试','DP':'数据处理测试','JR':'兼容性测试',\ 'LG':'逻辑测试','AZ':'安装性测试','TT':'时序测试','PA':'功耗分析'} self.sin_out.emit("进入根据说明转换记录线程......") self.sin_out.emit("开始转换......") #如果没有选择文件则退出 if not self.parent.open_file_name: self.sin_out.emit('nofile') self.parent.tabWidget.setEnabled(True) return pythoncom.CoInitialize() self.sin_out.emit('打开说明文档...') self.w = DispatchEx('Word.Application') self.w.DisplayAlerts = 0 try: shuomingfile = self.w.Documents.Open(self.parent.open_file_name[0]) except: self.sin_out.emit('open failed:选择的文档') self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return self.sin_out.emit('复制测试记录文档模板到本程序所在目录...') curpath = Path.cwd() / 'need' shuoming_path_tmp = curpath / 'document_templates' / '说明生成记录模板.docx' if shuoming_path_tmp.is_file(): self.sin_out.emit('已检测到有记录模板文件...') else: self.sin_out.emit('open failed:选择的文档') return #创建一个字典来储存单个用例 data_list = [] #获取表格数量 try: csx_tb_count = shuomingfile.Tables.Count self.sin_out.emit('total:' + str(csx_tb_count)) except: self.sin_out.emit('不存在表格，请检查文档！') QMessageBox.warning(self.parent, '出错了', '测试说明文档格式错误或者没有正确表格') try: shuomingfile.Close() except: pass self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return #用来储存章节号中的DC、SU等标识，用于章节号判断 is_type_su = "" #储存章节号标志 is_fire_su = "" for i in range(csx_tb_count): self.sin_out.emit(str(i)) self.sin_out.emit("正在处理第{}个表格".format(i + 1)) try: if shuomingfile.Tables[i].Rows.Count > 2: if shuomingfile.Tables[i].Cell( 2, 1).Range.Text.find('测试用例名称') != -1: #一个用例不变内容获取 try: shuomingfile.Tables[i].Rows.First.Select() #获取章节名，用于判断 zhangjieming = self.w.Selection.Bookmarks("\headinglevel").\ Range.Paragraphs(1).Range.Text.rstrip('\r') #获取表格基本信息 mingcheng = shuomingfile.Tables[i].Cell( 2, 2).Range.Text[:-2] biaoshi = shuomingfile.Tables[i].Cell( 2, 4).Range.Text[:-2] self.sin_out.emit(f"正在处理{biaoshi}用例{mingcheng}") zhuizong = shuomingfile.Tables[i].Cell( 3, 2).Range.Text[:-2] zongsu = shuomingfile.Tables[i].Cell( 4, 2).Range.Text[:-2] chushihua = shuomingfile.Tables[i].Cell( 5, 2).Range.Text[:-2] qianti = shuomingfile.Tables[i].Cell( 6, 2).Range.Text[:-2] #缓存一个data数据 data = {'mingcheng':'','biaoshi':'','zhuizong':'','is_first':'0',\ 'zongsu':'','chushihua':'','qianti':'','zuhe':[],'is_begin':'0',\ 'csx_type':'','csx_name':''} #获取步骤和预期 step_count = shuomingfile.Tables[i].Rows.Count - 11 for j in range(step_count): buzhou_dict = { 'buzhou': "", 'yuqi': "", 'xuhao': '' } buzhou_dict['buzhou'] = shuomingfile.Tables[ i].Cell(j + 9, 2).Range.Text[:-2] buzhou_dict['yuqi'] = shuomingfile.Tables[ i].Cell(j + 9, 3).Range.Text[:-2] buzhou_dict['xuhao'] = str(j + 1) data['zuhe'].append(buzhou_dict) #开始判断当前是否为测试项的第一个，如果是第一个则is_first改为1 if is_fire_su != zhangjieming: is_fire_su = zhangjieming data['is_first'] = '1' #判断测试类型，这里从标识里面获取 biaoshi_list = biaoshi.split("_") print('当前取的类型列表分割：', biaoshi_list) if len(biaoshi_list) >= 4: biaoshi_tmp = biaoshi_list[-3] else: biaoshi_tmp = biaoshi_list[1] if biaoshi_tmp != is_type_su: is_type_su = biaoshi_tmp data['is_begin'] = '1' if zhuan_dict[biaoshi_tmp] == '文档审查' or zhuan_dict[biaoshi_tmp] == '代码审查' or \ zhuan_dict[biaoshi_tmp] == '静态分析': data['is_first'] = '0' #data补全 data['mingcheng'] = mingcheng data['biaoshi'] = biaoshi data['zhuizong'] = zhuizong.replace('\r', '\n') data['zongsu'] = zongsu data['chushihua'] = chushihua data['qianti'] = qianti data['csx_type'] = zhuan_dict[biaoshi_tmp] data['csx_name'] = zhangjieming data_list.append(data) self.sin_out.emit("处理完毕{}用例".format(biaoshi)) except: self.sin_out.emit(f'错误！第{i+1}个表格处理失败!') except: self.sin_out.emit(f'错误！第{i+1}个表格处理失败!') #关闭大纲文档（因为以及提取完毕） try: shuomingfile.Close() self.w.Quit() pythoncom.CoUninitialize() except: self.sin_out.emit('function fail') self.w.Quit() pythoncom.CoUninitialize() return #打开模板文件进行渲染，然后就是用docxtpl生成用例 try: tpl_path = Path.cwd( ) / "need" / "document_templates" / "说明生成记录模板.docx" self.sin_out.emit('导入模板文件路径为：' + str(tpl_path)) tpl = DocxTemplate(tpl_path) #模板导入成功 except: QMessageBox.warning(self.parent, "出错了", "导入模板出错请检查模板文件是否存在或名字不正确") return #开始渲染模板文件-有2层循环 try: context = { "tables": data_list, "cs_renyuan": self.parent.lineEdit_4.text(), "jc_renyuan": self.parent.lineEdit_5.text(), "shijian": self.parent.lineEdit_6.text(), } tpl.render(context) tpl.save("生成的测试记录文档.docx") self.sin_out.emit('stopsuccess') except: self.sin_out.emit('stoperror') return ################################################################################## # 根据测试记录反向生成说明 ################################################################################## class create_shuomingfanxiang(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent def run(self): # 用来储存测试项DC等转换 zhuan_dict = {'DC':'文档审查','SU':'功能测试','CR':'代码审查','SA':'静态分析','AC':'性能测试',\ 'IO':'接口测试','SE':'安全性测试','BT':'边界测试','RE':'恢复性测试','ST':'强度测试',\ 'AT':'余量测试','GUI':'人机交互界面测试','DP':'数据处理测试','JR':'兼容性测试',\ 'LG':'逻辑测试','AZ':'安装性测试','TT':'时序测试','PA':'功耗分析'} self.sin_out.emit("进入测试记录转说明......") self.sin_out.emit("开始转换......") # 如果没有选择文件路径则退出 if not self.parent.open_file_name: self.sin_out.emit('nofile') self.parent.tabWidget.setEnabled(True) return pythoncom.CoInitialize() self.sin_out.emit('打开测试记录文件...') self.w = DispatchEx('Word.Application') #self.w.visible=True self.w.DisplayAlerts = 0 try: jilufile = self.w.Documents.Open(self.parent.open_file_name[0]) except: self.sin_out.emit('open failed:选择的文档') self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return self.sin_out.emit('复制测试说明文档模板到本程序所在目录...') curpath = Path.cwd() / 'need' shuoming_path_tmp = curpath / 'document_templates' / '反向测试说明模板.docx' print(shuoming_path_tmp) if shuoming_path_tmp.is_file(): self.sin_out.emit('已检测到有说明模板文件...') else: self.sin_out.emit('open failed:选择的文档') return #创建一个字典来储存单个用例 data_list = [] #获取表格数量 try: csx_tb_count = jilufile.Tables.Count self.sin_out.emit('total:' + str(csx_tb_count)) except: self.sin_out.emit('不存在表格！') QMessageBox.warning(self.parent, '出错了', '测试说明文档格式错误或者没有正确表格') try: jilufile.Close() except: pass self.w.Quit() pythoncom.CoUninitialize() self.parent.tabWidget.setEnabled(True) return #初始化表格外全局变量 is_fire_su = '' is_type_su = '' for i in range(csx_tb_count): self.sin_out.emit(str(i)) self.sin_out.emit(f"正在处理第{str(i+1)}个表格") if jilufile.Tables[i].Rows.Count > 2: if jilufile.Tables[i].Cell(2, 1).Range.Text.find('测试用例名称') != -1: #将表格中信息全部先拿出来 try: jilufile.Tables[i].Rows.First.Select() zhangjieming = self.w.Selection.Bookmarks("\headinglevel").\ Range.Paragraphs(1).Range.Text.rstrip('\r') zhangjiehao = self.w.Selection.Bookmarks("\headinglevel").\ Range.Paragraphs(1).Range.ListFormat.ListString mingcheng = jilufile.Tables[i].Cell(2, 2).Range.Text[:-2] biaoshi = jilufile.Tables[i].Cell(2, 4).Range.Text[:-2] self.sin_out.emit(f"正在处理{biaoshi}-用例{mingcheng}") zhuizong = jilufile.Tables[i].Cell(3, 2).Range.Text[:-2] zongsu = jilufile.Tables[i].Cell(4, 2).Range.Text[:-2] chushi = jilufile.Tables[i].Cell(5, 2).Range.Text[:-2] qianti = jilufile.Tables[i].Cell(6, 2).Range.Text[:-2] #缓存一个data数据 data = {'mingcheng':'','biaoshi':'','zhuizong':'','is_first':'0',\ 'zongsu':'','chushi':'','qianti':'','zuhe':[],'is_begin':'0',\ 'csx_type':'','csx_mingcheng':'','renyuan':''} #获取步骤和预期 step_count = jilufile.Tables[i].Rows.Count - 12 #获取人员信息 data['renyuan'] = jilufile.Tables[i].Cell( 10 + step_count, 2).Range.Text[:-2] for j in range(step_count): buzhou_dict = { 'buzhou': "", 'yuqi': "", 'xuhao': '' } buzhou_dict['buzhou'] = jilufile.Tables[i].Cell( j + 9, 2).Range.Text[:-2] buzhou_dict['yuqi'] = jilufile.Tables[i].Cell( j + 9, 3).Range.Text[:-2] buzhou_dict['xuhao'] = str(j + 1) data['zuhe'].append(buzhou_dict) # 开始判断当前是否为测试项的第一个，如果是第一个则is_first改为1 if is_fire_su != zhangjieming: is_fire_su = zhangjieming data['is_first'] = '1' # 判断测试类型，这里从标识里面获取 biaoshi_list = biaoshi.split("_") print('当前取的类型列表分割：', biaoshi_list) if len(biaoshi_list) >= 4: biaoshi_tmp = biaoshi_list[-4] else: biaoshi_tmp = biaoshi_list[1] if biaoshi_tmp != is_type_su: is_type_su = biaoshi_tmp data['is_begin'] = '1' if zhuan_dict[biaoshi_tmp] == '文档审查' or zhuan_dict[biaoshi_tmp] == '代码审查' or \ zhuan_dict[biaoshi_tmp] == '静态分析': data['is_first'] = '0' #data补全 data['mingcheng'] = mingcheng data['biaoshi'] = biaoshi data['zhuizong'] = zhuizong.replace('\r', '\n') data['zongsu'] = zongsu data['chushi'] = chushi data['qianti'] = qianti data['csx_type'] = zhuan_dict[biaoshi_tmp] data['csx_mingcheng'] = zhangjieming data_list.append(data) self.sin_out.emit("处理完毕{}用例".format(biaoshi)) except: self.sin_out.emit("第{}个表格处理失败，请检查".format(str(i + 1))) pass else: self.sin_out.emit( "该表格生成错误，请检查是否存在用例序号，每个用例必须有序号且必须包含【记录】两个字...") else: self.sin_out.emit("该表格生成错误，请检查表格是否存在并大于2行...") #关闭大纲文档（因为以及提取完毕） try: jilufile.Close() self.w.Quit() pythoncom.CoUninitialize() except: self.sin_out.emit('function fail') self.w.Quit() pythoncom.CoUninitialize() return #打开模板文件进行渲染，然后就是用docxtpl生成用例 try: tpl_path = Path.cwd( ) / "need" / "document_templates" / "反向测试说明模板.docx" self.sin_out.emit('导入模板文件路径为：' + str(tpl_path)) tpl = DocxTemplate(tpl_path) #模板导入成功 except: QMessageBox.warning(self.parent, "出错了", "导入模板出错请检查模板文件是否存在或名字不正确") return #开始渲染模板文件-有2层循环 try: context = { "tables": data_list, } tpl.render(context) tpl.save("反向生成的说明文档.docx") self.sin_out.emit('stopsuccess') except: self.sin_out.emit('stoperror') return ################################################################################## #自动填充单元格线程 ################################################################################## class create_zidong(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent def run(self): self.sin_out.emit('开始...') if self.parent.open_file_name == '': self.sin_out.emit('请点击“选择文档”按钮选择要填充的文档') self.parent.tabWidget.setEnabled(True) QMessageBox.warning(self.parent, '出错了！', '请选择要填充的文档！') return try: t_s_file = docx.Document(self.parent.open_file_name[0]) except: self.sin_out.emit('open failed:选择的文档') self.parent.tabWidget.setEnabled(True) QMessageBox.warning(self.parent, '出错了！', '打开选择的文档失败，请确认文档类型为docx，且未被打开！') return if self.parent.lineEdit_9.text() == '': self.sin_out.emit('单元格左侧不能为空！!!!') self.parent.tabWidget.setEnabled(True) QMessageBox.warning(self.parent, '出错了！', '单元格标题不能为空！') return if self.parent.lineEdit_10.text() == '': self.sin_out.emit('确定填充内容为空吗？填充内容为空相当于清空操作。可直接点击清空按钮！！') self.parent.tabWidget.setEnabled(True) QMessageBox.warning(self.parent, '警告！', '确定填充内容为空吗？填充内容为空相当于清空操作。可点击清空按钮！！') return tmp_fill = self.parent.lineEdit_11.text() if tmp_fill == '': tmp_fill = str(len(t_s_file.tables)) if (tmp_fill.strip().isdigit()) and (int(tmp_fill.strip()) < len( t_s_file.tables)): tmp_ran = int(tmp_fill) else: tmp_ran = len(t_s_file.tables) tmp_fillnum = 0 k = 0 self.sin_out.emit('total:' + str(tmp_ran)) self.parent.progressBar.setRange(0, tmp_ran - 1) for ft1 in t_s_file.tables: k += 1 self.sin_out.emit(str(k)) self.parent.progressBar.setValue(k) tmp_row = 0 for r in ft1.rows: tmpflag = 0 tmp_column = 0 for cell in r.cells: if cell.text.strip() == self.parent.lineEdit_9.text(): while ft1.cell(tmp_row, tmp_column).text.strip( ) == self.parent.lineEdit_9.text(): tmp_column += 1 #这里如果需要替换还是不替换 if ft1.cell(tmp_row, tmp_column).text == '': ft1.cell(tmp_row, tmp_column ).text = self.parent.lineEdit_10.text() tmp_fillnum += 1 else: pass tmpflag = 1 break else: tmp_column += 1 if tmpflag == 1: break tmp_row += 1 if tmp_fillnum >= int(tmp_fill): break try: t_s_file.save(self.parent.open_file_name[0]) self.sin_out.emit('function success') self.parent.tabWidget.setEnabled(True) return except: self.parent.tabWidget.setEnabled(True) self.sin_out.emit('function fail') QMessageBox.information(self.parent, '', '填充完成！') return ################################################################################## #清空单元格线程 ################################################################################## class clear_cell(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent def run(self): self.sin_out.emit('开始...') if self.parent.open_file_name == '': self.sin_out.emit('请点击“选择文档”按钮选择要填充的文档') self.parent.tabWidget.setEnabled(True) QMessageBox.warning(self.parent, '出错了！', '请选择要填充的文档！') return try: t_s_file = docx.Document(self.parent.open_file_name[0]) except: self.sin_out.emit('open failed:要填充的文档') QMessageBox.warning(self.parent, '出错了！', '打开选择的文档失败，请确认文档类型为docx，且未被打开！') self.parent.tabWidget.setEnabled(True) return if self.parent.lineEdit_9.text() == '': self.parent.tabWidget.setEnabled(True) self.sin_out.emit('单元格标题不能为空！') QMessageBox.warning(self.parent, '出错了！', '单元格标题不能为空！') return tmp_tblcnt = len(t_s_file.tables) k = 0 self.sin_out.emit('total:' + str(tmp_tblcnt)) for ft1 in t_s_file.tables: k += 1 self.sin_out.emit(str(k)) tmp_row = 0 for r in ft1.rows: tmpflag = 0 tmp_column = 0 for cell in r.cells: if cell.text.strip() == self.parent.lineEdit_9.text(): while ft1.cell(tmp_row, tmp_column).text.strip( ) == self.parent.lineEdit_9.text(): tmp_column += 1 ft1.cell(tmp_row, tmp_column).text = '' tmpflag = 1 break else: tmp_column += 1 if tmpflag == 1: break tmp_row += 1 try: t_s_file.save(self.parent.open_file_name[0]) self.sin_out.emit('function success') self.parent.tabWidget.setEnabled(True) return except: self.parent.tabWidget.setEnabled(True) self.sin_out.emit('function fail') QMessageBox.information(self.parent, '', '清空单元格成功！') return ################################################################################## #提取表格内容线程 ################################################################################## class get_content(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent #获取文档中表格内容函数 def run(self): curpath = Path.cwd() content_tmp = curpath / 'need' / 'document_templates' / 'get_content.docx' shutil.copy(content_tmp, curpath) content_tmp_path = curpath / 'get_content.docx' print(content_tmp_path) try: #c_file = self.w.Documents.Add() c_file = docx.Document(content_tmp_path) except: self.sin_out.emit('open failed:文档模板') self.parent.tabWidget.setEnabled(True) return try: s_file = docx.Document(self.parent.open_file_name[0]) s_tbls = s_file.tables except: self.sin_out.emit('open failed:选择的文档') c_file.save(content_tmp_path) self.parent.tabWidget.setEnabled(True) return #原来是5,6,7 if self.parent.lineEdit_12.text( ) == '' and self.parent.lineEdit_13.text( ) == '' and self.parent.lineEdit_14.text() == '': self.sin_out.emit( 'warning:请至少填写一个要提取的内容的标题，\n标题为要提取的单元格的前一单元格中的内容!') c_file.save(content_tmp_path) s_file.save(self.parent.open_file_name[0]) self.parent.tabWidget.setEnabled(True) return line_list = [ self.parent.lineEdit_12.text(), self.parent.lineEdit_13.text(), self.parent.lineEdit_14.text() ] self.sin_out.emit('开始提取...') rownum = 0 self.sin_out.emit('total:' + str(len(s_tbls))) for stb in s_tbls: c_file.tables[0].add_row() rownum += 1 self.sin_out.emit(str(rownum)) row = 0 for r1 in stb.rows: col = 0 for ce in r1.cells: if line_list[0] != '' and ce.text == line_list[0]: while stb.cell(row, col).text == line_list[0]: col += 1 c_file.tables[0].cell(rownum, 0).text = stb.cell(row, col).text break col += 1 col = 0 for ce in r1.cells: if line_list[1] != '' and ce.text == line_list[1]: while stb.cell(row, col).text == line_list[1]: col += 1 c_file.tables[0].cell(rownum, 1).text = stb.cell(row, col).text break col += 1 col = 0 for ce in r1.cells: if line_list[2] != '' and ce.text == line_list[2]: while stb.cell(row, col).text == line_list[2]: col += 1 c_file.tables[0].cell(rownum, 2).text = stb.cell(row, col).text break col += 1 row += 1 try: c_file.save(content_tmp_path) s_file.save(self.parent.open_file_name[0]) self.sin_out.emit('function success') self.sin_out.emit('生成文件名为(get_content.docx)，在根目录下查看') self.parent.tabWidget.setEnabled(True) return except: self.sin_out.emit('function fail') self.parent.tabWidget.setEnabled(True) return ################################################################################## #测评报告追溯表 ################################################################################## class create_baogao_zhuisu(QtCore.QThread): sin_out = pyqtSignal(str) def __init__(self, parent): super().__init__() self.parent = parent def run(self): self.sin_out.emit("进入报告追溯线程......") self.sin_out.emit("开始填写报告追溯表......") # 如果没有选择文件 if not self.parent.open_file_name: self.sin_out.emit('nofile') self.parent.tabWidget.setEnabled(True) return self.sin_out.emit('打开测试记录文档...') # 打开word应用 try: doc_path = self.parent.open_file_name[0] doc = Document(doc_path) except: self.sin_out.emit('open failed:选择的文档') self.parent.tabWidget.setEnabled(True) return self.sin_out.emit('已正确打开说明文档...') curpath = Path.cwd() / 'need' zhuisu_path_tmp = curpath / 'document_templates' / '报告追踪模板.docx' if zhuisu_path_tmp.is_file(): self.sin_out.emit('已检测到有报告追溯模板文件...') else: self.sin_out.emit('open failed:选择的文档') return # 创建个列表放数据 data_list = [] # 由于docx的是列表，所以直接len函数统计count count = len(doc.tables) self.sin_out.emit('total:' + str(count)) k = 0 for tb in doc.tables: k += 1 self.sin_out.emit('total:' + str(k)) #注意docx处理方式不一样从0开始，并且要算总行数 try: if tb.cell(1, 1).text.find('测试用例名称') != -1: data = { 'yongli_ming': '', 'yongli_biaoshi': '', 'yongli_qingkuang': '', 'beizhu': '' } data['yongli_ming'] = tb.cell(1, 4).text data['yongli_biaoshi'] = tb.cell(1, 8).text wenti = tb.rows[-2].cells[2] print('提取出来的信息：', wenti.text) if wenti.text == '/' or wenti.text == '': data['yongli_qingkuang'] = '通过' data['beizhu'] = '/' else: data['yongli_qingkuang'] = '不通过' data['beizhu'] = wenti.text self.sin_out.emit(f'处理完毕({tb.cell(1,8).text})用例..') data_list.append(data) else: self.sin_out.emit(f'当前表格({tb.cell(1,8).text})用例无法识别请检查') except: self.sin_out.emit(f'处理第{k}个表格失败，请检查该表格...') pass try: tpl_path = Path.cwd( ) / "need" / "document_templates" / '报告追踪模板.docx' self.sin_out.emit('导入模板文件路径为：' + str(tpl_path)) tpl = DocxTemplate(tpl_path) # 模板导入成功 except: QMessageBox.warning(self.parent, "出错了", "导入模板出错请检查模板文件是否存在或名字不正确") return # 开始渲染模板文件 print(data_list) try: context = { "tables": data_list, } tpl.render(context) tpl.save("说明追踪文档.docx") self.sin_out.emit('stopsuccess') except: self.sin_out.emit('stoperror') return ################################################################################## ## ##################################################################################