farcepest / MySQLdb1

MySQL database connector for Python (legacy version)
https://sourceforge.net/projects/mysql-python/
666 stars 318 forks source link

Ping not working #129

Open zhiephie opened 7 years ago

zhiephie commented 7 years ago

I'm use 2 options for connect with ping, but not working

  1. def __init__(self):
        if self._db_connection is None:
            self._db_connection = MySQLdb.connect(
                host=config.mysqlhost,
                user=config.mysqluser,
                passwd=config.mysqlpass,
                db=config.mysqldbnm
            )
            self._db_cur = self._db_connection.cursor()
        else:
            self._db_connection.ping(True)
  2. def __open(self):
        try:
            if self.__connection is None:
                cnx = MySQLdb.connect(self.__host, self.__user,
                                    self.__password, self.__database)
                self.__connection = cnx
                self._db_cur = cnx.cursor()
            else:
                self.__connection.ping(True)
    
        except MySQLdb.Error as e:
           print "Error %d: %s" % (e.args[0], e.args[1])