Updating an object in a for loop using SqlAlchemy, should this work in theory?

2 things: Number one, you shouldn't have to commit() after every change. You should be able to: for p in session. Query (query): p.

Someproperty = somevalue session.commit() and number two, see this thread here: stackoverflow.com/questions/270879/effic... This gives another example of the syntax, and also the accepted answer suggests a better, more efficient way to perform this mass update.

2 things: Number one, you shouldn't have to commit() after every change. You should be able to: for p in session. Query (query): p.

Someproperty = somevalue session.commit() and number two, see this thread here: stackoverflow.com/questions/270879/effic.... This gives another example of the syntax, and also the accepted answer suggests a better, more efficient way to perform this mass update.

You have to fetch the objects explicitly to be able to modify them; you have to iterate over session. Query(query_string).all() . And, of course, a single commit after the loop is finished would be more efficient.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.