take a look at my console session here. this includes those assertions I mentioned. I had to break it out on a fetch of a zip file which I wasn't sure was hanging or not, but it created all the tables, included COMMIT, then I did a little bit of alembic downgrade / upgrade, COMMIT succeeds, the two assertions succeed
https://gist.githubusercontent.com/zzzeek/6ea76bb4c3bf50995bc7cc49b84ad88f/raw/9128670e40d4f5b2a3a77a66fb39d500d9a27012/gistfile1.txt On Sun, Jan 15, 2023, at 12:01 PM, Lele Gaifax wrote: > "Mike Bayer" <mike_not_on_goo...@zzzcomputing.com> writes: > > > I'm able to add the assertions and run "make upgrade-db" here without the > > assertions failing. > > > > > > Can I get an exact version of what code you are running: > > > > 1. branch in gitlab, and/or local changes present > > 2. exact version of alembic > > 3. exact version of sqlalchemy > > 4. running on a clean dev sqlite db or is this some production DB ? > > With latest commit in the branch sol5 > (https://gitlab.com/metapensiero/SoL/-/commits/sol5), the problem should > emerge. > > Alembic is at 1.9.2 and SA at 2.0.0rc2 (pinned in requirements/base.txt). > > I'm testing against a copy of the production DB, but it actually does > not make any difference, as the same happens with an empty development > db. > > Thanks&bye, lele. > -- > nickname: Lele Gaifax | Quando vivrò di quello che ho pensato ieri > real: Emanuele Gaifas | comincerò ad aver paura di chi mi copia. > l...@metapensiero.it | -- Fortunato Depero, 1929. > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com > <mailto:sqlalchemy%2bunsubscr...@googlegroups.com>. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/87v8l7d95g.fsf%40metapensiero.it. > -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/cfa5cc47-be08-4028-bbd5-3ddf2ca11061%40app.fastmail.com.