Description:
[web] added support for output only problems
git-svn-id: http://theory.cpe.ku.ac.th/grader/web/trunk@188 6386c4cd-e34a-4fa8-8920-d93eb39b512e
Commit status:
[Not Reviewed]
References:
Diff options:
Comments:
0 Commit comments
0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
r99:ab383e0b489e - - 5 files changed: 64 inserted, 21 deleted
@@ -0,0 +1,11 | |||||
|
|
1 | + class AddSupportsForOutputOnlyProblems < ActiveRecord::Migration | ||
|
|
2 | + def self.up | ||
|
|
3 | + add_column :submissions, :source_filename, :string | ||
|
|
4 | + add_column :problems, :output_only, :boolean | ||
|
|
5 | + end | ||
|
|
6 | + | ||
|
|
7 | + def self.down | ||
|
|
8 | + remove_column :submissions, :source_filename | ||
|
|
9 | + add_column :problems, :output_only, :boolean | ||
|
|
10 | + end | ||
|
|
11 | + end |
@@ -12,49 +12,52 | |||||
|
12 |
|
12 | ||
|
13 |
|
13 | ||
|
14 | def index |
|
14 | def index |
|
15 | redirect_to :action => 'login' |
|
15 | redirect_to :action => 'login' |
|
16 | end |
|
16 | end |
|
17 |
|
17 | ||
|
18 | def login |
|
18 | def login |
|
19 | saved_notice = flash[:notice] |
|
19 | saved_notice = flash[:notice] |
|
20 | reset_session |
|
20 | reset_session |
|
21 | flash[:notice] = saved_notice |
|
21 | flash[:notice] = saved_notice |
|
22 |
|
22 | ||
|
23 | render :action => 'login', :layout => 'empty' |
|
23 | render :action => 'login', :layout => 'empty' |
|
24 | end |
|
24 | end |
|
25 |
|
25 | ||
|
26 | def list |
|
26 | def list |
|
27 | prepare_list_information |
|
27 | prepare_list_information |
|
28 | end |
|
28 | end |
|
29 |
|
29 | ||
|
30 | def submit |
|
30 | def submit |
|
31 | user = User.find(session[:user_id]) |
|
31 | user = User.find(session[:user_id]) |
|
32 |
|
32 | ||
|
33 | @submission = Submission.new(params[:submission]) |
|
33 | @submission = Submission.new(params[:submission]) |
|
34 | @submission.user = user |
|
34 | @submission.user = user |
|
35 | @submission.language_id = 0 |
|
35 | @submission.language_id = 0 |
|
36 | - @submission.source = params['file'].read if params['file']!='' |
|
36 | + if params['file']!='' |
|
|
37 | + @submission.source = params['file'].read | ||
|
|
38 | + @submission.source_filename = params['file'].original_filename | ||
|
|
39 | + end | ||
|
37 | @submission.submitted_at = Time.new |
|
40 | @submission.submitted_at = Time.new |
|
38 |
|
41 | ||
|
39 | if user.site!=nil and user.site.finished? |
|
42 | if user.site!=nil and user.site.finished? |
|
40 | @submission.errors.add_to_base "The contest is over." |
|
43 | @submission.errors.add_to_base "The contest is over." |
|
41 | prepare_list_information |
|
44 | prepare_list_information |
|
42 | render :action => 'list' and return |
|
45 | render :action => 'list' and return |
|
43 | end |
|
46 | end |
|
44 |
|
47 | ||
|
45 | if @submission.valid? |
|
48 | if @submission.valid? |
|
46 | if @submission.save == false |
|
49 | if @submission.save == false |
|
47 | flash[:notice] = 'Error saving your submission' |
|
50 | flash[:notice] = 'Error saving your submission' |
|
48 | elsif Task.create(:submission_id => @submission.id, |
|
51 | elsif Task.create(:submission_id => @submission.id, |
|
49 | :status => Task::STATUS_INQUEUE) == false |
|
52 | :status => Task::STATUS_INQUEUE) == false |
|
50 | flash[:notice] = 'Error adding your submission to task queue' |
|
53 | flash[:notice] = 'Error adding your submission to task queue' |
|
51 | end |
|
54 | end |
|
52 | else |
|
55 | else |
|
53 | prepare_list_information |
|
56 | prepare_list_information |
|
54 | render :action => 'list' and return |
|
57 | render :action => 'list' and return |
|
55 | end |
|
58 | end |
|
56 | redirect_to :action => 'list' |
|
59 | redirect_to :action => 'list' |
|
57 | end |
|
60 | end |
|
58 |
|
61 | ||
|
59 | def source |
|
62 | def source |
|
60 | submission = Submission.find(params[:id]) |
|
63 | submission = Submission.find(params[:id]) |
@@ -1,35 +1,38 | |||||
|
1 | class Submission < ActiveRecord::Base |
|
1 | class Submission < ActiveRecord::Base |
|
2 |
|
2 | ||
|
3 | belongs_to :language |
|
3 | belongs_to :language |
|
4 | belongs_to :problem |
|
4 | belongs_to :problem |
|
5 | belongs_to :user |
|
5 | belongs_to :user |
|
6 |
|
6 | ||
|
|
7 | + before_validation :assign_problem | ||
|
|
8 | + before_validation :assign_language | ||
|
|
9 | + | ||
|
7 | validates_presence_of :source |
|
10 | validates_presence_of :source |
|
8 | validates_length_of :source, :maximum => 100_000, :allow_blank => true, :message => 'too long' |
|
11 | validates_length_of :source, :maximum => 100_000, :allow_blank => true, :message => 'too long' |
|
9 | validates_length_of :source, :minimum => 1, :allow_blank => true, :message => 'too short' |
|
12 | validates_length_of :source, :minimum => 1, :allow_blank => true, :message => 'too short' |
|
|
13 | + validate :must_have_valid_problem | ||
|
10 | validate :must_specify_language |
|
14 | validate :must_specify_language |
|
11 | - validate :must_have_valid_problem |
|
||
|
12 |
|
15 | ||
|
13 | before_save :assign_latest_number_if_new_recond |
|
16 | before_save :assign_latest_number_if_new_recond |
|
14 |
|
17 | ||
|
15 | def self.find_last_by_user_and_problem(user_id, problem_id) |
|
18 | def self.find_last_by_user_and_problem(user_id, problem_id) |
|
16 | last_sub = find(:first, |
|
19 | last_sub = find(:first, |
|
17 | :conditions => {:user_id => user_id, |
|
20 | :conditions => {:user_id => user_id, |
|
18 | :problem_id => problem_id}, |
|
21 | :problem_id => problem_id}, |
|
19 | :order => 'number DESC') |
|
22 | :order => 'number DESC') |
|
20 | return last_sub |
|
23 | return last_sub |
|
21 | end |
|
24 | end |
|
22 |
|
25 | ||
|
23 | def self.find_all_last_by_problem(problem_id) |
|
26 | def self.find_all_last_by_problem(problem_id) |
|
24 | # need to put in SQL command, maybe there's a better way |
|
27 | # need to put in SQL command, maybe there's a better way |
|
25 | Submission.find_by_sql("SELECT * FROM submissions " + |
|
28 | Submission.find_by_sql("SELECT * FROM submissions " + |
|
26 | "WHERE id = " + |
|
29 | "WHERE id = " + |
|
27 | "(SELECT MAX(id) FROM submissions AS subs " + |
|
30 | "(SELECT MAX(id) FROM submissions AS subs " + |
|
28 | "WHERE subs.user_id = submissions.user_id AND " + |
|
31 | "WHERE subs.user_id = submissions.user_id AND " + |
|
29 | "problem_id = " + problem_id.to_s + " " + |
|
32 | "problem_id = " + problem_id.to_s + " " + |
|
30 | "GROUP BY user_id)") |
|
33 | "GROUP BY user_id)") |
|
31 | end |
|
34 | end |
|
32 |
|
35 | ||
|
33 | def self.find_last_for_all_available_problems(user_id) |
|
36 | def self.find_last_for_all_available_problems(user_id) |
|
34 | submissions = Array.new |
|
37 | submissions = Array.new |
|
35 | problems = Problem.find_available_problems |
|
38 | problems = Problem.find_available_problems |
@@ -76,59 +79,69 | |||||
|
76 | end |
|
79 | end |
|
77 | return nil |
|
80 | return nil |
|
78 | end |
|
81 | end |
|
79 |
|
82 | ||
|
80 | def self.find_language_in_source(source) |
|
83 | def self.find_language_in_source(source) |
|
81 | langopt = find_option_in_source(/^LANG:/,source) |
|
84 | langopt = find_option_in_source(/^LANG:/,source) |
|
82 | if language = Language.find_by_name(langopt) |
|
85 | if language = Language.find_by_name(langopt) |
|
83 | return language |
|
86 | return language |
|
84 | elsif language = Language.find_by_pretty_name(langopt) |
|
87 | elsif language = Language.find_by_pretty_name(langopt) |
|
85 | return language |
|
88 | return language |
|
86 | else |
|
89 | else |
|
87 | return nil |
|
90 | return nil |
|
88 | end |
|
91 | end |
|
89 | end |
|
92 | end |
|
90 |
|
93 | ||
|
91 | def self.find_problem_in_source(source) |
|
94 | def self.find_problem_in_source(source) |
|
92 | prob_opt = find_option_in_source(/^TASK:/,source) |
|
95 | prob_opt = find_option_in_source(/^TASK:/,source) |
|
93 | if problem = Problem.find_by_name(prob_opt) |
|
96 | if problem = Problem.find_by_name(prob_opt) |
|
94 | return problem |
|
97 | return problem |
|
95 | else |
|
98 | else |
|
96 | return nil |
|
99 | return nil |
|
97 | end |
|
100 | end |
|
98 | end |
|
101 | end |
|
99 |
|
102 | ||
|
|
103 | + def assign_problem | ||
|
|
104 | + if self.problem_id!=-1 | ||
|
|
105 | + begin | ||
|
|
106 | + self.problem = Problem.find(self.problem_id) | ||
|
|
107 | + rescue ActiveRecord::RecordNotFound | ||
|
|
108 | + self.problem = nil | ||
|
|
109 | + end | ||
|
|
110 | + else | ||
|
|
111 | + self.problem = Submission.find_problem_in_source(self.source) | ||
|
|
112 | + end | ||
|
|
113 | + end | ||
|
|
114 | + | ||
|
|
115 | + def assign_language | ||
|
|
116 | + self.language = Submission.find_language_in_source(self.source) | ||
|
|
117 | + end | ||
|
|
118 | + | ||
|
100 | # validation codes |
|
119 | # validation codes |
|
101 | def must_specify_language |
|
120 | def must_specify_language |
|
102 | return if self.source==nil |
|
121 | return if self.source==nil |
|
103 | - self.language = Submission.find_language_in_source(self.source) |
|
122 | + |
|
|
123 | + # for output_only tasks | ||
|
|
124 | + return if self.problem!=nil and self.problem.output_only | ||
|
|
125 | + | ||
|
|
126 | + if self.language==nil | ||
|
104 | errors.add('source',"must specify programming language") unless self.language!=nil |
|
127 | errors.add('source',"must specify programming language") unless self.language!=nil |
|
105 | end |
|
128 | end |
|
|
129 | + end | ||
|
106 |
|
130 | ||
|
107 | def must_have_valid_problem |
|
131 | def must_have_valid_problem |
|
108 | return if self.source==nil |
|
132 | return if self.source==nil |
|
109 |
- if self.problem |
|
133 | + if self.problem==nil |
|
110 | - begin |
|
||
|
111 | - problem = Problem.find(self.problem_id) |
|
||
|
112 | - rescue ActiveRecord::RecordNotFound |
|
||
|
113 | - problem = nil |
|
||
|
114 | - end |
|
||
|
115 | - else |
|
||
|
116 | - problem = Submission.find_problem_in_source(self.source) |
|
||
|
117 | - end |
|
||
|
118 | - if problem==nil |
|
||
|
119 | errors.add('problem',"must be specified.") |
|
134 | errors.add('problem',"must be specified.") |
|
120 | - elsif (!problem.available) and (self.new_record?) |
|
135 | + elsif (!self.problem.available) and (self.new_record?) |
|
121 | errors.add('problem',"must be valid.") |
|
136 | errors.add('problem',"must be valid.") |
|
122 | - else |
|
||
|
123 | - self.problem = problem |
|
||
|
124 | end |
|
137 | end |
|
125 | end |
|
138 | end |
|
126 |
|
139 | ||
|
127 | # callbacks |
|
140 | # callbacks |
|
128 | def assign_latest_number_if_new_recond |
|
141 | def assign_latest_number_if_new_recond |
|
129 | return if !self.new_record? |
|
142 | return if !self.new_record? |
|
130 | latest = Submission.find_last_by_user_and_problem(self.user_id, self.problem_id) |
|
143 | latest = Submission.find_last_by_user_and_problem(self.user_id, self.problem_id) |
|
131 | self.number = (latest==nil) ? 1 : latest.number + 1; |
|
144 | self.number = (latest==nil) ? 1 : latest.number + 1; |
|
132 | end |
|
145 | end |
|
133 |
|
146 | ||
|
134 | end |
|
147 | end |
@@ -1,38 +1,52 | |||||
|
1 | <%= error_messages_for 'problem' %> |
|
1 | <%= error_messages_for 'problem' %> |
|
2 |
|
2 | ||
|
3 | <!--[form:problem]--> |
|
3 | <!--[form:problem]--> |
|
4 | <p><label for="problem_name">Name</label><br/> |
|
4 | <p><label for="problem_name">Name</label><br/> |
|
5 | <%= text_field 'problem', 'name' %></p> |
|
5 | <%= text_field 'problem', 'name' %></p> |
|
6 |
|
6 | ||
|
7 | <p><label for="problem_full_name">Full name</label><br/> |
|
7 | <p><label for="problem_full_name">Full name</label><br/> |
|
8 | <%= text_field 'problem', 'full_name' %></p> |
|
8 | <%= text_field 'problem', 'full_name' %></p> |
|
9 |
|
9 | ||
|
10 | <p><label for="problem_full_score">Full score</label><br/> |
|
10 | <p><label for="problem_full_score">Full score</label><br/> |
|
11 | <%= text_field 'problem', 'full_score' %></p> |
|
11 | <%= text_field 'problem', 'full_score' %></p> |
|
12 |
|
12 | ||
|
13 | <p><label for="problem_date_added">Date added</label><br/> |
|
13 | <p><label for="problem_date_added">Date added</label><br/> |
|
14 | <%= date_select 'problem', 'date_added' %></p> |
|
14 | <%= date_select 'problem', 'date_added' %></p> |
|
15 |
|
15 | ||
|
16 | - <p><label for="problem_available">Available?</label> |
|
16 | + <% |
|
17 | - <%= select("problem","available",[['True',true],['False',false]]) %></p> |
|
17 | + # TODO: these should be put in model Problem, but I can't think of |
|
|
18 | + # nice default values for them. These values look fine only | ||
|
|
19 | + # in this case (of lazily adding new problems). | ||
|
|
20 | + @problem.available = true if @problem!=nil and @problem.available==nil | ||
|
|
21 | + @problem.test_allowed = true if @problem!=nil and @problem.test_allowed==nil | ||
|
|
22 | + @problem.output_only = false if @problem!=nil and @problem.output_only==nil | ||
|
|
23 | + %> | ||
|
18 |
|
24 | ||
|
19 | - <p><label for="problem_test_allowed">Test allowed?</label> |
|
25 | + <p> |
|
20 | - <%= select("problem","test_allowed",[['True',true],['False',false]]) %></p> |
|
26 | + <label for="problem_available">Available?</label> |
|
|
27 | + <%= check_box :problem, :available %> | ||
|
|
28 | + | ||
|
|
29 | + <label for="problem_test_allowed">Test allowed?</label> | ||
|
|
30 | + <%= check_box :problem, :test_allowed %> | ||
|
|
31 | + | ||
|
|
32 | + <label for="problem_output_only">Output only?</label> | ||
|
|
33 | + <%= check_box :problem, :output_only %> | ||
|
|
34 | + </p> | ||
|
21 |
|
35 | ||
|
22 | <%= error_messages_for 'description' %> |
|
36 | <%= error_messages_for 'description' %> |
|
23 |
|
37 | ||
|
24 | <p><label for="description_body">Description</label><br/> |
|
38 | <p><label for="description_body">Description</label><br/> |
|
25 | <%= text_area :description, :body, :rows => 10, :cols => 80 %></p> |
|
39 | <%= text_area :description, :body, :rows => 10, :cols => 80 %></p> |
|
26 |
|
40 | ||
|
27 | <p><label for="description_markdowned">Markdowned?</label> |
|
41 | <p><label for="description_markdowned">Markdowned?</label> |
|
28 | <%= select "description", |
|
42 | <%= select "description", |
|
29 | "markdowned", |
|
43 | "markdowned", |
|
30 | [['True',true],['False',false]], |
|
44 | [['True',true],['False',false]], |
|
31 | {:selected => (@description) ? @description.markdowned : false } |
|
45 | {:selected => (@description) ? @description.markdowned : false } |
|
32 | %></p> |
|
46 | %></p> |
|
33 |
|
47 | ||
|
34 | <p><label for="problem_url">URL</label><br/> |
|
48 | <p><label for="problem_url">URL</label><br/> |
|
35 | <%= text_field 'problem', 'url' %></p> |
|
49 | <%= text_field 'problem', 'url' %></p> |
|
36 |
|
50 | ||
|
37 |
|
51 | ||
|
38 | <!--[eoform:problem]--> |
|
52 | <!--[eoform:problem]--> |
@@ -1,36 +1,36 | |||||
|
1 | # This file is auto-generated from the current state of the database. Instead of editing this file, |
|
1 | # This file is auto-generated from the current state of the database. Instead of editing this file, |
|
2 | # please use the migrations feature of ActiveRecord to incrementally modify your database, and |
|
2 | # please use the migrations feature of ActiveRecord to incrementally modify your database, and |
|
3 | # then regenerate this schema definition. |
|
3 | # then regenerate this schema definition. |
|
4 | # |
|
4 | # |
|
5 | # Note that this schema.rb definition is the authoritative source for your database schema. If you need |
|
5 | # Note that this schema.rb definition is the authoritative source for your database schema. If you need |
|
6 | # to create the application database on another system, you should be using db:schema:load, not running |
|
6 | # to create the application database on another system, you should be using db:schema:load, not running |
|
7 | # all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations |
|
7 | # all the migrations from scratch. The latter is a flawed and unsustainable approach (the more migrations |
|
8 | # you'll amass, the slower it'll run and the greater likelihood for issues). |
|
8 | # you'll amass, the slower it'll run and the greater likelihood for issues). |
|
9 | # |
|
9 | # |
|
10 | # It's strongly recommended to check this file into your version control system. |
|
10 | # It's strongly recommended to check this file into your version control system. |
|
11 |
|
11 | ||
|
12 |
- ActiveRecord::Schema.define(:version => 3 |
|
12 | + ActiveRecord::Schema.define(:version => 31) do |
|
13 |
|
13 | ||
|
14 | create_table "announcements", :force => true do |t| |
|
14 | create_table "announcements", :force => true do |t| |
|
15 | t.string "author" |
|
15 | t.string "author" |
|
16 | t.text "body" |
|
16 | t.text "body" |
|
17 | t.boolean "published" |
|
17 | t.boolean "published" |
|
18 | t.datetime "created_at" |
|
18 | t.datetime "created_at" |
|
19 | t.datetime "updated_at" |
|
19 | t.datetime "updated_at" |
|
20 | end |
|
20 | end |
|
21 |
|
21 | ||
|
22 | create_table "configurations", :force => true do |t| |
|
22 | create_table "configurations", :force => true do |t| |
|
23 | t.string "key" |
|
23 | t.string "key" |
|
24 | t.string "value_type" |
|
24 | t.string "value_type" |
|
25 | t.string "value" |
|
25 | t.string "value" |
|
26 | t.datetime "created_at" |
|
26 | t.datetime "created_at" |
|
27 | t.datetime "updated_at" |
|
27 | t.datetime "updated_at" |
|
28 | end |
|
28 | end |
|
29 |
|
29 | ||
|
30 | create_table "descriptions", :force => true do |t| |
|
30 | create_table "descriptions", :force => true do |t| |
|
31 | t.text "body" |
|
31 | t.text "body" |
|
32 | t.boolean "markdowned" |
|
32 | t.boolean "markdowned" |
|
33 | t.datetime "created_at" |
|
33 | t.datetime "created_at" |
|
34 | t.datetime "updated_at" |
|
34 | t.datetime "updated_at" |
|
35 | end |
|
35 | end |
|
36 |
|
36 | ||
@@ -40,48 +40,49 | |||||
|
40 | t.string "mode" |
|
40 | t.string "mode" |
|
41 | t.boolean "active" |
|
41 | t.boolean "active" |
|
42 | t.datetime "created_at" |
|
42 | t.datetime "created_at" |
|
43 | t.datetime "updated_at" |
|
43 | t.datetime "updated_at" |
|
44 | t.integer "task_id" |
|
44 | t.integer "task_id" |
|
45 | end |
|
45 | end |
|
46 |
|
46 | ||
|
47 | add_index "grader_processes", ["host", "pid"], :name => "index_grader_processes_on_ip_and_pid" |
|
47 | add_index "grader_processes", ["host", "pid"], :name => "index_grader_processes_on_ip_and_pid" |
|
48 |
|
48 | ||
|
49 | create_table "languages", :force => true do |t| |
|
49 | create_table "languages", :force => true do |t| |
|
50 | t.string "name", :limit => 10 |
|
50 | t.string "name", :limit => 10 |
|
51 | t.string "pretty_name" |
|
51 | t.string "pretty_name" |
|
52 | t.string "ext", :limit => 10 |
|
52 | t.string "ext", :limit => 10 |
|
53 | end |
|
53 | end |
|
54 |
|
54 | ||
|
55 | create_table "problems", :force => true do |t| |
|
55 | create_table "problems", :force => true do |t| |
|
56 | t.string "name", :limit => 30 |
|
56 | t.string "name", :limit => 30 |
|
57 | t.string "full_name" |
|
57 | t.string "full_name" |
|
58 | t.integer "full_score" |
|
58 | t.integer "full_score" |
|
59 | t.date "date_added" |
|
59 | t.date "date_added" |
|
60 | t.boolean "available" |
|
60 | t.boolean "available" |
|
61 | t.string "url" |
|
61 | t.string "url" |
|
62 | t.integer "description_id" |
|
62 | t.integer "description_id" |
|
63 | t.boolean "test_allowed" |
|
63 | t.boolean "test_allowed" |
|
|
64 | + t.boolean "output_only" | ||
|
64 | end |
|
65 | end |
|
65 |
|
66 | ||
|
66 | create_table "rights", :force => true do |t| |
|
67 | create_table "rights", :force => true do |t| |
|
67 | t.string "name" |
|
68 | t.string "name" |
|
68 | t.string "controller" |
|
69 | t.string "controller" |
|
69 | t.string "action" |
|
70 | t.string "action" |
|
70 | end |
|
71 | end |
|
71 |
|
72 | ||
|
72 | create_table "rights_roles", :id => false, :force => true do |t| |
|
73 | create_table "rights_roles", :id => false, :force => true do |t| |
|
73 | t.integer "right_id" |
|
74 | t.integer "right_id" |
|
74 | t.integer "role_id" |
|
75 | t.integer "role_id" |
|
75 | end |
|
76 | end |
|
76 |
|
77 | ||
|
77 | add_index "rights_roles", ["role_id"], :name => "index_rights_roles_on_role_id" |
|
78 | add_index "rights_roles", ["role_id"], :name => "index_rights_roles_on_role_id" |
|
78 |
|
79 | ||
|
79 | create_table "roles", :force => true do |t| |
|
80 | create_table "roles", :force => true do |t| |
|
80 | t.string "name" |
|
81 | t.string "name" |
|
81 | end |
|
82 | end |
|
82 |
|
83 | ||
|
83 | create_table "roles_users", :id => false, :force => true do |t| |
|
84 | create_table "roles_users", :id => false, :force => true do |t| |
|
84 | t.integer "role_id" |
|
85 | t.integer "role_id" |
|
85 | t.integer "user_id" |
|
86 | t.integer "user_id" |
|
86 | end |
|
87 | end |
|
87 |
|
88 | ||
@@ -96,48 +97,49 | |||||
|
96 | add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id" |
|
97 | add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id" |
|
97 | add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at" |
|
98 | add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at" |
|
98 |
|
99 | ||
|
99 | create_table "sites", :force => true do |t| |
|
100 | create_table "sites", :force => true do |t| |
|
100 | t.string "name" |
|
101 | t.string "name" |
|
101 | t.boolean "started" |
|
102 | t.boolean "started" |
|
102 | t.datetime "start_time" |
|
103 | t.datetime "start_time" |
|
103 | t.datetime "created_at" |
|
104 | t.datetime "created_at" |
|
104 | t.datetime "updated_at" |
|
105 | t.datetime "updated_at" |
|
105 | end |
|
106 | end |
|
106 |
|
107 | ||
|
107 | create_table "submissions", :force => true do |t| |
|
108 | create_table "submissions", :force => true do |t| |
|
108 | t.integer "user_id" |
|
109 | t.integer "user_id" |
|
109 | t.integer "problem_id" |
|
110 | t.integer "problem_id" |
|
110 | t.integer "language_id" |
|
111 | t.integer "language_id" |
|
111 | t.text "source" |
|
112 | t.text "source" |
|
112 | t.binary "binary" |
|
113 | t.binary "binary" |
|
113 | t.datetime "submitted_at" |
|
114 | t.datetime "submitted_at" |
|
114 | t.datetime "compiled_at" |
|
115 | t.datetime "compiled_at" |
|
115 | t.text "compiler_message" |
|
116 | t.text "compiler_message" |
|
116 | t.datetime "graded_at" |
|
117 | t.datetime "graded_at" |
|
117 | t.integer "points" |
|
118 | t.integer "points" |
|
118 | t.text "grader_comment" |
|
119 | t.text "grader_comment" |
|
119 | t.integer "number" |
|
120 | t.integer "number" |
|
|
121 | + t.string "source_filename" | ||
|
120 | end |
|
122 | end |
|
121 |
|
123 | ||
|
122 | add_index "submissions", ["user_id", "problem_id", "number"], :name => "index_submissions_on_user_id_and_problem_id_and_number", :unique => true |
|
124 | add_index "submissions", ["user_id", "problem_id", "number"], :name => "index_submissions_on_user_id_and_problem_id_and_number", :unique => true |
|
123 | add_index "submissions", ["user_id", "problem_id"], :name => "index_submissions_on_user_id_and_problem_id" |
|
125 | add_index "submissions", ["user_id", "problem_id"], :name => "index_submissions_on_user_id_and_problem_id" |
|
124 |
|
126 | ||
|
125 | create_table "tasks", :force => true do |t| |
|
127 | create_table "tasks", :force => true do |t| |
|
126 | t.integer "submission_id" |
|
128 | t.integer "submission_id" |
|
127 | t.datetime "created_at" |
|
129 | t.datetime "created_at" |
|
128 | t.integer "status" |
|
130 | t.integer "status" |
|
129 | t.datetime "updated_at" |
|
131 | t.datetime "updated_at" |
|
130 | end |
|
132 | end |
|
131 |
|
133 | ||
|
132 | create_table "test_requests", :force => true do |t| |
|
134 | create_table "test_requests", :force => true do |t| |
|
133 | t.integer "user_id" |
|
135 | t.integer "user_id" |
|
134 | t.integer "problem_id" |
|
136 | t.integer "problem_id" |
|
135 | t.integer "submission_id" |
|
137 | t.integer "submission_id" |
|
136 | t.string "input_file_name" |
|
138 | t.string "input_file_name" |
|
137 | t.string "output_file_name" |
|
139 | t.string "output_file_name" |
|
138 | t.string "running_stat" |
|
140 | t.string "running_stat" |
|
139 | t.integer "status" |
|
141 | t.integer "status" |
|
140 | t.datetime "updated_at" |
|
142 | t.datetime "updated_at" |
|
141 | t.datetime "submitted_at" |
|
143 | t.datetime "submitted_at" |
|
142 | t.datetime "compiled_at" |
|
144 | t.datetime "compiled_at" |
|
143 | t.text "compiler_message" |
|
145 | t.text "compiler_message" |
You need to be logged in to leave comments.
Login now