From 2d5f913a431c4223a16c88551ffff4100ac483c4 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Sun, 28 Jul 2024 16:01:41 +0900 Subject: feat: implement game entry --- backend/query.sql | 10 ++++++++++ 1 file changed, 10 insertions(+) (limited to 'backend/query.sql') 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; -- cgit v1.2.3-70-g09d2