def button_clicked(self):
self.statusLabel.setText("Run")
print("Run")
excel = Excel.Excel(self.fileNameEdit.text())
self.fileNameEdit.text()
startDate = self.startDateEdit.text()
endDate = self.endDateEdit.text()
webData = WebData.WebData(startDate, endDate)
print("Web Data Run")
print(webData.run())
myDict = webData.getDict()
excel.write(1, 1, webData.run())
excel.write(1, 2, webData.getStockTitleList())
excel.write(1, 3, webData.getStockIDList())
excel.write(1, 4, myDict.values())
excel.write(1, 5, myDict.keys())
excel.save()
print("Save")
self.statusLabel.setText("Ready")
def exportSummaryResult(excelPath, smmaryResultDict):
print("excelPath = " + excelPath.replace("/", "\\"))
#excel = Excel(show=self.blnShowExcel, ifFailForceRestart=self.blnForceRestartExcel)
excel = Excel(show=True, ifFailForceRestart=False)
excel.get_sheet(1)
lineNum = 0
for (mainClass_k, mainClass_v) in smmaryResultDict.items():
lineNum += 1
excel.set_cell(lineNum, 1, mainClass_k)
colNum = 1
for (subClass_k, subClass_v) in mainClass_v.items():
colNum += 1
excel.set_cell(lineNum, colNum, subClass_k)
#for (sln_k, sln_v) in subClass_v:
subClass_key1 = mainClass_v.keys()[0]
subClass_v1 = mainClass_v[subClass_key1]
sln_keys = subClass_v1.keys()
for sln_key in sln_keys:
lineNum += 1
excel.set_cell(lineNum, 1, sln_key)
colNum = 1
for (subClass_k, subClass_v) in mainClass_v.items():
colNum += 1
print(subClass_v[sln_key])
excel.set_cell(lineNum, colNum, subClass_v[sln_key])
lineNum += 1
#excel.set_cell(1,1,"test")
excel.save(excelPath)
excel.close()
pass
d = (datetime.now() - timedelta(days=1)).strftime('%d')
h = (datetime.now() - timedelta(days=1)).strftime('%H')
M = (datetime.now() - timedelta(days=1)).strftime('%M')
S = (datetime.now() - timedelta(days=1)).strftime('%S')
isSendMail = func.get_config('global_value', 'isSendMail')
#主题调用函数
result, err_result, total_size_str = check_backup(Y, y, m, d)
if len(result) > 1:
att_filename = "xls/backuplist_" + str(Y) + "-" + str(m) + "-" + str(
d) + "_" + str(h) + str(M) + str(S) + ".xlsx"
hdngs = ['服务器IP', '备份昵称', '备份日期', '备份大小', '备份文件名', '备份目录']
exc_ins = Excel.Excel(att_filename,
sheet_name='ciSheet',
encoding='utf-8')
exc_ins.backup_xlsx_write(hdngs, result)
if is_auto and isSendMail == 'yes' and len(result) > 1:
content = func.toHtml(result, total_size_str)
sub = "服务器备份每日统计(" + str(Y) + '-' + str(m) + '-' + str(d) + ")"
#func.send_mail(func.mailto_list,sub,content)
func.sendMail(sub, content, func.mailto_list, att_filename)
else:
print json.dumps('suc!')
if len(err_result) > 0 and isSendMail == 'yes':
err_sub = "备件检查存在错误(" + str(Y) + '-' + str(m) + '-' + str(d) + ")"
err_content = func.toErrHtml(err_result)
func.send_mail(func.mailto_list, err_sub, err_content)
def __init__(self):
self.recherche = Recherche()
self.fichier = Excel()
self.idinse = self.recherche.getCommune()
def run(self):
const.start_time_style = time.strftime('%Y-%m-%d %H:%M:%S',
time.localtime())
const.start_time = datetime.datetime.now()
# if self.env.lower() == "online" and info.iterm == "yiqi":
# # 先将token变量值写入字典
# const.var_dict["${token}"] = login.login(y_con.username_online_yiqi, y_con.password_online_yiqi, "GET")
# elif self.env.lower() == "online" and info.iterm == "qingdao":
# const.var_dict["${token}"] = login.login(y_con.username_online_qingdao, y_con.password_online_qingdao, "GET")
# else:
# const.var_dict["${token}"] = login.login(y_con.username, y_con.password, "GET")
if self.env.lower() == "online" and info.iterm == "yiqi":
const.var_dict["${token}"] = login.login(
y_con.username_online_yiqi, y_con.password_online_yiqi, "GET")
else:
const.var_dict["${token}"] = login.login(y_con.username,
y_con.password, "GET")
excel = Excel(self.dir_case, self.dir_case_result)
# html_report = htmlGenerator.report(self.dir_result)
cases = excel.get_cases()
for case in cases:
# UAT环境，UAT一列，为No时不予执行
if self.env.lower() == "uat":
if case.uat_env != 'Yes':
continue
case.run_case()
if info.write_back == 0:
excel.set_out_cell(
excel.ROW_G, 9,
'{}={}'.format(case.va_in_para,
case.get_variable_in_params()))
all_result = [
case.entire_url, case.response, case.result_value,
case.fail_time, case.elapsed, case.actual_params
]
index = 0
for i in range(13, 19):
excel.set_out_cell(case.line, i, all_result[index])
excel.save_excel()
index += 1
excel.save_excel()
elif info.write_back == 1:
if case.result_value == 'Fail':
excel.set_out_cell(
excel.ROW_G, 9,
'{}={}'.format(case.va_in_para,
case.get_variable_in_params()))
all_result = [
case.entire_url, case.response, case.result_value,
case.fail_time, case.elapsed, case.actual_params
]
index = 0
for i in range(13, 19):
excel.set_out_cell(case.line, i, all_result[index])
excel.save_excel()
index += 1
excel.save_excel()
# coding=utf-8
#----------------------------------------
#2016.9.9 增加无需求文档时的适配
#----------------------------------------
import Excel
import codecs
import re
import os
excel = Excel.Excel()
reqexcel = Excel.Excel()
#测试用例excel名称
featurename = u"D:/资料/测试用例/test2/IDEALENS VR Web1.1-安全测试.xlsx"
#需求模板Excel名称
requirename = u"D:/资料/测试用例/test2/IDEALENS VR Web1.1-安全测试需求-30.xls"
#requirenamelist=featurename.split("/")
#requirenamelist[len(requirenamelist)-1]=requirenamelist[len(requirenamelist)-1].replace(u"测试用例",u"需求模板")
#requirename="/".join(requirenamelist)
#if os.path.exists(requirename):
# pass
#else:
# requirename=requirename[:-1]
reqList = {}
reqstring = u"<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n"
reqstring += u"<requirements>\n"
if os.path.exists(requirename):
reqexcel.open_excel(requirename)
requireNumber = reqexcel.worksheet.nrows
statusList = {"4.0": "F", "": "R"}
for i in range(1, requireNumber):
import queue
from Excel import *
from Menu import *
import datetime
from multiprocessing import Queue
Menu_Instructions()
# Loading Excel Files
oldfile, newfile = getXLfiles()
oldfile = oldfile
newfile = newfile
# Open Excel Files
OldExcel = Excel(oldfile)
NewExcel = Excel(newfile)
# Set Up Changes Tracked File
currentdata = x = datetime.datetime.now().strftime("%m.%d.%Y")
ChangeExcel = Excel(currentdata + " Changes Tracked")
ChangeExcel.setupfile()
print("Loading", oldfile, "....")
OldExcel.loadfile()
OldExcel.getIDs()
print(oldfile, "has been loaded!\n")
print("Loading", newfile, "....")
NewExcel.loadfile()
NewExcel.getIDs()
FileType = r"GDB"
#-----------------------------------------------------------------------------------
filePath = str(os.path.dirname(
workspaceEncoding.encode("cp1256"))).decode("cp1256")
ExcelName = filePath + "\\"
ExcelName = ExcelName + Database.decode("cp1256").rsplit(
".", 1)[0] + "_" + strftime("%Y%m%d_%H%M%S") + ".xlsx"
#ExcelName = ExcelName +str(CurrentTime.year).encode("cp1256")+"-"+str(CurrentTime.month).encode("cp1256")+"-"+str(CurrentTime.day).encode("cp1256")+".xlsx"
arcpy.AddMessage(ExcelName)
print(ExcelName)
if ExcelName == '#' or not ExcelName:
ExcelName = r"ExcelName.xlsx"
#print(ExcelName)
#-----------------------------------------------------------------------------------
xls = Excel(ExcelName, FileType, Database)
#-----------------------------------------------------------------------------------
ErorrsMSG = ""
ErrorCount = 0
FCRow = 2
FCCol = 1
BusinessTableRow = 2
BusinessTableCol = 1
BusTableFildesRow = 2
BusTableFildesCol = 1
FCSheet = 1
BusinessTableSheet = 2
FieldsCount = 0
#-----------------------------------------------------------------------------------
datasets = arcpy.ListDatasets("*", "Feature") + ['']
datasets.sort()
except:
print("Bad data file :(")
exit()
task = Task.Task()
for line in dataFileLines[settings.dataFileVariablesLine + 1:]:
trial = interpreter.interprete(line)
if (trial is None):
continue
task.addTrial(trial)
dataFile.close()
task.analyse()
excelFile = Excel.Excel(settings.excelFileName)
excelFile.metaSheet.write(1, 0, 'data file name')
excelFile.metaSheet.write(1, 1, settings.dataFileName)
excelFile.metaSheet.write(2, 0, 'git version')
excelFile.metaSheet.write(
2, 1,
str(
subprocess.check_output(['git', 'rev-parse', '--short',
'HEAD']).decode('ascii')))
excelFile.printTask(task)
excelFile.close()
