Something strange, Michael.. All bindparams are different. Compliller
should not add to SET all params if values() has bindparam args, no?
where() have:
bindparam('commit_date'), bindparam('serial'), bindparam
('office_id')
values() have:
bindparam('rollback_date'), bindparam('rollback_time'), bindparam
('rollback_user_id')
All bindparams are different.
params={'commit_date':'2009-10-22', 'serial':1, 'office_id':1,
'rollback_date':'2009-10-22', 'rollback_time':'11:12:15',
'rollback_user_id':1, 'foobar':1, 'sum':111})
UPDATE transactions SET serial=%(serial)s, office_id=%(office_id)s,
sum=%(sum)
s, commit_date=%(commit_date)s, rollback_date=%(rollback_date)s,
rollback_time=%(rollback_time)s, rollback_user_id=%(rollback_user_id)
s
WHERE transactions.commit_date = %(commit_date)s AND
transactions.serial = %(serial)s AND transactions.office_id = %
(office_id)s
On 22 окт, 19:45, "Michael Bayer" <mike...@zzzcomputing.com> wrote:
> sector119 wrote:
>
> >> though likely cleaner to pass the exact set of parameters desired.
>
> > How to pass that params if I use bindparam at where() and values(),
> > but I don't want to update colums that are at where() clause, only at
> > values() ?
>
> if you are using bindparam() objects, you'd given them all distinct names.
>
>
>
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
