Re: [sqlalchemy] Adding OR () with do_orm_execute

2023-01-12 Thread Mike Bayer
if you have a select() construct, you can add new AND things just calling .where() again. e.g. existing_statement.where(or_(f1, f2)) . On Wed, Jan 11, 2023, at 11:26 PM, Val Huber wrote: > I am using this and it is working well to AND a series of filters to a > statement. > > But I do not

[sqlalchemy] Adding OR () with do_orm_execute

2023-01-11 Thread Val Huber
I am using this and it is working well to AND a series of filters to a statement. But I do not see how to OR these into the original statement. For example, I have filters f1 and f2. I want the result to be: where AND (f1 OR f2). Thanks in advance, Val -- SQLAlchemy - The Python SQL Toolk