def retire_in_db(self, dbconn) :
retire_transaction_string = "UPDATE trked_trans set active = 0 where id = " + self.dbid
try:
dbconn.execute(retire_transaction_string)
return_dict["success"] = True
except pymysql.IntegrityError as e :
return_dict["success"] = False
return_dict["failure_message"] = "Integrity Error"
return_dict["debug"] = str(e)
except pymysql.ProgrammingError as e :
return_dict["success"] = False
return_dict["failure_message"] = "ProgrammingError"
return_dict["debug"] = str(e)
except pymysql.DataError as e :
return_dict["success"] = False
return_dict["failure_message"] = "DataError"
return_dict["debug"] = str(e)
except pymysql.NotSupportedError as e :
return_dict["success"] = False
return_dict["failure_message"] = "NotSupportedError"
return_dict["debug"] = str(e)
except pymysql.OperationalError as e :
return_dict["success"] = False
return_dict["failure_message"] = "OperationalError"
return_dict["debug"] = str(e)
except Exception as e :
return_dict["success"] = False
return_dict["failure_short"] = "Unknown Failure " + str(e)
return return_dict
评论列表
文章目录