Correction....
session.query(YourClass).filter(and_(YourClass.field1 == "any
value",
YourClass.otherfield == None )).update(values = dict(tag = "a"))
this is somewhat like update thetablerelatedtoYourClass set tag = ""
where field1 = "any value" and otherfield is null
If you want more than one field affected, include the key value pair
inside the dictionary related to values .
On Feb 17, 6:36 pm, Domingo Aguilera <domingo.aguil...@gmail.com>
wrote:
> This is one example...
>
> session.query(YourClass).update(values = dict(tag = "a"))
>
> the previous one modifies field named tag to "a" for every record.
>
> You can filter before doing update. For example...
> from sqlalchemy.sql import and_
> session.query(YourClass).filter(and_(YourClass.field1 == "any value",
> YourClass.otherfield == None ))update(values = dict(tag = "a"))
>
> On Feb 17, 4:23 pm, mando <mandol...@gmail.com> wrote:
>
>
>
> > Hi to alls,
>
> > still now I use this method to update values in my table:
>
> > table.update(table.c.table_name, 'id_table' == 1').execute({'field_1':
> > 'new_value'}))
>
> > But now I want to use session. I look around the web and this list but
> > I don't understand how to do it.
>
> > Session = sessionmaker(bind=self.engine, autoflush=True,
> > autocommit=True)
> > session = Session()
> > session.query(MYTABLECLASS).update( 'id_table' ==
> > 1').execute({'field_1': 'new_value'})
>
> > This is wrong, but where I can see somes examples? I read the official
> > sqlalchemy documentation, but I didn't find nothing that help me.
>
> > Sorry 8 ) and thanks a lot for any suggestions!!!
>
> > luca
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
