diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-07-28 17:13:01 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-07-28 17:13:01 +0900 |
| commit | aadc8cf037855b99cb82798c7b0ebaafc5bb025b (patch) | |
| tree | 4ea9f9db9dbe7cf1b7720205ae281a6b8bcca8e9 /backend/query.sql | |
| parent | 90741e8336b4ffba090bf08c3b899992860e2d98 (diff) | |
| parent | 2d5f913a431c4223a16c88551ffff4100ac483c4 (diff) | |
| download | phperkaigi-2025-albatross-aadc8cf037855b99cb82798c7b0ebaafc5bb025b.tar.gz phperkaigi-2025-albatross-aadc8cf037855b99cb82798c7b0ebaafc5bb025b.tar.zst phperkaigi-2025-albatross-aadc8cf037855b99cb82798c7b0ebaafc5bb025b.zip | |
Merge branch 'game-entry'
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 165c2c9..9b038a5 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -8,3 +8,13 @@ SELECT * FROM users JOIN user_auths ON users.user_id = user_auths.user_id WHERE users.username = $1 LIMIT 1; + +-- name: ListGames :many +SELECT * FROM games +LEFT JOIN problems ON games.problem_id = problems.problem_id; + +-- name: ListGamesForPlayer :many +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; |