thanks, this was the problem
I've had
class User(DeclarativeBase):
username = Column( UserName, ...)
is there any way to get UserName back knowing only the "words" User and
username?
Viktor
On Thu, Dec 9, 2010 at 4:31 PM, Michael Bayer <[email protected]>wrote:
> 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]<sqlalchemy%[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]<sqlalchemy%[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.