aboutsummaryrefslogtreecommitdiffhomepage
path: root/backend/query.sql
AgeCommit message (Collapse)Author
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
generated by cgit v1.3.1 (git 2.54.0) at 2026-06-05 10:59:03 +0000