Metadata-Version: 1.1
Name: marbaloo-sqlalchemy
Version: 0.1.0
Summary: SQLAlchemy support for cherrypy.
Home-page: http://github.com/marbaloo/marbaloo_sqlalchemy
Author: Mahdi Ghane.g
Author-email: UNKNOWN
License: MIT
Description: Marbaloo SQLAlchemy
        ===================
        
        `sqlalchemy <http://www.sqlalchemy.org//>`_ support for cherrypy.
        
        Installation
        ------------
        ::
        
            pip install marbaloo_sqlalchemy
        
        Usage
        -----
        
        ::
        
            # app.py
            import marbaloo_sqlalchemy
            import cherrypy
            import os
            from your_models import messages_model
            marbaloo_sqlalchemy.Plugin(cherrypy.engine).subscribe()
            cherrypy.tools.db = marbaloo_sqlalchemy.Tool()
        
        
            class Root(object):
        
                @cherrypy.expose
                def index(self):
                    db_session1 = cherrypy.request.db['db1']
                    db_session2 = cherrypy.request.db['db2']
        
                    query = messages_model.insert().values(message='TESTMessage')
                    db_session1.get_bind().execute(query)
                    db_session1.commit()
        
                    query = messages_model.insert().values(message='TESTMessage')
                    db_session2.get_bind().execute(query)
                    db_session2.commit()
        
            config = {
                'global': {
                    'marbaloo_sqlalchemy_db': {
                        'db1': {
                            'engine': {
                                'name_or_url': 'sqlite:///test1.db',
                                'echo': True,
                            },
                            'session': {
                                'expire_on_commit': True,
                                'autoflush': True,
                                'autocommit': False
                            }
                        },
                        'db2': {
                            'engine': {
                                'name_or_url': 'sqlite:///test2.db',
                                'echo': True,
                            },
                            'session': {
                                'expire_on_commit': True,
                                'autoflush': True,
                                'autocommit': False
                            }
                        },
                    }
                },
                '/': {
                    'tools.db.on': True
                }
            }
            cherrypy.quickstart(Root(), '/', config)
        
Keywords: sqlalchemy cherrypy marbaloo marbaloo_sqlalchemy
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Intended Audience :: Developers
Classifier: Framework :: CherryPy
Classifier: License :: OSI Approved :: MIT License
Classifier: Operating System :: POSIX :: Linux
Classifier: Operating System :: Unix
Classifier: Programming Language :: Python :: 3 :: Only
Classifier: Topic :: Software Development :: Libraries
