diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-10 19:55:28 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-10 19:55:50 +0900 |
| commit | 47f95342097e8828059053c168e06cd44e0ab43b (patch) | |
| tree | 843d09397ccc1e5ec36c926e3eb555e1d6e5ed52 /backend/query.sql | |
| parent | 0b520dc2529d7df6263842480d4ba7eaf07f4dcd (diff) | |
| download | phperkaigi-2025-albatross-47f95342097e8828059053c168e06cd44e0ab43b.tar.gz phperkaigi-2025-albatross-47f95342097e8828059053c168e06cd44e0ab43b.tar.zst phperkaigi-2025-albatross-47f95342097e8828059053c168e06cd44e0ab43b.zip | |
feat(backend): include `verification_steps` in `Game` object
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index 12b67b9..bcbee12 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -83,6 +83,11 @@ SELECT * FROM testcases WHERE testcases.problem_id = (SELECT problem_id FROM games WHERE game_id = $1) ORDER BY testcases.testcase_id; +-- name: ListTestcaseIDsByGameID :many +SELECT testcases.testcase_id 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); |