Apply condition based multiple filters in SQLAlchemy query

python Share on :

To apply multiple filters in SQLAlchemy queries which are condition-based you can use ** before queries object and pass it to the filter method.

all_filters = [UserModal.role == 'admin']

if user.last_name:
    all_filters.append(UserModal.last_name == 'Deo')

db.session.query(
    UserModal.username
).filter(
    **all_filters
).all()

In the code snippet, we are applying two filters on UserModel. First filter [UserModal.role == 'admin'] will be applied every time. But the second filter 'UserModal.last_name == 'Deo' will be applied if it will satisfy the condition user.last_name.

Contribute to this Snippet

Was this helpful?

Created by :

@

Write your Comment

1 Comments

sahaiaakash3B4B

This article has incorrect information. ** is used to unpack dict. * is used to unpack arrays. Please fix the article.

Wrong Information

Similar code snippets

Apply join based on multiple conditions SQLAlchemy
Change column values condition based in Pandas DataFrame
Filter based on NULL Values in SQLAlchemy
Filter query Sqlalchemy
Join models or tables query Sqlalchemy
Like query Sqlalchemy
Left Join Query python Sqlalchemy