cache on select not work, modify apps/todo/api, cacheable=True is work 
without defining cache
*apps/todo/__init__.py*
@action('api')                      # a GET API function
@action.uses(db)                    # all before starting a db connection
def todo():
    cache_time_expire = 10
    cache_db = (cache, cache_time_expire)
    return dict(items=db(db.todo).select(orderby=~db.todo.id, cache=cache_db
, cacheable=True).as_list())

ERROR:root:Traceback (most recent call last):
  File "/Users/sugizo/learn/python/web3py/web3py/core.py", line 413, in 
wrapper
    ret = func(*func_args, **func_kwargs)
  File "/Users/sugizo/learn/python/web3py/web3py/core.py", line 379, in 
wrapper
    ret = func(*args, **kwargs)
  File "/Users/sugizo/learn/python/web3py/apps/todo/__init__.py", line 31, 
in todo
    return dict(items=db(db.todo).select(orderby=~db.todo.id, cache=cache_db
, cacheable=True).as_list())
  File 
"/Users/sugizo/miniconda3/envs/python3_todo/lib/python3.7/site-packages/pydal/objects.py"
, line 2395, in select
    return adapter.select(self.query, fields, attributes)
  File 
"/Users/sugizo/miniconda3/envs/python3_todo/lib/python3.7/site-packages/pydal/adapters/sqlite.py"
, line 82, in select
    return super(SQLite, self).select(query, fields, attributes)
  File 
"/Users/sugizo/miniconda3/envs/python3_todo/lib/python3.7/site-packages/pydal/adapters/base.py"
, line 762, in select
    cache, sql, fields, attributes, colnames)
  File 
"/Users/sugizo/miniconda3/envs/python3_todo/lib/python3.7/site-packages/pydal/adapters/base.py"
, line 753, in _cached_select
    time_expire)
TypeError: 'Cache' object is not callable

*apps/todo/__init__.py*
@action('api')                      # a GET API function
@action.uses(db)                    # all before starting a db connection
def todo():
    cache_time_expire = 10
    cache_db = (cache.memoize(expiration=5), cache_time_expire)
    return dict(items=db(db.todo).select(orderby=~db.todo.id, cache=cache_db
, cacheable=True).as_list())

ERROR:root:Traceback (most recent call last):
  File "/Users/sugizo/learn/python/web3py/web3py/core.py", line 413, in 
wrapper
    ret = func(*func_args, **func_kwargs)
  File "/Users/sugizo/learn/python/web3py/web3py/core.py", line 379, in 
wrapper
    ret = func(*args, **kwargs)
  File "/Users/sugizo/learn/python/web3py/apps/todo/__init__.py", line 31, 
in todo
    return dict(items=db(db.todo).select(orderby=~db.todo.id, cache=cache_db
, cacheable=True).as_list())
  File 
"/Users/sugizo/miniconda3/envs/python3_todo/lib/python3.7/site-packages/pydal/objects.py"
, line 2395, in select
    return adapter.select(self.query, fields, attributes)
  File 
"/Users/sugizo/miniconda3/envs/python3_todo/lib/python3.7/site-packages/pydal/adapters/sqlite.py"
, line 82, in select
    return super(SQLite, self).select(query, fields, attributes)
  File 
"/Users/sugizo/miniconda3/envs/python3_todo/lib/python3.7/site-packages/pydal/adapters/base.py"
, line 762, in select
    cache, sql, fields, attributes, colnames)
  File 
"/Users/sugizo/miniconda3/envs/python3_todo/lib/python3.7/site-packages/pydal/adapters/base.py"
, line 753, in _cached_select
    time_expire)
TypeError: decorator() takes 1 positional argument but 3 were given

best regards,
stifan

-- 
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 [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/86bd1e59-98e0-48c0-83cb-93fb0b30b09b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to