skip to navigation
skip to content

Not Logged In

bottle-sqlite 0.1.2

SQLite3 integration for Bottle.

Bottle-sqlite is a plugin that integrates SQLite3 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.

Usage Example:

import bottle
from bottle.ext import sqlite

app = bottle.Bottle()
plugin = sqlite.Plugin(dbfile='/tmp/test.db')
app.install(plugin)

@app.route('/show/:item')
def show(item, db):
    row = db.execute('SELECT * from items where name=?', item).fetchone()
    if row:
        return template('showitem', page=row)
    return HTTPError(404, "Page not found")
 
File Type Py Version Uploaded on Size
bottle-sqlite-0.1.2.tar.gz (md5) Source 2012-02-07 3KB
  • Downloads (All Versions):
  • 66 downloads in the last day
  • 341 downloads in the last week
  • 1210 downloads in the last month