On Tue, Dec 23, 2008 at 4:45 AM, Rotem Tamir <[email protected]> wrote: > > hi all > > i want to do something like this: > UPDATE budgettreenodes > SET value=value+100 > WHERE id IN (1,2,3,7,89,432) > > i have my db mapped with sqlalchemy/elixir and everything else has > been working just fine so far > i have been struggling with this for quite a while but have no idea of > how to go about it > > any clues? >
the simplest way will be to use, SQLAlchemy's SQL layer, http://www.sqlalchemy.org/docs/05/sqlexpression.html#updates this will let you write, almost plain old SQL with a little python sugar. is this a one time thing? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/turbogears?hl=en -~----------~----~----~----~------~----~------~--~---
