Is there something equivalent to django managers in SQLAlchemy?

Question

I have some SQLAlchemy (declarative) models and some queries for writing like:

Mymodel.query.filter(Mymodel.myfield=='lambda')

Since I have to use the above query several times in my code, I would like to do it better than repeating it again and again. I know that in django you can do this by putting managers in your models.

Is there something equivalent to django managers in SQLAlchemy? Or maybe another way to do this?

Answer 1

For general queries, I add a class method to the mapped (ORM) class. For instance:

class User(object):

    @classmethod
    def get_by_username(cls, dbsession, username):
        return dbsession.query(cls).filter(cls.username==username).one()

.

Answer 2

. SA , / /etc Mgr.

class MyModelMgr(object):
    @staticmethod
    get_something(param):
        return MyModel.query.filter(MyModel.somefield==param).all()

class MyModel(Base):
    ........