strans.py 文件源码

def do_update(self, dbconn, updatedict):
        return_dict = dict()

        do_update_sql = "INSERT into attempts (fk_trked_trans_id, result) VALUES (%s, %s) ; " +\
                                        "UPDATE trked_trans set lastChecked = CURRENT_TIMESTAMP, active = %s  where id = %s ; " 

        values_to_insert = (self.dbid, updatedict["result"], updatedict["still_valid"], self.dbid )

        try:
            dbconn.execute(do_update_sql, values_to_insert)
            return_dict["insert_id"] = dbconn.lastrowid
            self.dbid = int(return_dict["insert_id"])
            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