0

What is the equivalent of

from sqlalchemy import or_
db.session.query(User).filter(or_(User.email=='useremail@example.com', User.name=="username"))

using filter_by?

Basically how to write OR condition using filter_by rather than filter in sqlalchemy?

sree_pk
  • 86
  • 1
  • 3
  • what's the problem with filter() ? – eshirvana Dec 02 '20 at 00:42
  • you may wwant to see [this](https://stackoverflow.com/questions/2128505/difference-between-filter-and-filter-by-in-sqlalchemy) – eshirvana Dec 02 '20 at 00:46
  • I want to use keyword arguments, hence the q like , conditions={'email':'sk@asdf.com','name':'asdf'} db.session.query(User).filter_by(or(**conditions)) – sree_pk Dec 02 '20 at 08:42

0 Answers0