i don't understand how to write it in turbogears?
can you please give an example?
my model:
class BudgetTreeNode(Entity):
name = Field(Unicode(255), required=True)
organ = ManyToOne('Organ')
value = Field(Float(), required=True)
type = ManyToOne('BudgetLineType')
actions = OneToMany('Action')
budget = ManyToOne('Budget')
created = Field(DateTime, required = True, default = datetime.now)
active = Field(Boolean, required=True, default=True)
On 23 דצמבר, 13:41, "Jorge Vargas" <[email protected]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
