def fuzz_case_write(fuzz_case_data):
# 尝试打开path下的FuzzCase.xlsx文件，若没有，则新建
path = MyExcel.current_path() + "\\FuzzCase.xlsx"
try:
fuzz_workbook, fuzz_sheet = MyExcel.read_excel(path)
except IOError, e:
logger.debug(u"fuzz_test,尝试打开指定路径文件失败 %s" % str(e))
if "Errno 2" in str(e):
fuzz_workbook, fuzz_sheet = MyExcel.read_excel()
fuzz_workbook.save(path)
def case_generate():
"""
从TestConfig中读取配置指定的表格，返回按行输出的生成器
配置应包含表格文件路径以及工作表名称
"""
logger.debug('enter case_generate')
logger_output.debug('enter case_generate')
workbook,sheet = MyExcel.read_excel(TestConfig.excel_case_path[0],TestConfig.excel_case_path[1])
case_list = list(sheet.rows)
case_list.pop(0) #去除标题行
logger.debug('count of case :%s'%len(case_list))
for case in case_list:
yield case
def first_run(col_num, row_num, value):
logger.debug("enter first_run")
logger_output.debug("enter first_run")
workbook, sheet = MyExcel.read_excel(TestConfig.excel_case_path[0], TestConfig.excel_case_path[1])
sheet.cell(column=col_num, row=row_num, value=value)
workbook.save(TestConfig.excel_case_path[0])
fuzz_case_name_list.append(u"参数字典为空")
fuzz_case_list.append("")
return (fuzz_case_list, fuzz_case_name_list)
def fuzz_case_write(fuzz_case_data):
# 尝试打开path下的FuzzCase.xlsx文件，若没有，则新建
path = MyExcel.current_path() + "\\FuzzCase.xlsx"
try:
fuzz_workbook, fuzz_sheet = MyExcel.read_excel(path)
except IOError, e:
logger.debug(u"fuzz_test,尝试打开指定路径文件失败 %s" % str(e))
if "Errno 2" in str(e):
fuzz_workbook, fuzz_sheet = MyExcel.read_excel()
fuzz_workbook.save(path)
MyExcel.rows_write(fuzz_case_data, path=path)
def relevance_request(case_values, relevance_parameter):
"""
执行关联用例，获得请求返回后解析所有参数加入字典
"""
logger.debug("enter relevance_request")
logger_output.debug("enter relevance_request")
try:
relevance_case_value = case_values.next()
request_url, name, reuqest_mode, required_parameter, optional_parameter, expect_response = relevance_case_value[
1:7
]
except StopIteration, e:
logger.error(e)
