From: Marius Gavrilescu <marius@ieval.ro>
Date: Mon, 16 Mar 2015 13:41:24 +0000 (+0200)
Subject: Add "reference" column to jobs
X-Git-Tag: 5999.000_014~60
X-Git-Url: http://git.ieval.ro/?p=gruntmaster-data.git;a=commitdiff_plain;h=987ee14e19e0fac15b4518c0f0df8aeb3ed2498e

Add "reference" column to jobs
---

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/;