🐛 Surgery table is not able to be updated

[lindaxiang]

Describe the bug

The surgery table is not able to be updated once submitted.

Steps To Reproduce

Steps to reproduce the behaviour:

1. Go to 'https://platform-ui.argo-qa.cumulus.genomeinformatics.org/'
2. Click on project 'PACA-CA' or other projects
3. If you already have surgery records submitted
4. Re-submit the surgery table with or without changes
5. Click the Validate submission button
6. it will give the error message:
   The submitter_specimen_id '*****' has already been associated with a surgery in the current or previous submission. Specimen can only be submitted once for a single surgery.

Expected behaviour

The surgery table should be updated accordingly without errors.

[demariadaniel]

Bug is actually the result of existing validation created in:
https://app.zenhub.com/workspaces/icgc-argo-platform-dk-production-board-5e542d38415f5034e9fed89d/issues/gh/icgc-argo/argo-clinical/773

&

#738

Will need to discuss solution that allows updating existing records, without creating duplicates
Any current issues with existing records can be resolved by deleting records & resubmitting

[demariadaniel]

Tested successful update scenario:

[demariadaniel]

Update success case TSV file:
surgery_resubmit_test1_update.txt

(tsv is not supported by zenhub, converted to txt)

[demariadaniel]

Validation successfully shows error for duplicate record:

[demariadaniel]

Error case record:

surgery_resubmit_test2_duplicate.txt