Hello, I have a project heavily based on joinedload inheritance. It's a CMS-like for which I've added a translation feature some months ago. It worked more or less, but some things are still not working properly.
The situation is the following: I have a joinedload inheritance for which the base class is "Content", with subclasses like Folder, Document, etc. Nothing really complicated. I'm also having another joinedload inheritance for which the base class is "ContentTranslation", with subclasses like FolderTranslation, DocumentTranslation, etc. The idea is that each Content-like class has a corresponding -Translation class (with common attributes for all Content-like stuff, like "title", "description", "language_id", etc, located in ContentTranslation class) On each Content-like class, there is "xxx_current_translation" and a "xxx_translations" relationships and I've added hybrid properties which map to the corresponding -Translation class. The problem I have is that I can't .order_by() or .filter() on the hybrid properties. Instead of making a JOIN on the "xxx_current_translation" (which is joinedload) SQLAlchemy adds the base ContentTranslation class. I've also tried with .join() manually and add it with orm.contains_eager() but it doesn't work either.. I've made a full POC on https://gist.github.com/silenius/77466fc260a9cb0f25025bffbf3339cd Any idea ? :) Thanks, Julien -- Julien Cigar Belgian Biodiversity Platform (http://www.biodiversity.be) PGP fingerprint: EEF9 F697 4B68 D275 7B11 6A25 B2BB 3710 A204 23C0 No trees were killed in the creation of this message. However, many electrons were terribly inconvenienced. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/20210528122520.4gzwrf2w4b6cqno5%40x1.