diff options
| author | nsfisis <nsfisis@gmail.com> | 2024-08-10 14:06:28 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2024-08-10 19:55:45 +0900 |
| commit | 0b520dc2529d7df6263842480d4ba7eaf07f4dcd (patch) | |
| tree | 4a015b17210ba1d61ca98d2e18e339c817016f8c /backend/db/query.sql.go | |
| parent | a8f2594e8dcb741fb942092cbc53d64cf93132ef (diff) | |
| download | phperkaigi-2025-albatross-0b520dc2529d7df6263842480d4ba7eaf07f4dcd.tar.gz phperkaigi-2025-albatross-0b520dc2529d7df6263842480d4ba7eaf07f4dcd.tar.zst phperkaigi-2025-albatross-0b520dc2529d7df6263842480d4ba7eaf07f4dcd.zip | |
feat(backend): include `players` in `Game` object
Diffstat (limited to 'backend/db/query.sql.go')
| -rw-r--r-- | backend/db/query.sql.go | 10 |
1 files changed, 5 insertions, 5 deletions
diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 47140fc..392e6a6 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -248,7 +248,7 @@ func (q *Queries) IsRegistrationTokenValid(ctx context.Context, token string) (b const listGamePlayers = `-- name: ListGamePlayers :many SELECT game_id, game_players.user_id, users.user_id, username, display_name, icon_path, is_admin, created_at FROM game_players -LEFT JOIN users ON game_players.user_id = users.user_id +JOIN users ON game_players.user_id = users.user_id WHERE game_players.game_id = $1 ORDER BY game_players.user_id ` @@ -256,11 +256,11 @@ ORDER BY game_players.user_id type ListGamePlayersRow struct { GameID int32 UserID int32 - UserID_2 *int32 - Username *string - DisplayName *string + UserID_2 int32 + Username string + DisplayName string IconPath *string - IsAdmin *bool + IsAdmin bool CreatedAt pgtype.Timestamp } |