-
Notifications
You must be signed in to change notification settings - Fork 411
Description
in AtCoder contest format I'm change judge/contest_format/atcoder.py from
with connection.cursor() as cursor: cursor.execute(f""" SELECT MAX(cs.points) as
score, ( SELECT MIN(csub.date) FROM judge_contestsubmission ccs LEFT OUTER JOIN judge_submission csub ON (csub.id = ccs.submission_id) WHERE ccs.problem_id = cp.id AND ccs.participation_id = %s AND ccs.points = MAX(cs.points) ) AS
time, cp.id AS
probFROM judge_contestproblem cp INNER JOIN judge_contestsubmission cs ON (cs.problem_id = cp.id AND cs.participation_id = %s) LEFT OUTER JOIN judge_submission sub ON (sub.id = cs.submission_id) GROUP BY cp.id """, (participation.id, participation.id))
to
with connection.cursor() as cursor: cursor.execute(f""" SELECT MIN(cs.points) as
score, ( SELECT MIN(csub.date) FROM judge_contestsubmission ccs LEFT OUTER JOIN judge_submission csub ON (csub.id = ccs.submission_id) WHERE ccs.problem_id = cp.id AND ccs.participation_id = %s AND ccs.points = MIN(cs.points) ) AS
time, cp.id AS
probFROM judge_contestproblem cp INNER JOIN judge_contestsubmission cs ON (cs.problem_id = cp.id AND cs.participation_id = %s) LEFT OUTER JOIN judge_submission sub ON (sub.id = cs.submission_id) GROUP BY cp.id """, (participation.id, participation.id))
to get submission with a minimum number of points in leader board.
But I still see in the leaderboard that users have submission with the maximum number of points.