+ my ($id) = @_;
+ my $ret = add_names query(job_entry_sth => $id)->hash;
+ $ret->{results} = decode_json $ret->{results} if $ret->{results};
+ $ret
+}
+
+sub job_full {
+ my ($id) = @_;
+ scalar query(job_full_sth => $id)->hash
+}
+
+sub create_job {
+ my (%args) = @_;
+ $db->update('users', {lastjob => time});
+ purge '/log/';
+ scalar $db->insert('jobs', \%args, {returning => 'id'})->list
+}
+
+sub calc_score {
+ my ($mxscore, $time, $tries, $totaltime) = @_;
+ my $score = $mxscore;
+ $time = 300 if $time > $totaltime; # uncoverable branch true does not happen anymore (only possible if opens are broken)
+ $score = ($totaltime - $time) / $totaltime * $score;
+ $score -= $tries / 10 * $mxscore;
+ $score = $mxscore * 3 / 10 if $score < $mxscore * 3 / 10;
+ int $score + 0.5
+}
+
+sub standings {
+ my ($ct) = @_;
+ $ct = contest_entry $ct;
+
+ my @problems = query(contest_problems_sth => $ct->{id})->flat;
+ my $pblist = problem_list;
+ my %values = query('problem_values_sth')->map;
+
+ my (%scores, %tries, %opens);
+ my $opens = query(opens_sth => $ct->{id});
+ while ($opens->into(my ($problem, $owner, $time))) {
+ $opens{$problem, $owner} = $time;
+ }
+
+ my $jobs = $db->select('job_entry', '*', {contest => $ct->{id}}, 'id');
+
+ while (my $job = $jobs->hash) {
+ my $open = $opens{$job->{problem}, $job->{owner}} // $ct->{start};
+ my $time = $job->{date} - $open;
+ next if $time < 0; # uncoverable branch true job sent before contest is deprecated
+ my $value = $values{$job->{problem}};
+ my $factor = $job->{result} ? 0 : 1;
+ $factor = $1 / 100 if $job->{result_text} =~ /^(\d+ )/s;
+ $scores{$job->{owner}}{$job->{problem}} = int ($factor * calc_score ($value, $time, $tries{$job->{owner}}{$job->{problem}}++, $ct->{stop} - $ct->{start}));
+ }
+
+ my @st = sort { $b->{score} <=> $a->{score} or $a->{user} cmp $b->{user} } map { ## no critic (ProhibitReverseSortBlock)
+ my $user = $_;
+ +{
+ user => $user,
+ user_name => object_name(users => $user),
+ score => sum (values %{$scores{$user}}),
+ scores => [map { $scores{$user}{$_} // '-'} @problems],
+ }
+ } keys %scores;
+
+ $st[0]->{rank} = 1 if @st;
+ $st[$_]->{rank} = $st[$_ - 1]->{rank} + ($st[$_]->{score} < $st[$_ - 1]->{score}) for 1 .. $#st;
+ +{
+ st => \@st,
+ problems => [map { [ $_, object_name(problems => $_)] } @problems],
+ }
+}
+
+sub update_status {
+ my $jobs = $db->select('jobs', 'id,owner,problem,result', {-not_bool => 'private'}, 'id');
+
+ my %hash;
+ while ($jobs->into(my ($id, $owner, $problem, $result))) {
+ $hash{$problem, $owner} = [$id, $result ? 0 : 1];
+ }
+
+ my @problem_statuses = map { [split ($;), @{$hash{$_}} ] } keys %hash;
+
+ my @contest_statuses = map {
+ my $ct = $_;
+ map { [$ct, $_->{user}, $_->{score}, $_->{rank}] } @{standings($ct)->{st}}
+ } $db->select('contests', 'id')->flat;
+
+ $db->begin;
+ $db->delete('problem_status');
+ $db->query('INSERT INTO problem_status (problem,owner,job,solved) VALUES (??)', @$_) for @problem_statuses;
+ $db->delete('contest_status');
+ $db->query('INSERT INTO contest_status (contest,owner,score,rank) VALUES (??)', @$_) for @contest_statuses;
+ $db->commit
+}
+
+sub rerun_job {
+ my ($id) = @_;
+ $db->query(rerun_job_sth => $id);
+ purge '/log/';
+ purge "/log/$id";
+}
+
+my @PURGE_HOSTS = exists $ENV{PURGE_HOSTS} ? split ' ', $ENV{PURGE_HOSTS} : ();
+my $ht = HTTP::Tiny->new;
+
+sub purge {
+ $ht->request(PURGE => "http://$_$_[0]") for @PURGE_HOSTS;