If I have this in my DB: db = DAL('sqlite://storage.sqlite', check_reserved=[])
db.define_table('test_table', Field('value'), ) if db(db.test_table.id > 0).count() == 0: db.test_table.bulk_insert([{'value': 'one'}, {'value': 'two'}, {'value': 'three'}, {'value': 'four'}, {'value': 'five'}]) And this in my default controller def index(): test_table_rows = db(db.test_table.id>0).select(cache=(cache.ram, 1800), cacheable=True) for record in test_table_rows: # Suppose I want to change the way the values are returned, here I'm adding a # but I could be # doing something useful like turning them into an URL() record.value = record.value + '#' return {'values': test_table_rows} Then go to /default/index.json and keep refreshing. What you end up getting will be something like: {"values": [{"id": 1, "value": "one##########################"}, {"id": 2, "value": "two##########################"}, {"id": 3, "value": "three##########################"}, {"id": 4, "value": "four##########################"}, {"id": 5, "value": "five##########################"}]} I find this behavior to be quite unexpected as I would think that the cached rows would not be affected, what I would expect would be for the select to always return me exactly the same cached Rows. This makes cacheable=True very dangerous in a way that reminds me of using mutables as default function arguments. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.