(dp1 S'output' p2 S" list indices must be integers, not Row" p3 sS'layer' p4 S'/home/jdalbey/Dropbox/web2py/applications/HLD/controllers/default.py' p5 sS'code' p6 S' at 0x7f88a016a230, 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"'list indices must be integers, not Row'" 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"'Inappropriate argument type.'" p37 sS'__getitem__' p38 S"" p39 sS'__setstate__' p40 S'' p41 sS'__getattribute__' p42 S"" p43 sS'args' p44 S"('list indices must be integers, not Row',)" 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'list indices must be integers, not Row' p57 sS'request' p58 cgluon.html XML_unpickle p59 (S'sXe\x00\x00
ajax:
False
application:
HLD
args:
cid:
None
client:
127.0.0.1
controller:
default
cookies:
session_id_admin:
127.0.0.1-7aa46645-aba0-417e-a3c2-87a61d1a3ea1
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_helloworld:
127.0.0.1-e83eb8da-7fe5-4878-aefd-a36a2f3775da
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_hld:
127.0.0.1-f516d593-9b9f-43b2-ac74-1b546582ea4b
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_welcome:
127.0.0.1-5d7b2241-45f8-4457-a169-2652201968d1
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-5d7b2241-45f8-4457-a169-2652201968d1; session_id_admin=127.0.0.1-7aa46645-aba0-417e-a3c2-87a61d1a3ea1; session_id_hld=127.0.0.1-f516d593-9b9f-43b2-ac74-1b546582ea4b; session_id_helloworld=127.0.0.1-e83eb8da-7fe5-4878-aefd-a36a2f3775da
HTTP_HOST:
127.0.0.1:8000
HTTP_REFERER:
http://127.0.0.1:8000/HLD/default/search
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/results
QUERY_STRING:
REMOTE_ADDR:
127.0.0.1
REMOTE_PORT:
47896
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/helloworld', '/home/jdalbey/Dropbox/web2py/applications/HLD'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f88b35279b0: {'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-5d7b2241-45f8-4457-a169-2652201968d1; session_id_admin=127.0.0.1-7aa46645-aba0-417e-a3c2-87a61d1a3ea1; session_id_hld=127.0.0.1-f516d593-9b9f-43b2-ac74-1b546582ea4b; session_id_helloworld=127.0.0.1-e83eb8da-7fe5-4878-aefd-a36a2f3775da
http_host:
127.0.0.1:8000
http_referer:
http://127.0.0.1:8000/HLD/default/search
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/results
query_string:
remote_addr:
127.0.0.1
remote_port:
47896
request_method:
GET
request_uri:
/HLD/default/results
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 0x7f88ba5a3270>
wsgi.file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f88b355d980>
wsgi.input:
<socket._fileobject object at 0x7f8881b5e5d0>
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 0x7f88ba5a3270>
wsgi_file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f88b355d980>
wsgi_input:
<socket._fileobject object at 0x7f8881b5e5d0>
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:
results
global_settings:
app_folders:
set(['/home/jdalbey/Dropbox/web2py/applications/welcome', '/home/jdalbey/Dropbox/web2py/applications/admin', '/home/jdalbey/Dropbox/web2py/applications/helloworld', '/home/jdalbey/Dropbox/web2py/applications/HLD'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f88b35279b0: {'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, 10, 22, 18, 59, 316821)
raw_args:
raw_extension:
None
url:
/HLD/default/results
utcnow:
datetime.datetime(2020, 3, 11, 5, 18, 59, 316843)
wsgi:
<gluon.main.LazyWSGI object at 0x7f8880f479d0>
' 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 0x7f88a016a230, 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 0x7f88a016a230, 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 0x7f88a016a230, 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 I66 sg73 (dp92 I64 S' return dict(form=form)' p93 sI55 S' return dict(msg=msg)' p94 sI56 S'' sI57 S'# Create a new record' p95 sI58 S'def submit():' p96 sI59 S" # Don't name this function 'request' because it creates a name conflict with http.request" p97 sI60 S' form = SQLFORM(db.closures)' p98 sI61 S' if form.process().accepted:' p99 sI62 S" response.flash = 'your submission is accepted'" p100 sI63 S" redirect(URL('list'))" 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 TABLE' p126 S"" p127 sS'mytable' p128 g108 sS'].closureid' p129 S"'T5AA'" p130 sS'hwy' p131 S'' p132 sS'global TR' p133 S"" p134 sS'row' p135 S"" p136 ssg72 I32 sg73 (dp137 I32 S' mytable = TABLE([TR(hwy[row].closureid) for row in hwy])' p138 sI33 S'' sI34 S' form = FORM(TABLE(TR(INPUT(_type=\'checkbox\', _name=\'cb1\', _value="boxone"), \'a\', \'b\'), TR(INPUT(_type=\'checkbox\', _name=\'cb1\', _value="boxtwo"),\'c\', \'d\')), INPUT(_type=\'submit\'))' p139 sI35 S' if form.process().accepted:' p140 sI36 S" session.flash = 'form accepted'" p141 sI27 S' msg = "Closure ID = " + session.closureid' p142 sI28 S' else:' p143 sI29 S' hwy = db(db.closures.startdate >= session.startdate).select()' p144 sI30 S' msg = "Start Date >= " + session.startdate' p145 sI31 S' count = len(hwy)' p146 ssg85 S'()' p147 sg87 S'results' p148 sa(dp149 g64 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py' p150 sg66 (dp151 S'i' S"" p152 sS'self' p153 S'' p154 sS'self.records' p155 S"[]" p156 sS'row' p157 g108 ssg72 I2938 sg73 (dp158 I2933 S' fields=self.fields)' p159 sI2934 S'' sI2935 S' def __getitem__(self, i):' p160 sI2936 S' if isinstance(i, slice):' p161 sI2937 S' return self.__getslice__(i.start, i.stop)' p162 sI2938 S' row = self.records[i]' p163 sI2939 S' keys = list(row.keys())' p164 sI2940 S" if self.compact and len(keys) == 1 and keys[0] != '_extra':" p165 sI2941 S' return row[keys[0]]' p166 sI2942 S' return row' p167 ssg85 S"(self=, i=)" p168 sg87 g38 sasS'pyver' p169 S'Python 2.7.17: /usr/bin/python (prefix: /usr)' p170 sS'session' p171 g59 (S's\xae\x03\x00\x00
cb1:
boxtwo
closureid:
flash:
None
frm1:
cb1:
None
cb2:
None
startdate:
' tRp172 sS'etype' p173 S"" p174 sS'date' p175 S'Tue Mar 10 22:18:59 2020' p176 sS'response' p177 g59 (S's\x16\x1d\x00\x00
body:
<cStringIO.StringO object at 0x7f88a03085f0>
cookies:
session_id_hld:
127.0.0.1-f516d593-9b9f-43b2-ac74-1b546582ea4b
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/results/\\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/1dd/094/127.0.0.1-f516d593-9b9f-43b2-ac74-1b546582ea4b', mode 'rb+' at 0x7f88819b5660>
session_filename:
/home/jdalbey/Dropbox/web2py/applications/HLD/sessions/127.0.0.1-f516d593-9b9f-43b2-ac74-1b546582ea4b
session_hash:
efa8a0aff1721c74fa411d46adb3ff24
session_id:
127.0.0.1-f516d593-9b9f-43b2-ac74-1b546582ea4b
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/results.html
' tRp178 sS'locals' p179 (dp180 S'i' S"" p181 sS'self' p182 S'' p183 sssS'traceback' p184 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 66, 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 32, in results\n mytable = TABLE([TR(hwy[row].closureid) for row in hwy])\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py", line 2938, in __getitem__\n row = self.records[i]\nTypeError: list indices must be integers, not Row\n' p185 s.