diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-05 05:35:45 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-05 05:35:45 +0900 |
| commit | b0ff29a3c88bd3014cc966c619683c8d7e33d703 (patch) | |
| tree | 529f1debc2972ac1486e8c0ca4b25827ccd069a6 /backend/query.sql | |
| parent | 9ff9c151e5defd9eed5cba3c88bc341b4360d09c (diff) | |
| parent | dc16e903999af89d87364ad6619e7c8b41301da4 (diff) | |
| download | phperkaigi-2025-albatross-b0ff29a3c88bd3014cc966c619683c8d7e33d703.tar.gz phperkaigi-2025-albatross-b0ff29a3c88bd3014cc966c619683c8d7e33d703.tar.zst phperkaigi-2025-albatross-b0ff29a3c88bd3014cc966c619683c8d7e33d703.zip | |
Merge branch 'feat/task-queue'
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index 245d5cf..6395b9b 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -53,3 +53,16 @@ SET started_at = $6, problem_id = $7 WHERE game_id = $1; + +-- name: CreateSubmission :one +INSERT INTO submissions (game_id, user_id, code, code_size) +VALUES ($1, $2, $3, $4) +RETURNING submission_id; + +-- name: ListTestcasesByGameID :many +SELECT * FROM testcases +WHERE testcases.problem_id = (SELECT problem_id FROM games WHERE game_id = $1); + +-- name: CreateTestcaseExecution :exec +INSERT INTO testcase_executions (submission_id, testcase_id, status, stdout, stderr) +VALUES ($1, $2, $3, $4, $5); |