diff options
Diffstat (limited to 'backend/db/query.sql.go')
| -rw-r--r-- | backend/db/query.sql.go | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 50aa02e..8a13726 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -293,6 +293,15 @@ func (q *Queries) DeleteTestcase(ctx context.Context, testcaseID int32) error { return err } +const deleteTestcaseResultsBySubmissionID = `-- name: DeleteTestcaseResultsBySubmissionID :exec +DELETE FROM testcase_results WHERE submission_id = $1 +` + +func (q *Queries) DeleteTestcaseResultsBySubmissionID(ctx context.Context, submissionID int32) error { + _, err := q.db.Exec(ctx, deleteTestcaseResultsBySubmissionID, submissionID) + return err +} + const deleteTournamentEntries = `-- name: DeleteTournamentEntries :exec DELETE FROM tournament_entries WHERE tournament_id = $1 |