Sage-Bionetworks / synAnnotationUtils

Apache License 2.0
4 stars 2 forks source link

entity-view update synapse and row indices error #39

Closed teslajoy closed 7 years ago

teslajoy commented 7 years ago

I have two "main" functions for updating and expanding fields utilizing an existing entity-view on my branch (teslajoy-update) in synAnnotationUtils.

Main function

updateEntityView(syn, syn_id, path, clause=None)

Integration Test function

test_update_entityview()

Inside _checkSave() I call to drop synapse minimal function and essentially only keep 'etag' of each row to handle the row match. If I leave ROW_ID and ROW_VERSION columns, I get this error:

"because it is necessary for version tracking in Synapse's tables").format(col_name) ) SynapseError: A column named 'ROW_ID' already exists and does not match the 'ROW_ID' values present in the DataFrame's row names. Please refain from using or modifying 'ROW_ID' as a column for your data because it is necessary for version tracking in Synapse's tables

kdaily commented 7 years ago

Close this one @teslajoy?

teslajoy commented 7 years ago

yup :)