heya HDM: committed a "for_update=True" flag to select(), union(), union_all() which tacks on a "FOR UPDATE" at the very end of the compiled string (its after any kind of ORDER BY etc. right?)
committed in changeset 1232. - mike HD Mail wrote: > HD Mail wrote: > > Actually, ignore my last post. I had a closer look and created this > patch. Hopefully it can be of some use. > > I added a for_update attribute to the Select class. > > Then changed the ansisql.py: > > def visit_select_postclauses > > to add my for_update statement. > > It seems to work for me. > > Huy > > >> Michael Bayer wrote: >>> I dont have "FOR UPDATE" in there as of yet. it can be added easily >>> enough, although im short on time this week. feel free to add a >>> ticket (or dig around sql.py and see if you can figure it out) >>> >> Thanks Michael. I did have a look. I could add it in SelectBaseMixin >> the same way you do order_by/group_by but because I not too familiar >> with SA internals, I'm a bit reluctant. >> >> Huy >>> >>> On Mar 29, 2006, at 8:00 AM, HD Mail wrote: >>> >>>> Hi, >>>> >>>> I am building a select using >>>> >>>> st = table.select() >>>> st.append_whereclause(...) >>>> >>>> Is it possible to append something like "FOR UPDATE" at the end of >>>> the generated select statement. >>>> >>>> Before anyone shoots me down for using "for update", i'm writing a >>>> stock control system. >>>> >>>> I love the query building features in SA so I really want to use it >>>> to write my sql rather then using straight sql. >>>> >>>> Thanks >>>> >>>> Huy >>>> >>>> >>>> >>>> ------------------------------------------------------- >>>> This SF.Net email is sponsored by xPML, a groundbreaking scripting >>>> language >>>> that extends applications into web and mobile media. Attend the live >>>> webcast >>>> and join the prime developer group breaking into this new coding >>>> territory! >>>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 >>>> >>>> _______________________________________________ >>>> Sqlalchemy-users mailing list >>>> Sqlalchemy-users@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users >>> >>> >>> >>> ------------------------------------------------------- >>> This SF.Net email is sponsored by xPML, a groundbreaking scripting >>> language >>> that extends applications into web and mobile media. Attend the live >>> webcast >>> and join the prime developer group breaking into this new coding >>> territory! >>> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 >>> _______________________________________________ >>> Sqlalchemy-users mailing list >>> Sqlalchemy-users@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users >> >> >> >> ------------------------------------------------------- >> This SF.Net email is sponsored by xPML, a groundbreaking scripting >> language >> that extends applications into web and mobile media. Attend the live >> webcast >> and join the prime developer group breaking into this new coding >> territory! >> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 >> _______________________________________________ >> Sqlalchemy-users mailing list >> Sqlalchemy-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users > > ------------------------------------------------------- This SF.Net email is sponsored by xPML, a groundbreaking scripting language that extends applications into web and mobile media. Attend the live webcast and join the prime developer group breaking into this new coding territory! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642 _______________________________________________ Sqlalchemy-users mailing list Sqlalchemy-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
