Re: [sqlalchemy] MSSQL with PyODBC: StaleDataError on UPDATE statement

2020-06-26 Thread jue...@gmail.com
asurement table have a primary key constraint present, and > does this primary key constraint consist of exactly the "ID" column only > and no other columns? it would appear you have not mapped the primary key > correctly. > > > > On Fri, Jun 26, 2020, at

Re: [sqlalchemy] MSSQL with PyODBC: StaleDataError on UPDATE statement

2020-06-29 Thread jue...@gmail.com
engine: > > engine.dialect.supports_sane_rowcount =False > > > On Fri, Jun 26, 2020, at 12:49 PM, jue...@gmail.com wrote: > > I think ID is the only primary key of the Measurements table, but I can > double check this on Monday. I used sqlacodegen to create the initial &

[sqlalchemy] Re: MSSQL with PyODBC: StaleDataError on UPDATE statement

2020-06-26 Thread jue...@gmail.com
() # --> This raises the StaleData Exception jue...@gmail.com schrieb am Freitag, 26. Juni 2020 um 15:57:32 UTC+2: > I'm currently working with sqlalchemy (Version 1.3.18) to access a > Microsoft Server SQL Database (Version: 14.00.3223). I use pyodbc > (Version 4.0.30) &g

[sqlalchemy] MSSQL with PyODBC: StaleDataError on UPDATE statement

2020-06-26 Thread jue...@gmail.com
I'm currently working with sqlalchemy (Version 1.3.18) to access a Microsoft Server SQL Database (Version: 14.00.3223). I use pyodbc (Version 4.0.30) When I try to update a single object and try to update and commit the object, I run into a StaleDataError: StaleDataError: UPDATE statement on

[sqlalchemy] Re: MSSQL with PyODBC: StaleDataError on UPDATE statement

2020-06-26 Thread jue...@gmail.com
': False, } jue...@gmail.com schrieb am Freitag, 26. Juni 2020 um 16:01:07 UTC+2: > Here is the code I used (simplified): > > class Measurement(Base): > __tablename__ = 'Measurement' > __table_args__ = ( > {'implicit_returning': False}, # Required because o