def test_update_test_case_data(self): payload = TestcaseDataPayload() payload.guid = "antestcaseguid" payload.testcaseAddress = self.id() payload.application = "python unittest" payload.execution_guid = "executionmachine" payload.runtime = 55 payload.state = "Massachusetts" payload.browser = "SeaMonkey" self.manager.insert_testcase_data(payload) new_payload = TestcaseDataPayload() new_payload.runtime = 300 new_payload.state = "Ohio" new_payload.retry_count = 82 new_payload.guid = "antestcaseguid" self.manager.update_testcase_data(new_payload) query = """ SELECT * FROM testcaseRunData WHERE guid = %(guid)s """ results = DatabaseManager('qa').\ fetchone_query_and_close(query, {"guid":'antestcaseguid'}) self.assertTrue(results[0] == 'antestcaseguid') self.assertTrue(results[1] == self.id()) self.assertTrue(results[2] == "python unittest") self.assertTrue(results[3] == "executionmachine") self.assertTrue(results[4] == 300) self.assertTrue(results[5] == 'Ohio') self.assertTrue(results[6] == 'SeaMonkey') self.assertTrue(results[8] == 82)
def startTest(self, test): """at the start of the test, set the test case details""" data_payload = TestcaseDataPayload() self.testcase_guid = str(uuid.uuid4()) data_payload.guid = self.testcase_guid data_payload.execution_guid = self.execution_guid if hasattr(test, "browser"): data_payload.browser = test.browser else: data_payload.browser = "N/A" data_payload.testcaseAddress = test.id() data_payload.application = \ ApplicationManager.generate_application_string(test) data_payload.state = constants.State.NOTRUN self.testcase_manager.insert_testcase_data(data_payload) self.case_start_time = int(time.time() * 1000) # Make the testcase guid available to other plugins test.testcase_guid = self.testcase_guid