Search code snippets, questions, articles...

Filter based on NULL Values in SQLAlchemy

NULL values filter on column values can be applied in SQLAlchemy using None keyword in filter query.
from sqlalchemy import or_

        EmployeeModel.status != 'active',
        EmployeeModel.status == None #this is used to check NULL values

In the code snippet, we are checking whether the status of the employee is not active or none. We are getting records based on these conditions. We can also apply and_ operator in place of or_ id we want both the conditions needs to be true.

Search Index Data (The code snippet can also be found with below search text)

NULL check SQLAlchemy
Was this helpful?
Programming Feeds
Learn something new everyday on Devsheet