pyramid_services_sqlalchemy

SQLAlchemy factories for pyramid_services.

This module provides removing SQLAlchemy’s boiler plates from your pyramid application codes.

In your pastedeploy.ini:

sqlalchemy.url = ENGINE://DBUSER:PASSWORD@DBHOST/DBNAME

In your application factory:

config.include('pyramid_services_sqlalchemy')

In your views:

from pyramid_services_sqlalchemy import get_tm_session

def aview(request):
    db = get_tm_session(request)

or you can use request.find_service:

from pyramid_services_sqlalchemy import IDBSession

def aview(request):
    db = request.find_service(IDBSession)

If you want to use multiple connections, pastedeploy.ini:

sqlalchemy.names = readonly readwrite
sqlalchemy.readonly.url = ENGINE://READ_DBUSER:PASSWORD@DBHOST/DBNAME
sqlalchemy.readwrite.url = ENGINE://WRITE_DBUSER:PASSWORD@DBHOST/DBNAME

and in your views:

from pyramid_services_sqlalchemy import get_tm_session

def aview(request):
    db = get_tm_session(request, name='readonly')

def a_write_view(request):
    db = get_tm_session(request, name='readwrite')