(dp1 S'output' p2 S" 'Query' object has no attribute 'select'" p3 sS'layer' p4 S'/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py' p5 sS'code' p6 S' at 0x7f4308039c30, 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'"\'Query\' object has no attribute \'select\'"' 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"'Attribute not found.'" p37 sS'__getitem__' p38 S"" p39 sS'__setstate__' p40 S'' p41 sS'__getattribute__' p42 S"" p43 sS'args' p44 S'("\'Query\' object has no attribute \'select\'",)' 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"'Query' object has no attribute 'select'" p57 sS'request' p58 cgluon.html XML_unpickle p59 (S's\xafd\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-099c5bd3-07da-4e68-a425-9fe21ffa9707
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
env:
CONTENT_LENGTH:
2482
CONTENT_TYPE:
multipart/form-data; boundary=---------------------------1448200308298561491418210374
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_CONNECTION:
keep-alive
HTTP_CONTENT_LENGTH:
2482
HTTP_CONTENT_TYPE:
multipart/form-data; boundary=---------------------------1448200308298561491418210374
HTTP_COOKIE:
session_id_welcome=127.0.0.1-099c5bd3-07da-4e68-a425-9fe21ffa9707; 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_ORIGIN:
http://127.0.0.1:8000
HTTP_REFERER:
http://127.0.0.1:8000/HLD/default/submit
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:
55012
REQUEST_METHOD:
POST
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 0x7f43245419b0: {'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_length:
2482
content_type:
multipart/form-data; boundary=---------------------------1448200308298561491418210374
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_connection:
keep-alive
http_content_length:
2482
http_content_type:
multipart/form-data; boundary=---------------------------1448200308298561491418210374
http_cookie:
session_id_welcome=127.0.0.1-099c5bd3-07da-4e68-a425-9fe21ffa9707; 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_origin:
http://127.0.0.1:8000
http_referer:
http://127.0.0.1:8000/HLD/default/submit
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:
55012
request_method:
POST
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 0x7f432b5bd270>
wsgi.file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f4324577980>
wsgi.input:
<socket._fileobject object at 0x7f43086c2f50>
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 0x7f432b5bd270>
wsgi_file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f4324577980>
wsgi_input:
<socket._fileobject object at 0x7f43086c2f50>
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 0x7f43245419b0: {'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:
POST
now:
datetime.datetime(2020, 3, 15, 14, 47, 2, 173755)
raw_args:
raw_extension:
None
url:
/HLD/default/submit
utcnow:
datetime.datetime(2020, 3, 15, 21, 47, 2, 173767)
wsgi:
<gluon.main.LazyWSGI object at 0x7f42e824be10>
' 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 0x7f4308039c30, 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 0x7f4308039c30, 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 0x7f4308039c30, 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 I163 sg73 (dp92 I160 S" newID = currID + 'Z'" p93 sI161 S' return newID' p94 sI152 S' newrec = db.closures.insert(closureid=calcNextClosure(form.vars.route),route=form.vars.route,direction=form.vars.direction,facility=form.vars.facility)' p95 sI153 S" session.flash = 'New lane closure added message appears here. IDnum='+str(newrec)" p96 sI154 S" redirect(URL('index.html'))" p97 sI155 S' return dict(form=form)' p98 sI156 S'' sI157 S'def calcNextClosure(routeNum):' p99 sI158 S" item = db.closures.closureid.startswith('T'+routeNum).select().last()" p100 sI159 S' currID = item.closureid' p101 ssg85 S'()' p102 sg87 S'' p103 sa(dp104 g64 S'/home/jdalbey/Dropbox/web2py/gluon/globals.py' p105 sg66 (dp106 S'self' p107 S'undefined' p108 sS'f' S'' p109 ssg72 I421 sg73 (dp110 I416 S" self.flash = '' # used by the default view layout" p111 sI417 S' self.meta = Storage() # used by web2py_ajax.html' p112 sI418 S' self.menu = [] # used by the default view layout' p113 sI419 S' self.files = [] # used by web2py_ajax.html' p114 sI420 S' self._vars = None' p115 sI421 S' self._caller = lambda f: f()' p116 sI422 S' self._view_environment = None' p117 sI423 S' self._custom_commit = None' p118 sI424 S' self._custom_rollback = None' p119 sI425 S" self.generic_patterns = ['*']" p120 ssg85 S'(f=)' p121 sg87 S'' p122 sa(dp123 g64 S'/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py' p124 sg66 (dp125 S'global calcNextClosure' p126 S'' p127 sS'direction' p128 g108 sS'form.vars' p129 S"" p130 sS'form' p131 S'' p132 sS'facility' p133 g108 sS'form.vars.direction' p134 S"'E'" p135 sS'route' p136 g108 sS'form.vars.facility' p137 S"'Blasting'" p138 sS'form.vars.route' p139 S"'5'" p140 sS'db.closures' p141 S'' p142 sS'db.closures.insert' p143 S'>' p144 sS'newrec' p145 g108 sS'global db' p146 S'' p147 sS'closureid' p148 g108 ssg72 I152 sg73 (dp149 I147 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']" p150 sI148 S" supervisors = ['','Able','Baker','Charly']" p151 sI149 S' streets = []' p152 sI150 S" form = FORM(LABEL('*Route',_for='route'), SELECT(hwys,_name='route', requires=IS_LENGTH(minsize=1,error_message='route cannot be empty')), XML('   '), LABEL('*Direction',_for='direction'), SELECT('','N', 'S', 'N/S','E','W','E/W',_name='direction', requires=IS_LENGTH(minsize=1,error_message='direction cannot be empty')), XML('   '), LABEL('*Facility',_for='facility'), SELECT(facilities,_name='facility', requires=IS_LENGTH(minsize=1,error_message='facility cannot be empty')), BR(),BR(), TABLE(TR(TD(),TD('*County'),TD('*Location')),TR(TD('BEGIN='),TD(SELECT('ORA',_name='startcounty')),TD(SELECT('','MAGDALENA'),_name='startlocation')),TR(TD('END='),TD(SELECT('ORA',_name='endcounty')),TD(SELECT('','MAGDALENA'),_name='endlocation'))),BR(),'Date Range:',BR(),LABEL('From',_for='startdate'),INPUT(_name='startdate'), XML('   '), LABEL('to:',_for='enddate'), INPUT(_name='enddate'),'(MMDDYYYY)',XML('      '), LABEL('Times',_for='starttime'),SELECT(hournames,_name='starttime'), LABEL(':',_for='starttimemin'),SELECT('','00','15','30','45','59',_name='starttimemin'), XML('  '), LABEL('to:',_for='endtime'),SELECT(hournames,_name='endtime'), LABEL(':',_for='endtimemin'),SELECT('','00','15','30','45','59',_name='endtimemin'), BR(),BR(), TABLE(TR(TD('Type of Closure'),TD('Type of Work'),TD('Estimated Delay'),TD('TMP Details')), TR(TD(SELECT(closuretypes,_name='closuretype')), TD(SELECT(worktypes,_name='worktype')), TD(INPUT(_name='estdelay'),'minutes'), TD(INPUT(_type='checkbox',_name='cozeep'),'CoZeep MaZeep/CHP',BR(), INPUT(_type='checkbox', _name='detour'),'Detour Available')), _width='100%' ), TABLE(TR(TD('Supervisor'),TD('Field Rep')), TR(TD(SELECT(supervisors,_name='supervisor')), TD(SELECT(supervisors,_name='fieldrep')))), BR(), TABLE(TR(TD('Meeting Place/CHP Contact'),TD('Reason for Closure'),TD('Additional Remarks / Detour ')), TR(TD(INPUT(_name='meeting')),TD(INPUT(_name='reason')),TD(INPUT(_name='remarks',_size='40'))) ), BR(), INPUT(_type='submit',_value='Submit Closure'))" p153 sI151 S' if form.process().accepted:' p154 sI152 S' newrec = db.closures.insert(closureid=calcNextClosure(form.vars.route),route=form.vars.route,direction=form.vars.direction,facility=form.vars.facility)' p155 sI153 S" session.flash = 'New lane closure added message appears here. IDnum='+str(newrec)" p156 sI154 S" redirect(URL('index.html'))" p157 sI155 S' return dict(form=form)' p158 sI156 S'' ssg85 S'()' p159 sg87 S'submit' p160 sa(dp161 g64 S'/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py' p162 sg66 (dp163 S'db.closures.closureid' p164 S'' p165 sS'routeNum' p166 S"'5'" p167 sS').select' p168 g108 sS'item' p169 g108 sS'global db' p170 S'' p171 sS'db.closures.closureid.startswith' p172 S'>' p173 sS'db.closures' p174 S'
' p175 ssg72 I158 sg73 (dp176 I160 S" newID = currID + 'Z'" p177 sI161 S' return newID' p178 sI152 S' newrec = db.closures.insert(closureid=calcNextClosure(form.vars.route),route=form.vars.route,direction=form.vars.direction,facility=form.vars.facility)' p179 sI153 S" session.flash = 'New lane closure added message appears here. IDnum='+str(newrec)" p180 sI154 S" redirect(URL('index.html'))" p181 sI155 S' return dict(form=form)' p182 sI156 S'' sI157 S'def calcNextClosure(routeNum):' p183 sI158 S" item = db.closures.closureid.startswith('T'+routeNum).select().last()" p184 sI159 S' currID = item.closureid' p185 ssg85 S"(routeNum='5')" p186 sg87 S'calcNextClosure' p187 sasS'pyver' p188 S'Python 2.7.17: /usr/bin/python (prefix: /usr)' p189 sS'session' p190 g59 (S's\xd8\x01\x00\x00
flash:
None
last_orderby:
None
last_query:
db.closures.closureid.startswith('T5')
' tRp191 sS'etype' p192 S"" p193 sS'date' p194 S'Sun Mar 15 14:47:02 2020' p195 sS'response' p196 g59 (S's\x1c\x1d\x00\x00
body:
<cStringIO.StringO object at 0x7f42e8131e30>
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:
Success!
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 0x7f42e81f2c00>
session_filename:
/home/jdalbey/Dropbox/web2py/applications/HLD/sessions/127.0.0.1-29e35efb-101b-45ed-9698-5613242067bc
session_hash:
f13a4db400900ba4eaa582223d358544
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
' tRp197 sS'locals' p198 (dp199 S'routeNum' p200 S"'5'" p201 sssS'traceback' p202 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 163, 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 152, in submit\n newrec = db.closures.insert(closureid=calcNextClosure(form.vars.route),route=form.vars.route,direction=form.vars.direction,facility=form.vars.facility)\n File "/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py", line 158, in calcNextClosure\n item = db.closures.closureid.startswith(\'T\'+routeNum).select().last()\nAttributeError: \'Query\' object has no attribute \'select\'\n' p203 s.