diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-31 22:20:35 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-31 22:20:35 +0900 |
| commit | 4aff0feca72da0175dcecb44aca9b3e30c861bc5 (patch) | |
| tree | 253a3094f3606682982b91b9be7a03f1e4b3f723 /backend/query.sql | |
| parent | 715651d6d263c5f526e8e13a8e2bb032193c5218 (diff) | |
| parent | 3840c6d8e4261f182657b11ba55f61da04d70b28 (diff) | |
| download | phperkaigi-2025-albatross-4aff0feca72da0175dcecb44aca9b3e30c861bc5.tar.gz phperkaigi-2025-albatross-4aff0feca72da0175dcecb44aca9b3e30c861bc5.tar.zst phperkaigi-2025-albatross-4aff0feca72da0175dcecb44aca9b3e30c861bc5.zip | |
Merge branch 'feat/admin-games-page'
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 10 |
1 files changed, 10 insertions, 0 deletions
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; |