From 5964fa404909550a2dd42a75633fef223fdb05fb Mon Sep 17 00:00:00 2001 From: nsfisis Date: Mon, 12 Aug 2024 01:23:54 +0900 Subject: feat: do not show preliminary score --- 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 408bf2d..25eb4df 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -78,6 +78,11 @@ INSERT INTO submissions (game_id, user_id, code, code_size, code_hash) VALUES ($1, $2, $3, $4, $5) RETURNING submission_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) -- cgit v1.2.3-70-g09d2