skip to navigation
skip to content

bottle-pgsql 0.1

PgSQL integration for Bottle

Latest Version: 0.2

Bottle-PgSQL is based on Bottle-MySQL and Bottle-sqlite. Bottle-PgSQL is a plugin that integrates PostgreSQL with your Bottle application. It automatically connects to a database at the beginning of a request, passes the database handle to the route callback and closes the connection afterwards.

To automatically detect routes that need a database connection, the plugin searches for route callbacks that require a db keyword argument (configurable) and skips routes that do not. This removes any overhead for routes that don’t need a database connection.

Results are returned as dictionaries.

Usage Example:

import bottle
import bottle_pgsql

app = bottle.Bottle()
plugin = bottle_pgsql.Plugin('dbname=db user=user password=pass')

def show(item, db):
    db.execute('SELECT * from items where name="%s"', (item,))
    row = db.fetchone()
    if row:
        return template('showitem', page=row)
    return HTTPError(404, "Page not found")
File Type Py Version Uploaded on Size
bottle-pgsql-0.1.tar.gz (md5) Source 2012-07-02 2KB