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