As a user, I want ranking can be update by match so that I can see the ranking for real time

Acceptance Criteria

• When the user clicks the "Update" button, the system performs a join query to calculate the latest rankings based on match results.
• The updated ranking data is immediately reflected in the UI.
• Rankings are calculated correctly according to the match results.
• The ranking data in the system is consistent with the match results after the update
• The data update operation does not introduce duplicates or incorrect rankings.

Tasks

• Design and implement the SQL join query to calculate rankings based on match results and existing ranking data.
• Create an endpoint that triggers the ranking update process.
• Integrate the join query into the backend logic.
• Add an "Update" button in the UI.
• Implement the logic to call the backend API when the button is clicked.

changed due date to December 11, 2024

changed milestone to %Sprint4

set weight to 3

assigned to @c24058946

changed the description

created branch 73-as-a-user-i-want-ranking-can-be-update-by-match-so-that-i-can-see-the-ranking-for-real-time to address this issue

mentioned in merge request !57 (merged)

mentioned in commit 9f668a3a

closed with merge request !57 (merged)

reopened

marked the checklist item When the user clicks the "Update" button, the system performs a join query to calculate the latest rankings based on match results. as completed

marked the checklist item The updated ranking data is immediately reflected in the UI. as completed

marked the checklist item Rankings are calculated correctly according to the match results. as completed

marked the checklist item The ranking data in the system is consistent with the match results after the update as completed

marked the checklist item The data update operation does not introduce duplicates or incorrect rankings. as completed

marked the checklist item Design and implement the SQL join query to calculate rankings based on match results and existing ranking data. as completed

marked the checklist item Create an endpoint that triggers the ranking update process. as completed

marked the checklist item Integrate the join query into the backend logic. as completed

marked the checklist item Add an "Update" button in the UI. as completed

marked the checklist item Implement the logic to call the backend API when the button is clicked. as completed