table.update() requires the "key" of the Column object, usually the same as
column.name, as the names inside the values dictionary (or better yet, the
table.c.mycol object itself as key). The behavior below suggests "mycol" is
not available as table.c.mycol.
On Dec 9, 2010, at 5:23 AM, Nagy Viktor wrote:
> Hi,
>
> it's probably a very simple question, but can't get around it.
>
> I run
>
> myquery.update(values={'mycol': 0.7})
>
> this generates sql:
>
> 'UPDATE executieoperatieangajat SET WHERE executieoperatieangajat."Operatie"
> = %(Operatie_1)s AND executieoperatieangajat."Terminat" = %(Terminat_1)s'
> {'Operatie_1': u'denumire9', 'Terminat_1': 0}
>
> as you can see, there is a missing part between SET and WHERE
>
> what do I do wrong?
>
> mycol is a column attribute in a declaratively given table
>
> thanks, Viktor
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" 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/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en.
