Exclude pending jobs from standings

[gruntmaster-data.git] / lib / Gruntmaster / Data / Result / Contest.pm

diff --git a/lib/Gruntmaster/Data/Result/Contest.pm b/lib/Gruntmaster/Data/Result/Contest.pm
index 77ac716b8c6de2d9e45c7f380e6e8014611c023a..02a50caeb819c86c5891ed7c0ee4b4e72dfeb0fa 100644 (file)
--- a/lib/Gruntmaster/Data/Result/Contest.pm
+++ b/lib/Gruntmaster/Data/Result/Contest.pm
@@ -6,7 +6,7 @@ package Gruntmaster::Data::Result::Contest;
 
 =head1 NAME
 
-Gruntmaster::Data::Result::Contest
+Gruntmaster::Data::Result::Contest - List of contests
 
 =cut
 
@@ -38,11 +38,15 @@ __PACKAGE__->table("contests");
   data_type: 'integer'
   is_nullable: 0
 
+Unix time when contest starts
+
 =head2 stop
 
   data_type: 'integer'
   is_nullable: 0
 
+Unix time when contest ends
+
 =head2 owner
 
   data_type: 'text'
@@ -164,11 +168,18 @@ Composing rels: L</contest_problems> -> problem
 __PACKAGE__->many_to_many("problems", "contest_problems", "problem");
 
 
-# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-12-11 23:51:27
-# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:nu+Io9AhYkzYCky5UpCaKQ
+# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-12-19 16:54:00
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:IxxZqQwKisBwDabCNUD55Q
 
+use Class::Method::Modifiers qw/after/;
 use List::Util qw/sum/;
 
+after qw/insert update delete/ => sub {
+       my ($self) = @_;
+       Gruntmaster::Data::purge '/ct/';
+       Gruntmaster::Data::purge '/ct/' . $self->id;
+};
+
 sub is_pending {
        my ($self, $time) = @_;
        $self->start > ($time // time)
@@ -202,7 +213,7 @@ sub standings {
        my @problems = map { $_->rawproblem } $self->contest_problems->search({contest => $ct}, {qw/join problem order_by problem.level/});
        my (%scores, %tries, %opens);
        $opens{$_->rawproblem, $_->rawowner} = $_ for $self->opens->search({contest => $ct});
-       for my $job ($self->jobs->search({contest => $ct}, {qw/order_by me.id prefetch/ => [qw/problem/]})) {
+       for my $job ($self->jobs->search({contest => $ct, result => {'!=', undef}}, {qw/order_by me.id prefetch/ => [qw/problem/]})) {
                my $open = $opens{$job->rawproblem, $job->rawowner};
                my $time = $job->date - ($open ? $open->time : $self->start);
                next if $time < 0;
@@ -224,7 +235,7 @@ sub standings {
                }
        } keys %scores;
 
-       $st[0]->{rank} = 1;
+       $st[0]->{rank} = 1 if @st;
        $st[$_]->{rank} = $st[$_ - 1]->{rank} + ($st[$_]->{score} < $st[$_ - 1]->{score}) for 1 .. $#st;
        @st
 }