fix(frontend): fix submission status flickering

1 files changed, 25 insertions, 0 deletions

diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go
index abf2631..da13f33 100644
--- a/backend/db/query.sql.go
+++ b/backend/db/query.sql.go
@@ -343,6 +343,7 @@ JOIN users ON game_states.user_id = users.user_id
 JOIN submissions ON game_states.best_score_submission_id = submissions.submission_id
 WHERE game_states.game_id = $1
 ORDER BY submissions.code_size ASC, submissions.created_at ASC
+LIMIT 30
 `
 
 type GetRankingRow struct {
@@ -716,6 +717,30 @@ func (q *Queries) UpdateCode(ctx context.Context, arg UpdateCodeParams) error {
 	return err
 }
 
+const updateCodeAndStatus = `-- name: UpdateCodeAndStatus :exec
+INSERT INTO game_states (game_id, user_id, code, status)
+VALUES ($1, $2, $3, $4)
+ON CONFLICT (game_id, user_id)
+DO UPDATE SET code = EXCLUDED.code, status = EXCLUDED.status
+`
+
+type UpdateCodeAndStatusParams struct {
+	GameID int32
+	UserID int32
+	Code   string
+	Status string
+}
+
+func (q *Queries) UpdateCodeAndStatus(ctx context.Context, arg UpdateCodeAndStatusParams) error {
+	_, err := q.db.Exec(ctx, updateCodeAndStatus,
+		arg.GameID,
+		arg.UserID,
+		arg.Code,
+		arg.Status,
+	)
+	return err
+}
+
 const updateGame = `-- name: UpdateGame :exec
 UPDATE games
 SET