diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-07 23:22:07 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-08 04:02:37 +0900 |
| commit | 47d81ffbd3e4fe178d2935325e312cef77276250 (patch) | |
| tree | 341f7aaa3429dbecc60cbfad0a84e6846152814e /backend/query.sql | |
| parent | 14f48b4e4f7463e0972c2a5b39e94ee674ec93ba (diff) | |
| download | phperkaigi-2025-albatross-47d81ffbd3e4fe178d2935325e312cef77276250.tar.gz phperkaigi-2025-albatross-47d81ffbd3e4fe178d2935325e312cef77276250.tar.zst phperkaigi-2025-albatross-47d81ffbd3e4fe178d2935325e312cef77276250.zip | |
feat(backend): create submission_results table
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index 493fdb8..0d32944 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -68,6 +68,10 @@ SELECT * FROM testcases WHERE testcases.problem_id = (SELECT problem_id FROM games WHERE game_id = $1) ORDER BY testcases.testcase_id; +-- name: CreateSubmissionResult :exec +INSERT INTO submission_results (submission_id, status, stdout, stderr) +VALUES ($1, $2, $3, $4); + -- name: CreateTestcaseResult :exec INSERT INTO testcase_results (submission_id, testcase_id, status, stdout, stderr) VALUES ($1, $2, $3, $4, $5); |