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/db/query.sql.go | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

(limited to 'backend/db/query.sql.go')

diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go
index 404f5d9..b5fef29 100644
--- a/backend/db/query.sql.go
+++ b/backend/db/query.sql.go
@@ -242,6 +242,38 @@ func (q *Queries) ListUsers(ctx context.Context) ([]User, error) {
 	return items, nil
 }
 
+const updateGame = `-- name: UpdateGame :exec
+UPDATE games
+SET
+    state = $2,
+    display_name = $3,
+    duration_seconds = $4,
+    started_at = $5,
+    problem_id = $6
+WHERE game_id = $1
+`
+
+type UpdateGameParams struct {
+	GameID          int32
+	State           string
+	DisplayName     string
+	DurationSeconds int32
+	StartedAt       pgtype.Timestamp
+	ProblemID       *int32
+}
+
+func (q *Queries) UpdateGame(ctx context.Context, arg UpdateGameParams) error {
+	_, err := q.db.Exec(ctx, updateGame,
+		arg.GameID,
+		arg.State,
+		arg.DisplayName,
+		arg.DurationSeconds,
+		arg.StartedAt,
+		arg.ProblemID,
+	)
+	return err
+}
+
 const updateGameStartedAt = `-- name: UpdateGameStartedAt :exec
 UPDATE games
 SET started_at = $2
-- 
cgit v1.2.3-70-g09d2