On Thu, Feb 25, 2016 at 9:03 AM, Piotr Dobrogost < p...@2016.groups.google.dobrogost.net> wrote:
> On Wednesday, February 24, 2016 at 2:41:43 PM UTC+1, Piotr Dobrogost wrote: >> >> Hi! >> >> Let's say I have a model Text with attribute "values" which is >> association proxy. >> I can update single object like this: >> text = session.query(Text).one() >> text.values.update(...) >> >> How can I update multiple objects with the same value without manually >> looping over result of a query? >> texts = session.query(Text).all() >> texts???values???.update(...) >> > > Any hints? > > I can't think of a way you could do this with objects you've already loaded into memory. Perhaps you could use Query.update to issue the appropriate SQL directly to the database? http://docs.sqlalchemy.org/en/rel_1_0/orm/query.html#sqlalchemy.orm.query.Query.update Simon -- 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 post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.
