diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-31 21:02:40 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-31 22:20:11 +0900 |
| commit | 3840c6d8e4261f182657b11ba55f61da04d70b28 (patch) | |
| tree | 253a3094f3606682982b91b9be7a03f1e4b3f723 /backend/query.sql | |
| parent | d9971c0443fae16af1e003c920f1347c9233b5ac (diff) | |
| download | phperkaigi-2025-albatross-3840c6d8e4261f182657b11ba55f61da04d70b28.tar.gz phperkaigi-2025-albatross-3840c6d8e4261f182657b11ba55f61da04d70b28.tar.zst phperkaigi-2025-albatross-3840c6d8e4261f182657b11ba55f61da04d70b28.zip | |
feat: implement /admin/games and /admin/games/{gameId}
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; |