def WriteEXcleData(self, listdata=[], **kw):
if os.path.exists(self._excelpath):
pass
else:
self._excelpath = "Res/report.xls"
logger.exception(
"The file does not exist and the default path is used[report.xls]"
)
if listdata == self.listdata:
exceldata = self.ReadEXcleBasis()
w_xls = copy(exceldata)
w_xls.save(self._excelpath)
else:
try:
wb = xlwt.Workbook(encoding='utf-8')
sh = wb.add_sheet("Report")
for i in range(0, len(listdata), 3):
b = listdata[i:i + 3]
sh.write(b[0], b[1], b[2])
except IndexError:
logger.exception(
"File data is lost, incoming data cannot be triples, illegal"
)
finally:
wb.save(self._excelpath)
def dir(self):
try:
for parent, dirnames, filenames in os.walk(self.path,
followlinks=False):
for x in dirnames:
self.dirlist.append(x)
return self.dirlist
except OSError as reason:
logger.exception('出错啦！' + str(reason))
def selectconfig(self):
try:
file = QFileDialog()
file.setFileMode(QFileDialog.AnyFile)
file.setFilter(QDir.Files)
if file.exec_():
filename = file.selectedFiles()
PATHDATA['config'] = filename[0]
self.configLable.setText(filename[0])
except IOError:
logger.exception("选择数据不符规则数据无效")
def selectcase(self):
try:
file = QFileDialog()
file.setFileMode(QFileDialog.AnyFile)
file.setFilter(QDir.Files)
if file.exec_():
filename = file.selectedFiles()
if PATHDATA['TestCase'] != filename[0]:
self.pathchanged.emit()
PATHDATA['TestCase'] = filename[0]
self.caseLable.setText(filename[0])
else:
pass
except IOError:
logger.exception("选择数据不符规则数据无效")
def ReadEXcleData(self):
self.listdata = []
if self.ReadEXcleBasis() == None:
return self.listdata
else:
try:
data = self.ReadEXcleBasis()
table = data.sheet_by_index(0)
for h in range(table.nrows):
for l in range(table.ncols):
self.listdata.append(h)
self.listdata.append(l)
self.listdata.append(str(table.cell(h, l).value))
return self.listdata
except IOError:
logger.exception("Read File opening exception")
return self.listdata["1", "1", ""]
def WriteConfigData(self, outconfdata={}, **kw):
section = "Config"
if outconfdata == self.confdata:
logger.info("Configuration files are not changed to write")
else:
self.confdata = outconfdata
conf = configparser.ConfigParser()
try:
conf.add_section(section)
for key, value in self.confdata.items():
conf.set(section, str(key), str(value))
try:
with open(self._configpath, 'w') as fw:
conf.write(fw)
except IOError:
logger.exception(
"The file path does not exist and cannot be saved")
except:
logger.exception(
"File content exception incorrect writing erro")
def myui(self):
try:
self.dialog = ConfigDialog()
except:
logger.exception("配置文件初始化错误")
try:
self.widget = CentralView()
self.setCentralWidget(self.widget)
self.widget.Screenshotsignalhide.connect(self.winhide)
self.widget.Screenshotsignalshow.connect(self.winshow)
except:
self.widget = QWidget()
self.setCentralWidget(self.widget)
logger.exception("测试用例初始化错误")
exitAction = QAction(QIcon("Res/exit.png"), "退出", self)
exitAction.setShortcut("ctrl+q")
exitAction.setStatusTip("退出")
exitAction.triggered.connect(qApp.quit)
openfile = QAction(QIcon("Res/open.png"), "打开测试用例", self)
openfile.setShortcut("ctrl+o")
openfile.setStatusTip("打开测试用例")
openfile.triggered.connect(self.openfile_data)
savefile = QAction(QIcon("Res/save.png"), "保存", self)
savefile.setShortcut("ctrl+s")
savefile.setStatusTip("保存")
savefile.triggered.connect(self.save)
saveas = QAction(QIcon("Res/save.png"), "另保存", self)
saveas.setShortcut("ctrl+s+s")
saveas.setStatusTip("另保存")
saveas.triggered.connect(self.save_as)
self.runaction = QAction(QIcon("Res/run.png"), "运行", self)
self.runaction.setShortcut("ctrl+r")
self.runaction.setStatusTip("运行")
self.runaction.triggered.connect(self.run)
qtaction = QAction(QIcon("Res/qt.png"), "关于qt", self)
qtaction.setStatusTip("关于qt")
qtaction.triggered.connect(self.qt)
aboutaction = QAction(QIcon("Res/aboutus.png"), "关于我们", self)
aboutaction.setStatusTip("关于我们")
aboutaction.triggered.connect(self.aboutus)
self.freshenaction = QAction(QIcon("Res/aboutus.png"), "刷新", self)
self.freshenaction.setStatusTip("刷新列表")
self.freshenaction.setShortcut("F5")
self.freshenaction.triggered.connect(self.Refresh)
configaction = QAction(QIcon("Res/qt.png"), "配置", self)
configaction.setStatusTip("配置")
configaction.setShortcut("")
configaction.triggered.connect(self.guide)
filemenubar1 = self.menuBar()
filemenu = filemenubar1.addMenu("文件")
filemenu.addAction(openfile)
filemenu.addAction(self.runaction)
filemenu.addAction(savefile)
filemenu.addAction(saveas)
filemenu.addAction(exitAction)
filemenubar2 = self.menuBar()
filemenu = filemenubar2.addMenu("关于")
filemenu.addAction(qtaction)
filemenu.addAction(aboutaction)
filemenubar3 = self.menuBar()
filemenu = filemenubar3.addMenu("刷新")
filemenu.addAction(self.freshenaction)
timer = MyTimer()
tb = self.addToolBar("工具栏")
tb.addAction(self.runaction)
tb.addAction(openfile)
tb.addAction(savefile)
tb.addAction(configaction)
tb.addAction(self.freshenaction)
tb.setMovable(True)
tb.insertSeparator(openfile)
tb.setSizePolicy(QSizePolicy.Maximum, QSizePolicy.Fixed)
tb.addWidget(timer)
# self.text = QTextEdit()
# self.text.setSizePolicy(QSizePolicy.Maximum, QSizePolicy.Fixed)
# self.pbar = QProgressBar(self)
# self.pbar.setGeometry(1050, 730, 100, 20)
self.setGeometry(100, 100, 1120, 750)
# self.showFullScreen()
# self.setWindowState(Qt.windowNoState|Qt.windowFullScreen)
self.setWindowTitle("自动化")
self.setWindowIcon(QIcon("Res/aboutus.png"))
self.center()
self.show()