SQLAlchemy "or" statement with multiple parameters

Question

I have a query that require to use the "or" | operator :

Mymodel.query.filter((Mymodel.a== 'b') | (Mymodel.b == 'c'))

That works fine. However, I want my conditions to be put in an array of unkown length :

conds = [ Mymodel.a== 'b', Mymodel.b == 'c', Mymodel.c == 'd']
Mymodel.query.filter(???(conds))

Thanks !

Alfred Rossi · Accepted Answer · 2015-05-08 12:06:57Z

20

You are looking for or_

conds = [ Mymodel.a== 'b', Mymodel.b == 'c', Mymodel.c == 'd']

If you have the above list of conditions just pass them all to or_

from sqlalchemy import or_
Mymodel.query.filter(or_(*conds))

answered May 8, 2015 at 12:06

Alfred Rossi

1,95115 silver badges20 bronze badges

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

1 Answer 1