How to use query.filter and .filter_by in SQLAlchemy?

Question

With Django it is possible to find models using the filter method with keyword-arguments like so:

MyModel.objects.filter(serialNo_gt=10)

giving all models with a serial number greater than 10.

Is it possibly to use a similar query language with sql-alchemy? I know that one can write something like MyModel.seriealNO < 10, but with that the code that uses this construct need to import MyModel and I want to create the keywords/query parameters externally without importing MyModel (for a facade-pattern).

zzzeek · Accepted Answer · 2012-09-08 01:20:20Z

3

the concept of "<attributename>_<operatorname>=<value>" is not built in to SQLAlchemy's Query, however the effect is very easy to reproduce. Here's a quick example done by the author of Flask: https://github.com/mitsuhiko/sqlalchemy-django-query/blob/master/sqlalchemy_django_query.py

answered Sep 8, 2012 at 1:20

zzzeek

75.8k24 gold badges204 silver badges190 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use query.filter and .filter_by in SQLAlchemy?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related