Re: [sqlalchemy] sqlalchemy.orm.exc.StaleDataError: UPDATE statement on table 'PPESSOA' expected to update 1 row(s); 0 were matched.

o.1.1" SQLALCHEMY_TCLOUD_DATABASE_URI = 'mssql://'+TCLOUD_DATABASE_USERNAME+':'+TCLOUD_DATABASE_PASSWORD_UPDATED+'@ '+TCLOUD_DATABASE_HOST+':'+TCLOUD_DATABASE_PORT+'/'+TCLOUD_DATABASE_NAME+'?driver='+TCLOUD_DATABASE_DRIVER_V18+'=yes=yes' Em ter., 5 de set. de 2023 às 22:03, Leandro Lázaro < l

Re: [sqlalchemy] sqlalchemy.orm.exc.StaleDataError: UPDATE statement on table 'PPESSOA' expected to update 1 row(s); 0 were matched.

UPDATE will succeed. however, after > the program runs, look in the database and make sure the UPDATE took effect > correctly.if so, the driver, either pyodbc, or the ODBC driver in use, > has an unknown bug. try updating drivers, both pyodbc and the ODBC driver > in use. > >

Re: [sqlalchemy] sqlalchemy.orm.exc.StaleDataError: UPDATE statement on table 'PPESSOA' expected to update 1 row(s); 0 were matched.

oducible in a single environment or can it be reproduced elsewhere? > > > On Tue, Aug 22, 2023, at 2:42 PM, Leandro Lázaro wrote: > > Hello > > First, thanks for building this library. God bless you > > > I've been trying to understand what's going on for days. > > This code w

[sqlalchemy] sqlalchemy.orm.exc.StaleDataError: UPDATE statement on table 'PPESSOA' expected to update 1 row(s); 0 were matched.

Hello First, thanks for building this library. God bless you I've been trying to understand what's going on for days. This code works fine: https://pastebin.com/fLTnB8jy But if I try to modify any other parameter like PERSONAL EMAIL I get the error: sqlalchemy.orm.exc.StaleDataError:

[sqlalchemy] Sqlacodegen freeze when generate models.py

Hello, When I use the command sqlacodegen mssql+pymssql://USER:PASS@IP:PORT/DB > model.py, the process hangs and continues running for several hours without any results. The database I'm trying to generate models.py for is quite large (over 1000 tables). Is the execution time normal, or is