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)