diff options
| author | nsfisis <nsfisis@gmail.com> | 2026-02-20 21:30:49 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2026-02-20 21:30:49 +0900 |
| commit | fa788237eb5649e08b2a38ec21689b481b10c073 (patch) | |
| tree | 13ad37ff587b81810f59e8e7c5943aafd25f61dd /backend/query.sql | |
| parent | 9f9efc2bc07810d2e06b37bad94e5922681eadef (diff) | |
| download | phperkaigi-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/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 |