(dp1 S'output' p2 S" No table selected" p3 sS'layer' p4 S'/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py' p5 sS'code' p6 S' at 0x7f190a6a4ab0, file "/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.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\xf9^\x00\x00
ajax:
False
application:
HLD
args:
cid:
None
client:
127.0.0.1
controller:
default
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:
HTTP_ACCEPT:
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
HTTP_ACCEPT_ENCODING:
gzip, deflate
HTTP_ACCEPT_LANGUAGE:
en-US,en;q=0.5
HTTP_CACHE_CONTROL:
max-age=0
HTTP_CONNECTION:
keep-alive
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/HLD/default/index
HTTP_UPGRADE_INSECURE_REQUESTS:
1
HTTP_USER_AGENT:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0
PATH_INFO:
/HLD/default/submit
QUERY_STRING:
REMOTE_ADDR:
127.0.0.1
REMOTE_PORT:
57784
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}>
db_sessions:
set([])
debugging:
True
gluon_parent:
/home/jdalbey/Dropbox/web2py
http_accept:
text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8
http_accept_encoding:
gzip, deflate
http_accept_language:
en-US,en;q=0.5
http_cache_control:
max-age=0
http_connection:
keep-alive
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/HLD/default/index
http_upgrade_insecure_requests:
1
http_user_agent:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0
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/default/submit
query_string:
remote_addr:
127.0.0.1
remote_port:
57784
request_method:
GET
request_uri:
/HLD/default/submit
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 0x7f190a59f5d0>
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 0x7f190a59f5d0>
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:
submit
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, 33, 38, 704918)
raw_args:
raw_extension:
None
url:
/HLD/default/submit
utcnow:
datetime.datetime(2020, 3, 16, 1, 33, 38, 704936)
wsgi:
<gluon.main.LazyWSGI object at 0x7f190a783590>
' 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 0x7f190a6a4ab0, file "/...applications/HLD/controllers/default.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 0x7f190a6a4ab0, file "/...applications/HLD/controllers/default.py", line 1>, environment={\'A\': , \'ANY_OF\': , \'ASSIGNJS\': , \'B\': , \'BEAUTIFY\': , \'BODY\': , \'BR\': , \'BUTTON\': , \'CAT\': , \'CENTER\': , ...}, layer=\'/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py\', scode= at 0x7f190a6a4ab0, file "/...applications/HLD/controllers/default.py", line 1>)' p86 sS'func' p87 S'restricted' p88 sa(dp89 g64 S'/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py' p90 sg66 (dp91 sg72 I200 sg73 (dp92 I192 S' currID = item.closureid' p93 sI193 S' lastchar = currID[-1:] # Get last character of ID' p94 sI194 S' lastchar = chr(ord(lastchar) + 1) # increment it to next character (need bounds check)' p95 sI195 S' newID = currID[:-1] + lastchar # append char to ID' p96 sI196 S' return newID' p97 sI197 S' else:' p98 sI198 S" return 'T'+routeNum+'AA' # For a non-existing route" p99 sI189 S' # Retrieve any existing closures on this route' p100 sI190 S" item = db(db.closures.closureid.startswith('T'+routeNum)).select().last() # Might need to sort these" p101 sI191 S' if (item != None):' p102 ssg85 S'()' p103 sg87 S'' p104 sa(dp105 g64 S'/home/jdalbey/Dropbox/web2py/gluon/globals.py' p106 sg66 (dp107 S'self' p108 S'undefined' p109 sS'f' S'' p110 ssg72 I421 sg73 (dp111 I416 S" self.flash = '' # used by the default view layout" p112 sI417 S' self.meta = Storage() # used by web2py_ajax.html' p113 sI418 S' self.menu = [] # used by the default view layout' p114 sI419 S' self.files = [] # used by web2py_ajax.html' p115 sI420 S' self._vars = None' p116 sI421 S' self._caller = lambda f: f()' p117 sI422 S' self._view_environment = None' p118 sI423 S' self._custom_commit = None' p119 sI424 S' self._custom_rollback = None' p120 sI425 S" self.generic_patterns = ['*']" p121 ssg85 S'(f=)' p122 sg87 S'' p123 sa(dp124 g64 S'/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py' p125 sg66 (dp126 S'global db' p127 S'' p128 sS'db.supervisors.ALL' p129 S'' p130 sS'db.supervisors' p131 S'' p132 sS').delete' p133 g109 ssg72 I148 sg73 (dp134 I143 S" hwys = ['','1','5', '22', '55', '57', '73', '74', '91', '133', '142', '241', '261', '405', '605']" p135 sI144 S" hournames = ['','00', '01', '02', '03', '04', '05', '06', '07', '08', '09', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23']" p136 sI145 S" closuretypes = ['', 'Lane', 'Full', 'Moving', 'One-Way Traffic', 'Alternating Lanes', 'Traffic Break']" p137 sI146 S" worktypes = ['', 'Connector', 'Conventional_Hwy', 'Mainline', 'Off Ramp', 'On Ramp', 'Rest Area', 'Surface Street']" p138 sI147 S" facilities = ['','AC Paving', 'Accident Investigation', 'Attenuator Repair', 'Blasting', 'Bridge Inspection', 'Bridge Work', 'Brush Fire', 'Chip Seal Operation', 'Concrete Pour', 'Core Drilling', 'Crack Seal Operation', 'Curb/Gutter/Sidewalk Work', 'Drainage Cleaning', 'Drainage Inspection', 'Drainage Work', 'Electrical Work', 'Emergency Work', 'Falsework Installation', 'Falsework Removal', 'Fence Work', 'Filming Activity', 'Fog Seal Operation', 'Graffiti Removal', 'Grinding and Paving', 'Grinding Operation', 'Guardrail Repair', 'Guardrail Work', 'Highway Construction', 'K-rail Installation', 'K-rail Removal', 'Landscape Work', 'Litter Removal', 'Maintenance Operation', 'Median Barrier Work', 'Miscellaneous Work', 'Pavement Marker Replacement', 'Pavement Repair', 'Pavement Work', 'Paving Operation', 'Pile Driving', 'Police Investigation', 'Roadway Excavation', 'Roadway Flooding', 'Sewer Work', 'Shoulder Work', 'Sign Work', 'Slab Replacement', 'Slide Removal', 'Slope Clearing', 'Soundwall Work', 'Special Event', 'Spray Operation', 'Striping Operation', 'Survey Work', 'Sweeping Operation', 'Traffic Signal Work', 'Tree Work', 'Utility Work', 'Vegetation Spraying']" p139 sI148 S' db(db.supervisors.ALL).delete()' p140 sI149 S" db.supervisors.import_from_csv_file(open('supervisors.csv', 'r'))" p141 sI150 S" supervisors = [] # ['','Able','Baker','Charly']" p142 sI151 S' for row in db().select(db.supervisors.ALL):' p143 sI152 S' boss = row.name' p144 ssg85 S'()' p145 sg87 S'submit' p146 sa(dp147 g64 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py' p148 sg66 (dp149 S'self.query' p150 S'' p151 sS'db._adapter' p152 S'' p153 sS'self' p154 S'' p155 sS'db' p156 S'' p157 sS'db._adapter.get_table' p158 S'>' p159 sS'table' p160 g109 ssg72 I2419 sg73 (dp161 I2414 S' fields = adapter.expand_all(fields, tablenames)' p162 sI2415 S' return adapter.nested_select(self.query, fields, attributes)' p163 sI2416 S'' sI2417 S' def delete(self):' p164 sI2418 S' db = self.db' p165 sI2419 S' table = db._adapter.get_table(self.query)' p166 sI2420 S' if any(f(self) for f in table._before_delete):' p167 sI2421 S' return 0' p168 sI2422 S' ret = db._adapter.delete(table, self.query)' p169 sI2423 S' ret and [f(self) for f in table._after_delete]' p170 ssg85 S'(self=)' p171 sg87 S'delete' p172 sa(dp173 g64 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py' p174 sg66 (dp175 S'builtinRuntimeError' p176 S"" p177 ssg72 I133 sg73 (dp178 I128 S' def get_table(self, *queries):' p179 sI129 S' tablemap = self.tables(*queries)' p180 sI130 S' if len(tablemap) == 1:' p181 sI131 S' return tablemap.popitem()[1]' p182 sI132 S' elif len(tablemap) < 1:' p183 sI133 S' raise RuntimeError("No table selected")' p184 sI134 S' else:' p185 sI135 S' raise RuntimeError(' p186 sI136 S' "Too many tables selected (%s)" % str(list(tablemap)))' p187 sI137 S'' ssg85 S'(self=, *queries=(,))' p188 sg87 S'get_table' p189 sasS'pyver' p190 S'Python 2.7.17: /usr/bin/python (prefix: /usr)' p191 sS'session' p192 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:
' tRp193 sS'etype' p194 S"" p195 sS'date' p196 S'Sun Mar 15 18:33:38 2020' p197 sS'response' p198 g59 (S's\x14\x1d\x00\x00
body:
<cStringIO.StringO object at 0x7f190a30c130>
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:
Home
False
/HLD/default/index
List
False
/HLD/default/list
Search
False
/HLD/default/search
Request
False
/HLD/default/submit
meta:
author:
Author
description:
describe your app
keywords:
keyword
models_to_run:
^\\w+\\.py$
^default/\\w+\\.py$
^default/submit/\\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 0x7f190a2234b0>
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
subtitle:
subtitle customize me!
title:
HLD
view:
default/submit.html
' tRp199 sS'locals' p200 (dp201 S'self' p202 S'' p203 sS'tablemap' p204 g19 sS'queries' p205 S'(,)' p206 sssS'traceback' p207 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/controllers/default.py", line 200, in \n File "/home/jdalbey/Dropbox/web2py/gluon/globals.py", line 421, in \n self._caller = lambda f: f()\n File "/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py", line 148, in submit\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' p208 s.