Login and I will give you edit access.

On Monday, 18 June 2012 14:44:39 UTC-5, howesc wrote:
>
> thanks!  now how do i go about updating the book to discuss these new 
> features?
>
> On Sunday, June 17, 2012 9:09:33 PM UTC-7, Massimo Di Pierro wrote:
>>
>> uploading.... :-)
>>
>> On Sunday, 17 June 2012 10:40:51 UTC-5, howesc wrote:
>>>
>>> sorry if i confused you by submitting 2 non-inclusive patches. :(  the 
>>> reference patch for 
>>> https://groups.google.com/forum/?fromgroups#!topic/web2py/mKgLFC5pxcYis 
>>> what you applied, and with your change still works for me.
>>>
>>> if the cursor patch in this thread looks ok can you add it as well? 
>>>  this is the same patch file with updated line numbers for tip of tunk.
>>>
>>> thanks!
>>>
>>> christian
>>>
>>> On Saturday, June 16, 2012 3:04:00 PM UTC-7, Massimo Di Pierro wrote:
>>>>
>>>> In trunk with a minor change. Please make sure I did not break your 
>>>> patch.
>>>>
>>>> massimo
>>>>
>>>> On Saturday, 16 June 2012 13:59:34 UTC-5, howesc wrote:
>>>>>
>>>>> Hello again,
>>>>>
>>>>> I wanna use cursors on my GAE queries: 
>>>>> https://developers.google.com/appengine/docs/python/datastore/queries#Query_Cursors
>>>>>
>>>>> i have attached a patch that adds an optional parameter "reusecursor" 
>>>>> to select on GAE.  If True, and the query has a limitby, it indicates 
>>>>> that 
>>>>> db['_lastcursor'] will have the cursor (i didn't want to store it if you 
>>>>> are not gonna use it because i'm not sure of the cost of getting that 
>>>>> cursor).  If a reusecursor is a string that string will be passed to the 
>>>>> GAE query as the cursor.  Note that you must use limitby on all queries 
>>>>> that you want to return the cursor for, and that queries that use a 
>>>>> cursor 
>>>>> must have the exact same filters.  Keep in mind that limitby will be in 
>>>>> relation to the cursor, so in most cases you want offset of 0.
>>>>>
>>>>> my suggested patch is attached.  i welcome comments.
>>>>>
>>>>> example:
>>>>>
>>>>> def test3():
>>>>>     cursor = request.vars.cursor or True
>>>>>
>>>>>     #say the manu_item has about a hundred rows....
>>>>>     rows = db(db.menu_item.id>0).select(reusecursor=cursor, 
>>>>> limitby=(0,10))
>>>>>     cursor = db['_lastcursor']
>>>>>     next_link = A('next', _href=URL(r=request, vars={'cursor':cursor}))
>>>>>     
>>>>>     
>>>>>     # Use generic HTML views
>>>>>     response.generic_patterns = ['html']
>>>>>     return dict(
>>>>>         rows=rows,
>>>>>         cursor=cursor,
>>>>>         next_link = next_link)
>>>>>
>>>>> thanks,
>>>>>
>>>>> christian
>>>>>
>>>>

Reply via email to