Not recognizable column in query result
Description
This change in PLFM added a new field in the SelectColumn object: https://github.com/Sage-Bionetworks/Synapse-Repository-Services/pull/3348/files#diff-3391b309663d046c639a8b5ad69aa0d1
The Python client code does not recognize the new field. This cause error running table query against staging in both R and Python client. My test against staging:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
>>> import synapseclient
>>> syn = synapseclient.login()
Welcome, Kimyen Truong!
>>> syn.repoEndpoint
'https://repo-staging.prod.sagebase.org/repo/v1'
>>> qr = syn.tableQuery("select * from syn11213698 limit 1")
[####################]100.00% 1/1 Done...
Downloading [####################]100.00% 50.0bytes/50.0bytes (19.1kB/s) Job-67571347474773473790060892.csv Done...
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/Users/kimyentruong/Documents/synapsePythonClient/synapseclient/client.py", line 2876, in tableQuery
return CsvFileTable.from_table_query(self, query, **kwargs)
File "/Users/kimyentruong/Documents/synapsePythonClient/synapseclient/table.py", line 1558, in from_table_query
headers=[SelectColumn(**header) for header in download_from_table_result['headers']])
File "/Users/kimyentruong/Documents/synapsePythonClient/synapseclient/table.py", line 1558, in <listcomp>
headers=[SelectColumn(**header) for header in download_from_table_result['headers']])
TypeError: __init__() got an unexpected keyword argument 'columnSQL'
>>>If we release staging without a fix, all table queries in the Python client and synapser client will be broken.
Environment
Status
Assignee
Kimyen Truong
Reporter
Kimyen Truong
Validator
Ziming Dong
Epic Link
Fix versions
Priority
Critical