I have models in two different schemas with a foreign key relationship like this.

Despite seeing many answers to my question it does not work for me.
Working with SQLAlchemy 1.4.32 the following works:

I am running the following code in python 3.8, sqlalchemy-2.0.30.

given a list of sql statements, that shall be executed as a unit. How can I achieve a rollback of all previously succesfully executed statements, if any statement fails?

I am building a polymorphic relationship between classes A and B through a Link class.
I want to achieve that when an A object is deleted, the linked B objects are deleted too.
To do that, I defined a relationship between A and Link, with a cascade relationship all, delete, in this way as soon as A is deleted we will try to delete all the links, and then I intercepted the delete on the Link using an event listener before_delete class and I used it to delete also the B object.
A better solution can exist, and most of all I am concerned about the connection object in the event listener that doesn’t seem to be bound to any session.

In SQLAlchemy 2 how to query a polymorphic type child by base columns?
i.e

The title does more or less say everything. I want to create a data model with SQLAlchemy and it should contain fields with values that contain unicode and should be considered case-sensitive.

I have 4 types of nodes with specific implementation:

Lets say I have the following simplified example:

Using SQLAlchemy I’m trying to create a one-to-one relationship on the same table. This table represents some physical ethernet ports that can be connected. Here is my code: