doh. found! maybe it's better to put it in the book. cacheable makes the select return a "stripped" Rows object. When you use cache, if cacheable is False, you store the list of the results, that are turned into a Rows object "filling" a new empty copy. So, cacheable=False cached results are then transformed to a full Rows object (find() works) ... cacheable=False returns a Rows object, that cached (pickled) returns a list, but it's not "transformed back" to a full Rows object.
On Thursday, September 13, 2012 9:33:27 PM UTC+2, Niphlod wrote: > > no errors but both (cacheable and not cacheable) are gluon.dal.Rows before > pickling and list after pickle.dumps() > > On Thursday, September 13, 2012 9:18:59 PM UTC+2, Massimo Di Pierro wrote: >> >> try pickle and unpickle this: >> rows = db(db.tests.id>0).select(cache=(cache.disk, 200), cacheable=True) >> >> perhaps something is failing there? >> >> >> On Sep 13, 2012, at 2:14 PM, Niphlod wrote: >> >> uhm. web2py 2.0.8 ... this works >> >> rows = db(db.tests.id>0).select(cache=(cache.disk, 200)) >> rows = db(db.tests.id>0).select(cache=(cache.disk, 200)) >> print rows.find(lambda row: row.id == 1) >> >> this don't >> >> rows = db(db.tests.id>0).select(cache=(cache.disk, 200), cacheable=True) >> rows = db(db.tests.id>0).select(cache=(cache.disk, 200), cacheable=True) >> print rows.find(lambda row: row.id == 1) >> >> the same exact thing is happening using cache.redis (cacheable=True >> doesn't work, the other works) >> >> -- >> -- mail from:GoogleGroups "web2py-developers" mailing list >> make speech: [email protected] >> unsubscribe: [email protected] >> details : http://groups.google.com/group/web2py-developers >> the project: http://code.google.com/p/web2py/ >> official : http://www.web2py.com/ >> >> >> >> >> --
