def update_score_in_contest(self,
problem_alias,
contest_alias,
verdict='AC',
score=1):
'''Set verdict and score of latest run'''
run_id = database_utils.mysql(('''
SELECT
MAX(`r`.`run_id`)
FROM
`Runs` AS `r`
INNER JOIN
`Problems` AS `p` ON
`p`.`problem_id` = `r`.`problem_id`
INNER JOIN
`Problemsets` AS `ps` ON
`ps`.`problemset_id` = `r`.`problemset_id`
INNER JOIN
`Contests` AS `c` ON `c`.`acl_id` = `ps`.`acl_id`
WHERE
`p`.`alias` = '%s'
AND `c`.`alias` = '%s';
''') % (problem_alias, contest_alias),
dbname='omegaup',
auth=self.mysql_auth())
self.update_run_score(int(run_id.strip()), verdict, score)
def update_run_score(self, run_id, verdict, score):
'''Set verdict and score of specified run'''
database_utils.mysql(('''
UPDATE
`Runs`
SET
`score` = %s,
`contest_score` = %s,
`verdict` = '%s',
`status` = 'ready'
WHERE
`run_id` = %s;
''') % (str(score), str(score * 100), verdict, str(run_id)),
dbname='omegaup',
auth=self.mysql_auth())
