+
+class MyCursor(MySQLdb.cursors.DictCursor):
+ def execute(self, *args, **kwargs):
+ if 'norecurse' in kwargs:
+ norecurse = kwargs['norecurse']
+ del kwargs['norecurse']
+ else:
+ norecurse = False
+ main.log("[SQL]", "?", "MyCursor.execute(self, %s, %s)" % (', '.join([repr(i) for i in args]), ', '.join([str(key)+"="+repr(kwargs[key]) for key in kwargs])))
+# print "%09.3f [SQL] [#] MyCursor.execute(self, %s, %s)" % (time.time() % 100000, ', '.join([repr(i) for i in args]), ', '.join([str(key)+"="+repr(kwargs[key]) for key in kwargs]))
+ try:
+ return super(self.__class__, self).execute(*args, **kwargs)
+ except MySQLdb.MySQLError as e:
+ main.log("[SQL]", "!", "MySQL error! %r" % (e))
+# print "%09.3f [SQL] [!] MySQL error! %r" % (time.time() % 100000, e)
+ if not norecurse:
+ dbsetup()
+ return self.execute(norecurse=True, *args, **kwargs)
+ return False
+ return True
+
+
+def dbsetup():
+ main.db = None
+ main.db = MySQLdb.connect(host=cfg.dbhost, user=cfg.dbuser, passwd=cfg.dbpass, db=cfg.dbname, cursorclass=MyCursor)