import json import unittest from common.configHttp import RunMain import paramunittest import geturlParams import urllib.parse import pythoncom import readExcel pythoncom.CoInitialize() url = geturlParams.GeturlParams().get_url() # 调用geturlParams获取拼接的URL shopAll_xls = readExcel.readExcel().get_xls('userCase.xlsx', 'shop') # 获取该接口测试用例所有数据 shop_xls = [] for i in shopAll_xls: if i[0] == 'GetAvailableCoupons': shopData = i[1:] shop_xls.append(shopData) @paramunittest.parametrized(*shop_xls) class GetAvailableCoupons(unittest.TestCase): def setParameters(self, case_name, path, query, method): self.case_name = str(case_name) self.path = str(path) self.query = str(query) self.method = str(method)
# @describe:测试断言 import json import unittest from common.configHttp import RunMain import paramunittest import geturlParams import urllib.parse import readExcel url = geturlParams.GeturlParams().get_Url() query_xls = readExcel.ReadExcel().get_xls('testcase01.xlsx', 'test') @paramunittest.parametrized(*query_xls) class TestQuery(unittest.TestCase): def setParameters(self, case_name, path, query, method): self.case_name = str(case_name) self.path = str(path) self.query = str(query) self.method = str(method) def description(self): self.case_name def setup(self): print(self.case_name + '测试开始前准备') def test01case(self): self.checkResult()