-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy patherrors.main.py~
127 lines (124 loc) · 7.55 KB
/
errors.main.py~
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 60, in <module>
completedRequest = processRequest.ProcessRequest(data)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 17, in ProcessRequest
sql_data = sql_utils.get_dict(sqlQuery)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sql_utils.py", line 25, in get_dict
cur.execute(query)
File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 222, in execute
return _cursor.execute(self, query, vars)
TypeError: argument 1 must be a string or unicode object
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 60, in <module>
completedRequest = processRequest.ProcessRequest(data)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 17, in ProcessRequest
sql_data = sql_utils.get_dict(sqlQuery)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sql_utils.py", line 25, in get_dict
cur.execute(query)
File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 222, in execute
return _cursor.execute(self, query, vars)
TypeError: argument 1 must be a string or unicode object
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 60, in <module>
completedRequest = processRequest.ProcessRequest(data)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 17, in ProcessRequest
sql_data = sql_utils.get_dict(sqlQuery)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sql_utils.py", line 25, in get_dict
cur.execute(query)
File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 222, in execute
return _cursor.execute(self, query, vars)
TypeError: argument 1 must be a string or unicode object
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 9, in <module>
import processRequest
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 4, in <module>
import sqlParmsToQuery
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sqlParmsToQuery.py", line 89
SELECT Site, DataSource,
^
IndentationError: unexpected indent
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 9, in <module>
import processRequest
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 4, in <module>
import sqlParmsToQuery
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sqlParmsToQuery.py", line 89
SELECT Site, DataSource,
^
IndentationError: unexpected indent
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 9, in <module>
import processRequest
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 4, in <module>
import sqlParmsToQuery
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sqlParmsToQuery.py", line 89
SELECT Site, DataSource,
^
IndentationError: unexpected indent
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 9, in <module>
import processRequest
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 4, in <module>
import sqlParmsToQuery
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sqlParmsToQuery.py", line 89
SELECT Site, DataSource,
^
IndentationError: unexpected indent
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 60, in <module>
completedRequest = processRequest.ProcessRequest(data)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 17, in ProcessRequest
sql_data = sql_utils.get_dict(sqlQuery)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sql_utils.py", line 25, in get_dict
cur.execute(query)
File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 222, in execute
return _cursor.execute(self, query, vars)
psycopg2.ProgrammingError: syntax error at or near "FROM"
LINE 1: ...2) - height)/0.9156 ) - height) > 65 THEN 'Extreme' FROM pet
^
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 60, in <module>
completedRequest = processRequest.ProcessRequest(data)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 17, in ProcessRequest
sql_data = sql_utils.get_dict(sqlQuery)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sql_utils.py", line 25, in get_dict
cur.execute(query)
File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 222, in execute
return _cursor.execute(self, query, vars)
psycopg2.ProgrammingError: column "width" does not exist
LINE 1: SELECT CASE WHEN ((((width/0.7062) - height)/0.9156 ) - heig...
^
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 60, in <module>
completedRequest = processRequest.ProcessRequest(data)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 15, in ProcessRequest
sqlQuery = sqlParmsToQuery.sqlParmsToQuery(sqlParms, dataInput)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sqlParmsToQuery.py", line 19, in sqlParmsToQuery
query = AnalysisType(loadedJson, inputParms)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sqlParmsToQuery.py", line 37, in AnalysisType
query = lookupType(loadedJson, inputParms)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sqlParmsToQuery.py", line 66, in lookupType
query = query + " WHERE " + inputParms
TypeError: unsupported operand type(s) for +: 'NoneType' and 'str'
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 60, in <module>
completedRequest = processRequest.ProcessRequest(data)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 17, in ProcessRequest
sql_data = sql_utils.get_dict(sqlQuery)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sql_utils.py", line 25, in get_dict
cur.execute(query)
File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 222, in execute
return _cursor.execute(self, query, vars)
psycopg2.ProgrammingError: can't execute an empty query
Traceback (most recent call last):
File "ClinicalAnalysisEngine/main.py", line 60, in <module>
completedRequest = processRequest.ProcessRequest(data)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/processRequest.py", line 17, in ProcessRequest
sql_data = sql_utils.get_dict(sqlQuery)
File "/home/colehoffele/Documents/CIS4250/ClinicalAnalysis/ClinicalAnalysisEngine/sql_utils.py", line 25, in get_dict
cur.execute(query)
File "/usr/lib/python3/dist-packages/psycopg2/extras.py", line 222, in execute
return _cursor.execute(self, query, vars)
psycopg2.ProgrammingError: column "width" does not exist
LINE 1: SELECT CASE WHEN ((((width/0.7062) - height)/0.9156 ) - heig...
^