scalableminds / webknossos

Visualize, share and annotate your large 3D images online
https://webknossos.org
GNU Affero General Public License v3.0
126 stars 23 forks source link

Allow to delete/archive voxelytics workflow reports #7973

Open fm3 opened 3 months ago

fm3 commented 3 months ago

Occasionally, users want to delete voxelytics workflow reports to avoid sharing secret information. We should have a look how such a functionality would fit in.

Tobias314 commented 2 months ago

+1

Tobias314 commented 2 months ago

For internal use, there is now an SQL script available under: https://www.notion.so/scalableminds/Webknossos-Move-Voxelytics-Runs-Between-Orgnizations-fd44fef189224589b699c6287f9d4860?pvs=4

fm3 commented 1 week ago

I’d say a delete route makes sense. Delete by hash. Only allowed for superusers. Use hard DELETE in postgres. This needs to cascade to all voxelytics tables. If the _voxelytics_workflowHash is referenced in the jobs tables, set it to NULL there.

Add a button in frontend in workflow view, with confirm modal.

an isDeleted boolean would not work well, because the hash would stay reserved. I think a hard delete is ok.