(dp1 S'output' p2 S" duplicate column name: closurereason" p3 sS'layer' p4 S'/home/jdalbey/Dropbox/web2py/applications/Highways/models/db.py' p5 sS'code' p6 S' at 0x7f52d1ce2530, file "/home/jdalbey/Dropbox/web2py/applications/Highways/models/db.py", line 1>' p7 sS'snapshot' p8 (dp9 S'exception' p10 (dp11 S'__module__' p12 S"'sqlite3'" p13 sS'__getslice__' p14 S"" p15 sS'__str__' p16 S"" p17 sS'__reduce__' p18 S'' p19 sS'__dict__' p20 S'{}' p21 sS'__sizeof__' p22 S'' p23 sS'__weakref__' p24 S'None' p25 sS'message' p26 S"'duplicate column name: closurereason'" p27 sS'__init__' p28 S"" p29 sS'__setattr__' p30 S"" p31 sS'__reduce_ex__' p32 S'' p33 sS'__new__' p34 S'' p35 sS'__format__' p36 S'' p37 sS'__class__' p38 S"" p39 sS'__doc__' p40 S'None' p41 sS'__getitem__' p42 S"" p43 sS'__setstate__' p44 S'' p45 sS'__getattribute__' p46 S"" p47 sS'args' p48 S"('duplicate column name: closurereason',)" p49 sS'__subclasshook__' p50 S'' p51 sS'__unicode__' p52 S'' p53 sS'__delattr__' p54 S"" p55 sS'__repr__' p56 S"" p57 sS'__hash__' p58 S"" p59 ssS'evalue' p60 S'duplicate column name: closurereason' p61 sS'request' p62 cgluon.html XML_unpickle p63 (S's&d\x00\x00
ajax:
True
application:
Highways
args:
cid:
c688692688559
client:
127.0.0.1
controller:
appadmin
cookies:
session_id_admin:
127.0.0.1-8efe7917-31fa-4f87-a52c-efe37b591f81
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_highways:
127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf
comment:
domain:
expires:
httponly:
max-age:
path:
samesite:
secure:
version:
session_id_welcome:
127.0.0.1-25659124-e799-48ef-9e72-8d5b67717631
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-25659124-e799-48ef-9e72-8d5b67717631; session_id_admin=127.0.0.1-8efe7917-31fa-4f87-a52c-efe37b591f81; session_id_highways=127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf
HTTP_HOST:
127.0.0.1:8000
HTTP_REFERER:
http://127.0.0.1:8000/admin/default/edit/Highways/views/default/list.html?id=views__default__list__html
HTTP_USER_AGENT:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0
HTTP_WEB2PY_COMPONENT_ELEMENT:
c688692688559
HTTP_WEB2PY_COMPONENT_LOCATION:
http://127.0.0.1:8000/admin/default/edit/Highways/views/default/list.html?id=views__default__list__html
HTTP_X_REQUESTED_WITH:
XMLHttpRequest
PATH_INFO:
/Highways/appadmin/hooks
QUERY_STRING:
REMOTE_ADDR:
127.0.0.1
REMOTE_PORT:
54454
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/Highways', '/home/jdalbey/Dropbox/web2py/applications/welcome', '/home/jdalbey/Dropbox/web2py/applications/admin'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f530c1e89b0: {'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-25659124-e799-48ef-9e72-8d5b67717631; session_id_admin=127.0.0.1-8efe7917-31fa-4f87-a52c-efe37b591f81; session_id_highways=127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf
http_host:
127.0.0.1:8000
http_referer:
http://127.0.0.1:8000/admin/default/edit/Highways/views/default/list.html?id=views__default__list__html
http_user_agent:
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0
http_web2py_component_element:
c688692688559
http_web2py_component_location:
http://127.0.0.1:8000/admin/default/edit/Highways/views/default/list.html?id=views__default__list__html
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:
/Highways/appadmin/hooks
query_string:
remote_addr:
127.0.0.1
remote_port:
54454
request_method:
GET
request_uri:
/Highways/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 0x7f5313264270>
wsgi.file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f530c21e980>
wsgi.input:
<socket._fileobject object at 0x7f52d25f1950>
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 0x7f5313264270>
wsgi_file_wrapper:
<class wsgiref.util.FileWrapper at 0x7f530c21e980>
wsgi_input:
<socket._fileobject object at 0x7f52d25f1950>
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/Highways
function:
hooks
global_settings:
app_folders:
set(['/home/jdalbey/Dropbox/web2py/applications/Highways', '/home/jdalbey/Dropbox/web2py/applications/welcome', '/home/jdalbey/Dropbox/web2py/applications/admin'])
applications_parent:
/home/jdalbey/Dropbox/web2py
cmd_args:
cmd_options:
<Values at 0x7f530c1e89b0: {'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, 4, 18, 25, 0, 716983)
raw_args:
raw_extension:
None
url:
/Highways/appadmin/hooks
utcnow:
datetime.datetime(2020, 3, 5, 2, 25, 0, 717020)
wsgi:
<gluon.main.LazyWSGI object at 0x7f52d2f9b0d0>
' tRp64 sS'frames' p65 (lp66 (dp67 S'file' p68 S'/home/jdalbey/Dropbox/web2py/gluon/restricted.py' p69 sS'dump' p70 (dp71 S'environment' p72 S"{'A': , 'ANY_OF': , 'ASSIGNJS': , 'B': , 'BEAUTIFY': , 'BODY': , 'BR': , 'BUTTON': , 'CAT': , 'CENTER': , ...}" p73 sS'ccode' p74 S' at 0x7f52d1ce2530, file "/...b2py/applications/Highways/models/db.py", line 1>' p75 ssS'lnum' p76 I219 sS'lines' p77 (dp78 I214 S' if environment is None:' p79 sI215 S' environment = {}' p80 sI216 S" environment['__file__'] = layer" p81 sI217 S" environment['__name__'] = '__restricted__'" p82 sI218 S' try:' p83 sI219 S' exec(ccode, environment)' p84 sI220 S' except HTTP:' p85 sI221 S' raise' p86 sI222 S' except RestrictedError:' p87 sI223 S' # do not encapsulate (obfuscate) the original RestrictedError' p88 ssS'call' p89 S'(ccode= at 0x7f52d1ce2530, file "/...b2py/applications/Highways/models/db.py", line 1>, environment={\'A\': , \'ANY_OF\': , \'ASSIGNJS\': , \'B\': , \'BEAUTIFY\': , \'BODY\': , \'BR\': , \'BUTTON\': , \'CAT\': , \'CENTER\': , ...}, layer=\'/home/jdalbey/Dropbox/web2py/applications/Highways/models/db.py\', scode= at 0x7f52d1ce2530, file "/...b2py/applications/Highways/models/db.py", line 1>)' p90 sS'func' p91 S'restricted' p92 sa(dp93 g68 S'/home/jdalbey/Dropbox/web2py/applications/Highways/models/db.py' p94 sg70 (dp95 S'builtinformat' p96 S'' p97 ssg76 I25 sg77 (dp98 I19 S" Field('tmpdetails')," p99 sI20 S" Field('meetingplace')," p100 sI21 S" Field('closurereason')," p101 sI22 S" Field('supervisor')," p102 sI23 S" Field('fieldrep')," p103 sI24 S" Field('remarks')," p104 sI25 S" format = '%(route)s')" p105 sI26 S'' sI27 S'db.highways.lognum.requires = IS_NOT_IN_DB(db, db.highways.lognum)' p106 sI28 S'db.highways.lognum.requires = IS_NOT_EMPTY()' p107 ssg89 S'()' p108 sg91 S'' p109 sa(dp110 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/base.py' p111 sg70 (dp112 S'fields' p113 S'(, , , , , , , , , , , , , , , , , , , , ...)' p114 sS'self' p115 S'' p116 sS'tablename' p117 S"'highways'" p118 sS'kwargs' p119 S"{'format': '%(route)s'}" p120 sS'table' p121 S'undefined' p122 sS'self.lazy_define_table' p123 S'>' p124 ssg76 I592 sg77 (dp125 I587 S' if self._lazy_tables:' p126 sI588 S' if tablename not in self._LAZY_TABLES or redefine:' p127 sI589 S' self._LAZY_TABLES[tablename] = (tablename, fields, kwargs)' p128 sI590 S' table = None' p129 sI591 S' else:' p130 sI592 S' table = self.lazy_define_table(tablename, *fields, **kwargs)' p131 sI593 S' if tablename not in self.tables:' p132 sI594 S' self.tables.append(tablename)' p133 sI595 S' return table' p134 sI596 S'' ssg89 S'(self=, tablename=\'highways\', *fields=(, , , , , , , , , , , , , , , , , , , , ...), **kwargs={\'format\': \'%(route)s\'})' p135 sg91 S'define_table' p136 sa(dp137 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/base.py' p138 sg70 (dp139 S'polymodel' p140 S'None' p141 ssg76 I626 sg77 (dp142 I621 S' try:' p143 sI622 S' GLOBAL_LOCKER.acquire()' p144 sI623 S' self._adapter.create_table(' p145 sI624 S' table, migrate=migrate,' p146 sI625 S' fake_migrate=fake_migrate,' p147 sI626 S' polymodel=polymodel)' p148 sI627 S' finally:' p149 sI628 S' GLOBAL_LOCKER.release()' p150 sI629 S' else:' p151 sI630 S' table._dbt = None' p152 ssg89 S'(self=, tablename=\'highways\', *fields=(, , , , , , , , , , , , , , , , , , , , ...), **kwargs={\'format\': \'%(route)s\'})' p153 sg91 S'lazy_define_table' p154 sa(dp155 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py' p156 sg70 (dp157 S'self' p158 S'' p159 sS'args' p160 S'(,)' p161 sS'self.migrator' p162 S'' p163 sS'self.migrator.create_table' p164 S'>' p165 sS'kwargs' p166 S"{'fake_migrate': False, 'migrate': True, 'polymodel': None}" p167 ssg76 I798 sg77 (dp168 I800 S' def _drop_table_cleanup(self, table):' p169 sI801 S' super(SQLAdapter, self)._drop_table_cleanup(table)' p170 sI802 S' if table._dbt:' p171 sI793 S'' sI794 S' def bulk_insert(self, table, items):' p172 sI795 S' return [self.insert(table, item) for item in items]' p173 sI796 S'' sI797 S' def create_table(self, *args, **kwargs):' p174 sI798 S' return self.migrator.create_table(*args, **kwargs)' p175 sI799 S'' ssg89 S"(self=, *args=(
,), **kwargs={'fake_migrate': False, 'migrate': True, 'polymodel': None})" p176 sg91 S'create_table' p177 sa(dp178 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/migrator.py' p179 sg70 (dp180 S'fake_migrate' p181 S'False' p182 ssg76 I318 sg77 (dp183 I320 S' return query' p184 sI321 S'' sI322 S' def _fix(self, item):' p185 sI313 S' if sql_fields != sql_fields_old:' p186 sI314 S' self.migrate_table(' p187 sI315 S' table,' p188 sI316 S' sql_fields, sql_fields_old,' p189 sI317 S' sql_fields_aux, None,' p190 sI318 S' fake_migrate=fake_migrate' p191 sI319 S' )' p192 ssg89 S'(self=, table=
, migrate=True, fake_migrate=False, polymodel=None)' p193 sg91 g177 sa(dp194 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/migrator.py' p195 sg70 (dp196 S'self' p197 S'' p198 sS'self.adapter.execute' p199 S'>' p200 sS'self.adapter' p201 S'' p202 sS'sub_query' p203 S'\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\'' p204 ssg76 I451 sg77 (dp205 I448 S' self.save_dbt(table, sql_fields_current)' p206 sI449 S" self.log('faked!\\n', table)" p207 sI450 S' else:' p208 sI451 S' self.adapter.execute(sub_query)' p209 sI452 S' # Caveat: mysql, oracle and firebird' p210 sI453 S' # do not allow multiple alter table' p211 sI454 S' # in one transaction so we must commit' p212 sI455 S' # partial transactions and' p213 sI446 S' if fake_migrate:' p214 sI447 S' if db._adapter.commit_on_alter_table:' p215 ssg89 S'(self=, table=
, sql_fields={\'closureid\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'closureid\', \'rname\': \'"closureid"\', \'sortable\': 2, \'sql\': \'CHAR(512) UNIQUE\', \'type\': \'string\', \'unique\': True}, \'closurereason\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'closurereason\', \'rname\': \'"closurereason"\', \'sortable\': 19, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'closuretype\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'closuretype\', \'rname\': \'"closuretype"\', \'sortable\': 14, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'direction\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'direction\', \'rname\': \'"direction"\', \'sortable\': 5, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'endcounty\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'endcounty\', \'rname\': \'"endcounty"\', \'sortable\': 9, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'enddate\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'enddate\', \'rname\': \'"enddate"\', \'sortable\': 7, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'endlocation\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'endlocation\', \'rname\': \'"endlocation"\', \'sortable\': 13, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'endtime\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'endtime\', \'rname\': \'"endtime"\', \'sortable\': 11, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'estdelay\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'estdelay\', \'rname\': \'"estdelay"\', \'sortable\': 16, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'fieldrep\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'fieldrep\', \'rname\': \'"fieldrep"\', \'sortable\': 21, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, ...}, sql_fields_old={\'closuretype\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'closuretype\', \'rname\': \'"closuretype"\', \'sortable\': 14, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'county\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'county\', \'rname\': \'"county"\', \'sortable\': 7, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'direction\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'direction\', \'rname\': \'"direction"\', \'sortable\': 5, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'endcounty\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'endcounty\', \'rname\': \'"endcounty"\', \'sortable\': 8, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'enddate\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'enddate\', \'rname\': \'"enddate"\', \'sortable\': 6, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'endlocation\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'endlocation\', \'rname\': \'"endlocation"\', \'sortable\': 13, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'endtime\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'endtime\', \'rname\': \'"endtime"\', \'sortable\': 10, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'estdelay\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'estdelay\', \'rname\': \'"estdelay"\', \'sortable\': 13, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'fieldrep\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'fieldrep\', \'rname\': \'"fieldrep"\', \'sortable\': 21, \'sql\': \'CHAR(512)\', \'type\': \'string\', \'unique\': False}, \'id\': {\'length\': 512, \'notnull\': False, \'raw_rname\': \'id\', \'rname\': \'"id"\', \'sortable\': 1, \'sql\': \'INTEGER PRIMARY KEY AUTOINCREMENT\', \'type\': \'id\', \'unique\': False}, ...}, sql_fields_aux={\'closureid\': {\'sql\': \'CHAR(512) UNIQUE\'}, \'closurereason\': {\'sql\': \'CHAR(512)\'}, \'closuretype\': {\'sql\': \'CHAR(512)\'}, \'direction\': {\'sql\': \'CHAR(512)\'}, \'endcounty\': {\'sql\': \'CHAR(512)\'}, \'enddate\': {\'sql\': \'CHAR(512)\'}, \'endlocation\': {\'sql\': \'CHAR(512)\'}, \'endtime\': {\'sql\': \'CHAR(512)\'}, \'estdelay\': {\'sql\': \'CHAR(512)\'}, \'fieldrep\': {\'sql\': \'CHAR(512)\'}, ...}, logfile=None, fake_migrate=False)' p216 sg91 S'migrate_table' p217 sa(dp218 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/__init__.py' p219 sg70 (dp220 S'kwargs' p221 g21 sS'args' p222 S'(, \'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\')' p223 sS'f' S'' p224 ssg76 I67 sg77 (dp225 I64 S' if len(args) > 1:' p226 sI65 S' raise ValueError(args[1])' p227 sI66 S" raise RuntimeError('no connection available')" p228 sI67 S' return f(*args, **kwargs)' p229 sI68 S' return wrap' p230 sI69 S'' sI70 S'' sI71 S'from .base import SQLAdapter, NoSQLAdapter' p231 sI62 S' def wrap(*args, **kwargs):' p232 sI63 S' if not args[0].connection:' p233 ssg89 S'(*args=(, \'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\'), **kwargs={})' p234 sg91 S'wrap' p235 sa(dp236 g68 S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py' p237 sg70 (dp238 S'rv' p239 g122 sS'self' p240 S'' p241 sS'args' p242 S'(\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\',)' p243 sS'self.cursor' p244 S'' p245 sS'command' p246 S'\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\'' p247 sS'self.cursor.execute' p248 S'' p249 sS'kwargs' p250 g21 ssg76 I413 sg77 (dp251 I416 S' return rv' p252 sI417 S'' sI408 S' def execute(self, *args, **kwargs):' p253 sI409 S' command = self.filter_sql_command(args[0])' p254 sI410 S' handlers = self._build_handlers_for_execution()' p255 sI411 S' for handler in handlers:' p256 sI412 S' handler.before_execute(command)' p257 sI413 S' rv = self.cursor.execute(command, *args[1:], **kwargs)' p258 sI414 S' for handler in handlers:' p259 sI415 S' handler.after_execute(command)' p260 ssg89 S'(self=, *args=(\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\',), **kwargs={})' p261 sg91 S'execute' p262 sasS'pyver' p263 S'Python 2.7.17: /usr/bin/python (prefix: /usr)' p264 sS'session' p265 g63 (S's9\x01\x00\x00
last_orderby:
None
last_query:
db.highways.id>0
' tRp266 sS'etype' p267 S"" p268 sS'date' p269 S'Wed Mar 4 18:25:00 2020' p270 sS'response' p271 g63 (S's\xfb\x17\x00\x00
body:
<cStringIO.StringO object at 0x7f52d271f8b0>
cookies:
session_id_highways:
127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf
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_highways
session_file:
<open file '/home/jdalbey/Dropbox/web2py/applications/Highways/sessions/120/0a0/127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf', mode 'rb+' at 0x7f52d25c1660>
session_filename:
/home/jdalbey/Dropbox/web2py/applications/Highways/sessions/127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf
session_hash:
8df36882fd43219ed8632e741a6b611c
session_id:
127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf
session_id_name:
session_id_highways
session_locked:
True
session_masterapp:
Highways
session_new:
False
session_storage_type:
file
status:
200
view:
appadmin/hooks.html
' tRp272 sS'locals' p273 (dp274 S'handlers' p275 S'[]' p276 sS'self' p277 S'' p278 sg48 S'(\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\',)' p279 sS'handler' p280 S'' p281 sS'command' p282 S'\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\'' p283 sS'kwargs' p284 g21 sssS'traceback' p285 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/Highways/models/db.py", line 25, in \n format = \'%(route)s\')\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/base.py", line 592, in define_table\n table = self.lazy_define_table(tablename, *fields, **kwargs)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/base.py", line 626, in lazy_define_table\n polymodel=polymodel)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 798, in create_table\n return self.migrator.create_table(*args, **kwargs)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/migrator.py", line 318, in create_table\n fake_migrate=fake_migrate\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/migrator.py", line 451, in migrate_table\n self.adapter.execute(sub_query)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/__init__.py", line 67, in wrap\n return f(*args, **kwargs)\n File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 413, in execute\n rv = self.cursor.execute(command, *args[1:], **kwargs)\nOperationalError: duplicate column name: closurereason\n' p286 s.