diff options
| author | nsfisis <nsfisis@gmail.com> | 2026-02-20 23:32:22 +0900 |
|---|---|---|
| committer | nsfisis <nsfisis@gmail.com> | 2026-02-20 23:32:22 +0900 |
| commit | 8e73d12a703e90ad908962143951178c13d0d6fe (patch) | |
| tree | 8bed43aa4b115f8bc50ed258aa192a94b6d2903e /backend/query.sql | |
| parent | aa07ba2e0a40b0097a4f9aee3c06dcbd9a749105 (diff) | |
| download | phperkaigi-2026-albatross-8e73d12a703e90ad908962143951178c13d0d6fe.tar.gz phperkaigi-2026-albatross-8e73d12a703e90ad908962143951178c13d0d6fe.tar.zst phperkaigi-2026-albatross-8e73d12a703e90ad908962143951178c13d0d6fe.zip | |
feat: add user submission history page
Allow users to view their own past submissions (code, size, status,
timestamp) for each game. Adds API endpoint, backend handler, SQL query,
and frontend page with expandable code display.
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
Diffstat (limited to 'backend/query.sql')
| -rw-r--r-- | backend/query.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/backend/query.sql b/backend/query.sql index 45ac46f..c791c27 100644 --- a/backend/query.sql +++ b/backend/query.sql @@ -259,6 +259,11 @@ WHERE testcase_id = $1; DELETE FROM testcases WHERE testcase_id = $1; +-- name: GetSubmissionsByGameIDAndUserID :many +SELECT * FROM submissions +WHERE game_id = $1 AND user_id = $2 +ORDER BY created_at DESC; + -- name: GetSubmissionsByGameID :many SELECT * FROM submissions |