MySQLdb如何判断数据库连接有效?
程序中用到了MySQLdb来连接MySQL的数据库,但需要一直连接,那么在访问数据前请怎么确定此连接是否还在激活?
可以用MySQLdb.connection.ping来实现
ping(...)
Checks whether or not the connection to the server is
working. If it has gone down, an automatic reconnection is
attempted.
This function can be used by clients that remain idle for a
long while, to check whether or not the server has closed the
connection and reconnect if necessary.
New in 1.2.2: Accepts an optional reconnect parameter. If True,
then the client will attempt reconnection. Note that this setting
is persistent. By default, this is on in MySQL<5.0.3, and off
thereafter.
Non-standard. You should assume that ping() performs an
implicit rollback; use only when starting a new transaction.
You have been warned.