From c807d6e47b11a91ec56225ed8358e3f2ef903e5c Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Mon, 10 Mar 2025 00:25:42 +0900
Subject: refactor(backend): remove unused db queries

---
 backend/query.sql | 15 ---------------
 1 file changed, 15 deletions(-)

(limited to 'backend/query.sql')

diff --git a/backend/query.sql b/backend/query.sql
index 192bf41..dbf050b 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -70,26 +70,11 @@ JOIN users ON game_main_players.user_id = users.user_id
 WHERE game_main_players.game_id = ANY($1::INT[])
 ORDER BY game_main_players.user_id;
 
--- name: ListMainPlayerIDs :many
-SELECT user_id FROM game_main_players
-WHERE game_id = $1
-ORDER BY user_id;
-
--- name: GetSubmissionCodeSizeByID :one
-SELECT code_size FROM submissions
-WHERE submission_id = $1
-LIMIT 1;
-
 -- name: ListTestcasesByGameID :many
 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: CreateTestcaseResult :exec
 INSERT INTO testcase_results (submission_id, testcase_id, status, stdout, stderr)
 VALUES ($1, $2, $3, $4, $5);
-- 
cgit v1.2.3-70-g09d2

