def test_advancedtest_fields(self): xl = excelDataFileLib(testInputDataFile = self.inputCsvFile) xl.loadTestData() e = xl.testDataInputs[0] response = requestsLib(url = e.url, payload = e.input).response() self.assertEqual(e.url, response.url) self.assertEqual(response.status_code, e.expectedHttpStatus) self.assertEqual(response.json(),ast.literal_eval(e.expectedOutput))
def test_invokerequest_compare(self): xl = excelDataFileLib(self.inputCsvFile) xl.loadTestData() r = requests.post(xl.testDataInputs[0].url, headers = {"HTTP-CORRELATION-ID" :'337fb81b-ef9a-4c1d-8f7e-e5f3ea2f6cb5', "Content-Type" : 'application/json'}, data = xl.testDataInputs[0].input) response = r.json() self.assertEqual(response, ast.literal_eval(xl.testDataInputs[0].expectedOutput))
def test_results_count(self): xl = excelDataFileLib(testInputDataFile = self.inputCsvFile) xl.loadTestData() inputs = xl.testDataInputs results = [] for e in inputs: response = requestsLib(url = e.url, payload = e.input).response() testResult = TestDataOutput(e, actualOutput = json.dumps(response.json()), actualHttpStatus = response.status_code, actualError = None) results.append(testResult) wb = openpyxl.load_workbook(self.inputCsvFile) sheet = wb.get_active_sheet() self.assertEqual(results.__len__(),sheet.get_highest_row()-1)
def test_compare_jsons_type(self): xl = excelDataFileLib(testInputDataFile = self.inputCsvFile) xl.loadTestData() inputs = xl.testDataInputs results = [] for e in inputs: response = requestsLib(url = e.url, payload = e.input).response() testResult = TestDataOutput(e, actualOutput = json.dumps(response.json()), actualHttpStatus = response.status_code, actualError = None) results.append(testResult) dict1 = json.loads(results[0].actualOutput) dict2 = json.loads(results[0].expectedOutput) self.assertEqual(cmp(dict1, dict2), 0)
def test_write_excel_body(self): xl = excelDataFileLib(testInputDataFile = self.inputCsvFile) xl.loadTestData() inputs = xl.testDataInputs results = [] for e in inputs: response = requestsLib(url = e.url, payload = e.input).response() testResult = TestDataOutput(e, actualOutput = json.dumps(response.json()), actualHttpStatus = response.status_code, actualError = None) results.append(testResult) xl.writeTestDataResults(testDataResults = results) outfile = xl.getResultsFilePath() wb = openpyxl.load_workbook(outfile) sheet = wb.get_active_sheet() self.assertEqual(sheet.cell(row = 2, column = 1).value, results[0].url) self.assertEqual(sheet.cell(row = 2, column = 4).value, results[0].expectedHttpStatus) self.assertEqual(sheet.cell(row = 2, column = 5).value, results[0].expectedError) self.assertEqual(sheet.cell(row = 2, column = 7).value, results[0].actualHttpStatus) self.assertEqual(sheet.cell(row = 2, column = 8).value, results[0].actualError)
def test_result_file_name(self): xl = excelDataFileLib(testInputDataFile = self.inputCsvFile) self.assertEqual(xl.getResultsFilePath(), "/Users/rakesh.varma/bitbucket/calc_api_tests/results/drs_dev_calc_api_tests_results.xlsx")
def test_loadtestdata(self): xl = excelDataFileLib(self.inputCsvFile) xl.loadTestData() self.assertEqual("http://10.136.14.13:8076/api/effectiveapr", xl.testDataInputs[0].url)