8.32. SQLAlchemy Query Filter

Important

• Filter

• Filter By

• Where

8.32.1. Filter

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.filter

8.32.2. Filter By

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.filter_by

8.32.3. Where

• https://docs.sqlalchemy.org/en/stable/orm/query.html#sqlalchemy.orm.Query.where

✘

>>> shrew = Animal(u'shrew')
>>> shrew[u'cuteness'] = 5
>>> shrew[u'weasel-like'] = False
>>> shrew[u'poisonous'] = True
>>>
>>> session.add(shrew)
>>> session.flush()
>>>
>>> q = (session.query(Animal).
...      filter(Animal.facts.any(
...        and_(AnimalFact.key == u'weasel-like',
...             AnimalFact.value == True))))
>>> print('weasel-like animals', q.all())