def insert_delayed_test_data(self, guid_, testcase_address, expected_result, done=0, expires_at=DEFAULT_EXPIRATION):
""" This method inserts rows into the delayedTestData table
in the DB based on the given parameters where
inserted_at (Date format) is automatically set in this method.
:param guid_: The guid that is provided by the test case.
(Format: str(uuid.uuid4()))
:param testcase_address: The ID (address) of the test case.
:param expected_result: The result string of persistent data
that will be stored in the DB.
:param done: (0 for test not done or 1 for test done)
:returns: True (when no exceptions or errors occur)
"""
inserted_at = int(time.time() * 1000)
db = DatabaseManager()
query = """INSERT INTO delayedTestData(
guid,testcaseAddress,insertedAt,
expectedResult,done,expiresAt)
VALUES (%(guid)s,%(testcaseAddress)s,%(inserted_at)s,
%(expected_result)s,%(done)s,%(expires_at)s)"""
db.execute_query_and_close(
query,
{
"guid": guid_,
"testcaseAddress": testcase_address,
"inserted_at": inserted_at,
"expected_result": expected_result,
"done": done,
"expires_at": inserted_at + expires_at,
},
)
return True
def set_delayed_test_to_done(self, guid_):
""" This method updates the delayedTestData table in the DB
to set the test with the selected guid to done.
:param guid_: The guid that is provided by the test case.
(Format: str(uuid.uuid4()))
:returns: True (when no exceptions or errors occur)
"""
db = DatabaseManager()
query = """UPDATE delayedTestData
SET done=TRUE
WHERE guid=%(guid)s
AND done=FALSE"""
db.execute_query_and_close(query, {"guid": guid_})
return True
def set_delayed_test_to_done(self, guid_):
""" This method updates the delayedTestData table in the DB
to set the test with the selected guid to done.
:param guid_: The guid that is provided by the test case.
(Format: str(uuid.uuid4()))
:returns: True (when no exceptions or errors occur)
"""
db = DatabaseManager()
query = """UPDATE delayedTestData
SET done=TRUE
WHERE guid=%(guid)s
AND done=FALSE"""
db.execute_query_and_close(query, {"guid": guid_})
return True
def insert_delayed_test_data(self,
guid_,
testcase_address,
expected_result,
done=0,
expires_at=DEFAULT_EXPIRATION):
""" This method inserts rows into the delayedTestData table
in the DB based on the given parameters where
inserted_at (Date format) is automatically set in this method.
:param guid_: The guid that is provided by the test case.
(Format: str(uuid.uuid4()))
:param testcase_address: The ID (address) of the test case.
:param expected_result: The result string of persistent data
that will be stored in the DB.
:param done: (0 for test not done or 1 for test done)
:returns: True (when no exceptions or errors occur)
"""
inserted_at = int(time.time() * 1000)
db = DatabaseManager()
query = """INSERT INTO delayedTestData(
guid,testcaseAddress,insertedAt,
expectedResult,done,expiresAt)
VALUES (%(guid)s,%(testcaseAddress)s,%(inserted_at)s,
%(expected_result)s,%(done)s,%(expires_at)s)"""
db.execute_query_and_close(
query, {
"guid": guid_,
"testcaseAddress": testcase_address,
"inserted_at": inserted_at,
"expected_result": expected_result,
"done": done,
"expires_at": inserted_at + expires_at
})
return True
