Maybe someone can just place an example of correct update() usage
please: can't sort it out from docs rather google, thanks.
On Jul 30, 3:51 pm, vitsin <vitaly.sinit...@gmail.com> wrote:
> hi,
> can't figure out why raw SQL works fine, but update() is not working:
> 1.working raw SQL:
> self.session.execute("update public.my_table set
> status='L',updated_at=now() where my_name='%s'" % (self.my_name))
>
> 2.non working update() from Alchemy:
> s = aliased(MyTable)
> query = self.session.query(s).filter(s.my_name==self.my_name)
> sts = self.session.execute(query).fetchone()
> sts.update(values={'status':'L'})
>
> sts.update(values={s.status:'L'})
> File "/usr/lib/python2.6/dist-packages/sqlalchemy/engine/base.py",
> line 2097, in _key_fallback
> "Could not locate column in row for column '%s'" % key)
> sqlalchemy.exc.NoSuchColumnError: "Could not locate column in row for
> column 'update'"
>
> But Column s.status exists ...
> appreciate any help,
> --vs
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@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.
