From fa788237eb5649e08b2a38ec21689b481b10c073 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Fri, 20 Feb 2026 21:30:49 +0900 Subject: feat(admin): add rejudge functionality for submissions Allow administrators to re-execute test cases for a specific submission from the submission detail page. This is useful after testcase fixes or worker issues. Co-Authored-By: Claude Opus 4.6 --- backend/db/query.sql.go | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'backend/db/query.sql.go') 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 -- cgit v1.3.1