Search code snippets, questions, articles...

Replace NULL with false while Selecting in SQLAlchemy

Here we are replacing active column value of user table with false if it is null
from sqlalchemy import func

# SYNTAX - func.coalesce(model.prop, default_value)
db.session.query(
    UserModel.id,
    func.coalesce(UserModel.active, false).label('is_active'),
).filter(
    UserModel.status == 'active'
).all()
Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool
Was this helpful?
0 Comments