Open a ticket and we will look to include it. The problem is that not all
databases support it.
On Friday, 12 October 2012 20:47:06 UTC-5, vince wrote:
>
> oh db.executesql, thx.
>
> will we have any table locking implement on web2py? say an option to lock
> all queried table read only until commit?
>
> On Thursday, October 11, 2012 9:32:14 PM UTC+8, Massimo Di Pierro wrote:
>>
>> You can try:
>>
>> db.executesql('LOCK TABLE tablename READ;')
>>
>>
>> http://aarklondatabasetrivia.blogspot.com/2009/04/how-to-lock-and-unlock-tables-in-mysql.html
>>
>>
>> On Thursday, 11 October 2012 01:44:14 UTC-5, vince wrote:
>>>
>>> can i lock a table as readonly during the transaction? the case is i
>>> need to insert a record to table B which is base on the query result of
>>> table A, i would like to lock table A as readonly until i finish the insert.
>>>
>>> i am using mysql at the moment. i know web2py may not have this feature,
>>> what is the best way to use mysql's 'lock table' on web2py?
>>>
>>> thanks in advance,
>>> vince
>>>
>>
--
