CherryPy Recipes / web / database / sql_alchemy /

# -*- coding: utf-8 -*-
import cherrypy

class Root(object):
    def index(self):
        # Get the SQLAlchemy session associated
        # with this request.
        # It'll be released once the request
        # processing terminates
        db = cherrypy.request.db

        return "Hello World"
if __name__ == '__main__':
    # Register the SQLAlchemy plugin
    from saplugin import SAEnginePlugin
    SAEnginePlugin(cherrypy.engine, 'sqlite:///my.db').subscribe()

    # Register the SQLAlchemy tool
    from satool import SATool = SATool()
    cherrypy.quickstart(Root(), '', {'/': {'tools.db.on': True}})
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.