From 987ee14e19e0fac15b4518c0f0df8aeb3ed2498e Mon Sep 17 00:00:00 2001 From: Marius Gavrilescu Date: Mon, 16 Mar 2015 15:41:24 +0200 Subject: [PATCH] Add "reference" column to jobs --- db.sql | 2 ++ lib/Gruntmaster/Data/Result/Job.pm | 13 +++++++++++-- 2 files changed, 13 insertions(+), 2 deletions(-) diff --git a/db.sql b/db.sql index 706265e..ba8a621 100644 --- a/db.sql +++ b/db.sql @@ -74,6 +74,7 @@ CREATE TABLE jobs ( format TEXT NOT NULL, private BOOLEAN NOT NULL DEFAULT FALSE, problem TEXT NOT NULL REFERENCES problems ON DELETE CASCADE, + reference INT, result INT, result_text TEXT, results TEXT, @@ -154,6 +155,7 @@ INSERT INTO column_comments VALUES ('jobs', 'date', 'Unix time when job was subm INSERT INTO column_comments VALUES ('jobs', 'errors', 'Compiler errors'); INSERT INTO column_comments VALUES ('jobs', 'extension', 'File extension of submitted program, without a leading dot'); INSERT INTO column_comments VALUES ('jobs', 'format', 'Format (programming language) of submitted program'); +INSERT INTO column_comments VALUES ('jobs', 'reference', 'If not null, this is a reference solution that should get this result. For example, set reference=0 on jobs that should be accepted, reference=3 on jobs that should get TLE, etc'); INSERT INTO column_comments VALUES ('jobs', 'result', 'Job result (integer constant from Gruntmaster::Daemon::Constants)'); INSERT INTO column_comments VALUES ('jobs', 'result_text', 'Job result (human-readable text)'); INSERT INTO column_comments VALUES ('jobs', 'results', 'Per-test results (JSON array of hashes with keys id (test number, counting from 1), result (integer constant from Gruntmaster::Daemon::Constants), result_text (human-readable text), time (execution time in decimal seconds))'); diff --git a/lib/Gruntmaster/Data/Result/Job.pm b/lib/Gruntmaster/Data/Result/Job.pm index 39d44bd..b6abf02 100644 --- a/lib/Gruntmaster/Data/Result/Job.pm +++ b/lib/Gruntmaster/Data/Result/Job.pm @@ -83,6 +83,13 @@ Format (programming language) of submitted program is_foreign_key: 1 is_nullable: 0 +=head2 reference + + data_type: 'integer' + is_nullable: 1 + +If not null, this is a reference solution that should get this result. For example, set reference=0 on jobs that should be accepted, reference=3 on jobs that should get TLE, etc + =head2 result data_type: 'integer' @@ -141,6 +148,8 @@ __PACKAGE__->add_columns( { data_type => "boolean", default_value => \"false", is_nullable => 0 }, "problem", { data_type => "text", is_foreign_key => 1, is_nullable => 0 }, + "reference", + { data_type => "integer", is_nullable => 1 }, "result", { data_type => "integer", is_nullable => 1 }, "result_text", @@ -233,8 +242,8 @@ __PACKAGE__->has_many( ); -# Created by DBIx::Class::Schema::Loader v0.07042 @ 2014-12-19 16:54:00 -# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:hEAVL5heV13+nalSmgr0WA +# Created by DBIx::Class::Schema::Loader v0.07042 @ 2015-03-16 15:40:48 +# DO NOT MODIFY THIS OR ANYTHING ABOVE! md5sum:aaVaCgk198pT0kBGMefkkA use Class::Method::Modifiers qw/after/; -- 2.39.2