# Pylons 0.9.7 + Elixir 0.6.1
# This is just what works for me. YMMV.

# I have all my Entities in model/entities.py (nothing special there)

# model/__init__.py
"""The application's model objects"""
from sqlalchemy import orm
import elixir

# you may want different args to sessionmaker here:
Session = orm.scoped_session(orm.sessionmaker(autoflush=False, expire_on_commit=False))
elixir.session = Session
# next line is optional, and you may want different options:
elixir.options_defaults.update(dict(shortnames=True, inheritance='multi', polymorphic=True))
metadata = elixir.metadata
from entities import *
Session = elixir.session

def init_model(engine):
    """Call me before using any of the tables or classes in the model"""
    metadata.bind = engine

# environment.py

# in the imports section:
import yourapp.model as model
from sqlalchemy import engine_from_config

# then replace the SQLAlchemy setup section with:
    
    # Setup Elixir
    # note: in this example, I'm leaving connect_args empty, fill in what is right
    # for your app.
    config['pylons.app_globals'].sa_engine = \
        engine_from_config(config, 'sqlalchemy.',
                           connect_args={}, pool_recycle=90)
    elixir.bind = config['pylons.app_globals'].sa_engine
    model.metadata.bind = config['pylons.app_globals'].sa_engine
    elixir.setup_all()

# lib/base.py --------------------------------------------------------

# imports section:
import yourapp.model as model

# change BaseController like so:

class BaseController(WSGIController):

    def __call__(self, environ, start_response):
        """Invoke the Controller"""
        # WSGIController.__call__ dispatches to the Controller method
        # the request is routed to. This routing information is
        # available in environ['pylons.routes_dict']
        try:
            return WSGIController.__call__(self, environ, start_response)
        finally:
            model.Session.remove()