From 534df5bd1a36bc7ba5ed76828e37ab6a1240f3c7 Mon Sep 17 00:00:00 2001 From: nsfisis Date: Thu, 22 Aug 2024 19:14:32 +0900 Subject: . --- backend/db/query.sql.go | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) (limited to 'backend/db/query.sql.go') diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 35b7edd..60438e8 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -374,8 +374,8 @@ func (q *Queries) ListGames(ctx context.Context) ([]ListGamesRow, error) { const listGamesForPlayer = `-- name: ListGamesForPlayer :many SELECT games.game_id, game_type, state, display_name, duration_seconds, created_at, started_at, games.problem_id, problems.problem_id, title, description, game_players.game_id, user_id FROM games 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 +LEFT JOIN game_players ON games.game_id = game_players.game_id +WHERE game_players.user_id = $1 OR games.game_id = 39 ORDER BY games.game_id ` @@ -391,8 +391,8 @@ type ListGamesForPlayerRow struct { ProblemID_2 int32 Title string Description string - GameID_2 int32 - UserID int32 + GameID_2 *int32 + UserID *int32 } func (q *Queries) ListGamesForPlayer(ctx context.Context, userID int32) ([]ListGamesForPlayerRow, error) { -- cgit v1.2.3-70-g09d2