diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-28 20:09:09 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-29 02:32:26 +0900 |
| commit | daaf81ae931654e20f882fbc6bbc4a02cbfc0273 (patch) | |
| tree | 2d0eb7c9f40e28a4295dc1065c80d5d891a8995a /backend/query.sql | |
| parent | 0b90018afbd438d61db7b41e5c3ea41cbb563bfe (diff) | |
| download | phperkaigi-2025-albatross-daaf81ae931654e20f882fbc6bbc4a02cbfc0273.tar.gz phperkaigi-2025-albatross-daaf81ae931654e20f882fbc6bbc4a02cbfc0273.tar.zst phperkaigi-2025-albatross-daaf81ae931654e20f882fbc6bbc4a02cbfc0273.zip | |
feat(backend): partially implement gaming
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index 9b038a5..b2ad2c4 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -18,3 +18,19 @@ SELECT * FROM games LEFT JOIN problems ON games.problem_id = problems.problem_id JOIN game_players ON games.game_id = game_players.game_id WHERE game_players.user_id = $1; + +-- name: UpdateGameState :exec +UPDATE games +SET state = $2 +WHERE game_id = $1; + +-- name: UpdateGameStartedAt :exec +UPDATE games +SET started_at = $2 +WHERE game_id = $1; + +-- name: GetGameById :one +SELECT * FROM games +LEFT JOIN problems ON games.problem_id = problems.problem_id +WHERE games.game_id = $1 +LIMIT 1; |