def testUpdateStatusNotValid(self):
"""
Test that we cannot update a status that is not:
Checked Out | Pending Return | Verified Return | Damaged Lost
"""
rc, msg = self.testInsertRelationshipSmoke()
self.assertTrue(rc)
r = Relationship("*****@*****.**", "101010",
"WRONG STATUS", "2021-01-01 01:01:01", None,
"Pending Return")
rc, updateRelationship = self.dao.updateRelationship(r)
self.assertFalse(rc)
r.status = "Checked out"
rc, updateRelationship = self.dao.updateRelationship(r)
self.assertFalse(rc)
r.status = "pending return"
rc, updateRelationship = self.dao.updateRelationship(r)
self.assertFalse(rc)
r.status = "VERIFIED RETURN"
rc, updateRelationship = self.dao.updateRelationship(r)
self.assertFalse(rc)
def tearDown(self):
"""
Delete the temporary database
"""
r = Relationship("*****@*****.**", "101010",
"Checked Out", "2021-01-01 01:01:01", None,
None) # r is relationship object
self.dao.deleteRelationship(r)
r.status = "Verified Return"
self.dao.deleteRelationship(r)
r.status = "Damaged Lost"
self.dao.deleteRelationship(r)
r.status = "Pending Return"
self.dao.deleteRelationship(r)
def changeOldRelationship(self, result):
try:
logging.info("Entering changeOldRelationship")
sql = "SELECT * from hascontainer WHERE qrcode = '" + result[
1] + "' and status <> 'Verified Return' ORDER BY statusUpdateTime DESC"
myresult = self.handleSQL(sql, True, None)
if (myresult[0] == False):
return myresult
if (myresult[1] != [] and myresult[1] is not None):
oldEmail = myresult[1][0]
tempR = Relationship(oldEmail[0], oldEmail[1], oldEmail[2],
oldEmail[3], oldEmail[4], None)
if (tempR.status == "Damaged Lost"):
tempR.description = ""
#return False, "Container has been marked as Damaged Lost"
#if(result[2] != "Damaged Lost"):
tempR.status = "Verified Return"
self.updateRelationship(tempR)
except Exception as e:
logging.error("Error in changeOldRelationship")
logging.error(str(e))
return self.handleError(e)