MySQL integration for Bottle.
Bottle-MySQL is a plugin that integrates MySQL 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 pymydb 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.
import bottle import bottle_pymysql app = bottle.Bottle() # dbhost is optional, default is localhost plugin = bottle_pymysql.Plugin(dbuser='user', dbpass='pass', dbname='db') app.install(plugin) @app.route('/show/:<tem>') def show(item, pymydb): pymydb.execute('SELECT * from items where name="%s"', (item,)) row = pymydb.fetchone() if row: return template('showitem', page=row) return HTTPError(404, "Page not found")
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.