It's conceivable that users might decide to alter their submission before the deadline. In these cases, we should always accept the most recent submission from the user. This logic should be implemented as a DISTINCT clause on the query to retrieve submissions for score calculations.
[x] #23
[x] Modify retrieval of submissions to use DISTINCT ON (submission.user_id, submission.game_id, submission.round_number) ORDER BY timestamp DESC
It's conceivable that users might decide to alter their submission before the deadline. In these cases, we should always accept the most recent submission from the user. This logic should be implemented as a
DISTINCTclause on the query to retrieve submissions for score calculations.DISTINCT ON (submission.user_id, submission.game_id, submission.round_number) ORDER BY timestamp DESC