[web2py] db issue when accessing db from more than one place

[Tomas Pelka]

Hey,

have following issue.
model:
db.define_table('syslogs', Field('datetime', 'datetime', 
label='date&time'), Field('incident', 'string', label='incident'))

controller:
from applications.myapp.modules.LOG import log

@auth.requires_login()
def index():
    log("log controler", "test message from log!")
    return dict()

myapp/modules/LOG.py
import datetime
from applications.myapp.models.db import __getDB

def log(id, msg):
    """
    Provides logging to DB.

    Keyword arguments:
    id -- identifies source of log message
    msg -- string with log message
    """
    log_msg = "[%s]:: %s" % (id, msg)
    db = __getDB()
    db.syslogs.insert(datetime=datetime.datetime.now(), incident=log_msg)


Always getting this traceback:

Traceback(most recent call last):
  File"/home/tom/web2py/gluon/restricted.py",line178,inrestricted
    execccodeinenvironment
  File"/home/tom/web2py/applications/myapp/controllers/logs.py"  
<https://147.229.148.207:8000/admin/default/edit/NetSim/controllers/logs.py>,line9,in<module>
  File"/home/tom/web2py/gluon/globals.py",line96,in<lambda>
    self._caller=lambdaf:f()
  File"/home/tom/web2py/gluon/tools.py",line2170,inf
    returnaction(*a, **b)
  File"/home/tom/web2py/applications/myapp/controllers/logs.py"  
<https://147.229.148.207:8000/admin/default/edit/NetSim/controllers/logs.py>,line6,inindex
    log("log controler","test message from log!")
  File"/home/tom/web2py/applications/myapp/modules/LOG.py",line18,inlog
  File"/home/tom/web2py/gluon/sql.py",line1329,in__getattr__
    returndict.__getitem__(self,key)
KeyError:'syslogs'



When I run " db.syslogs.insert(datetime=datetime.datetime.now(), 
incident="test")" from model it works just fine.

Many thanks for advices.

--
Tomas Pelka