TODOs

[martian0x80]

• Invalid Prometheus exports from the opentelemetry-dotnet implementation causes Prometheus scraper and Grafana to stop API metrics.

• Use a reverse proxy and load balancer (YARP, caddy, nginx). Using Traefik now.

• Add CI/CD pipeline to containerize the web app, push to docker registry and deploy via ssh to the new vps.

• Revised results sometimes may be released with paperid as subcode.
  

• If GetSubjectByEnrollment returns null, then query without 'progcode in paperid/subcode' condition.
  Affected Enrollment No. - 00114815923.

• Change the query for GetInstitutesByProgramme such that it uses student table rather than the junction table, and evaluate the redundancy based on the performance. Will remove the junction table pipeline job, if it's viable.

• Overall ranklist sometimes returns incorrect data for certain students, wrong semester GPA for any random semester averages the CGPA to a very low value (peaks in the gpa/percentage line chart are the evidence).
  Affected page example:
  https://{{baseUrl}}/rank/instcode=248&progcode=020&batch=2020&pageNumber=0&pageSize=100/
  

• Support for profile data aggregation based on SID when transfer status is passed. This should allow for accurate student data retrieval for upgradation/transfer students.

• Add avgGPA key to both ranklist responses for the reference line in the ranklist line chart.

• Add an ordered GPA list for all students to the ranklist response for an accurate line chart irrespective of pagination status.