(dp1 S'output' p2 S" No table selected" p3 sS'layer' p4 S'/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py' p5 sS'code' p6 S' at 0x7f1909945730, file "/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py", line 1>' p7 sS'snapshot' p8 (dp9 S'exception' p10 (dp11 S'__getslice__' p12 S"" p13 sS'__str__' p14 S"" p15 sS'__reduce__' p16 S'' p17 sS'__dict__' p18 S'{}' p19 sS'message' p20 S"'No table selected'" p21 sS'__sizeof__' p22 S'' p23 sS'__init__' p24 S"" p25 sS'__setattr__' p26 S"" p27 sS'__reduce_ex__' p28 S'' p29 sS'__new__' p30 S'' p31 sS'__format__' p32 S'' p33 sS'__class__' p34 S"" p35 sS'__doc__' p36 S"'Unspecified run-time error.'" p37 sS'__getitem__' p38 S"" p39 sS'__setstate__' p40 S'' p41 sS'__getattribute__' p42 S"" p43 sS'args' p44 S"('No table selected',)" p45 sS'__subclasshook__' p46 S'' p47 sS'__unicode__' p48 S'' p49 sS'__delattr__' p50 S"" p51 sS'__repr__' p52 S"" p53 sS'__hash__' p54 S"" p55 ssS'evalue' p56 S'No table selected' p57 sS'request' p58 cgluon.html XML_unpickle p59 (S's\xd1c\x00\x00
ajax:
True
application:
HLD
args:
cid:
c803896560264
client:
127.0.0.1
controller:
appadmin
cookies:
session_id_admin:
127.0.0.1-2d0c1c6c-dcb3-4443-b1b3-fa032509dc6a
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_hld:
127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_welcome:
127.0.0.1-ac132756-0bb0-401d-a583-5ff90dff4a86
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
env:
CONTENT_TYPE:
application/x-www-form-urlencoded; charset=UTF-8
HTTP_ACCEPT:
*/*
HTTP_ACCEPT_ENCODING:
gzip, deflate
HTTP_ACCEPT_LANGUAGE:
en-US,en;q=0.5
HTTP_CONNECTION:
keep-alive
HTTP_CONTENT_TYPE:
application/x-www-form-urlencoded; charset=UTF-8
HTTP_COOKIE:
session_id_welcome=127.0.0.1-ac132756-0bb0-401d-a583-5ff90dff4a86; session_id_admin=127.0.0.1-2d0c1c6c-dcb3-4443-b1b3-fa032509dc6a; session_id_hld=127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
HTTP_HOST:
127.0.0.1:8000
HTTP_REFERER:
http://127.0.0.1:8000/admin/default/edit/HLD/controllers/default.py?id=controllers__default__py
HTTP_USER_AGENT:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0
HTTP_WEB2PY_COMPONENT_ELEMENT:
c803896560264
HTTP_WEB2PY_COMPONENT_LOCATION:
http://127.0.0.1:8000/admin/default/edit/HLD/controllers/default.py?id=controllers__default__py
HTTP_X_REQUESTED_WITH:
XMLHttpRequest
PATH_INFO:
/HLD/appadmin/hooks
QUERY_STRING:
REMOTE_ADDR:
127.0.0.1
REMOTE_PORT:
57232
REQUEST_METHOD:
GET
SCRIPT_NAME:
SERVER_NAME:
Omen
SERVER_PORT:
8000
SERVER_PROTOCOL:
HTTP/1.1
SERVER_SOFTWARE:
Rocket 1.2.6
app_folders:
set(['/home/jdalbey/Dropbox/web2py/applications/welcome', '/home/jdalbey/Dropbox/web2py/applications/admin', '/home/jdalbey/Dropbox/web2py/applications/HLD'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f193b7ed9b0: {'verbose': False, 'ip': '127.0.0.1', 'debuglevel': 30, 'with_scheduler': False, 'shutdown_timeout': 5, 'taskbar': False, 'with_coverage': False, 'pid_filename': 'httpserver.pid', 'maxthreads': None, 'softcron': False, 'server_name': 'Omen', 'bpython': False, 'nogui': False, 'port': 8000, 'print_errors': False, 'extcron': False, 'runcron': False, 'run_system_tests': False, 'test': None, 'folder': '/home/jdalbey/Dropbox/web2py', 'config': '', 'minthreads': None, 'shell': None, 'run': '', 'log_filename': 'httpserver.log', 'profiler_dir': None, 'args': [], 'socket_timeout': 5, 'ssl_ca_certificate': None, 'scheduler': None, 'interfaces': None, 'ssl_private_key': '', 'gae': None, 'password': '******', 'request_queue_size': 5, 'ssl_certificate': '', 'cronjob': False, 'numthreads': None, 'quiet': False, 'import_models': False, 'timeout': 10, 'plain': False, 'nobanner': False}>
content_type:
application/x-www-form-urlencoded; charset=UTF-8
db_sessions:
set([])
debugging:
True
gluon_parent:
/home/jdalbey/Dropbox/web2py
http_accept:
*/*
http_accept_encoding:
gzip, deflate
http_accept_language:
en-US,en;q=0.5
http_connection:
keep-alive
http_content_type:
application/x-www-form-urlencoded; charset=UTF-8
http_cookie:
session_id_welcome=127.0.0.1-ac132756-0bb0-401d-a583-5ff90dff4a86; session_id_admin=127.0.0.1-2d0c1c6c-dcb3-4443-b1b3-fa032509dc6a; session_id_hld=127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
http_host:
127.0.0.1:8000
http_referer:
http://127.0.0.1:8000/admin/default/edit/HLD/controllers/default.py?id=controllers__default__py
http_user_agent:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0
http_web2py_component_element:
c803896560264
http_web2py_component_location:
http://127.0.0.1:8000/admin/default/edit/HLD/controllers/default.py?id=controllers__default__py
http_x_requested_with:
XMLHttpRequest
is_jython:
False
is_py2:
True
is_pypy:
False
is_source:
True
local_hosts:
::1
127.0.1.1
::ffff:127.0.0.1
127.0.0.1
Omen
path_info:
/HLD/appadmin/hooks
query_string:
remote_addr:
127.0.0.1
remote_port:
57232
request_method:
GET
request_uri:
/HLD/appadmin/hooks
script_name:
server_name:
Omen
server_port:
8000
server_protocol:
HTTP/1.1
server_software:
Rocket 1.2.6
web2py_path:
/home/jdalbey/Dropbox/web2py
web2py_version:
2.18.5-stable+timestamp.2019.04.08.04.22.03
wsgi.errors:
<open file '<stderr>', mode 'w' at 0x7f1942869270>
wsgi.file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f193b823980>
wsgi.input:
<socket._fileobject object at 0x7f190988b1d0>
wsgi.multiprocess:
False
wsgi.multithread:
True
wsgi.run_once:
False
wsgi.url_scheme:
http
wsgi.version:
1
0
wsgi_errors:
<open file '<stderr>', mode 'w' at 0x7f1942869270>
wsgi_file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f193b823980>
wsgi_input:
<socket._fileobject object at 0x7f190988b1d0>
wsgi_multiprocess:
False
wsgi_multithread:
True
wsgi_run_once:
False
wsgi_url_scheme:
http
wsgi_version:
1
0
extension:
html
folder:
/home/jdalbey/Dropbox/web2py/applications/HLD
function:
hooks
global_settings:
app_folders:
set(['/home/jdalbey/Dropbox/web2py/applications/welcome', '/home/jdalbey/Dropbox/web2py/applications/admin', '/home/jdalbey/Dropbox/web2py/applications/HLD'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f193b7ed9b0: {'verbose': False, 'ip': '127.0.0.1', 'debuglevel': 30, 'with_scheduler': False, 'shutdown_timeout': 5, 'taskbar': False, 'with_coverage': False, 'pid_filename': 'httpserver.pid', 'maxthreads': None, 'softcron': False, 'server_name': 'Omen', 'bpython': False, 'nogui': False, 'port': 8000, 'print_errors': False, 'extcron': False, 'runcron': False, 'run_system_tests': False, 'test': None, 'folder': '/home/jdalbey/Dropbox/web2py', 'config': '', 'minthreads': None, 'shell': None, 'run': '', 'log_filename': 'httpserver.log', 'profiler_dir': None, 'args': [], 'socket_timeout': 5, 'ssl_ca_certificate': None, 'scheduler': None, 'interfaces': None, 'ssl_private_key': '', 'gae': None, 'password': '******', 'request_queue_size': 5, 'ssl_certificate': '', 'cronjob': False, 'numthreads': None, 'quiet': False, 'import_models': False, 'timeout': 10, 'plain': False, 'nobanner': False}>
db_sessions:
set([])
debugging:
True
gluon_parent:
/home/jdalbey/Dropbox/web2py
is_jython:
False
is_py2:
True
is_pypy:
False
is_source:
True
local_hosts:
::1
127.0.1.1
::ffff:127.0.0.1
127.0.0.1
Omen
web2py_version:
2.18.5-stable+timestamp.2019.04.08.04.22.03
is_https:
False
is_local:
True
is_restful:
False
is_scheduler:
False
is_shell:
False
method:
GET
now:
datetime.datetime(2020, 3, 15, 18, 30, 6, 715323)
raw_args:
raw_extension:
None
url:
/HLD/appadmin/hooks
utcnow:
datetime.datetime(2020, 3, 16, 1, 30, 6, 715356)
wsgi:
<gluon.main.LazyWSGI object at 0x7f190a2e6210>
' tRp60 sS'frames' p61 (lp62 (dp63 S'file' p64 S'/home/jdalbey/Dropbox/web2py/gluon/restricted.py' p65 sS'dump' p66 (dp67 S'environment' p68 S"{'A': , 'ANY_OF': , 'ASSIGNJS': , 'B': , 'BEAUTIFY': , 'BODY': , 'BR': , 'BUTTON': , 'CAT': , 'CENTER': , ...}" p69 sS'ccode' p70 S' at 0x7f1909945730, file "/...ox/web2py/applications/HLD/models/db.py", line 1>' p71 ssS'lnum' p72 I219 sS'lines' p73 (dp74 I214 S' if environment is None:' p75 sI215 S' environment = {}' p76 sI216 S" environment['__file__'] = layer" p77 sI217 S" environment['__name__'] = '__restricted__'" p78 sI218 S' try:' p79 sI219 S' exec(ccode, environment)' p80 sI220 S' except HTTP:' p81 sI221 S' raise' p82 sI222 S' except RestrictedError:' p83 sI223 S' # do not encapsulate (obfuscate) the original RestrictedError' p84 ssS'call' p85 S'(ccode= at 0x7f1909945730, file "/...ox/web2py/applications/HLD/models/db.py", line 1>, environment={\'A\': , \'ANY_OF\': , \'ASSIGNJS\': , \'B\': , \'BEAUTIFY\': , \'BODY\': , \'BR\': , \'BUTTON\': , \'CAT\': , \'CENTER\': , ...}, layer=\'/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py\', scode= at 0x7f1909945730, file "/...ox/web2py/applications/HLD/models/db.py", line 1>)' p86 sS'func' p87 S'restricted' p88 sa(dp89 g64 S'/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py' p90 sg66 (dp91 S'db.supervisors.ALL' p92 S'' p93 sS').delete' p94 S'undefined' p95 sS'db.supervisors' p96 S'' p97 sS'db' p98 S'' p99 ssg72 I57 sg73 (dp100 I49 S'db.closures.closuretype.requires = IS_NOT_EMPTY()' p101 sI50 S'db.closures.worktype.requires = IS_NOT_EMPTY()' p102 sI51 S'db.closures.supervisor.requires = IS_NOT_EMPTY()' p103 sI52 S'' sI53 S"db.define_table('supervisors'," p104 sI54 S" Field('name')," p105 sI55 S" Field('radiocallnum')\\" p106 sI56 S' )' p107 sI57 S'db(db.supervisors.ALL).delete()' p108 sI58 S"db.supervisors.import_from_csv_file(open('supervisors.csv', 'r'))" p109 ssg85 S'()' p110 sg87 S'' p111 sa(dp112 g64 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py' p113 sg66 (dp114 S'self.query' p115 S'' p116 sS'db._adapter' p117 S'' p118 sS'self' p119 S'' p120 sS'db' p121 S'' p122 sS'db._adapter.get_table' p123 S'>' p124 sS'table' p125 g95 ssg72 I2419 sg73 (dp126 I2414 S' fields = adapter.expand_all(fields, tablenames)' p127 sI2415 S' return adapter.nested_select(self.query, fields, attributes)' p128 sI2416 S'' sI2417 S' def delete(self):' p129 sI2418 S' db = self.db' p130 sI2419 S' table = db._adapter.get_table(self.query)' p131 sI2420 S' if any(f(self) for f in table._before_delete):' p132 sI2421 S' return 0' p133 sI2422 S' ret = db._adapter.delete(table, self.query)' p134 sI2423 S' ret and [f(self) for f in table._after_delete]' p135 ssg85 S'(self=)' p136 sg87 S'delete' p137 sa(dp138 g64 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py' p139 sg66 (dp140 S'builtinRuntimeError' p141 S"" p142 ssg72 I133 sg73 (dp143 I128 S' def get_table(self, *queries):' p144 sI129 S' tablemap = self.tables(*queries)' p145 sI130 S' if len(tablemap) == 1:' p146 sI131 S' return tablemap.popitem()[1]' p147 sI132 S' elif len(tablemap) < 1:' p148 sI133 S' raise RuntimeError("No table selected")' p149 sI134 S' else:' p150 sI135 S' raise RuntimeError(' p151 sI136 S' "Too many tables selected (%s)" % str(list(tablemap)))' p152 sI137 S'' ssg85 S'(self=, *queries=(,))' p153 sg87 S'get_table' p154 sasS'pyver' p155 S'Python 2.7.17: /usr/bin/python (prefix: /usr)' p156 sS'session' p157 g59 (S's\x1c\x05\x00\x00
closureid:
direction:
enddate:
flash:
None
last_orderby:
None
last_query:
with open('snoopy.csv', 'wb') as dumpfile: dumpfile.write(str(db(db.closures).select()))
lognum:
route:
5
startdate:
' tRp158 sS'etype' p159 S"" p160 sS'date' p161 S'Sun Mar 15 18:30:06 2020' p162 sS'response' p163 g59 (S's\xdd\x17\x00\x00
body:
<cStringIO.StringO object at 0x7f190a2207f0>
cookies:
session_id_hld:
127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
comment:
domain:
expires:
httponly:
max-age:
path:
/
samesite:
secure:
version:
delimiters:
{{
}}
files:
flash:
form_label_separator:
:
formstyle:
table3cols
generic_patterns:
*
headers:
X-Powered-By:
web2py
menu:
meta:
models_to_run:
^\\w+\\.py$
^appadmin/\\w+\\.py$
^appadmin/hooks/\\w+\\.py$
postprocessing:
session_client:
127.0.0.1
session_cookie_compression_level:
None
session_cookie_expires:
None
session_data_name:
session_data_hld
session_file:
<open file '/home/jdalbey/Dropbox/web2py/applications/HLD/sessions/1db/0eb/127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc', mode 'rb+' at 0x7f190a3434b0>
session_filename:
/home/jdalbey/Dropbox/web2py/applications/HLD/sessions/127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
session_hash:
34d1caf474f4034a340f0d20daafed18
session_id:
127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
session_id_name:
session_id_hld
session_locked:
True
session_masterapp:
HLD
session_new:
False
session_storage_type:
file
status:
200
view:
appadmin/hooks.html
' tRp164 sS'locals' p165 (dp166 S'self' p167 S'' p168 sS'tablemap' p169 g19 sS'queries' p170 S'(,)' p171 sssS'traceback' p172 S'Traceback (most recent call last):\n File "/home/jdalbey/Dropbox/web2py/gluon/restricted.py", line 219, in restricted\n exec(ccode, environment)\n File "/home/jdalbey/Dropbox/web2py/applications/HLD/models/db.py", line 57, in \n db(db.supervisors.ALL).delete()\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py", line 2419, in delete\n table = db._adapter.get_table(self.query)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 133, in get_table\n raise RuntimeError("No table selected")\nRuntimeError: No table selected\n' p173 s.