source: tmcsimulator/branches/LCSv1/errors/127.0.0.1.2020-03-19.15-32-28.32455448-dd91-4574-9200-2175ca1a2deb @ 593

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

Add branch LCSv1
Line 
1(dp1
2S'output'
3p2
4S"<type 'exceptions.ValueError'> need more than 1 value to unpack"
5p3
6sS'layer'
7p4
8S'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/appadmin.py'
9p5
10sS'code'
11p6
12S'<code object <module> at 0x7f7c907eda30, file "/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/appadmin.py", line 7>'
13p7
14sS'snapshot'
15p8
16(dp9
17S'exception'
18p10
19(dp11
20S'__getslice__'
21p12
22S"<method-wrapper '__getslice__' of exceptions.ValueError object>"
23p13
24sS'__str__'
25p14
26S"<method-wrapper '__str__' of exceptions.ValueError object>"
27p15
28sS'__reduce__'
29p16
30S'<built-in method __reduce__ of exceptions.ValueError object>'
31p17
32sS'__dict__'
33p18
34S'{}'
35p19
36sS'message'
37p20
38S"'need more than 1 value to unpack'"
39p21
40sS'__sizeof__'
41p22
42S'<built-in method __sizeof__ of exceptions.ValueError object>'
43p23
44sS'__init__'
45p24
46S"<method-wrapper '__init__' of exceptions.ValueError object>"
47p25
48sS'__setattr__'
49p26
50S"<method-wrapper '__setattr__' of exceptions.ValueError object>"
51p27
52sS'__reduce_ex__'
53p28
54S'<built-in method __reduce_ex__ of exceptions.ValueError object>'
55p29
56sS'__new__'
57p30
58S'<built-in method __new__ of type object>'
59p31
60sS'__format__'
61p32
62S'<built-in method __format__ of exceptions.ValueError object>'
63p33
64sS'__class__'
65p34
66S"<type 'exceptions.ValueError'>"
67p35
68sS'__doc__'
69p36
70S"'Inappropriate argument value (of correct type).'"
71p37
72sS'__getitem__'
73p38
74S"<method-wrapper '__getitem__' of exceptions.ValueError object>"
75p39
76sS'__setstate__'
77p40
78S'<built-in method __setstate__ of exceptions.ValueError object>'
79p41
80sS'__getattribute__'
81p42
82S"<method-wrapper '__getattribute__' of exceptions.ValueError object>"
83p43
84sS'args'
85p44
86S"('need more than 1 value to unpack',)"
87p45
88sS'__subclasshook__'
89p46
90S'<built-in method __subclasshook__ of type object>'
91p47
92sS'__unicode__'
93p48
94S'<built-in method __unicode__ of exceptions.ValueError object>'
95p49
96sS'__delattr__'
97p50
98S"<method-wrapper '__delattr__' of exceptions.ValueError object>"
99p51
100sS'__repr__'
101p52
102S"<method-wrapper '__repr__' of exceptions.ValueError object>"
103p53
104sS'__hash__'
105p54
106S"<method-wrapper '__hash__' of exceptions.ValueError object>"
107p55
108ssS'evalue'
109p56
110S'need more than 1 value to unpack'
111p57
112sS'request'
113p58
114cgluon.html
115XML_unpickle
116p59
117(S's\xa8k\x00\x00<div><table><tr><td style="font-weight:bold;vertical-align:top;">ajax</td><td style="vertical-align:top;">:</td><td><div>False</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">application</td><td style="vertical-align:top;">:</td><td><div>Multiform</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">args</td><td style="vertical-align:top;">:</td><td><div><table><tr><td><div>db</div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">cid</td><td style="vertical-align:top;">:</td><td><div>None</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-45f002ee-d673-4882-8232-a947f722f0cc<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-570ad9dc-d7c8-4390-a43e-9c3207ed2917<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_multiform</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359<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_tiny_website</td><td style="vertical-align:top;">:</td><td><div>2:bc5fb02a-35d0-419c-876b-bfec4f92e2a2<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-7eb52914-6c77-4487-8920-cde8f07dbed3<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;">HTTP_ACCEPT</td><td style="vertical-align:top;">:</td><td><div>text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8</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_COOKIE</td><td style="vertical-align:top;">:</td><td><div>session_id_welcome=127.0.0.1-7eb52914-6c77-4487-8920-cde8f07dbed3; session_id_admin=127.0.0.1-45f002ee-d673-4882-8232-a947f722f0cc; session_id_multiform=127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359; session_id_tiny_website=&quot;2:bc5fb02a-35d0-419c-876b-bfec4f92e2a2&quot;; session_id_highways=127.0.0.1-570ad9dc-d7c8-4390-a43e-9c3207ed2917</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/Multiform/appadmin/select/db?query=db.closures.id%3E0</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">HTTP_UPGRADE_INSECURE_REQUESTS</td><td style="vertical-align:top;">:</td><td><div>1</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:74.0) Gecko/20100101 Firefox/74.0</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">PATH_INFO</td><td style="vertical-align:top;">:</td><td><div>/Multiform/appadmin/csv/db</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">QUERY_STRING</td><td style="vertical-align:top;">:</td><td><div>query=db.closures.id%3E0</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>58020</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/Multiform&#x27;, &#x27;/home/jdalbey/Dropbox/web2py/applications/tiny_website&#x27;, &#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 0x7f7cbeceb9b0: {&#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([&#x27;tiny_website&#x27;])</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>text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8</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_cookie</td><td style="vertical-align:top;">:</td><td><div>session_id_welcome=127.0.0.1-7eb52914-6c77-4487-8920-cde8f07dbed3; session_id_admin=127.0.0.1-45f002ee-d673-4882-8232-a947f722f0cc; session_id_multiform=127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359; session_id_tiny_website=&quot;2:bc5fb02a-35d0-419c-876b-bfec4f92e2a2&quot;; session_id_highways=127.0.0.1-570ad9dc-d7c8-4390-a43e-9c3207ed2917</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/Multiform/appadmin/select/db?query=db.closures.id%3E0</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">http_upgrade_insecure_requests</td><td style="vertical-align:top;">:</td><td><div>1</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:74.0) Gecko/20100101 Firefox/74.0</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>/Multiform/appadmin/csv/db</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">query_string</td><td style="vertical-align:top;">:</td><td><div>query=db.closures.id%3E0</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>58020</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>/Multiform/appadmin/csv/db?query=db.closures.id%3E0</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 0x7f7cc5d67270&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 0x7f7cbed21980&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 0x7f7c90685c50&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 0x7f7cc5d67270&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 0x7f7cbed21980&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 0x7f7c90685c50&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/Multiform</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">function</td><td style="vertical-align:top;">:</td><td><div>csv</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/Multiform&#x27;, &#x27;/home/jdalbey/Dropbox/web2py/applications/tiny_website&#x27;, &#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 0x7f7cbeceb9b0: {&#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([&#x27;tiny_website&#x27;])</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, 19, 15, 32, 28, 591176)</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">raw_args</td><td style="vertical-align:top;">:</td><td><div>db</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>/Multiform/appadmin/csv/db</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, 19, 22, 32, 28, 591207)</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 0x7f7c9051ed90&gt;</div></td></tr></table></div>'
118tRp60
119sS'frames'
120p61
121(lp62
122(dp63
123S'file'
124p64
125S'/home/jdalbey/Dropbox/web2py/gluon/restricted.py'
126p65
127sS'dump'
128p66
129(dp67
130S'environment'
131p68
132S"{'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'>, ...}"
133p69
134sS'ccode'
135p70
136S'<code object <module> at 0x7f7c907eda30, file "/...tions/Multiform/controllers/appadmin.py", line 7>'
137p71
138ssS'lnum'
139p72
140I219
141sS'lines'
142p73
143(dp74
144I214
145S'    if environment is None:'
146p75
147sI215
148S'        environment = {}'
149p76
150sI216
151S"    environment['__file__'] = layer"
152p77
153sI217
154S"    environment['__name__'] = '__restricted__'"
155p78
156sI218
157S'    try:'
158p79
159sI219
160S'        exec(ccode, environment)'
161p80
162sI220
163S'    except HTTP:'
164p81
165sI221
166S'        raise'
167p82
168sI222
169S'    except RestrictedError:'
170p83
171sI223
172S'        # do not encapsulate (obfuscate) the original RestrictedError'
173p84
174ssS'call'
175p85
176S'(ccode=<code object <module> at 0x7f7c907eda30, file "/...tions/Multiform/controllers/appadmin.py", line 7>, 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/Multiform/controllers/appadmin.py\', scode=<code object <module> at 0x7f7c907eda30, file "/...tions/Multiform/controllers/appadmin.py", line 7>)'
177p86
178sS'func'
179p87
180S'restricted'
181p88
182sa(dp89
183g64
184S'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/appadmin.py'
185p90
186sg66
187(dp91
188sg72
189I695
190sg73
191(dp92
192I684
193S"                    referenced_table = f_type.split()[1].split('.')[0]"
194p93
195sI685
196S''
197sI686
198S'                    links.append(dict(source=tablename, target = referenced_table))'
199p94
200sI687
201S''
202sI688
203S'            nodes.append(dict(name=tablename, type="table", fields = fields))'
204p95
205sI689
206S''
207sI690
208S'    # d3 v4 allows individual modules to be specified.  The complete d3 library is included below.'
209p96
210sI691
211S"    response.files.append(URL('admin','static','js/d3.min.js'))"
212p97
213sI692
214S"    response.files.append(URL('admin','static','js/d3_graph.js'))"
215p98
216sI693
217S'    return dict(databases=databases, nodes=nodes, links=links)'
218p99
219ssg85
220S'()'
221p100
222sg87
223S'<module>'
224p101
225sa(dp102
226g64
227S'/home/jdalbey/Dropbox/web2py/gluon/globals.py'
228p103
229sg66
230(dp104
231S'self'
232p105
233S'undefined'
234p106
235sS'f'
236S'<function csv>'
237p107
238ssg72
239I421
240sg73
241(dp108
242I416
243S"        self.flash = ''            # used by the default view layout"
244p109
245sI417
246S'        self.meta = Storage()      # used by web2py_ajax.html'
247p110
248sI418
249S'        self.menu = []             # used by the default view layout'
250p111
251sI419
252S'        self.files = []            # used by web2py_ajax.html'
253p112
254sI420
255S'        self._vars = None'
256p113
257sI421
258S'        self._caller = lambda f: f()'
259p114
260sI422
261S'        self._view_environment = None'
262p115
263sI423
264S'        self._custom_commit = None'
265p116
266sI424
267S'        self._custom_rollback = None'
268p117
269sI425
270S"        self.generic_patterns = ['*']"
271p118
272ssg85
273S'(f=<function csv>)'
274p119
275sg87
276S'<lambda>'
277p120
278sa(dp121
279g64
280S'/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/appadmin.py'
281p122
282sg66
283(dp123
284S'builtinstr'
285p124
286S"<type 'str'>"
287p125
288sS'builtinTrue'
289p126
290S'True'
291p127
292sS'ignore_common_filters'
293p128
294g106
295sS'db'
296p129
297S'<DAL uri="sqlite://storage.sqlite">'
298p130
299sS').select'
300p131
301g106
302sS'query'
303p132
304S'<Query ("closures"."id" > 0)>'
305p133
306ssg72
307I173
308sg73
309(dp134
310I168
311S'    query = get_query(request)'
312p135
313sI169
314S'    if not query:'
315p136
316sI170
317S'        return None'
318p137
319sI171
320S"    response.headers['Content-disposition'] = 'attachment; filename=%s_%s.csv'\\"
321p138
322sI172
323S"        % tuple(request.vars.query.split('.')[:2])"
324p139
325sI173
326S'    return str(db(query, ignore_common_filters=True).select())'
327p140
328sI174
329S''
330sI175
331S''
332sI176
333S'def import_csv(table, file):'
334p141
335sI177
336S'    table.import_from_csv_file(file)'
337p142
338ssg85
339S'()'
340p143
341sg87
342S'csv'
343p144
344sa(dp145
345g64
346S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py'
347p146
348sg66
349(dp147
350S'self.query'
351p148
352S'<Query ("closures"."id" > 0)>'
353p149
354sS'adapter.select'
355p150
356S'<bound method SQLite.select of <pydal.adapters.sqlite.SQLite object>>'
357p151
358sS'fields'
359p152
360S'[<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>, ...]'
361p153
362sS'adapter'
363p154
364S'<pydal.adapters.sqlite.SQLite object>'
365p155
366sS'attributes'
367p156
368g19
369sS'self'
370p157
371S'<Set ("closures"."id" > 0)>'
372p158
373ssg72
374I2395
375sg73
376(dp159
377I2390
378S"                                    attributes.get('join', None),"
379p160
380sI2391
381S"                                    attributes.get('left', None),"
382p161
383sI2392
384S"                                    attributes.get('orderby', None),"
385p162
386sI2393
387S"                                    attributes.get('groupby', None))"
388p163
389sI2394
390S'        fields = adapter.expand_all(fields, tablenames)'
391p164
392sI2395
393S'        return adapter.select(self.query, fields, attributes)'
394p165
395sI2396
396S''
397sI2397
398S'    def iterselect(self, *fields, **attributes):'
399p166
400sI2398
401S'        adapter = self.db._adapter'
402p167
403sI2399
404S'        tablenames = adapter.tables(self.query,'
405p168
406ssg85
407S'(self=<Set ("closures"."id" > 0)>, *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>, ...], **attributes={})'
408p169
409sg87
410S'select'
411p170
412sa(dp171
413g64
414S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/sqlite.py'
415p172
416sg66
417(dp173
418S'fields'
419p174
420S'[<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>, ...]'
421p175
422sS'self'
423p176
424S'<pydal.adapters.sqlite.SQLite object>'
425p177
426sS').select'
427p178
428S'<bound method SQLite.select of <pydal.adapters.sqlite.SQLite object>>'
429p179
430sS'attributes'
431p180
432g19
433sS'query'
434p181
435S'<Query ("closures"."id" > 0)>'
436p182
437sS'builtinsuper'
438p183
439S"<type 'super'>"
440p184
441sS'global SQLite'
442p185
443S"<class 'pydal.adapters.sqlite.SQLite'>"
444p186
445ssg72
446I82
447sg73
448(dp187
449I77
450S"            self.execute('PRAGMA foreign_keys=ON;')"
451p188
452sI78
453S''
454sI79
455S'    def select(self, query, fields, attributes):'
456p189
457sI80
458S"        if attributes.get('for_update', False) and 'cache' not in attributes:"
459p190
460sI81
461S"            self.execute('BEGIN IMMEDIATE TRANSACTION;')"
462p191
463sI82
464S'        return super(SQLite, self).select(query, fields, attributes)'
465p192
466sI83
467S''
468sI84
469S'    def delete(self, table, query):'
470p193
471sI85
472S'        db = self.db'
473p194
474sI86
475S'        deleted = [x[table._id.name] for x in db(query).select(table._id)]'
476p195
477ssg85
478S'(self=<pydal.adapters.sqlite.SQLite object>, query=<Query ("closures"."id" > 0)>, 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>, ...], attributes={})'
479p196
480sg87
481g170
482sa(dp197
483g64
484S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py'
485p198
486sg66
487(dp199
488S'self._select_aux'
489p200
490S'<bound method SQLite._select_aux of <pydal.adapters.sqlite.SQLite object>>'
491p201
492sS'fields'
493p202
494S'[<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>, ...]'
495p203
496sS'self'
497p204
498S'<pydal.adapters.sqlite.SQLite object>'
499p205
500sS'sql'
501p206
502S'\'SELECT "closures"."id", "closures"."closureid", ...one" FROM "closures" WHERE ("closures"."id" > 0);\''
503p207
504sS'attributes'
505p208
506g19
507sS'colnames'
508p209
509S"['closures.id', 'closures.closureid', 'closures.lognum', 'closures.route', 'closures.direction', 'closures.facility', 'closures.startdate', 'closures.enddate', 'closures.starttime', 'closures.endtime', 'closures.startcounty', 'closures.endcounty', 'closures.startlocation', 'closures.endlocation', 'closures.closuretype', 'closures.worktype', 'closures.estdelay', 'closures.tmpcozeep', 'closures.tmpdetour', 'closures.supervisor', ...]"
510p210
511ssg72
512I763
513sg73
514(dp211
515I758
516S'        colnames, sql = self._select_wcols(query, fields, **attributes)'
517p212
518sI759
519S"        cache = attributes.get('cache', None)"
520p213
521sI760
522S"        if cache and attributes.get('cacheable', False):"
523p214
524sI761
525S'            return self._cached_select('
526p215
527sI762
528S'                cache, sql, fields, attributes, colnames)'
529p216
530sI763
531S'        return self._select_aux(sql, fields, attributes, colnames)'
532p217
533sI764
534S''
535sI765
536S'    def iterselect(self, query, fields, attributes):'
537p218
538sI766
539S'        colnames, sql = self._select_wcols(query, fields, **attributes)'
540p219
541sI767
542S"        cacheable = attributes.get('cacheable', False)"
543p220
544ssg85
545S'(self=<pydal.adapters.sqlite.SQLite object>, query=<Query ("closures"."id" > 0)>, 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>, ...], attributes={})'
546p221
547sg87
548g170
549sa(dp222
550g64
551S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py'
552p223
553sg66
554(dp224
555S'fields'
556p225
557S'[<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>, ...]'
558p226
559sS'colnames'
560p227
561S"['closures.id', 'closures.closureid', 'closures.lognum', 'closures.route', 'closures.direction', 'closures.facility', 'closures.startdate', 'closures.enddate', 'closures.starttime', 'closures.endtime', 'closures.startcounty', 'closures.endcounty', 'closures.startlocation', 'closures.endlocation', 'closures.closuretype', 'closures.worktype', 'closures.estdelay', 'closures.tmpcozeep', 'closures.tmpdetour', 'closures.supervisor', ...]"
562p228
563sS'rows'
564p229
565S"[(46, u'T5AA', u'1', u'5', u'N', u'Mainline', u'20200101', u'20200102', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'66', u'NO', u'NO', u'Joe', ...), (47, u'T405AA', u'1', u'405', u'N', u'Mainline', u'20200202', u'20200302', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Joe', ...), (48, u'T5AB', u'1', u'5', u'S', u'Mainline', u'20190122', u'20190125', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Sam', ...), (49, u'T22AA', u'1', u'22', u'E', u'Mainline', u'20000101', u'20001010', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Sue', ...), (50, u'T22BB', u'1', u'22', u'W', u'Mainline', u'20000101', u'20001010', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Sue', ...), (51, u'T55AA', u'1', u'55', u'N', u'Off Ramp', u'200010101', u'20001011', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'Blasting', u'22', u'YES', u'NO', u'Sam', ...), (52, u'T5AA', u'1', u'5', u'N', u'Mainline', u'2020-01-01', u'2020-01-02', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'66', u'NO', u'NO', u'Joe', ...), (53, u'T5AC', u'1', u'5', u'NB', u'Mainline', u'2020-03-18', u'2020-03-19', u'0800', u'0900', u'ORA', None, u'First', u'Second', u'Lane', u'Blasting', u'66', None, None, u'Sam', ...)]"
566p230
567sS'processor'
568p231
569S'<bound method SQLite.parse of <pydal.adapters.sqlite.SQLite object>>'
570p232
571sS'cacheable'
572p233
573S'False'
574p234
575ssg72
576I742
577sg73
578(dp235
579I737
580S'            rows = list(rows)'
581p236
582sI738
583S"        limitby = attributes.get('limitby', None) or (0,)"
584p237
585sI739
586S'        rows = self.rowslice(rows, limitby[0], None)'
587p238
588sI740
589S"        processor = attributes.get('processor', self.parse)"
590p239
591sI741
592S"        cacheable = attributes.get('cacheable', False)"
593p240
594sI742
595S'        return processor(rows, fields, colnames, cacheable=cacheable)'
596p241
597sI743
598S''
599sI744
600S'    def _cached_select(self, cache, sql, fields, attributes, colnames):'
601p242
602sI745
603S"        del attributes['cache']"
604p243
605sI746
606S'        (cache_model, time_expire) = cache'
607p244
608ssg85
609S'(self=<pydal.adapters.sqlite.SQLite object>, sql=\'SELECT "closures"."id", "closures"."closureid", ...one" FROM "closures" WHERE ("closures"."id" > 0);\', 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>, ...], attributes={}, colnames=[\'closures.id\', \'closures.closureid\', \'closures.lognum\', \'closures.route\', \'closures.direction\', \'closures.facility\', \'closures.startdate\', \'closures.enddate\', \'closures.starttime\', \'closures.endtime\', \'closures.startcounty\', \'closures.endcounty\', \'closures.startlocation\', \'closures.endlocation\', \'closures.closuretype\', \'closures.worktype\', \'closures.estdelay\', \'closures.tmpcozeep\', \'closures.tmpdetour\', \'closures.supervisor\', ...])'
610p245
611sg87
612S'_select_aux'
613p246
614sa(dp247
615g64
616S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py'
617p248
618sg66
619(dp249
620S'rows'
621p250
622S"[(46, u'T5AA', u'1', u'5', u'N', u'Mainline', u'20200101', u'20200102', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'66', u'NO', u'NO', u'Joe', ...), (47, u'T405AA', u'1', u'405', u'N', u'Mainline', u'20200202', u'20200302', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Joe', ...), (48, u'T5AB', u'1', u'5', u'S', u'Mainline', u'20190122', u'20190125', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Sam', ...), (49, u'T22AA', u'1', u'22', u'E', u'Mainline', u'20000101', u'20001010', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Sue', ...), (50, u'T22BB', u'1', u'22', u'W', u'Mainline', u'20000101', u'20001010', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Sue', ...), (51, u'T55AA', u'1', u'55', u'N', u'Off Ramp', u'200010101', u'20001011', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'Blasting', u'22', u'YES', u'NO', u'Sam', ...), (52, u'T5AA', u'1', u'5', u'N', u'Mainline', u'2020-01-01', u'2020-01-02', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'66', u'NO', u'NO', u'Joe', ...), (53, u'T5AC', u'1', u'5', u'NB', u'Mainline', u'2020-03-18', u'2020-03-19', u'0800', u'0900', u'ORA', None, u'First', u'Second', u'Lane', u'Blasting', u'66', None, None, u'Sam', ...)]"
623p251
624sS'row'
625p252
626S"(46, u'T5AA', u'1', u'5', u'N', u'Mainline', u'20200101', u'20200102', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'66', u'NO', u'NO', u'Joe', ...)"
627p253
628ssg72
629I306
630sg73
631(dp254
632I301
633S'            self._parse_expand_colnames(fields)'
634p255
635sI302
636S'        new_rows = ['
637p256
638sI303
639S'            self._parse('
640p257
641sI304
642S'                row, tmps, fields, colnames, blob_decode, cacheable,'
643p258
644sI305
645S'                fields_virtual, fields_lazy)'
646p259
647sI306
648S'            for row in rows'
649p260
650sI307
651S'        ]'
652p261
653sI308
654S'        rowsobj = self.db.Rows(self.db, new_rows, colnames, rawrows=rows,'
655p262
656sI309
657S'                fields=fields)'
658p263
659sI310
660S'        # Old style virtual fields'
661p264
662ssg85
663S"(self=<pydal.adapters.sqlite.SQLite object>, rows=[(46, u'T5AA', u'1', u'5', u'N', u'Mainline', u'20200101', u'20200102', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'66', u'NO', u'NO', u'Joe', ...), (47, u'T405AA', u'1', u'405', u'N', u'Mainline', u'20200202', u'20200302', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Joe', ...), (48, u'T5AB', u'1', u'5', u'S', u'Mainline', u'20190122', u'20190125', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Sam', ...), (49, u'T22AA', u'1', u'22', u'E', u'Mainline', u'20000101', u'20001010', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Sue', ...), (50, u'T22BB', u'1', u'22', u'W', u'Mainline', u'20000101', u'20001010', u'0800', u'1700', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'33', u'NO', u'NO', u'Sue', ...), (51, u'T55AA', u'1', u'55', u'N', u'Off Ramp', u'200010101', u'20001011', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'Blasting', u'22', u'YES', u'NO', u'Sam', ...), (52, u'T5AA', u'1', u'5', u'N', u'Mainline', u'2020-01-01', u'2020-01-02', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'66', u'NO', u'NO', u'Joe', ...), (53, u'T5AC', u'1', u'5', u'NB', u'Mainline', u'2020-03-18', u'2020-03-19', u'0800', u'0900', u'ORA', None, u'First', u'Second', u'Lane', u'Blasting', u'66', None, None, u'Sam', ...)], 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>, ...], colnames=['closures.id', 'closures.closureid', 'closures.lognum', 'closures.route', 'closures.direction', 'closures.facility', 'closures.startdate', 'closures.enddate', 'closures.starttime', 'closures.endtime', 'closures.startcounty', 'closures.endcounty', 'closures.startlocation', 'closures.endlocation', 'closures.closuretype', 'closures.worktype', 'closures.estdelay', 'closures.tmpcozeep', 'closures.tmpdetour', 'closures.supervisor', ...], blob_decode=True, cacheable=False)"
664p265
665sg87
666S'parse'
667p266
668sa(dp267
669g64
670S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py'
671p268
672sg66
673(dp269
674S'blob_decode'
675p270
676g127
677sS'ft'
678p271
679S"'date'"
680p272
681sS'fit'
682p273
683S"'date'"
684p274
685sS'self.parse_value'
686p275
687S'<bound method SQLite.parse_value of <pydal.adapters.sqlite.SQLite object>>'
688p276
689sS'self'
690p277
691S'<pydal.adapters.sqlite.SQLite object>'
692p278
693sS'value'
694p279
695S"u'20200101'"
696p280
697ssg72
698I232
699sg73
700(dp281
701I227
702S'            #: do we have a real column?'
703p282
704sI228
705S'            if tmp:'
706p283
707sI229
708S'                (tablename, fieldname, table, field, ft, fit) = tmp'
709p284
710sI230
711S'                colset = new_row[tablename]'
712p285
713sI231
714S'                #: parse value'
715p286
716sI232
717S'                value = self.parse_value(value, fit, ft, blob_decode)'
718p287
719sI233
720S'                if field.filter_out:'
721p288
722sI234
723S'                    value = field.filter_out(value)'
724p289
725sI235
726S'                colset[fieldname] = value'
727p290
728sI236
729S'                #! backward compatibility'
730p291
731ssg85
732S"(self=<pydal.adapters.sqlite.SQLite object>, row=(46, u'T5AA', u'1', u'5', u'N', u'Mainline', u'20200101', u'20200102', u'0800', u'0900', u'ORA', u'ORA', u'BAKER', u'BRISTOL', u'Lane', u'AC Paving', u'66', u'NO', u'NO', u'Joe', ...), tmps=[('closures', 'id', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'id', 'id'), ('closures', 'closureid', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'lognum', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'route', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'direction', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'facility', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'startdate', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'date', 'date'), ('closures', 'enddate', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'date', 'date'), ('closures', 'starttime', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'endtime', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'startcounty', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'endcounty', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'startlocation', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'endlocation', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'closuretype', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'worktype', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'estdelay', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'tmpcozeep', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'tmpdetour', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ('closures', 'supervisor', <Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, <pydal.objects.Field object>, 'string', 'string'), ...], 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>, ...], colnames=['closures.id', 'closures.closureid', 'closures.lognum', 'closures.route', 'closures.direction', 'closures.facility', 'closures.startdate', 'closures.enddate', 'closures.starttime', 'closures.endtime', 'closures.startcounty', 'closures.endcounty', 'closures.startlocation', 'closures.endlocation', 'closures.closuretype', 'closures.worktype', 'closures.estdelay', 'closures.tmpcozeep', 'closures.tmpdetour', 'closures.supervisor', ...], blob_decode=True, cacheable=False, fields_virtual={'closures': (<Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, [])}, fields_lazy={'closures': (<Table closures (id, closureid, lognum, route, d...ne, s1022date, s1022time, s1022user, s1022phone)>, [])})"
733p292
734sg87
735S'_parse'
736p293
737sa(dp294
738g64
739S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py'
740p295
741sg66
742(dp296
743S'field_type'
744p297
745S"'date'"
746p298
747sS'self'
748p299
749S'<pydal.adapters.sqlite.SQLite object>'
750p300
751sS'value'
752p301
753S"'20200101'"
754p302
755sS'self.parser'
756p303
757S'<pydal.parsers.sqlite.SQLiteParser object>'
758p304
759sS'field_itype'
760p305
761S"'date'"
762p306
763sS'self.parser.parse'
764p307
765S'<bound method SQLiteParser.parse of <pydal.parsers.sqlite.SQLiteParser object>>'
766p308
767ssg72
768I199
769sg73
770(dp309
771I194
772S'        if not isinstance(field_type, str) or value is None:'
773p310
774sI195
775S'            return value'
776p311
777sI196
778S"        elif field_type == 'blob' and not blob_decode:"
779p312
780sI197
781S'            return value'
782p313
783sI198
784S'        else:'
785p314
786sI199
787S'            return self.parser.parse(value, field_itype, field_type)'
788p315
789sI200
790S''
791sI201
792S'    def _add_operators_to_parsed_row(self, rid, table, row):'
793p316
794sI202
795S'        for key, record_operator in iteritems(self.db.record_operators):'
796p317
797sI203
798S'            setattr(row, key, record_operator(row, table, rid))'
799p318
800ssg85
801S"(self=<pydal.adapters.sqlite.SQLite object>, value='20200101', field_itype='date', field_type='date', blob_decode=True)"
802p319
803sg87
804S'parse_value'
805p320
806sa(dp321
807g64
808S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/__init__.py'
809p322
810sg66
811(dp323
812S'field_itype'
813p324
814S"'date'"
815p325
816sS'field_type'
817p326
818S"'date'"
819p327
820sS'self'
821p328
822S'<pydal.parsers.sqlite.SQLiteParser object>'
823p329
824sS'self.registered'
825p330
826S'defaultdict(<function <lambda> at 0x7f7c913b0ed0...s.ParserMethodWrapper object at 0x7f7c9068ed10>})'
827p331
828sS'value'
829p332
830S"'20200101'"
831p333
832ssg72
833I100
834sg73
835(dp334
836I96
837S'    def _default(self, value, field_type):'
838p335
839sI97
840S'        return value'
841p336
842sI98
843S''
844sI99
845S'    def parse(self, value, field_itype, field_type):'
846p337
847sI100
848S'        return self.registered[field_itype](value, field_type)'
849p338
850sI101
851S''
852sI102
853S''
854sI103
855S'from .base import BasicParser'
856p339
857sI104
858S'from .sqlite import SQLiteParser'
859p340
860sI95
861S''
862ssg85
863S"(self=<pydal.parsers.sqlite.SQLiteParser object>, value='20200101', field_itype='date', field_type='date')"
864p341
865sg87
866g266
867sa(dp342
868g64
869S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/__init__.py'
870p343
871sg66
872(dp344
873S'field_type'
874p345
875S"'date'"
876p346
877sS'self'
878p347
879S'<pydal.parsers.ParserMethodWrapper object>'
880p348
881sS'self.call'
882p349
883S'<bound method ParserMethodWrapper._call of <pydal.parsers.ParserMethodWrapper object>>'
884p350
885sS'value'
886p351
887S"'20200101'"
888p352
889ssg72
890I75
891sg73
892(dp353
893I70
894S''
895sI71
896S'    def _call(self, value, field_type):'
897p354
898sI72
899S'        return self.f(self.parser, value)'
900p355
901sI73
902S''
903sI74
904S'    def __call__(self, value, field_type):'
905p356
906sI75
907S'        return self.call(value, field_type)'
908p357
909sI76
910S''
911sI77
912S''
913sI78
914S'class Parser(with_metaclass(MetaParser)):'
915p358
916sI79
917S'    def __init__(self, adapter):'
918p359
919ssg85
920S"(self=<pydal.parsers.ParserMethodWrapper object>, value='20200101', field_type='date')"
921p360
922sg87
923S'__call__'
924p361
925sa(dp362
926g64
927S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/__init__.py'
928p363
929sg66
930(dp364
931S'self'
932p365
933S'<pydal.parsers.ParserMethodWrapper object>'
934p366
935sS'self.f'
936p367
937S'<function _date>'
938p368
939sS'self.parser'
940p369
941S'<pydal.parsers.sqlite.SQLiteParser object>'
942p370
943sS'value'
944p371
945S"'20200101'"
946p372
947ssg72
948I72
949sg73
950(dp373
951I67
952S'    def _call_with_extras(self, value, field_type):'
953p374
954sI68
955S'        extras = self.extra(self.parser, field_type)'
956p375
957sI69
958S'        return self.f(self.parser, value, **extras)'
959p376
960sI70
961S''
962sI71
963S'    def _call(self, value, field_type):'
964p377
965sI72
966S'        return self.f(self.parser, value)'
967p378
968sI73
969S''
970sI74
971S'    def __call__(self, value, field_type):'
972p379
973sI75
974S'        return self.call(value, field_type)'
975p380
976sI76
977S''
978ssg85
979S"(self=<pydal.parsers.ParserMethodWrapper object>, value='20200101', field_type='date')"
980p381
981sg87
982S'_call'
983p382
984sa(dp383
985g64
986S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/sqlite.py'
987p384
988sg66
989(dp385
990S'self'
991p386
992S'<pydal.parsers.sqlite.SQLiteParser object>'
993p387
994sS'global DateParser'
995p388
996S"<class 'pydal.parsers.base.DateParser'>"
997p389
998sS'value'
999p390
1000S"'20200101'"
1001p391
1002sS'].f'
1003p392
1004g106
1005sS'DateParser._declared_parsers_'
1006p393
1007S"{'_date': <pydal.parsers.for_type object>}"
1008p394
1009ssg72
1010I25
1011sg73
1012(dp395
1013I20
1014S'        return Decimal(value)'
1015p396
1016sI21
1017S''
1018sI22
1019S"    @for_type('date')"
1020p397
1021sI23
1022S'    def _date(self, value):'
1023p398
1024sI24
1025S'        if not isinstance(value, date):'
1026p399
1027sI25
1028S"            return DateParser._declared_parsers_['_date'].f(self, value)"
1029p400
1030sI26
1031S'        return value'
1032p401
1033sI27
1034S''
1035sI28
1036S"    @for_type('datetime')"
1037p402
1038sI29
1039S'    def _datetime(self, value):'
1040p403
1041ssg85
1042S"(self=<pydal.parsers.sqlite.SQLiteParser object>, value='20200101')"
1043p404
1044sg87
1045S'_date'
1046p405
1047sa(dp406
1048g64
1049S'/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/base.py'
1050p407
1051sg66
1052(dp408
1053S'd'
1054g106
1055sS'].strip'
1056p409
1057S'<built-in method strip of str object>'
1058p410
1059sS'builtinstr'
1060p411
1061S"<type 'str'>"
1062p412
1063sS'm'
1064g106
1065sS'value'
1066p413
1067S"'20200101'"
1068p414
1069sS').split'
1070p415
1071g106
1072sS'y'
1073g106
1074sS'builtinint'
1075p416
1076S"<type 'int'>"
1077p417
1078sS'builtinmap'
1079p418
1080S'<built-in function map>'
1081p419
1082ssg72
1083I74
1084sg73
1085(dp420
1086I69
1087S'class DateParser(Parser):'
1088p421
1089sI70
1090S"    @for_type('date')"
1091p422
1092sI71
1093S'    def _date(self, value):'
1094p423
1095sI72
1096S'        if isinstance(value, datetime):'
1097p424
1098sI73
1099S'            return value.date()'
1100p425
1101sI74
1102S"        (y, m, d) = map(int, str(value)[:10].strip().split('-'))"
1103p426
1104sI75
1105S'        return date(y, m, d)'
1106p427
1107sI76
1108S''
1109sI77
1110S''
1111sI78
1112S'class TimeParser(Parser):'
1113p428
1114ssg85
1115S"(self=<pydal.parsers.sqlite.SQLiteParser object>, value='20200101')"
1116p429
1117sg87
1118g405
1119sasS'pyver'
1120p430
1121S'Python 2.7.17: /usr/bin/python (prefix: /usr)'
1122p431
1123sS'session'
1124p432
1125g59
1126(S's\\\x06\x00\x00<div><table><tr><td style="font-weight:bold;vertical-align:top;">chosenid</td><td style="vertical-align:top;">:</td><td><div>None</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">closureid</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">direction</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">enddate</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><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.closures.id&gt;0</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">lognum</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">route</td><td style="vertical-align:top;">:</td><td><div></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">startdate</td><td style="vertical-align:top;">:</td><td><div>2018-03-20</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">statuser</td><td style="vertical-align:top;">:</td><td><div>Joe</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">statustype</td><td style="vertical-align:top;">:</td><td><div>1022T5AA</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">username</td><td style="vertical-align:top;">:</td><td><div>a</div></td></tr></table></div>'
1127tRp433
1128sS'etype'
1129p434
1130S"<type 'exceptions.ValueError'>"
1131p435
1132sS'date'
1133p436
1134S'Thu Mar 19 15:32:29 2020'
1135p437
1136sS'response'
1137p438
1138g59
1139(S's\xae\x1e\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 0x7f7c90f71d30&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_multiform</td><td style="vertical-align:top;">:</td><td><div>127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359<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;">Content-Type</td><td style="vertical-align:top;">:</td><td><div>text/csv; charset=utf-8</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">Content-disposition</td><td style="vertical-align:top;">:</td><td><div>attachment; filename=db_closures.csv</div></td></tr><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><tr><td><div><table><tr><td><div>design</div></td></tr><tr><td><div>False</div></td></tr><tr><td><div>/admin/default/design/Multiform</div></td></tr></table></div></td></tr><tr><td><div><table><tr><td><div>db</div></td></tr><tr><td><div>False</div></td></tr><tr><td><div>/Multiform/appadmin/index</div></td></tr></table></div></td></tr><tr><td><div><table><tr><td><div>state</div></td></tr><tr><td><div>False</div></td></tr><tr><td><div>/Multiform/appadmin/state</div></td></tr></table></div></td></tr><tr><td><div><table><tr><td><div>cache</div></td></tr><tr><td><div>False</div></td></tr><tr><td><div>/Multiform/appadmin/ccache</div></td></tr></table></div></td></tr></table></div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">meta</td><td style="vertical-align:top;">:</td><td><div><table><tr><td style="font-weight:bold;vertical-align:top;">author</td><td style="vertical-align:top;">:</td><td><div>Author</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">description</td><td style="vertical-align:top;">:</td><td><div>describe your app</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">keywords</td><td style="vertical-align:top;">:</td><td><div>keyword</div></td></tr></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/csv/\\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_multiform</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/Multiform/sessions/17d/0fd/127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359&#x27;, mode &#x27;rb+&#x27; at 0x7f7c912abf60&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/Multiform/sessions/127.0.0.1-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">session_hash</td><td style="vertical-align:top;">:</td><td><div>a93a762ec2344630a984de4409e432f8</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-09ffaed9-b74c-4ca7-8ed7-d8d3639d8359</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_multiform</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>Multiform</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;">subtitle</td><td style="vertical-align:top;">:</td><td><div>Database Administration (appadmin)</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">title</td><td style="vertical-align:top;">:</td><td><div>Multiform</div></td></tr><tr><td style="font-weight:bold;vertical-align:top;">view</td><td style="vertical-align:top;">:</td><td><div>appadmin.html</div></td></tr></table></div>'
1140tRp439
1141sS'locals'
1142p440
1143(dp441
1144S'self'
1145p442
1146S'<pydal.parsers.sqlite.SQLiteParser object>'
1147p443
1148sS'value'
1149p444
1150S"'20200101'"
1151p445
1152sssS'traceback'
1153p446
1154S'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/Multiform/controllers/appadmin.py", line 695, in <module>\n  File "/home/jdalbey/Dropbox/web2py/gluon/globals.py", line 421, in <lambda>\n    self._caller = lambda f: f()\n  File "/home/jdalbey/Dropbox/web2py/applications/Multiform/controllers/appadmin.py", line 173, in csv\n    return str(db(query, ignore_common_filters=True).select())\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/objects.py", line 2395, in select\n    return adapter.select(self.query, fields, attributes)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/sqlite.py", line 82, in select\n    return super(SQLite, self).select(query, fields, attributes)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 763, in select\n    return self._select_aux(sql, fields, attributes, colnames)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 742, in _select_aux\n    return processor(rows, fields, colnames, cacheable=cacheable)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 306, in parse\n    for row in rows\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 232, in _parse\n    value = self.parse_value(value, fit, ft, blob_decode)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/adapters/base.py", line 199, in parse_value\n    return self.parser.parse(value, field_itype, field_type)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/__init__.py", line 100, in parse\n    return self.registered[field_itype](value, field_type)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/__init__.py", line 75, in __call__\n    return self.call(value, field_type)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/__init__.py", line 72, in _call\n    return self.f(self.parser, value)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/sqlite.py", line 25, in _date\n    return DateParser._declared_parsers_[\'_date\'].f(self, value)\n  File "/home/jdalbey/Dropbox/web2py/gluon/packages/dal/pydal/parsers/base.py", line 74, in _date\n    (y, m, d) = map(int, str(value)[:10].strip().split(\'-\'))\nValueError: need more than 1 value to unpack\n'
1155p447
1156s.
Note: See TracBrowser for help on using the repository browser.