generate.py
1.13 KB
#!/usr/bin/env python
# -*- coding: utf-8 -*-
# @Time : 2021/7/16 下午5:37
# @Author : 付孟奇
import os
from util import HandleExcel
from config.vendorPath import excel_path
# 类的实例、被测试的接口名称、测试数据文件名、测试数据表单名称
def generateTestCases(instanse, inerfaceName, tesDataName, sheetName):
# 合成Excel文件路径
file_path = os.path.join(excel_path, tesDataName)
# 读取Excel指定接口的执行case
data_list = HandleExcel.excel_to_list(file_path, sheetName)
for i in range(len(data_list)):
setattr(instanse, 'test_' + inerfaceName + '_%s' % (str(data_list[i]["tc_num"])),
instanse.getTestFunc(data_list[i]))
func_name = 'test_' + inerfaceName + '_%s' % (str(data_list[i]["tc_num"]))
func_attr = getattr(instanse, func_name)
func_attr.__doc__ = str(data_list[i]["tc_name"])
def getTestCase(tesDataName, sheetName):
# 合成Excel文件路径
file_path = os.path.join(excel_path, tesDataName)
# 读取Excel指定接口的执行case
data_list = HandleExcel.excel_to_list(file_path, sheetName)
return data_list