Re: [sqlalchemy] Alembic with SQLite FOREIGN_KEYS pragma

2023-01-15 Thread Mike Bayer
On Sun, Jan 15, 2023, at 6:51 AM, Lele Gaifax wrote: > Hi all, > > this is loosely related to my other post: modern SA/Alembic transaction > handling changed (unsurprisingly! :-) somewhat, and old migration trick > does not work anymore. I found a way out, but maybe there is a better > approach,

[sqlalchemy] Alembic with SQLite FOREIGN_KEYS pragma

2023-01-15 Thread Lele Gaifax
Hi all, this is loosely related to my other post: modern SA/Alembic transaction handling changed (unsurprisingly! :-) somewhat, and old migration trick does not work anymore. I found a way out, but maybe there is a better approach, who knows! My app, being SQLite based, installs an event handler