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

Reply via email to