diff options
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index b4b589c..1e49780 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -271,6 +271,9 @@ FROM submissions WHERE submission_id = $1 LIMIT 1; +-- name: DeleteTestcaseResultsBySubmissionID :exec +DELETE FROM testcase_results WHERE submission_id = $1; + -- name: GetTestcaseResultsBySubmissionID :many SELECT * FROM testcase_results |