SqlAlchemy – Filtering by Relationship Attribute

by

Use method has() of relationship (more readable):

patients = Patient.query.filter(Patient.mother.has(phenoscore=10))

or join (usually faster):

patients = Patient.query.join(Patient.mother, aliased=True)\
                    .filter_by(phenoscore=10)

More Related Contents:

  1. Sqlite / SQLAlchemy: how to enforce Foreign Keys?
  2. sqlalchemy: create relations but without foreign key constraint in db?
  3. SQLAlchemy: get Model from table name. This may imply appending some function to a metaclass constructor as far as I can see
  4. SQLAlchemy create_all() does not create tables
  5. How do I get a raw, compiled SQL query from a SQLAlchemy expression?
  6. How to check if one dictionary is a subset of another larger dictionary?
  7. SQL Alchemy ORM returning a single column, how to avoid common post processing
  8. How do I execute inserts and updates in an Alembic upgrade script?
  9. SQLAlchemy, get object not bound to a Session
  10. Python: filter list of list with another list
  11. Python call sql-server stored procedure with table valued parameter
  12. Generate sql with subquery as a column in select statement using SQLAlchemy
  13. Complex foreign key constraint in SQLAlchemy
  14. Flask sqlalchemy many-to-many insert data
  15. Connection problems with SQLAlchemy and multiple processes
  16. How to upsert pandas DataFrame to Microsoft SQL Server table?
  17. remove None value from a list without removing the 0 value
  18. How do I select literal values in an sqlalchemy query?
  19. Get inserted key before commit session
  20. SQLAlchemy multiple foreign keys in one mapped class to the same primary key
  21. How to change ForeignKey display text in the Django Admin?
  22. SQLAlchemy: engine, connection and session difference
  23. Relations on composite keys using sqlalchemy
  24. Dynamically filtering a pandas dataframe
  25. flake8 complains on boolean comparison “==” in filter clause
  26. SQLAlchemy – Mapping self-referential relationship as one to many (declarative form)
  27. pandas to_sql all columns as nvarchar
  28. How to make mysql connection that requires CA-CERT with sqlalchemy or SQLObject
  29. Can’t change system default SQLite binary
  30. add column to SQLAlchemy Table

Leave a Comment