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 __insert_test_result(self, state, test, err=None):
data_payload = TestcaseDataPayload()
data_payload.runtime = int(time.time() * 1000) - self.case_start_time
data_payload.guid = self.testcase_guid
data_payload.execution_guid = self.execution_guid
data_payload.state = state
if err is not None:
data_payload.message = err[1].__str__().split('-------------------- >> begin captured logging << --------------------', 1)[0]
self.testcase_manager.update_testcase_data(data_payload)
