From c807d6e47b11a91ec56225ed8358e3f2ef903e5c Mon Sep 17 00:00:00 2001 From: nsfisis 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