From 47f95342097e8828059053c168e06cd44e0ab43b Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Sat, 10 Aug 2024 19:55:28 +0900
Subject: feat(backend): include `verification_steps` in `Game` object

---
 backend/query.sql | 5 +++++
 1 file changed, 5 insertions(+)

(limited to 'backend/query.sql')

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);
-- 
cgit v1.3.1

