aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/query.sql
AgeCommit message (Collapse)Author
2026-02-20feat: add user submission history pagensfisis
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>
2026-02-20feat(admin): add bulk rejudge for game submissionsnsfisis
Extract common rejudge logic into a helper method and add two new endpoints: rejudge-latest (per-user latest only) and rejudge-all. This allows re-running submissions in bulk after testcase changes. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-20feat(admin): add rejudge functionality for submissionsnsfisis
Allow administrators to re-execute test cases for a specific submission from the submission detail page. This is useful after testcase fixes or worker issues. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-18feat: refactor tournament to generic DB-backed N-person bracketnsfisis
Replace hardcoded 6-person tournament with a generic single-elimination bracket system backed by new DB tables (tournaments, tournament_entries, tournament_matches). Includes admin CRUD, standard seeding algorithm, bye handling, and a CSS Grid bracket renderer on the frontend. Add comprehensive tests for backend API/admin handlers, seeding logic, and frontend bracket component. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2026-02-15refactor(auth): replace JWT authentication with server-side sessionsnsfisis
Migrate from stateless JWT tokens to server-side session management backed by PostgreSQL. Sessions are hashed with SHA-256 before storage, cleaned up periodically, and invalidated on logout. This removes the need for JWT_SECRET/COOKIE_SECRET environment variables and the golang-jwt dependency. Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
2025-09-17feat(backend): add admin pages for submissionsnsfisis
2025-09-06fix(*): support compile_error as worker resultnsfisis
2025-09-06feat(backend): update qualifying ranking pagensfisis
2025-09-06feat(backend): add admin pages for testcasesnsfisis
2025-09-06feat(backend): add admin page for game creationnsfisis
2025-09-06feat(backend): add admin page for problemsnsfisis
2025-04-02feat(backend): add admin tool to fix submission statusnsfisis
2025-04-02fix(backend): fix incorrect aggregation of testcase resultsnsfisis
2025-03-21fix(frontend): fix submission status flickeringnsfisis
2025-03-21feat(backend): limit ranking entriesnsfisis
2025-03-20fix(backend): fix online qualifying rankingnsfisis
2025-03-20feat(backend): add /admin/online-qualifying-rankingnsfisis
2025-03-20feat: show submission date on rankingnsfisis
2025-03-15feat(backen): allow admin to edit main playersnsfisis
2025-03-12feat(backend): implement user edit pagensfisis
2025-03-10refactor(backend): remove unused db queriesnsfisis
2025-03-08websocket to pollingnsfisis
2025-03-04rm registration tokennsfisis
2024-08-27Revert "."nsfisis
This reverts commit 534df5bd1a36bc7ba5ed76828e37ab6a1240f3c7.
2024-08-22.nsfisis
2024-08-17feat(backend): fetch user icon from forteensfisis
2024-08-17feat(backend): allow login/signup with email addressnsfisis
2024-08-12feat: do not show preliminary scorensfisis
2024-08-11feat(backend): make `games.problem_id` non-nullnsfisis
2024-08-10feat(backend): include `verification_steps` in `Game` objectnsfisis
2024-08-10feat(backend): include `players` in `Game` objectnsfisis
2024-08-09feat: support authentication via forteensfisis
2024-08-08feat(backend): add `code_hash` to `submissions` tablensfisis
2024-08-08feat(backend): aggregate testcase resultsnsfisis
2024-08-08feat(backend): create submission_results tablensfisis
2024-08-08feat(backend): rename testcase_executions to testcase_resultsnsfisis
2024-08-05fix(backend): fix an issue where listing query does not specify order by clausensfisis
2024-08-05feat(backend): implement task queue processornsfisis
2024-08-05feat(backend): wait for all players to enternsfisis
2024-08-05feat(backend): allow to edit `game_type` in admin pagensfisis
2024-08-01refactor(backend): `Id` to `ID` in sqlcnsfisis
2024-07-31feat: implement /admin/games and /admin/games/{gameId}nsfisis
2024-07-31feat: implement /admin/users pagensfisis
2024-07-29feat(backend): partially implement gamingnsfisis
2024-07-28feat: implement game entrynsfisis
2024-07-27backend: jwtnsfisis
2024-07-22user loginnsfisis
2024-07-21add sqldef and sqlcnsfisis