All this web2py is new for me so it's likely that I messed up
something.
It's all part of a monitoring page where I can check the processes
running on the server.
from: applications\monitor\views\default\index.html
I call:
{{=TD(LOAD(url=URL(r=request,f='getProcesStatus',args=proces_key),
ajax=True))}}
the getProcesStatus is in applications\monitor\controllers\default.py
which calls getProcess(command_line=proces_cmd) from applications
\monitor\models\monitor.py
which calls updateProcessesList() from applications\monitor\models
\processes.py
updateProcessesList() checks an update time stored in
monitordb.updates (the last update time of the processes list stored
in another table: monitordb.processes ), and if needed uses WMI to get
the list of processes and update the db
also, the table used to cache the processes list is defined as
follows:
monitordb.define_table('processes',
Field('processid'),
Field('parentprocessid'),
Field('creationdate'),
Field('name'),
Field('commandline'),
Field('updatetime')
)
and I have the same "OperationalError: no such table:" problem
described above when I try to execute:
monitordb.processes.insert(**process_details)
from shell:
monitordb.processes.insert(**process_details)
or
monitordb.processes.truncate()
return
Traceback (most recent call last):
File "<input>", line 1, in <module>
File "C:\LOCALWORKS\python\web2py\gluon\sql.py", line 2005, in
insert
self._db._execute(query)
File "C:\LOCALWORKS\python\web2py\gluon\sql.py", line 947, in
<lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
ProgrammingError: Cannot operate on a closed database.
Am I over complicating everything?
