Chrome Extension

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_

dbsession.query(
    EmployeeModel
).filter(
    or_(
        EmployeeModel.status != 'active',
        EmployeeModel.status == None #this is used to check NULL values
    )
).all()
Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool

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?
0 Comments