OR operator in Flask-sqlachemy query

Question

I using flask-sqlachemy. It is an extension of sqlachemy and I am not sure how _or translates to flask-sqlalchemy. For example, my query:

qry = DateModel.query.filter(
            DateModel.from_date >= f_date, 
            DateModel.from_date <= t_date).all()

Here two lines inside filter translates to AND. So I get all records between f_date and t_date.

Now I want to add more data with OR. For example:

qry = DateModel.query.filter(
            DateModel.from_date >= f_date, 
            DateModel.from_date <= t_date 

            OR?

            DateModel.to_date >= f_date, 
            DateModel.to_date <= t_date).all()

What would be the syntax for such query?

Vigen · Accepted Answer · 2021-04-06 12:54:39Z

2

From this question solution with sqlachemy is below

query = session.query(DateModel).filter(
((DateModel.from_date >= f_date) &
(DateModel.from_date <= t_date)).self_group() |
((DateModel.to_date >= f_date) &
(DateModel.to_date <= t_date)).self_group()).all()

Not familiar with flask-sqlalchemy, but I'm expecting something like:

query = DateModel.query.filter(
((DateModel.from_date >= f_date) &
(DateModel.from_date <= t_date)).self_group() |
((DateModel.to_date >= f_date) &
(DateModel.to_date <= t_date)).self_group()).all()

answered Apr 6, 2021 at 12:54

Vigen

5021 gold badge6 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

OR operator in Flask-sqlachemy 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