diff options
| author | Claude <noreply@anthropic.com> | 2026-03-20 01:49:35 +0000 |
|---|---|---|
| committer | Claude <noreply@anthropic.com> | 2026-03-20 01:49:35 +0000 |
| commit | 7f06648cf2f5cb63a52465f1b57a081a1ed7e0ea (patch) | |
| tree | afe3044f2d76e6f05e41eb2654b3011d7f7a028a /backend/db/query.sql.go | |
| parent | d8804372262167d248170aea30a4a9ffc2e4ace2 (diff) | |
| download | phperkaigi-2026-albatross-7f06648cf2f5cb63a52465f1b57a081a1ed7e0ea.tar.gz phperkaigi-2026-albatross-7f06648cf2f5cb63a52465f1b57a081a1ed7e0ea.tar.zst phperkaigi-2026-albatross-7f06648cf2f5cb63a52465f1b57a081a1ed7e0ea.zip | |
提出結果の取得を最新50件に制限
プレイ画面の提出結果一覧が際限なく増えるのを防ぐため、
GetSubmissionsByGameIDAndUserID クエリに LIMIT 50 を追加。
https://claude.ai/code/session_015rm8yZD4va9hRH429u9N6q
Diffstat (limited to 'backend/db/query.sql.go')
| -rw-r--r-- | backend/db/query.sql.go | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/db/query.sql.go b/backend/db/query.sql.go index 80cbc16..0d1c018 100644 --- a/backend/db/query.sql.go +++ b/backend/db/query.sql.go @@ -709,6 +709,7 @@ const getSubmissionsByGameIDAndUserID = `-- name: GetSubmissionsByGameIDAndUserI SELECT submission_id, game_id, user_id, code, code_size, status, created_at FROM submissions WHERE game_id = $1 AND user_id = $2 ORDER BY created_at DESC +LIMIT 50 ` type GetSubmissionsByGameIDAndUserIDParams struct { |