Usage¶

The ORM base class is available as pyramid_sqlalchemy.meta.BaseObject and can be included directly:

from pyramid_sqlalchemy import BaseObject

class Account(BaseObject):
    __tablename__ = 'account'
    # Define your columns and methods here.

When you need to build a query you can use the pyramid_sqlalchemy.Session session factory.

from pyramid_sqlalchemy import Session

account = Session.query(Account).first()

When writing methods for a model in a you can also use sqlalchemy.orm.session.object_session() to get the current session for the object.

from sqlalchemy.orm import object_session

class Account(BaseObject):
    def favourites(self):
        """Return all the recent favourite articles."""
        session = object_session(self)
        return session.query(Article).all()