You can use the core API to create an "update ____ where _____" clause on a
given table(s).
http://docs.sqlalchemy.org/en/rel_0_9/core/dml.html
If you need to use the ORM , there is some syntactic sugar that makes doing
this easier ( going back to the .5 branch here
-
http://stackoverflow.com/questions/270879/efficiently-updating-database-using-sqlalchemy-orm
) BUT using the ORM generally means loading all the objects from the
database and then modifying them. You generally want to avoid that sort of
operation, as it also means having to track the state of objects in the
database and the session independently.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
