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 models, so if this tool correctly detects primary keys, the Measurement model should match the table definition.
I also tried to execute the follwing statement using engine.execute: 2020-06-26 15:50:59,872 INFO sqlalchemy.engine.base.Engine UPDATE tbm.[Measurement] SET [IsCompleted]=? WHERE tbm.[Measurement].[ID] = ? 2020-06-26 15:50:59,872 INFO sqlalchemy.engine.base.Engine (True, 6248) The result also indicated that 5051 rows where affected, but I don't get it why... There is clearly only one Measurement with ID 6248... I know that certain triggers are executed if IsCompleted is changed, so maybe this has an effect on the reported rows? Mike Bayer schrieb am Freitag, 26. Juni 2020 um 18:40:11 UTC+2: > hi - > > does your Measurement 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 9:57 AM, jue...@gmail.com wrote: > > 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 table 'Measurement' expected to update > 1 row(s); 5051 were matched. > > The update statement looks perfectly fine: > > 2020-06-26 15:50:59,872 INFO sqlalchemy.engine.base.Engine UPDATE > tbm.[Measurement] SET [IsCompleted]=? WHERE tbm.[Measurement].[ID] = ? > 2020-06-26 15:50:59,872 INFO sqlalchemy.engine.base.Engine (True, 6248) > > Any Idea what's wrong with this. > > > -- > 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+...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/d607c30c-2bc5-4680-9e7f-842da8f28792n%40googlegroups.com > > <https://groups.google.com/d/msgid/sqlalchemy/d607c30c-2bc5-4680-9e7f-842da8f28792n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > > > -- 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/811cc2da-18fc-4679-914f-e7d672c4bdcfn%40googlegroups.com.
