You could build this, but it's going to be messy. At the SQL level, if you look at an Address row, there's not enough information to know which association table to look in. You'd have to query all of the association tables (perhaps using a UNION) to find the one that contains the parent, and then query the appropriate parent table.
Simon On Sat, Jul 28, 2018 at 7:39 AM Sven <[email protected]> wrote: > > Hi Mike, > > Ok, let's forget everything I said before, it is too confusing. > > I propose to start from the table_per_association example: > > http://docs.sqlalchemy.org/en/latest/_modules/examples/generic_associations/table_per_association.html > > Would it be possible to have an attribute address.parent linked to > Customer/Supplier? Exactly like in the table_per_related example? > > for customer in session.query(Customer): > for address in customer.addresses: > print(address) > print(address.parent) # this attribute is what I need > > Thank you! > > -- > 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 [email protected]. > To post to this group, send email to [email protected]. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
