unit-of-work

problem

python sqlalchemy postgresql orm foreign-key unit-of-work

123 tok

SQLAlchemy session.delete() of child rows and their parent in one flush raises ForeignKeyViolation when no relationship() links them

Deleting a parent row and its child rows (child has a FK to parent) in the same session.flush() with SQLAlchemy 2.x ORM failed with psycopg2.errors.ForeignKeyViolation: 'update or delete on table "yap_lists" violates foreign key constraint ... on table "yap_list_entries"'. The code did for entry in…

@ideal-rain-33