source: tmcsimulator/branches/LCSv1/errors/127.0.0.1.2020-03-04.18-25-00.d4fe5114-ff2f-4e72-bbbd-9fa997c763f7 @ 593

Revision 593, 51.3 KB checked in by jdalbey, 6 years ago (diff)

Add branch LCSv1
Line 
1(dp1
2S'output'
3p2
4S"<class 'sqlite3.OperationalError'> duplicate column name: closurereason"
5p3
6sS'layer'
7p4
8S'/home/jdalbey/Dropbox/web2py/applications/Highways/models/db.py'
9p5
10sS'code'
11p6
12S'<code object <module> at 0x7f52d1ce2530, file "/home/jdalbey/Dropbox/web2py/applications/Highways/models/db.py", line 1>'
13p7
14sS'snapshot'
15p8
16(dp9
17S'exception'
18p10
19(dp11
20S'__module__'
21p12
22S"'sqlite3'"
23p13
24sS'__getslice__'
25p14
26S"<method-wrapper '__getslice__' of OperationalError object>"
27p15
28sS'__str__'
29p16
30S"<method-wrapper '__str__' of OperationalError object>"
31p17
32sS'__reduce__'
33p18
34S'<built-in method __reduce__ of OperationalError object>'
35p19
36sS'__dict__'
37p20
38S'{}'
39p21
40sS'__sizeof__'
41p22
42S'<built-in method __sizeof__ of OperationalError object>'
43p23
44sS'__weakref__'
45p24
46S'None'
47p25
48sS'message'
49p26
50S"'duplicate column name: closurereason'"
51p27
52sS'__init__'
53p28
54S"<method-wrapper '__init__' of OperationalError object>"
55p29
56sS'__setattr__'
57p30
58S"<method-wrapper '__setattr__' of OperationalError object>"
59p31
60sS'__reduce_ex__'
61p32
62S'<built-in method __reduce_ex__ of OperationalError object>'
63p33
64sS'__new__'
65p34
66S'<built-in method __new__ of type object>'
67p35
68sS'__format__'
69p36
70S'<built-in method __format__ of OperationalError object>'
71p37
72sS'__class__'
73p38
74S"<class 'sqlite3.OperationalError'>"
75p39
76sS'__doc__'
77p40
78S'None'
79p41
80sS'__getitem__'
81p42
82S"<method-wrapper '__getitem__' of OperationalError object>"
83p43
84sS'__setstate__'
85p44
86S'<built-in method __setstate__ of OperationalError object>'
87p45
88sS'__getattribute__'
89p46
90S"<method-wrapper '__getattribute__' of OperationalError object>"
91p47
92sS'args'
93p48
94S"('duplicate column name: closurereason',)"
95p49
96sS'__subclasshook__'
97p50
98S'<built-in method __subclasshook__ of type object>'
99p51
100sS'__unicode__'
101p52
102S'<built-in method __unicode__ of OperationalError object>'
103p53
104sS'__delattr__'
105p54
106S"<method-wrapper '__delattr__' of OperationalError object>"
107p55
108sS'__repr__'
109p56
110S"<method-wrapper '__repr__' of OperationalError object>"
111p57
112sS'__hash__'
113p58
114S"<method-wrapper '__hash__' of OperationalError object>"
115p59
116ssS'evalue'
117p60
118S'duplicate column name: closurereason'
119p61
120sS'request'
121p62
122cgluon.html
123XML_unpickle
124p63
125(S's&d\x00\x00<div><table><tr><td style="font-weight:bold;vertical-align:top;">ajax</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">application</td><td style="vertical-align:top;">:</td><td><div>Highways</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">args</td><td style="vertical-align:top;">:</td><td><div><table></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">cid</td><td style="vertical-align:top;">:</td><td><div>c688692688559</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">client</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">controller</td><td style="vertical-align:top;">:</td><td><div>appadmin</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">cookies</td><td style="vertical-align:top;">:</td><td><div><table><tr><td style="font-weight:bold;vertical-align:top;">session_id_admin</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1-8efe7917-31fa-4f87-a52c-efe37b591f81<table><tr><td style="font-weight:bold;vertical-align:top;">comment</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">domain</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">expires</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">httponly</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">max-age</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">path</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">samesite</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">secure</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">version</td><td style="vertical-align:top;">:</td><td><div></div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_id_highways</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf<table><tr><td style="font-weight:bold;vertical-align:top;">comment</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">domain</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">expires</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">httponly</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">max-age</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">path</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">samesite</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">secure</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">version</td><td style="vertical-align:top;">:</td><td><div></div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_id_welcome</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1-25659124-e799-48ef-9e72-8d5b67717631<table><tr><td style="font-weight:bold;vertical-align:top;">comment</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">domain</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">expires</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">httponly</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">max-age</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">path</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">samesite</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">secure</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">version</td><td style="vertical-align:top;">:</td><td><div></div></td></tr></table></div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">env</td><td style="vertical-align:top;">:</td><td><div><table><tr><td style="font-weight:bold;vertical-align:top;">CONTENT_TYPE</td><td style="vertical-align:top;">:</td><td><div>application/x-www-form-urlencoded; charset=UTF-8</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_ACCEPT</td><td style="vertical-align:top;">:</td><td><div>*/*</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_ACCEPT_ENCODING</td><td style="vertical-align:top;">:</td><td><div>gzip, deflate</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_ACCEPT_LANGUAGE</td><td style="vertical-align:top;">:</td><td><div>en-US,en;q=0.5</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_CONNECTION</td><td style="vertical-align:top;">:</td><td><div>keep-alive</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_CONTENT_TYPE</td><td style="vertical-align:top;">:</td><td><div>application/x-www-form-urlencoded; charset=UTF-8</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_COOKIE</td><td style="vertical-align:top;">:</td><td><div>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</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_HOST</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1:8000</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_REFERER</td><td style="vertical-align:top;">:</td><td><div>http://127.0.0.1:8000/admin/default/edit/Highways/views/default/list.html?id=views__default__list__html</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_USER_AGENT</td><td style="vertical-align:top;">:</td><td><div>Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_WEB2PY_COMPONENT_ELEMENT</td><td style="vertical-align:top;">:</td><td><div>c688692688559</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_WEB2PY_COMPONENT_LOCATION</td><td style="vertical-align:top;">:</td><td><div>http://127.0.0.1:8000/admin/default/edit/Highways/views/default/list.html?id=views__default__list__html</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_X_REQUESTED_WITH</td><td style="vertical-align:top;">:</td><td><div>XMLHttpRequest</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">PATH_INFO</td><td style="vertical-align:top;">:</td><td><div>/Highways/appadmin/hooks</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">QUERY_STRING</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">REMOTE_ADDR</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">REMOTE_PORT</td><td style="vertical-align:top;">:</td><td><div>54454</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">REQUEST_METHOD</td><td style="vertical-align:top;">:</td><td><div>GET</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">SCRIPT_NAME</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">SERVER_NAME</td><td style="vertical-align:top;">:</td><td><div>Omen</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">SERVER_PORT</td><td style="vertical-align:top;">:</td><td><div>8000</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">SERVER_PROTOCOL</td><td style="vertical-align:top;">:</td><td><div>HTTP/1.1</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">SERVER_SOFTWARE</td><td style="vertical-align:top;">:</td><td><div>Rocket 1.2.6</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">app_folders</td><td style="vertical-align:top;">:</td><td><div>set([&#x27;/home/jdalbey/Dropbox/web2py/applications/Highways&#x27;, &#x27;/home/jdalbey/Dropbox/web2py/applications/welcome&#x27;, &#x27;/home/jdalbey/Dropbox/web2py/applications/admin&#x27;])</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">applications_parent</td><td style="vertical-align:top;">:</td><td><div>/home/jdalbey/Dropbox/web2py</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">cmd_args</td><td style="vertical-align:top;">:</td><td><div><table></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">cmd_options</td><td style="vertical-align:top;">:</td><td><div>&lt;Values at 0x7f530c1e89b0: {&#x27;verbose&#x27;: False, &#x27;ip&#x27;: &#x27;127.0.0.1&#x27;, &#x27;debuglevel&#x27;: 30, &#x27;with_scheduler&#x27;: False, &#x27;shutdown_timeout&#x27;: 5, &#x27;taskbar&#x27;: False, &#x27;with_coverage&#x27;: False, &#x27;pid_filename&#x27;: &#x27;httpserver.pid&#x27;, &#x27;maxthreads&#x27;: None, &#x27;softcron&#x27;: False, &#x27;server_name&#x27;: &#x27;Omen&#x27;, &#x27;bpython&#x27;: False, &#x27;nogui&#x27;: False, &#x27;port&#x27;: 8000, &#x27;print_errors&#x27;: False, &#x27;extcron&#x27;: False, &#x27;runcron&#x27;: False, &#x27;run_system_tests&#x27;: False, &#x27;test&#x27;: None, &#x27;folder&#x27;: &#x27;/home/jdalbey/Dropbox/web2py&#x27;, &#x27;config&#x27;: &#x27;&#x27;, &#x27;minthreads&#x27;: None, &#x27;shell&#x27;: None, &#x27;run&#x27;: &#x27;&#x27;, &#x27;log_filename&#x27;: &#x27;httpserver.log&#x27;, &#x27;profiler_dir&#x27;: None, &#x27;args&#x27;: [], &#x27;socket_timeout&#x27;: 5, &#x27;ssl_ca_certificate&#x27;: None, &#x27;scheduler&#x27;: None, &#x27;interfaces&#x27;: None, &#x27;ssl_private_key&#x27;: &#x27;&#x27;, &#x27;gae&#x27;: None, &#x27;password&#x27;: &#x27;******&#x27;, &#x27;request_queue_size&#x27;: 5, &#x27;ssl_certificate&#x27;: &#x27;&#x27;, &#x27;cronjob&#x27;: False, &#x27;numthreads&#x27;: None, &#x27;quiet&#x27;: False, &#x27;import_models&#x27;: False, &#x27;timeout&#x27;: 10, &#x27;plain&#x27;: False, &#x27;nobanner&#x27;: False}&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">content_type</td><td style="vertical-align:top;">:</td><td><div>application/x-www-form-urlencoded; charset=UTF-8</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">db_sessions</td><td style="vertical-align:top;">:</td><td><div>set([])</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">debugging</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">gluon_parent</td><td style="vertical-align:top;">:</td><td><div>/home/jdalbey/Dropbox/web2py</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_accept</td><td style="vertical-align:top;">:</td><td><div>*/*</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_accept_encoding</td><td style="vertical-align:top;">:</td><td><div>gzip, deflate</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_accept_language</td><td style="vertical-align:top;">:</td><td><div>en-US,en;q=0.5</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_connection</td><td style="vertical-align:top;">:</td><td><div>keep-alive</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_content_type</td><td style="vertical-align:top;">:</td><td><div>application/x-www-form-urlencoded; charset=UTF-8</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_cookie</td><td style="vertical-align:top;">:</td><td><div>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</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_host</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1:8000</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_referer</td><td style="vertical-align:top;">:</td><td><div>http://127.0.0.1:8000/admin/default/edit/Highways/views/default/list.html?id=views__default__list__html</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_user_agent</td><td style="vertical-align:top;">:</td><td><div>Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:73.0) Gecko/20100101 Firefox/73.0</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_web2py_component_element</td><td style="vertical-align:top;">:</td><td><div>c688692688559</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_web2py_component_location</td><td style="vertical-align:top;">:</td><td><div>http://127.0.0.1:8000/admin/default/edit/Highways/views/default/list.html?id=views__default__list__html</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_x_requested_with</td><td style="vertical-align:top;">:</td><td><div>XMLHttpRequest</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_jython</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_py2</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_pypy</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_source</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">local_hosts</td><td style="vertical-align:top;">:</td><td><div><table><tr><td><div>::1</div></td></tr><tr><td><div>127.0.1.1</div></td></tr><tr><td><div>::ffff:127.0.0.1</div></td></tr><tr><td><div>127.0.0.1</div></td></tr><tr><td><div>Omen</div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">path_info</td><td style="vertical-align:top;">:</td><td><div>/Highways/appadmin/hooks</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">query_string</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">remote_addr</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">remote_port</td><td style="vertical-align:top;">:</td><td><div>54454</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">request_method</td><td style="vertical-align:top;">:</td><td><div>GET</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">request_uri</td><td style="vertical-align:top;">:</td><td><div>/Highways/appadmin/hooks</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">script_name</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">server_name</td><td style="vertical-align:top;">:</td><td><div>Omen</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">server_port</td><td style="vertical-align:top;">:</td><td><div>8000</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">server_protocol</td><td style="vertical-align:top;">:</td><td><div>HTTP/1.1</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">server_software</td><td style="vertical-align:top;">:</td><td><div>Rocket 1.2.6</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">web2py_path</td><td style="vertical-align:top;">:</td><td><div>/home/jdalbey/Dropbox/web2py</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">web2py_version</td><td style="vertical-align:top;">:</td><td><div>2.18.5-stable+timestamp.2019.04.08.04.22.03</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi.errors</td><td style="vertical-align:top;">:</td><td><div>&lt;open file &#x27;&lt;stderr&gt;&#x27;, mode &#x27;w&#x27; at 0x7f5313264270&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi.file_wrapper</td><td style="vertical-align:top;">:</td><td><div>&lt;class wsgiref.util.FileWrapper at 0x7f530c21e980&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi.input</td><td style="vertical-align:top;">:</td><td><div>&lt;socket._fileobject object at 0x7f52d25f1950&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi.multiprocess</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi.multithread</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi.run_once</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi.url_scheme</td><td style="vertical-align:top;">:</td><td><div>http</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi.version</td><td style="vertical-align:top;">:</td><td><div><table><tr><td><div>1</div></td></tr><tr><td><div>0</div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi_errors</td><td style="vertical-align:top;">:</td><td><div>&lt;open file &#x27;&lt;stderr&gt;&#x27;, mode &#x27;w&#x27; at 0x7f5313264270&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi_file_wrapper</td><td style="vertical-align:top;">:</td><td><div>&lt;class wsgiref.util.FileWrapper at 0x7f530c21e980&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi_input</td><td style="vertical-align:top;">:</td><td><div>&lt;socket._fileobject object at 0x7f52d25f1950&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi_multiprocess</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi_multithread</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi_run_once</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi_url_scheme</td><td style="vertical-align:top;">:</td><td><div>http</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi_version</td><td style="vertical-align:top;">:</td><td><div><table><tr><td><div>1</div></td></tr><tr><td><div>0</div></td></tr></table></div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">extension</td><td style="vertical-align:top;">:</td><td><div>html</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">folder</td><td style="vertical-align:top;">:</td><td><div>/home/jdalbey/Dropbox/web2py/applications/Highways</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">function</td><td style="vertical-align:top;">:</td><td><div>hooks</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">global_settings</td><td style="vertical-align:top;">:</td><td><div><table><tr><td style="font-weight:bold;vertical-align:top;">app_folders</td><td style="vertical-align:top;">:</td><td><div>set([&#x27;/home/jdalbey/Dropbox/web2py/applications/Highways&#x27;, &#x27;/home/jdalbey/Dropbox/web2py/applications/welcome&#x27;, &#x27;/home/jdalbey/Dropbox/web2py/applications/admin&#x27;])</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">applications_parent</td><td style="vertical-align:top;">:</td><td><div>/home/jdalbey/Dropbox/web2py</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">cmd_args</td><td style="vertical-align:top;">:</td><td><div><table></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">cmd_options</td><td style="vertical-align:top;">:</td><td><div>&lt;Values at 0x7f530c1e89b0: {&#x27;verbose&#x27;: False, &#x27;ip&#x27;: &#x27;127.0.0.1&#x27;, &#x27;debuglevel&#x27;: 30, &#x27;with_scheduler&#x27;: False, &#x27;shutdown_timeout&#x27;: 5, &#x27;taskbar&#x27;: False, &#x27;with_coverage&#x27;: False, &#x27;pid_filename&#x27;: &#x27;httpserver.pid&#x27;, &#x27;maxthreads&#x27;: None, &#x27;softcron&#x27;: False, &#x27;server_name&#x27;: &#x27;Omen&#x27;, &#x27;bpython&#x27;: False, &#x27;nogui&#x27;: False, &#x27;port&#x27;: 8000, &#x27;print_errors&#x27;: False, &#x27;extcron&#x27;: False, &#x27;runcron&#x27;: False, &#x27;run_system_tests&#x27;: False, &#x27;test&#x27;: None, &#x27;folder&#x27;: &#x27;/home/jdalbey/Dropbox/web2py&#x27;, &#x27;config&#x27;: &#x27;&#x27;, &#x27;minthreads&#x27;: None, &#x27;shell&#x27;: None, &#x27;run&#x27;: &#x27;&#x27;, &#x27;log_filename&#x27;: &#x27;httpserver.log&#x27;, &#x27;profiler_dir&#x27;: None, &#x27;args&#x27;: [], &#x27;socket_timeout&#x27;: 5, &#x27;ssl_ca_certificate&#x27;: None, &#x27;scheduler&#x27;: None, &#x27;interfaces&#x27;: None, &#x27;ssl_private_key&#x27;: &#x27;&#x27;, &#x27;gae&#x27;: None, &#x27;password&#x27;: &#x27;******&#x27;, &#x27;request_queue_size&#x27;: 5, &#x27;ssl_certificate&#x27;: &#x27;&#x27;, &#x27;cronjob&#x27;: False, &#x27;numthreads&#x27;: None, &#x27;quiet&#x27;: False, &#x27;import_models&#x27;: False, &#x27;timeout&#x27;: 10, &#x27;plain&#x27;: False, &#x27;nobanner&#x27;: False}&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">db_sessions</td><td style="vertical-align:top;">:</td><td><div>set([])</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">debugging</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">gluon_parent</td><td style="vertical-align:top;">:</td><td><div>/home/jdalbey/Dropbox/web2py</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_jython</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_py2</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_pypy</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_source</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">local_hosts</td><td style="vertical-align:top;">:</td><td><div><table><tr><td><div>::1</div></td></tr><tr><td><div>127.0.1.1</div></td></tr><tr><td><div>::ffff:127.0.0.1</div></td></tr><tr><td><div>127.0.0.1</div></td></tr><tr><td><div>Omen</div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">web2py_version</td><td style="vertical-align:top;">:</td><td><div>2.18.5-stable+timestamp.2019.04.08.04.22.03</div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_https</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_local</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_restful</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_scheduler</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">is_shell</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">method</td><td style="vertical-align:top;">:</td><td><div>GET</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">now</td><td style="vertical-align:top;">:</td><td><div>datetime.datetime(2020, 3, 4, 18, 25, 0, 716983)</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">raw_args</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">raw_extension</td><td style="vertical-align:top;">:</td><td><div>None</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">url</td><td style="vertical-align:top;">:</td><td><div>/Highways/appadmin/hooks</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">utcnow</td><td style="vertical-align:top;">:</td><td><div>datetime.datetime(2020, 3, 5, 2, 25, 0, 717020)</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">wsgi</td><td style="vertical-align:top;">:</td><td><div>&lt;gluon.main.LazyWSGI object at 0x7f52d2f9b0d0&gt;</div></td></tr></table></div>'
126tRp64
127sS'frames'
128p65
129(lp66
130(dp67
131S'file'
132p68
133S'/home/jdalbey/Dropbox/web2py/gluon/restricted.py'
134p69
135sS'dump'
136p70
137(dp71
138S'environment'
139p72
140S"{'A': <class 'gluon.html.A'>, 'ANY_OF': <class 'pydal.validators.ANY_OF'>, 'ASSIGNJS': <function ASSIGNJS>, 'B': <class 'gluon.html.B'>, 'BEAUTIFY': <class 'gluon.html.BEAUTIFY'>, 'BODY': <class 'gluon.html.BODY'>, 'BR': <class 'gluon.html.BR'>, 'BUTTON': <class 'gluon.html.BUTTON'>, 'CAT': <class 'gluon.html.CAT'>, 'CENTER': <class 'gluon.html.CENTER'>, ...}"
141p73
142sS'ccode'
143p74
144S'<code object <module> at 0x7f52d1ce2530, file "/...b2py/applications/Highways/models/db.py", line 1>'
145p75
146ssS'lnum'
147p76
148I219
149sS'lines'
150p77
151(dp78
152I214
153S'    if environment is None:'
154p79
155sI215
156S'        environment = {}'
157p80
158sI216
159S"    environment['__file__'] = layer"
160p81
161sI217
162S"    environment['__name__'] = '__restricted__'"
163p82
164sI218
165S'    try:'
166p83
167sI219
168S'        exec(ccode, environment)'
169p84
170sI220
171S'    except HTTP:'
172p85
173sI221
174S'        raise'
175p86
176sI222
177S'    except RestrictedError:'
178p87
179sI223
180S'        # do not encapsulate (obfuscate) the original RestrictedError'
181p88
182ssS'call'
183p89
184S'(ccode=<code object <module> at 0x7f52d1ce2530, file "/...b2py/applications/Highways/models/db.py", line 1>, environment={\'A\': <class \'gluon.html.A\'>, \'ANY_OF\': <class \'pydal.validators.ANY_OF\'>, \'ASSIGNJS\': <function ASSIGNJS>, \'B\': <class \'gluon.html.B\'>, \'BEAUTIFY\': <class \'gluon.html.BEAUTIFY\'>, \'BODY\': <class \'gluon.html.BODY\'>, \'BR\': <class \'gluon.html.BR\'>, \'BUTTON\': <class \'gluon.html.BUTTON\'>, \'CAT\': <class \'gluon.html.CAT\'>, \'CENTER\': <class \'gluon.html.CENTER\'>, ...}, layer=\'/home/jdalbey/Dropbox/web2py/applications/Highways/models/db.py\', scode=<code object <module> at 0x7f52d1ce2530, file "/...b2py/applications/Highways/models/db.py", line 1>)'
185p90
186sS'func'
187p91
188S'restricted'
189p92
190sa(dp93
191g68
192S'/home/jdalbey/Dropbox/web2py/applications/Highways/models/db.py'
193p94
194sg70
195(dp95
196S'builtinformat'
197p96
198S'<built-in function format>'
199p97
200ssg76
201I25
202sg77
203(dp98
204I19
205S"                Field('tmpdetails'),"
206p99
207sI20
208S"                Field('meetingplace'),"
209p100
210sI21
211S"                Field('closurereason'),"
212p101
213sI22
214S"                Field('supervisor'),"
215p102
216sI23
217S"                Field('fieldrep'),"
218p103
219sI24
220S"                Field('remarks'),"
221p104
222sI25
223S"                format = '%(route)s')"
224p105
225sI26
226S''
227sI27
228S'db.highways.lognum.requires = IS_NOT_IN_DB(db, db.highways.lognum)'
229p106
230sI28
231S'db.highways.lognum.requires = IS_NOT_EMPTY()'
232p107
233ssg89
234S'()'
235p108
236sg91
237S'<module>'
238p109
239sa(dp110
240g68
241S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/base.py'
242p111
243sg70
244(dp112
245S'fields'
246p113
247S'(<pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, ...)'
248p114
249sS'self'
250p115
251S'<DAL uri="sqlite://storage.sqlite">'
252p116
253sS'tablename'
254p117
255S"'highways'"
256p118
257sS'kwargs'
258p119
259S"{'format': '%(route)s'}"
260p120
261sS'table'
262p121
263S'undefined'
264p122
265sS'self.lazy_define_table'
266p123
267S'<bound method DAL.lazy_define_table of <DAL uri="sqlite://storage.sqlite">>'
268p124
269ssg76
270I592
271sg77
272(dp125
273I587
274S'        if self._lazy_tables:'
275p126
276sI588
277S'            if tablename not in self._LAZY_TABLES or redefine:'
278p127
279sI589
280S'                self._LAZY_TABLES[tablename] = (tablename, fields, kwargs)'
281p128
282sI590
283S'            table = None'
284p129
285sI591
286S'        else:'
287p130
288sI592
289S'            table = self.lazy_define_table(tablename, *fields, **kwargs)'
290p131
291sI593
292S'        if tablename not in self.tables:'
293p132
294sI594
295S'            self.tables.append(tablename)'
296p133
297sI595
298S'        return table'
299p134
300sI596
301S''
302ssg89
303S'(self=<DAL uri="sqlite://storage.sqlite">, tablename=\'highways\', *fields=(<pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, ...), **kwargs={\'format\': \'%(route)s\'})'
304p135
305sg91
306S'define_table'
307p136
308sa(dp137
309g68
310S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/base.py'
311p138
312sg70
313(dp139
314S'polymodel'
315p140
316S'None'
317p141
318ssg76
319I626
320sg77
321(dp142
322I621
323S'            try:'
324p143
325sI622
326S'                GLOBAL_LOCKER.acquire()'
327p144
328sI623
329S'                self._adapter.create_table('
330p145
331sI624
332S'                    table, migrate=migrate,'
333p146
334sI625
335S'                    fake_migrate=fake_migrate,'
336p147
337sI626
338S'                    polymodel=polymodel)'
339p148
340sI627
341S'            finally:'
342p149
343sI628
344S'                GLOBAL_LOCKER.release()'
345p150
346sI629
347S'        else:'
348p151
349sI630
350S'            table._dbt = None'
351p152
352ssg89
353S'(self=<DAL uri="sqlite://storage.sqlite">, tablename=\'highways\', *fields=(<pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, <pydal.objects.Field object>, ...), **kwargs={\'format\': \'%(route)s\'})'
354p153
355sg91
356S'lazy_define_table'
357p154
358sa(dp155
359g68
360S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py'
361p156
362sg70
363(dp157
364S'self'
365p158
366S'<pydal.adapters.sqlite.SQLite object>'
367p159
368sS'args'
369p160
370S'(<Table highways (id, closureid, lognum, route, d...e, closurereason, supervisor, fieldrep, remarks)>,)'
371p161
372sS'self.migrator'
373p162
374S'<pydal.migrator.Migrator object>'
375p163
376sS'self.migrator.create_table'
377p164
378S'<bound method Migrator.create_table of <pydal.migrator.Migrator object>>'
379p165
380sS'kwargs'
381p166
382S"{'fake_migrate': False, 'migrate': True, 'polymodel': None}"
383p167
384ssg76
385I798
386sg77
387(dp168
388I800
389S'    def _drop_table_cleanup(self, table):'
390p169
391sI801
392S'        super(SQLAdapter, self)._drop_table_cleanup(table)'
393p170
394sI802
395S'        if table._dbt:'
396p171
397sI793
398S''
399sI794
400S'    def bulk_insert(self, table, items):'
401p172
402sI795
403S'        return [self.insert(table, item) for item in items]'
404p173
405sI796
406S''
407sI797
408S'    def create_table(self, *args, **kwargs):'
409p174
410sI798
411S'        return self.migrator.create_table(*args, **kwargs)'
412p175
413sI799
414S''
415ssg89
416S"(self=<pydal.adapters.sqlite.SQLite object>, *args=(<Table highways (id, closureid, lognum, route, d...e, closurereason, supervisor, fieldrep, remarks)>,), **kwargs={'fake_migrate': False, 'migrate': True, 'polymodel': None})"
417p176
418sg91
419S'create_table'
420p177
421sa(dp178
422g68
423S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/migrator.py'
424p179
425sg70
426(dp180
427S'fake_migrate'
428p181
429S'False'
430p182
431ssg76
432I318
433sg77
434(dp183
435I320
436S'        return query'
437p184
438sI321
439S''
440sI322
441S'    def _fix(self, item):'
442p185
443sI313
444S'            if sql_fields != sql_fields_old:'
445p186
446sI314
447S'                self.migrate_table('
448p187
449sI315
450S'                    table,'
451p188
452sI316
453S'                    sql_fields, sql_fields_old,'
454p189
455sI317
456S'                    sql_fields_aux, None,'
457p190
458sI318
459S'                    fake_migrate=fake_migrate'
460p191
461sI319
462S'                    )'
463p192
464ssg89
465S'(self=<pydal.migrator.Migrator object>, table=<Table highways (id, closureid, lognum, route, d...e, closurereason, supervisor, fieldrep, remarks)>, migrate=True, fake_migrate=False, polymodel=None)'
466p193
467sg91
468g177
469sa(dp194
470g68
471S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/migrator.py'
472p195
473sg70
474(dp196
475S'self'
476p197
477S'<pydal.migrator.Migrator object>'
478p198
479sS'self.adapter.execute'
480p199
481S'<bound method SQLite.wrap of <pydal.adapters.sqlite.SQLite object>>'
482p200
483sS'self.adapter'
484p201
485S'<pydal.adapters.sqlite.SQLite object>'
486p202
487sS'sub_query'
488p203
489S'\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\''
490p204
491ssg76
492I451
493sg77
494(dp205
495I448
496S'                            self.save_dbt(table, sql_fields_current)'
497p206
498sI449
499S"                        self.log('faked!\\n', table)"
500p207
501sI450
502S'                    else:'
503p208
504sI451
505S'                        self.adapter.execute(sub_query)'
506p209
507sI452
508S'                        # Caveat: mysql, oracle and firebird'
509p210
510sI453
511S'                        # do not allow multiple alter table'
512p211
513sI454
514S'                        # in one transaction so we must commit'
515p212
516sI455
517S'                        # partial transactions and'
518p213
519sI446
520S'                    if fake_migrate:'
521p214
522sI447
523S'                        if db._adapter.commit_on_alter_table:'
524p215
525ssg89
526S'(self=<pydal.migrator.Migrator object>, table=<Table highways (id, closureid, lognum, route, d...e, closurereason, supervisor, fieldrep, remarks)>, 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)'
527p216
528sg91
529S'migrate_table'
530p217
531sa(dp218
532g68
533S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/__init__.py'
534p219
535sg70
536(dp220
537S'kwargs'
538p221
539g21
540sS'args'
541p222
542S'(<pydal.adapters.sqlite.SQLite object>, \'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\')'
543p223
544sS'f'
545S'<function execute>'
546p224
547ssg76
548I67
549sg77
550(dp225
551I64
552S'            if len(args) > 1:'
553p226
554sI65
555S'                raise ValueError(args[1])'
556p227
557sI66
558S"            raise RuntimeError('no connection available')"
559p228
560sI67
561S'        return f(*args, **kwargs)'
562p229
563sI68
564S'    return wrap'
565p230
566sI69
567S''
568sI70
569S''
570sI71
571S'from .base import SQLAdapter, NoSQLAdapter'
572p231
573sI62
574S'    def wrap(*args, **kwargs):'
575p232
576sI63
577S'        if not args[0].connection:'
578p233
579ssg89
580S'(*args=(<pydal.adapters.sqlite.SQLite object>, \'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\'), **kwargs={})'
581p234
582sg91
583S'wrap'
584p235
585sa(dp236
586g68
587S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py'
588p237
589sg70
590(dp238
591S'rv'
592p239
593g122
594sS'self'
595p240
596S'<pydal.adapters.sqlite.SQLite object>'
597p241
598sS'args'
599p242
600S'(\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\',)'
601p243
602sS'self.cursor'
603p244
604S'<sqlite3.Cursor object>'
605p245
606sS'command'
607p246
608S'\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\''
609p247
610sS'self.cursor.execute'
611p248
612S'<built-in method execute of sqlite3.Cursor object>'
613p249
614sS'kwargs'
615p250
616g21
617ssg76
618I413
619sg77
620(dp251
621I416
622S'        return rv'
623p252
624sI417
625S''
626sI408
627S'    def execute(self, *args, **kwargs):'
628p253
629sI409
630S'        command = self.filter_sql_command(args[0])'
631p254
632sI410
633S'        handlers = self._build_handlers_for_execution()'
634p255
635sI411
636S'        for handler in handlers:'
637p256
638sI412
639S'            handler.before_execute(command)'
640p257
641sI413
642S'        rv = self.cursor.execute(command, *args[1:], **kwargs)'
643p258
644sI414
645S'        for handler in handlers:'
646p259
647sI415
648S'            handler.after_execute(command)'
649p260
650ssg89
651S'(self=<pydal.adapters.sqlite.SQLite object>, *args=(\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\',), **kwargs={})'
652p261
653sg91
654S'execute'
655p262
656sasS'pyver'
657p263
658S'Python 2.7.17: /usr/bin/python (prefix: /usr)'
659p264
660sS'session'
661p265
662g63
663(S's9\x01\x00\x00<div><table><tr><td style="font-weight:bold;vertical-align:top;">last_orderby</td><td style="vertical-align:top;">:</td><td><div>None</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">last_query</td><td style="vertical-align:top;">:</td><td><div>db.highways.id&gt;0</div></td></tr></table></div>'
664tRp266
665sS'etype'
666p267
667S"<class 'sqlite3.OperationalError'>"
668p268
669sS'date'
670p269
671S'Wed Mar  4 18:25:00 2020'
672p270
673sS'response'
674p271
675g63
676(S's\xfb\x17\x00\x00<div><table><tr><td style="font-weight:bold;vertical-align:top;">body</td><td style="vertical-align:top;">:</td><td><div>&lt;cStringIO.StringO object at 0x7f52d271f8b0&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">cookies</td><td style="vertical-align:top;">:</td><td><div><table><tr><td style="font-weight:bold;vertical-align:top;">session_id_highways</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf<table><tr><td style="font-weight:bold;vertical-align:top;">comment</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">domain</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">expires</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">httponly</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">max-age</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">path</td><td style="vertical-align:top;">:</td><td><div>/</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">samesite</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">secure</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">version</td><td style="vertical-align:top;">:</td><td><div></div></td></tr></table></div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">delimiters</td><td style="vertical-align:top;">:</td><td><div><table><tr><td><div>{{</div></td></tr><tr><td><div>}}</div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">files</td><td style="vertical-align:top;">:</td><td><div><table></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">flash</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">form_label_separator</td><td style="vertical-align:top;">:</td><td><div>: </div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">formstyle</td><td style="vertical-align:top;">:</td><td><div>table3cols</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">generic_patterns</td><td style="vertical-align:top;">:</td><td><div><table><tr><td><div>*</div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">headers</td><td style="vertical-align:top;">:</td><td><div><table><tr><td style="font-weight:bold;vertical-align:top;">X-Powered-By</td><td style="vertical-align:top;">:</td><td><div>web2py</div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">menu</td><td style="vertical-align:top;">:</td><td><div><table></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">meta</td><td style="vertical-align:top;">:</td><td><div><table></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">models_to_run</td><td style="vertical-align:top;">:</td><td><div><table><tr><td><div>^\\w+\\.py$</div></td></tr><tr><td><div>^appadmin/\\w+\\.py$</div></td></tr><tr><td><div>^appadmin/hooks/\\w+\\.py$</div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">postprocessing</td><td style="vertical-align:top;">:</td><td><div><table></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_client</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_cookie_compression_level</td><td style="vertical-align:top;">:</td><td><div>None</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_cookie_expires</td><td style="vertical-align:top;">:</td><td><div>None</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_data_name</td><td style="vertical-align:top;">:</td><td><div>session_data_highways</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_file</td><td style="vertical-align:top;">:</td><td><div>&lt;open file &#x27;/home/jdalbey/Dropbox/web2py/applications/Highways/sessions/120/0a0/127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf&#x27;, mode &#x27;rb+&#x27; at 0x7f52d25c1660&gt;</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_filename</td><td style="vertical-align:top;">:</td><td><div>/home/jdalbey/Dropbox/web2py/applications/Highways/sessions/127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_hash</td><td style="vertical-align:top;">:</td><td><div>8df36882fd43219ed8632e741a6b611c</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_id</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1-a96b6f85-d902-4c9d-bbb9-5971693a0dcf</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_id_name</td><td style="vertical-align:top;">:</td><td><div>session_id_highways</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_locked</td><td style="vertical-align:top;">:</td><td><div>True</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_masterapp</td><td style="vertical-align:top;">:</td><td><div>Highways</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_new</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_storage_type</td><td style="vertical-align:top;">:</td><td><div>file</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">status</td><td style="vertical-align:top;">:</td><td><div>200</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">view</td><td style="vertical-align:top;">:</td><td><div>appadmin/hooks.html</div></td></tr></table></div>'
677tRp272
678sS'locals'
679p273
680(dp274
681S'handlers'
682p275
683S'[<pydal.helpers.classes.TimingHandler object>]'
684p276
685sS'self'
686p277
687S'<pydal.adapters.sqlite.SQLite object>'
688p278
689sg48
690S'(\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\',)'
691p279
692sS'handler'
693p280
694S'<pydal.helpers.classes.TimingHandler object>'
695p281
696sS'command'
697p282
698S'\'ALTER TABLE "highways" ADD "closurereason" CHAR(512);\''
699p283
700sS'kwargs'
701p284
702g21
703sssS'traceback'
704p285
705S'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 <module>\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'
706p286
707s.
Note: See TracBrowser for help on using the repository browser.