Challenge Overview
Currently in Topcoder Direct, Besides Marathon Match Challenge type, the Registrants tab is working properly.
For this challenge, we'd like to make the Registrants tab working the same as other challenge types for Marathon Match.
1. If the challenge has `Marathon Match Type` property (project_info_type_id=87), querying the registrants, the same as other challenge type, you probabily can reuse the existing functionality.
2. If the challenge has `Marathon Match Type` property, but the registrants list is empty, retry step 3
3. If the challenge has `Marathon Match Contest Id` property (project_info_type_id=86), querying the needed information of registrants from informixoltp:round_registration
4. If the challenge has `Marathon Match Id` property (project_info_type_id=56), this is the round id, so querying the registrants from informixoltp:round_registration
5. For Ratings, please use the Marathon Match Ratings purposely
6. For Submission Date, one registrant can have 0 or more than 1 submissions, please use the latest submission date for displaying.
7. Reference queries you can learn from
- https://github.com/topcoder-platform/tc-database-scripts/blob/dev/informixoltp/query_tool/query_long_contest_all_submissions.txt
- https://github.com/topcoder-platform/tc-database-scripts/blob/dev/informixoltp/query_tool/query_long_contest_coder_submissions_info.txt
Local Setup
- Please follow Build and Run with Docker compose to run the direct app locally
- Verification Steps (please directly use queries to change the state of the challenges, so you can test these different cases)
For this challenge, we'd like to make the Registrants tab working the same as other challenge types for Marathon Match.
1. If the challenge has `Marathon Match Type` property (project_info_type_id=87), querying the registrants, the same as other challenge type, you probabily can reuse the existing functionality.
2. If the challenge has `Marathon Match Type` property, but the registrants list is empty, retry step 3
3. If the challenge has `Marathon Match Contest Id` property (project_info_type_id=86), querying the needed information of registrants from informixoltp:round_registration
4. If the challenge has `Marathon Match Id` property (project_info_type_id=56), this is the round id, so querying the registrants from informixoltp:round_registration
5. For Ratings, please use the Marathon Match Ratings purposely
6. For Submission Date, one registrant can have 0 or more than 1 submissions, please use the latest submission date for displaying.
7. Reference queries you can learn from
- https://github.com/topcoder-platform/tc-database-scripts/blob/dev/informixoltp/query_tool/query_long_contest_all_submissions.txt
- https://github.com/topcoder-platform/tc-database-scripts/blob/dev/informixoltp/query_tool/query_long_contest_coder_submissions_info.txt
Local Setup
- Please follow Build and Run with Docker compose to run the direct app locally
Final Submission Guidelines
- Code Changes- Verification Steps (please directly use queries to change the state of the challenges, so you can test these different cases)