Elegant way to filter by none or not none

Question

The following SQLAlchemy code works, but looks un-pythonic:

if has_died: # has_died: True or False
  query = query.filter(User.died_at != None)
else:
  query = query.filter(User.died_at == None)

What is a more elegant way to add the filter?

Answer 1

Well, you could do this:

query = query.filter((User.died_at != None) if has_died else (User.died_at == None))

But it's a bit hard to read. I think how you're doing it is fine.

Answer 2

You could rewrite it as one line with a ternary operator

query = query.filter((User.died_at != None) if has_died else (User.died_at == None))