Merge branch 'feat/watch-page'

1 files changed, 31 insertions, 5 deletions

diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go
index 47140fc..cbef51d 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
 }
 
@@ -403,6 +403,32 @@ func (q *Queries) ListGamesForPlayer(ctx context.Context, userID int32) ([]ListG
 	return items, nil
 }
 
+const listTestcaseIDsByGameID = `-- name: ListTestcaseIDsByGameID :many
+SELECT testcases.testcase_id FROM testcases
+WHERE testcases.problem_id = (SELECT problem_id FROM games WHERE game_id = $1)
+ORDER BY testcases.testcase_id
+`
+
+func (q *Queries) ListTestcaseIDsByGameID(ctx context.Context, gameID int32) ([]int32, error) {
+	rows, err := q.db.Query(ctx, listTestcaseIDsByGameID, gameID)
+	if err != nil {
+		return nil, err
+	}
+	defer rows.Close()
+	var items []int32
+	for rows.Next() {
+		var testcase_id int32
+		if err := rows.Scan(&testcase_id); err != nil {
+			return nil, err
+		}
+		items = append(items, testcase_id)
+	}
+	if err := rows.Err(); err != nil {
+		return nil, err
+	}
+	return items, nil
+}
+
 const listTestcasesByGameID = `-- name: ListTestcasesByGameID :many
 SELECT testcase_id, problem_id, stdin, stdout FROM testcases
 WHERE testcases.problem_id = (SELECT problem_id FROM games WHERE game_id = $1)