Thanks a lot, Michael!

On Oct 23, 4:09 am, Michael Bayer <mike...@zzzcomputing.com> wrote:
> On Oct 22, 2009, at 3:26 PM, sector119 wrote:
>
>
>
> > 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')
>
> OK i have this fully repaired in trunk r6428.  if you use a bindparam
> () with a column name, it will be honored as is and won't be  
> implicitly added to the SET or VALUES clause of an update or insert.
>
>
>
> > 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
-~----------~----~----~----~------~----~------~--~---

Reply via email to