[sqlalchemy] Issue with cascade deletion

2023-11-10 Thread Javier Uribe
Hi, so I have the database classes as follows: class Thing(Base): DatasetId = Column(ForeignKey(schema + 'Dataset.DatasetId'), primary_key=True, nullable=False, index=True) RequiredThing_child = relationship('RequiredThing', cascade='all, delete-orphan') class Location(Base): DatasetId =

[sqlalchemy] Issue with cascade deletion for multiple tables

2023-11-10 Thread Javier Uribe
Hi, so I have the database classes as follows: class Thing(Base): DatasetId = Column(ForeignKey(schema + 'Dataset.DatasetId'), primary_key=True, nullable=False, index=True) RequiredThing_child = relationship('RequiredThing', cascade='all, delete-orphan') class Location(Base): DatasetId =