well you are giving Name an inherit condition that conflicts with how you set up the foreign key.
Name.node_id FKs to Property.node_id but then inherit condition is Name.node_id -> Node.node_id There seems to be a little unsmoothness to actually being able to configure it that way, that is, skipping over Property.node_id, but in this case your FKs make it clear what you're going for which is the "normal' setup of Name->Property->Node so you can remove "inherit condition" from Name and it works fine: class Name(Property): __tablename__ = 'Name' node_id = Column(Integer, ForeignKey("Property.node_id"), primary_key=True) __mapper_args__ = { "polymorphic_identity": "Name", } or set it: class Name(Property): __tablename__ = 'Name' node_id = Column(Integer, ForeignKey("Property.node_id"), primary_key=True) __mapper_args__ = { "polymorphic_identity": "Name", "inherit_condition": node_id == Property.node_id, } On Wed, Sep 2, 2020, at 10:08 PM, Richard Damon wrote: > Here is the code, note in all cases node_id are foreign key/primary_key > to a primary_key down the chain: > > > class Base: > """Base Class for SQLAlchemy ORM Classes""" > @declared_attr > def __tablename__(cls): > """Default the Table Name to the Class Name""" > return cls.__name__ > > Base = declarative_base(cls=Base) > > class Node(Base): > """Class repesents the base of the User Data types.""" > node_id = Column(Integer, primary_key=True) > type_name = Column(String(255), nullable=False) # todo should come > from type_id > > @declared_attr > def __mapper_args__(cls): > if cls.__name__ == 'Node' : > __mapper_args__ = { > 'polymorphic_identity': 'Node', > 'polymorphic_on': cls.type_name, > } > else: > __mapper_args__ = { > 'polymorphic_identity': cls.__tablename__, > "inherit_condition": cls.node_id == Node.node_id > } > return __mapper_args__ > > class Property(Node): > node_id = Column(Integer, ForeignKey('Node.node_id'), primary_key=True) > ref_id = Column(Integer, ForeignKey('Node.node_id')) > > class Name(Property): > node_id = Column(Integer, ForeignKey('Property.node_id'), > primary_key=True) > > > On 9/2/20 9:39 PM, Mike Bayer wrote: > > there's an FAQ entry, a little bit dated but the general idea is still > > there, at: > > > > https://docs.sqlalchemy.org/en/13/faq/ormconfiguration.html#i-m-getting-a-warning-or-error-about-implicitly-combining-column-x-under-attribute-y > > > > for joined table inheritance, where Name(Node) -> node_id are FK -> > > PK, the warning isn't emitted. so please share the mapping if it is > > doing this when it shouldnt. > > > > > > On Wed, Sep 2, 2020, at 9:08 PM, Richard Damon wrote: > >> I am getting the following error: > >> > >> SAWarning: Implicitly combining column Node.node_id with column > >> Name.node_id under attribute 'node_id'. Please configure one or more > >> attributes for these same-named columns explicitly. > >> > >> In my case I am using poymorphic classes by joining with the ORM. Node > >> is the base of the hierarchy (derived from declarative_base), then I > >> have a class Property derived from it, and a class Name derived from > >> Property. Each class has a primary_key named node_id, with a foreign key > >> constraint one step done the hierarchy. I have also tried making all the > >> Foreign key constraints point to Node.node_id and it doesn't make a > >> difference. > >> > >> It is just a warning, and the lookup does seem to make the double join, > >> so it doesn't seem to be a big problem, but it seems it want me to > >> configure something for these, but I am not sure what. > >> > >> Two level inheritance is working just fine, it is just where it hits the > >> 3rd level that it seems to want something explicit. > >> > >> -- > >> Richard Damon > >> > >> -- > >> 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 > >> <mailto:sqlalchemy+unsubscr...@googlegroups.com>. > >> To view this discussion on the web > >> visit > >> https://groups.google.com/d/msgid/sqlalchemy/8fa8e94d-cc6f-5bf5-efeb-dbdbae0d7663%40Damon-Family.org. > >> > > > > -- > > 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 > > <mailto:sqlalchemy+unsubscr...@googlegroups.com>. > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/sqlalchemy/e07cc259-2216-4ece-baf9-daabebf4ac00%40www.fastmail.com > > <https://groups.google.com/d/msgid/sqlalchemy/e07cc259-2216-4ece-baf9-daabebf4ac00%40www.fastmail.com?utm_medium=email&utm_source=footer>. > > > -- > Richard Damon > > -- > 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/7a9c5943-ff71-2a3e-a139-5feb522070e5%40Damon-Family.org. > -- 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/e26bbed4-c6a1-4b12-ba0b-723767cd623d%40www.fastmail.com.