NoForeignKeysError inconsistent error? about sqlalchemy

[zzzeek]

Am traveling this week. Will have time to look early next week if no one else is available to triage this

[zzzeek]

Law of twos with #11321

[zzzeek]

the correct parameter for setting the tablename on a decalrative base is __tablename__, not tablename. Fixing that, your program fails because you have an errant comma in your table definition:

sqlalchemy.exc.NoForeignKeysError: Can't find any foreign key relationships between '('subusers',)' and 'instance_subuser'.
                                                                                      ^^^^^^^^^^^ note tuple here


class SubUser(Base):
    tablename = 'subusers',
                         ^^^ errant comma here

    id = Column(Integer, primary_key = True)
    instances = relationship('Instance', secondary = InstanceSubuserRelationShipTable, back_populates='subusers')
    # Irrelevant parameters here...

[ElHaban3ro]

Ironically it wasn't that (because later I fixed it and it kept throwing error), it was ',' after the 'tablename'. Biggest nonsense in the universe, I know.

[CaselIT]

just fyi, black and compatible formatters will format a one-tuple with parents, so your case would have become __tablename__ = ('subusers',), making it more visible when there are errant comma