Here are the examples of the python api sqlalchemy.pool.Pool taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.
1 Examples
3
View Complete Implementation : config.py
Copyright GNU Affero General Public License v3.0
Author : CERT-Polska
Copyright GNU Affero General Public License v3.0
Author : CERT-Polska
def _install_reconnector(self):
# copied from:
# http://docs.sqlalchemy.org/en/rel_0_9/core/pooling.html#disconnect-handling-pessimistic
# and slightly adjusted
@sqlalchemy.event.listens_for(sqlalchemy.pool.Pool, "checkout")
def ping_connection(dbapi_connection, connection_record, connection_proxy):
cursor = dbapi_connection.cursor()
try:
cursor.execute("SELECT 1")
except Exception:
# dispose the whole pool instead of invalidating one at a time
connection_proxy._pool.dispose()
# pool will try connecting again up to three times before giving up
raise sqlalchemy.exc.DisconnectionError()
cursor.close()