From 3840c6d8e4261f182657b11ba55f61da04d70b28 Mon Sep 17 00:00:00 2001
From: nsfisis <nsfisis@gmail.com>
Date: Wed, 31 Jul 2024 21:02:40 +0900
Subject: feat: implement /admin/games and /admin/games/{gameId}

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

(limited to 'backend/query.sql')

diff --git a/backend/query.sql b/backend/query.sql
index ca2095c..ed8c7bc 100644
--- a/backend/query.sql
+++ b/backend/query.sql
@@ -37,3 +37,13 @@ SELECT * FROM games
 LEFT JOIN problems ON games.problem_id = problems.problem_id
 WHERE games.game_id = $1
 LIMIT 1;
+
+-- name: UpdateGame :exec
+UPDATE games
+SET
+    state = $2,
+    display_name = $3,
+    duration_seconds = $4,
+    started_at = $5,
+    problem_id = $6
+WHERE game_id = $1;
-- 
cgit v1.2.3-70-g09d2

