Using OR in SQLAlchemy ORM query

Question

I have some sql queries I'm trying to run as sqlalchemy.orm.query objects and I'm wondering if there is a way to use OR. I can use AND by adding commas into the filter statement but I don't know how to do an OR. Example code below:

query = MyTable.q.filter(MyTable.id == some_number)

However I don't know how to do a query with an OR

query = MyTable.q.filter(MyTable.id == some_number OR MyTable.id == some_other_number)

Any help is greatly appreciated

Duplicate question, please refer to: stackoverflow.com/questions/7942547/using-or-in-sqlalchemy — user581592
– user581592, Commented Jul 11, 2013 at 15:45

davidism · Accepted Answer · 2013-07-11 16:22:11Z

1

from sqlalchemy.sql import or_

query = MyTable.q.filter(
        or_(MyTable.id == some_number, MyTable.id == some_other_number)
    )

Of course, there's no point in this case since you can solve it with in_.

query = MyTable.q.filter(MyTable.id.in_([some_number, some_other_number])

answered Jul 11, 2013 at 16:22

davidism

128k31 gold badges417 silver badges348 bronze badges

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

Collectives™ on Stack Overflow

Using OR in SQLAlchemy ORM query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related