sorry if i confused you by submitting 2 non-inclusive patches. :( the reference patch for https://groups.google.com/forum/?fromgroups#!topic/web2py/mKgLFC5pxcY is 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 >> >
cursorpatch2.out
Description: Binary data
