aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/db/query.sql.go
diff options
context:
space:
mode:
authornsfisis <nsfisis@gmail.com>2026-02-20 21:30:49 +0900
committernsfisis <nsfisis@gmail.com>2026-02-20 21:30:49 +0900
commitfa788237eb5649e08b2a38ec21689b481b10c073 (patch)
tree13ad37ff587b81810f59e8e7c5943aafd25f61dd /backend/db/query.sql.go
parent9f9efc2bc07810d2e06b37bad94e5922681eadef (diff)
downloadphperkaigi-2026-albatross-fa788237eb5649e08b2a38ec21689b481b10c073.tar.gz
phperkaigi-2026-albatross-fa788237eb5649e08b2a38ec21689b481b10c073.tar.zst
phperkaigi-2026-albatross-fa788237eb5649e08b2a38ec21689b481b10c073.zip
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 <noreply@anthropic.com>
Diffstat (limited to 'backend/db/query.sql.go')
-rw-r--r--backend/db/query.sql.go9
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