def run_test(self, sheet, url): """再执行测试用例""" rows = excel.get_rows(sheet) fail = 0 for i in range(2, rows): testNumber = str(int(excel.get_content(sheet, i, cs.CASE_NUMBER))) testData = excel.get_content(sheet, i, cs.CASE_DATA) testName = excel.get_content(sheet, i, cs.CASE_NAME) testUrl = excel.get_content(sheet, i, cs.CASE_URL) testUrl = url + testUrl testMethod = excel.get_content(sheet, i, cs.CASE_METHOD) testHeaders = eval(excel.get_content(sheet, i, cs.CASE_HEADERS)) testCode = excel.get_content(sheet, i, cs.CASE_CODE) actualCode = request.api(testMethod, testUrl, testData, testHeaders) expectCode = str(int(testCode)) failResults = PrettyTable(["Number", "Method", "Url", "Data", "ActualCode", "ExpectCode"]) failResults.align["Number"] = "l" failResults.padding_width = 1 failResults.add_row([testNumber, testMethod, testUrl, testData, actualCode, expectCode]) if actualCode != expectCode: logging.info("FailCase %s", testName) print "FailureInfo" print failResults fail += 1 else: logging.info("Number %s", testNumber) logging.info("TrueCase %s", testName) if fail > 0: return False return True
def run_test(self, sheet, url): """再执行测试用例""" rows = excel.get_rows(sheet) fail = 0 rb = xlrd.open_workbook( "C:\\Users\\user\\Desktop\\pythonTest\\api4excel-master\\test.xls") rs = rb.sheet_by_index(0) wb = copy(rb) ws = wb.get_sheet(0) for i in range(2, rows): testNumber = str(int(excel.get_content(sheet, i, cs.CASE_NUMBER))) testData = eval(excel.get_content(sheet, i, cs.CASE_DATA)) testName = excel.get_content(sheet, i, cs.CASE_NAME) testUrl = excel.get_content(sheet, i, cs.CASE_URL) testUrl = url + testUrl testMethod = excel.get_content(sheet, i, cs.CASE_METHOD) testHeaders = eval(excel.get_content(sheet, i, cs.CASE_HEADERS)) testCode = excel.get_content(sheet, i, cs.CASE_CODE) actualCode = requests.request(testMethod, testUrl, data=json.dumps(testData), headers=testHeaders) expectCode = int(testCode) failResults = PrettyTable([ "Number", "Method", "Url", "Data", "ActualCode", "ExpectCode" ]) failResults.align["Number"] = "l" failResults.padding_width = 1 failResults.add_row([ testNumber, testMethod, testUrl, testData, actualCode.status_code, expectCode ]) response = json.loads(actualCode.text) ws.write(i, 7, response["msg"]) wb.save( "C:\\Users\\user\\Desktop\\pythonTest\\api4excel-master\\2test.xls" ) if actualCode.status_code != expectCode: logging.info("FailCase %s", testName) print("FailureInfo") print(failResults) fail += 1 else: logging.info("Number %s", testNumber) logging.info("TrueCase %s", testName) if fail > 0: return False return True
def get_prepare_sql(self, sheet): """获取预执行SQL""" return excel.get_content(sheet, cs.SQL_ROW, cs.SQL_COL)