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.
Usage Example:
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")
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
bottle-pymysql-0.1.4.tar.gz
(5.6 kB
view details)
File details
Details for the file bottle-pymysql-0.1.4.tar.gz.
File metadata
- Download URL: bottle-pymysql-0.1.4.tar.gz
- Upload date:
- Size: 5.6 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via: twine/4.0.2 CPython/3.11.1
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
04a9aca61ade7443d4d0b39224cff63b90a9bc5cf21d5acef590fd4f62dbacef
|
|
| MD5 |
a514483a32df7252f082d852b1e87b06
|
|
| BLAKE2b-256 |
06a8c22c1bb3706b9876d514177c937d0ccb4ee27e2b584d0dd2310349d4d4db
|
