CherryPy tool to manage Psycopg 2 database connections
Project description
CherryPy-Psycopg2
CherryPy-Psycopg2 is a simple CherryPy Tool to manage a (thread-safe) pool of database connections and make them available to handlers.
Import cherrypy_psycopg2
to make the tool available in CherryPy's default toolbox.
The following configuration settings are understood:
tools.psycopg2.minconn
- passed to the psycopg2 pool constructortools.psycopg2.maxconn
- passed to the psycopg2 pool constructortools.psycopg2.dsn
- passed to the psycopg2 pool constructortools.psycopg2.cursor_factory
- passed to the psycopg2 connection's cursor() method
When the tool is enabled on a handler, it will collect a database connection
from the pool, expose a cursor as cherrypy.request.psycopg2_cursor
,
execute the handler and then commit the transaction (if the handler was
successful or raised one of the
cherrypy_psycopg2.COMMITTABLE_HANDLER_EXCEPTIONS
), or rollback the
transaction if the handler raised any other exception.
For example:
class Root:
@cherrypy.expose
@cherrypy.tools.psycopg2()
def index(self):
cursor = cherrypy.request.psycopg2_cursor
cursor.execute("SELECT now()")
return cursor.fetchone()[0]
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for cherrypy_psycopg2-2.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | e3b1738286ca20001697586c4c782f8578eb2e40a776aae179a3e5f24d6f94ee |
|
MD5 | f2bb17bccc894c69faa5f839af51253e |
|
BLAKE2b-256 | eff6d38a0127511581db05150c00e9217290856f72575379b49b0d7229bd7dec |