Allow user to delete their problem #524
Description
Currently, normal users cannot delete their own problems.
We could allow this easily (available in admin-ui already), but there are a few concerns:
- Deleting a problem will also delete all related submissions due to cascading deletes. This could be slow and may cause high CPU/database usage to the server.
- The same issue applies to contests and contest participations linked to the problem.
There is many way to approach this:
- To perform deletions asynchronously (e.g. put the delete job into a Celery queue)
- Or mark problem as deleted (more field) without actually delete it
- Or allow submission.problem field to be null
- ...
How should we do it will be discuss later when we implement this
_raw_delete