=head1 NAME
-Gruntmaster::Data::Result::Contest
+Gruntmaster::Data::Result::Contest - List of contests
=cut
data_type: 'text'
is_nullable: 0
+=head2 editorial
+
+ data_type: 'text'
+ is_nullable: 1
+
+HTML fragment placed before the editorial
+
+=head2 description
+
+ data_type: 'text'
+ is_nullable: 1
+
+HTML fragment placed on contest page
+
=head2 start
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'
{ data_type => "text", is_nullable => 0 },
"name",
{ data_type => "text", is_nullable => 0 },
+ "editorial",
+ { data_type => "text", is_nullable => 1 },
+ "description",
+ { data_type => "text", is_nullable => 1 },
"start",
{ data_type => "integer", is_nullable => 0 },
"stop",
__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 @ 2015-02-14 10:52:58
+# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:UTfqBbyhmo0r1HyWtGXidA
+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)
my ($self) = @_;
my $ct = $self->id;
- my @problems = map { $_->rawproblem } $self->contest_problems->search({contest => $ct}, {qw/join problem order_by problem.level/});
+ my @problems = map { $_->rawproblem } $self->contest_problems->search({contest => $ct}, {qw/join problem order_by problem.value/});
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;
$scores{$job->rawowner}{$job->rawproblem} = int ($factor * calc_score ($value, $time, $tries{$job->rawowner}{$job->rawproblem}++, $self->stop - $self->start));
}
- my %user_to_name = map { $_ => $_->name } $self->result_source->schema->users->all;
+ my %user_to_name = map { $_->id => $_->name } $self->result_source->schema->users->all;
+ say STDERR join "\n\n", @problems;
my @st = sort { $b->{score} <=> $a->{score} or $a->{user} cmp $b->{user} } map { ## no critic (ProhibitReverseSortBlock)
my $user = $_;
+{
}
} 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
}