I looked at my question, the reference function was actually a typo, my
apology, it was supposed to be definition().
I worked it out again as follows:
*model:*
db = DAL('sqlite://storage.sqlite', migrate=False, fake_migrate=False)
response.generic_patterns = ['*'] if request.is_local else []
auth = Auth(db, hmac_key=Auth.get_or_create_key())
auth.define_tables()
crud, service, plugins = Crud(db), Service(), PluginManager()
current.db= db
db.define_table('definition',
Field('definition', 'text', length= 1000000, default="We'll update
soon.", notnull=True))
*module:#define code*
from gluon import current
from pydal import DAL, Field
db = current.db
def definition():
rows = db(db.definition).select()
for row in rows:
return row.definition
With this , the error disappeared but when running the code in web2py, i
now have a new headache:
File
"applications/Hestque_Wellness/modules/Hestquewell/abnvalinterpretation/wellabnvalinterpret0.py",
line 101, in wellabnvalinterpret
rows = db(db.health).select()
File "/usr/local/lib/python2.7/dist-packages/pydal/objects.py", line
2250, in select
return adapter.select(self.query, fields, attributes)
File "/usr/local/lib/python2.7/dist-packages/pydal/adapters/sqlite.py",
line 82, in select
return super(SQLite, self).select(query, fields, attributes)
File "/usr/local/lib/python2.7/dist-packages/pydal/adapters/base.py",
line 762, in select
return self._select_aux(sql, fields, attributes, colnames)
File "/usr/local/lib/python2.7/dist-packages/pydal/adapters/base.py",
line 718, in _select_aux
rows = self._select_aux_execute(sql)
File "/usr/local/lib/python2.7/dist-packages/pydal/adapters/base.py",
line 712, in _select_aux_execute
self.execute(sql)
File "/usr/local/lib/python2.7/dist-packages/pydal/adapters/__init__.py",
line 63, in wrap
if not args[0].connection:
File "/usr/local/lib/python2.7/dist-packages/pydal/connection.py",
line 36, in connection
return getattr(THREAD_LOCAL, self._connection_uname_)
AttributeError: 'thread._local' object has no attribute
'_pydal_connection_140327873342608_17719'
The module wellabnvalinterpret0 imports definition()function. It accesses
the health db.
Kind regards
On Sun, Apr 22, 2018 at 9:00 PM, Maurice Waka <[email protected]> wrote:
> Will send it once I get back to the comp
>
> On Sun, 22 Apr 2018, 20:55 Anthony <[email protected]> wrote:
>
>> Can't help without the code.
>>
>> --
>> 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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit https://groups.google.com/d/
>> topic/web2py/7xCGTfc6xAA/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> [email protected].
>> For more options, visit https://groups.google.com/d/optout.
>>
>
--
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].
For more options, visit https://groups.google.com/d/optout.
