Use SQLAlchemy with CherryPy
Project description
CherryPy-SQLAlchemy makes it easy to use SQLAlchemy within CherryPy apps.
Credits
This package was primarily created from Sylvain’s SQLAlchemy recipe.
Basic Usage
There are two elements of CherryPy-SQLAlchemy
A CherryPy tool that will create a session for use with each request.
A CherryPy plugin that can maintains information about the database and binds the session to the specific DB.
Here is an example connecting to a sqlite db:
import cherrypy from app import Root from app.models import ORMBase from cp_sqlalchemy import SQLAlchemyTool, SQLAlchemyPlugin def run(): cherrypy.tools.db = SQLAlchemyTool() cherrypy.tree.mount(Root(), '/', { '/': { 'tools.db.on': True } }) SQLAlchemyPlugin( cherrypy.engine, ORMBase, 'sqlite:////path/to/file.db' ) cherrypy.engine.start() cherrypy.engine.block()
One thin to note is the ORMBase we imported is sqlalchemy.ext.declarative.declarative_base() that was used when creating models.
From there, each request will have access to cherrypy.request.db, which is an instance of a SQLAlchemy session.
There is a more complete example.py in the source.
Free software: BSD license
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
Hashes for CherryPy-SQLAlchemy-0.5.3.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | b9704d4251994532e81014163427d3bc5eed66fce93a34432a827013e29b633c |
|
MD5 | 1a122e0ace1aa3351bf6ed5f2d7b62dc |
|
BLAKE2b-256 | d9ce8d1b22e31daddab97d75fb980852cb275de9de7e2dbbc484ed47fdfae01d |