Sage-Bionetworks / synAnnotationUtils

Apache License 2.0
4 stars 2 forks source link

annotation queries against file views #20

Closed kkdang closed 6 years ago

kkdang commented 7 years ago

All uses of select * from file where x=y that pull things down by annotations need to change to pull from the relevant file view entity.

teslajoy commented 7 years ago

Currently file view file entity synId retrieval only works if the file view and its associated schema exists (i.e. Schema class doesn't take a file view synId as a parameter). Also, still need to iter over all files individually to update their associated annotation. After parallelization we can change the code to update a chunk at once. - with python client. restful API may help to just parse through the data frame and post to file view.

teslajoy commented 6 years ago

can pass a sql clause as value see https://github.com/Sage-Bionetworks/synAnnotationUtils/blob/master/synAnnotationUtils/update.py