Description:
added test pair assignment, requests new input, downloads input
Commit status:
[Not Reviewed]
References:
Comments:
0 Commit comments 0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
Add another comment

r213:805be1d05f2d - - 13 files changed: 179 inserted, 6 deleted

@@ -0,0 +1,5
1 + class TestPairAssignment < ActiveRecord::Base
2 + belongs_to :user
3 + belongs_to :test_pair
4 + belongs_to :problem
5 + end
@@ -0,0 +1,9
1 + class AddNumberToTestPair < ActiveRecord::Migration
2 + def self.up
3 + add_column 'test_pairs', 'number', :integer
4 + end
5 +
6 + def self.down
7 + remove_column 'test_pairs', 'number'
8 + end
9 + end
@@ -0,0 +1,16
1 + class CreateTestPairAssignments < ActiveRecord::Migration
2 + def self.up
3 + create_table :test_pair_assignments do |t|
4 + t.integer "user_id"
5 + t.integer "problem_id"
6 + t.integer "test_pair_id"
7 + t.integer "test_pair_number"
8 + t.integer "request_number"
9 + t.timestamps
10 + end
11 + end
12 +
13 + def self.down
14 + drop_table :test_pair_assignments
15 + end
16 + end
@@ -0,0 +1,9
1 + class AddSubmittedToTestPairAssignment < ActiveRecord::Migration
2 + def self.up
3 + add_column 'test_pair_assignments', 'submitted', :boolean
4 + end
5 +
6 + def self.down
7 + remove_column 'test_pair_assignments', 'submitted'
8 + end
9 + end
@@ -0,0 +1,7
1 + # Read about fixtures at http://ar.rubyonrails.org/classes/Fixtures.html
2 +
3 + # one:
4 + # column: value
5 + #
6 + # two:
7 + # column: value
@@ -0,0 +1,8
1 + require 'test_helper'
2 +
3 + class TestPairAssignmentTest < ActiveSupport::TestCase
4 + # Replace this with your real tests.
5 + test "the truth" do
6 + assert true
7 + end
8 + end
@@ -131,96 +131,127
131 end
131 end
132 prepare_grading_result(@submission)
132 prepare_grading_result(@submission)
133 end
133 end
134
134
135 def load_output
135 def load_output
136 if !Configuration.show_grading_result or params[:num]==nil
136 if !Configuration.show_grading_result or params[:num]==nil
137 redirect_to :action => 'list' and return
137 redirect_to :action => 'list' and return
138 end
138 end
139 @user = User.find(session[:user_id])
139 @user = User.find(session[:user_id])
140 @submission = Submission.find(params[:id])
140 @submission = Submission.find(params[:id])
141 if @submission.user!=@user
141 if @submission.user!=@user
142 flash[:notice] = 'You are not allowed to view result of other users.'
142 flash[:notice] = 'You are not allowed to view result of other users.'
143 redirect_to :action => 'list' and return
143 redirect_to :action => 'list' and return
144 end
144 end
145 case_num = params[:num].to_i
145 case_num = params[:num].to_i
146 out_filename = output_filename(@user.login,
146 out_filename = output_filename(@user.login,
147 @submission.problem.name,
147 @submission.problem.name,
148 @submission.id,
148 @submission.id,
149 case_num)
149 case_num)
150 if !FileTest.exists?(out_filename)
150 if !FileTest.exists?(out_filename)
151 flash[:notice] = 'Output not found.'
151 flash[:notice] = 'Output not found.'
152 redirect_to :action => 'list' and return
152 redirect_to :action => 'list' and return
153 end
153 end
154
154
155 response.headers['Content-Type'] = "application/force-download"
155 response.headers['Content-Type'] = "application/force-download"
156 response.headers['Content-Disposition'] = "attachment; filename=\"output-#{case_num}.txt\""
156 response.headers['Content-Disposition'] = "attachment; filename=\"output-#{case_num}.txt\""
157 response.headers["X-Sendfile"] = out_filename
157 response.headers["X-Sendfile"] = out_filename
158 response.headers['Content-length'] = File.size(out_filename)
158 response.headers['Content-length'] = File.size(out_filename)
159 render :nothing => true
159 render :nothing => true
160 end
160 end
161
161
162 def error
162 def error
163 @user = User.find(session[:user_id])
163 @user = User.find(session[:user_id])
164 end
164 end
165
165
166 # announcement refreshing and hiding methods
166 # announcement refreshing and hiding methods
167
167
168 def announcements
168 def announcements
169 if params.has_key? 'recent'
169 if params.has_key? 'recent'
170 prepare_announcements(params[:recent])
170 prepare_announcements(params[:recent])
171 else
171 else
172 prepare_announcements
172 prepare_announcements
173 end
173 end
174 render(:partial => 'announcement',
174 render(:partial => 'announcement',
175 :collection => @announcements,
175 :collection => @announcements,
176 :locals => {:announcement_effect => true})
176 :locals => {:announcement_effect => true})
177 end
177 end
178
178
179 + # actions for Code Jom
180 + def new_input
181 + problem = Problem.find(params[:id])
182 + user = User.find(session[:user_id])
183 + if user.can_request_new_test_pair_for? problem
184 + assignment = user.get_new_test_pair_assignment_for problem
185 + assignment.save
186 +
187 + send_data(assignment.test_pair.input,
188 + { :filename => "#{problem.name}-#{assignment.request_number}.in",
189 + :type => 'text/plain' })
190 + else
191 + flash[:notice] = 'You cannot request new input now.'
192 + redirect_to :action => 'list'
193 + end
194 + end
195 +
196 + def download
197 + problem = Problem.find(params[:id])
198 + user = User.find(session[:user_id])
199 + recent_assignment = user.get_recent_test_pair_assignment_for problem
200 + if recent_assignment != nil
201 + send_data(recent_assignment.test_pair.input,
202 + { :filename => "#{problem.name}-#{recent_assignment.request_number}.in",
203 + :type => 'text/plain' })
204 + else
205 + flash[:notice] = 'You have not request for any input data for this problem.'
206 + redirect_to :action => 'list'
207 + end
208 + end
209 +
179 protected
210 protected
180
211
181 def prepare_announcements(recent=nil)
212 def prepare_announcements(recent=nil)
182 if Configuration.show_tasks_to?(@user)
213 if Configuration.show_tasks_to?(@user)
183 @announcements = Announcement.find_published(true)
214 @announcements = Announcement.find_published(true)
184 else
215 else
185 @announcements = Announcement.find_published
216 @announcements = Announcement.find_published
186 end
217 end
187 if recent!=nil
218 if recent!=nil
188 recent_id = recent.to_i
219 recent_id = recent.to_i
189 @announcements = @announcements.find_all { |a| a.id > recent_id }
220 @announcements = @announcements.find_all { |a| a.id > recent_id }
190 end
221 end
191 end
222 end
192
223
193 def prepare_list_information
224 def prepare_list_information
194 @problems = Problem.find_available_problems
225 @problems = Problem.find_available_problems
195 @prob_submissions = Array.new
226 @prob_submissions = Array.new
196 @user = User.find(session[:user_id])
227 @user = User.find(session[:user_id])
197 @problems.each do |p|
228 @problems.each do |p|
198 sub = Submission.find_last_by_user_and_problem(@user.id,p.id)
229 sub = Submission.find_last_by_user_and_problem(@user.id,p.id)
199 if sub!=nil
230 if sub!=nil
200 @prob_submissions << { :count => sub.number, :submission => sub }
231 @prob_submissions << { :count => sub.number, :submission => sub }
201 else
232 else
202 @prob_submissions << { :count => 0, :submission => nil }
233 @prob_submissions << { :count => 0, :submission => nil }
203 end
234 end
204 end
235 end
205 prepare_announcements
236 prepare_announcements
206 end
237 end
207
238
208 def check_viewability
239 def check_viewability
209 @user = User.find(session[:user_id])
240 @user = User.find(session[:user_id])
210 if (!Configuration.show_tasks_to?(@user)) and
241 if (!Configuration.show_tasks_to?(@user)) and
211 ((action_name=='submission') or (action_name=='submit'))
242 ((action_name=='submission') or (action_name=='submit'))
212 redirect_to :action => 'list' and return
243 redirect_to :action => 'list' and return
213 end
244 end
214 end
245 end
215
246
216 def prepare_grading_result(submission)
247 def prepare_grading_result(submission)
217 if Configuration.task_grading_info.has_key? submission.problem.name
248 if Configuration.task_grading_info.has_key? submission.problem.name
218 grading_info = Configuration.task_grading_info[submission.problem.name]
249 grading_info = Configuration.task_grading_info[submission.problem.name]
219 else
250 else
220 # guess task info from problem.full_score
251 # guess task info from problem.full_score
221 cases = submission.problem.full_score / 10
252 cases = submission.problem.full_score / 10
222 grading_info = {
253 grading_info = {
223 'testruns' => cases,
254 'testruns' => cases,
224 'testcases' => cases
255 'testcases' => cases
225 }
256 }
226 end
257 end
@@ -1,60 +1,75
1 class Problem < ActiveRecord::Base
1 class Problem < ActiveRecord::Base
2
2
3 belongs_to :description
3 belongs_to :description
4 has_many :test_pairs, :dependent => :delete_all
4 has_many :test_pairs, :dependent => :delete_all
5
5
6 validates_presence_of :name
6 validates_presence_of :name
7 validates_format_of :name, :with => /^\w+$/
7 validates_format_of :name, :with => /^\w+$/
8 validates_presence_of :full_name
8 validates_presence_of :full_name
9
9
10 DEFAULT_TIME_LIMIT = 1
10 DEFAULT_TIME_LIMIT = 1
11 DEFAULT_MEMORY_LIMIT = 32
11 DEFAULT_MEMORY_LIMIT = 32
12
12
13 + def test_pair_count
14 + @test_pair_count ||= test_pairs.size
15 + end
16 +
17 + def uses_random_test_pair?
18 + test_pair_count != 0
19 + end
20 +
21 + def random_test_pair(forbidden_numbers=nil)
22 + begin
23 + test_num = 1 + rand(test_pair_count)
24 + end while forbidden_numbers!=nil and forbidden_numbers.include? test_num
25 + test_pairs.find_by_number test_num
26 + end
27 +
13 def self.find_available_problems
28 def self.find_available_problems
14 find(:all, :conditions => {:available => true}, :order => "date_added DESC")
29 find(:all, :conditions => {:available => true}, :order => "date_added DESC")
15 end
30 end
16
31
17 def self.create_from_import_form_params(params, old_problem=nil)
32 def self.create_from_import_form_params(params, old_problem=nil)
18 problem = old_problem || Problem.new
33 problem = old_problem || Problem.new
19 import_params = Problem.extract_params_and_check(params, problem)
34 import_params = Problem.extract_params_and_check(params, problem)
20
35
21 if not problem.valid?
36 if not problem.valid?
22 return problem, 'Error importing'
37 return problem, 'Error importing'
23 end
38 end
24
39
25 problem.full_score = 100
40 problem.full_score = 100
26 problem.date_added = Time.new
41 problem.date_added = Time.new
27 problem.test_allowed = true
42 problem.test_allowed = true
28 problem.output_only = false
43 problem.output_only = false
29 problem.available = false
44 problem.available = false
30
45
31 if not problem.save
46 if not problem.save
32 return problem, 'Error importing'
47 return problem, 'Error importing'
33 end
48 end
34
49
35 import_to_db = params.has_key? :import_to_db
50 import_to_db = params.has_key? :import_to_db
36
51
37 importer = TestdataImporter.new(problem)
52 importer = TestdataImporter.new(problem)
38
53
39 if not importer.import_from_file(import_params[:file],
54 if not importer.import_from_file(import_params[:file],
40 import_params[:time_limit],
55 import_params[:time_limit],
41 import_params[:memory_limit],
56 import_params[:memory_limit],
42 import_to_db)
57 import_to_db)
43 problem.errors.add_to_base('Import error.')
58 problem.errors.add_to_base('Import error.')
44 end
59 end
45
60
46 return problem, importer.log_msg
61 return problem, importer.log_msg
47 end
62 end
48
63
49 protected
64 protected
50
65
51 def self.to_i_or_default(st, default)
66 def self.to_i_or_default(st, default)
52 if st!=''
67 if st!=''
53 st.to_i
68 st.to_i
54 else
69 else
55 default
70 default
56 end
71 end
57 end
72 end
58
73
59 def self.extract_params_and_check(params, problem)
74 def self.extract_params_and_check(params, problem)
60 time_limit = Problem.to_i_or_default(params[:time_limit],
75 time_limit = Problem.to_i_or_default(params[:time_limit],
@@ -1,3 +1,9
1 + # TestPair stores an input-solution pair for a problem. This is used
2 + # in a certain "test-pair"-type problem for the CodeJom competition
3 + # which follows the Google Code Jam format, i.e., a participant only
4 + # submits a solution to a single random input that the participant
5 + # requested. This input-solution pair is a TestPair.
6 +
1 class TestPair < ActiveRecord::Base
7 class TestPair < ActiveRecord::Base
2 - belongs_to :problem
8 + belongs_to :problem
3 end
9 end
@@ -1,117 +1,161
1 require 'digest/sha1'
1 require 'digest/sha1'
2
2
3 class User < ActiveRecord::Base
3 class User < ActiveRecord::Base
4
4
5 has_and_belongs_to_many :roles
5 has_and_belongs_to_many :roles
6
6
7 has_many :test_requests, :order => "submitted_at DESC"
7 has_many :test_requests, :order => "submitted_at DESC"
8
8
9 has_many :messages,
9 has_many :messages,
10 :class_name => "Message",
10 :class_name => "Message",
11 :foreign_key => "sender_id",
11 :foreign_key => "sender_id",
12 :order => 'created_at DESC'
12 :order => 'created_at DESC'
13
13
14 has_many :replied_messages,
14 has_many :replied_messages,
15 :class_name => "Message",
15 :class_name => "Message",
16 :foreign_key => "receiver_id",
16 :foreign_key => "receiver_id",
17 :order => 'created_at DESC'
17 :order => 'created_at DESC'
18
18
19 + has_many :test_pair_assignments, :dependent => :delete_all
20 +
19 belongs_to :site
21 belongs_to :site
20 belongs_to :country
22 belongs_to :country
21
23
22 named_scope :activated_users, :conditions => {:activated => true}
24 named_scope :activated_users, :conditions => {:activated => true}
23
25
24 validates_presence_of :login
26 validates_presence_of :login
25 validates_uniqueness_of :login
27 validates_uniqueness_of :login
26 validates_format_of :login, :with => /^[\_A-Za-z0-9]+$/
28 validates_format_of :login, :with => /^[\_A-Za-z0-9]+$/
27 validates_length_of :login, :within => 3..30
29 validates_length_of :login, :within => 3..30
28
30
29 validates_presence_of :full_name
31 validates_presence_of :full_name
30 validates_length_of :full_name, :minimum => 1
32 validates_length_of :full_name, :minimum => 1
31
33
32 validates_presence_of :password, :if => :password_required?
34 validates_presence_of :password, :if => :password_required?
33 validates_length_of :password, :within => 4..20, :if => :password_required?
35 validates_length_of :password, :within => 4..20, :if => :password_required?
34 validates_confirmation_of :password, :if => :password_required?
36 validates_confirmation_of :password, :if => :password_required?
35
37
36 validates_format_of :email,
38 validates_format_of :email,
37 :with => /\A([^@\s]+)@((?:[-a-z0-9]+\.)+[a-z]{2,})\Z/i,
39 :with => /\A([^@\s]+)@((?:[-a-z0-9]+\.)+[a-z]{2,})\Z/i,
38 :if => :email_validation?
40 :if => :email_validation?
39 validate :uniqueness_of_email_from_activated_users,
41 validate :uniqueness_of_email_from_activated_users,
40 :if => :email_validation?
42 :if => :email_validation?
41 validate :enough_time_interval_between_same_email_registrations,
43 validate :enough_time_interval_between_same_email_registrations,
42 :if => :email_validation?
44 :if => :email_validation?
43
45
44 # these are for ytopc
46 # these are for ytopc
45 # disable for now
47 # disable for now
46 #validates_presence_of :province
48 #validates_presence_of :province
47
49
48 attr_accessor :password
50 attr_accessor :password
49
51
50 before_save :encrypt_new_password
52 before_save :encrypt_new_password
51 before_save :assign_default_site
53 before_save :assign_default_site
52
54
53 def self.authenticate(login, password)
55 def self.authenticate(login, password)
54 user = find_by_login(login)
56 user = find_by_login(login)
55 return user if user && user.authenticated?(password)
57 return user if user && user.authenticated?(password)
56 end
58 end
57
59
58 def authenticated?(password)
60 def authenticated?(password)
59 if self.activated
61 if self.activated
60 hashed_password == User.encrypt(password,self.salt)
62 hashed_password == User.encrypt(password,self.salt)
61 else
63 else
62 false
64 false
63 end
65 end
64 end
66 end
65
67
66 def admin?
68 def admin?
67 self.roles.detect {|r| r.name == 'admin' }
69 self.roles.detect {|r| r.name == 'admin' }
68 end
70 end
69
71
72 + # These are methods related to test pairs
73 +
74 + def get_test_pair_assignments_for(problem)
75 + test_pair_assignments.find_all { |a| a.problem_id == problem.id }
76 + end
77 +
78 + def get_recent_test_pair_assignment_for(problem)
79 + assignments = get_test_pair_assignments_for problem
80 + if assignments.length == 0
81 + return nil
82 + else
83 + recent = assignments[0]
84 + assignments.each do |a|
85 + recent = a if a.request_number > recent.request_number
86 + end
87 + return recent
88 + end
89 + end
90 +
91 + def can_request_new_test_pair_for?(problem)
92 + recent = get_recent_test_pair_assignment_for problem
93 + return (recent == nil or recent.submitted)
94 + end
95 +
96 + def get_new_test_pair_assignment_for(problem)
97 + previous_assignment_numbers =
98 + get_test_pair_assignments_for(problem).collect {|a| a.test_pair_number }
99 + test_pair = problem.random_test_pair(previous_assignment_numbers)
100 + if test_pair
101 + assignment = TestPairAssignment.new(:user => self,
102 + :problem => problem,
103 + :test_pair => test_pair,
104 + :test_pair_number => test_pair.number,
105 + :request_number =>
106 + previous_assignment_numbers.length + 1,
107 + :submitted => false)
108 + return assignment
109 + else
110 + return nil
111 + end
112 + end
113 +
70 def email_for_editing
114 def email_for_editing
71 if self.email==nil
115 if self.email==nil
72 "(unknown)"
116 "(unknown)"
73 elsif self.email==''
117 elsif self.email==''
74 "(blank)"
118 "(blank)"
75 else
119 else
76 self.email
120 self.email
77 end
121 end
78 end
122 end
79
123
80 def email_for_editing=(e)
124 def email_for_editing=(e)
81 self.email=e
125 self.email=e
82 end
126 end
83
127
84 def alias_for_editing
128 def alias_for_editing
85 if self.alias==nil
129 if self.alias==nil
86 "(unknown)"
130 "(unknown)"
87 elsif self.alias==''
131 elsif self.alias==''
88 "(blank)"
132 "(blank)"
89 else
133 else
90 self.alias
134 self.alias
91 end
135 end
92 end
136 end
93
137
94 def alias_for_editing=(e)
138 def alias_for_editing=(e)
95 self.alias=e
139 self.alias=e
96 end
140 end
97
141
98 def activation_key
142 def activation_key
99 if self.hashed_password==nil
143 if self.hashed_password==nil
100 encrypt_new_password
144 encrypt_new_password
101 end
145 end
102 Digest::SHA1.hexdigest(self.hashed_password)[0..7]
146 Digest::SHA1.hexdigest(self.hashed_password)[0..7]
103 end
147 end
104
148
105 def verify_activation_key(key)
149 def verify_activation_key(key)
106 key == activation_key
150 key == activation_key
107 end
151 end
108
152
109 def self.random_password(length=5)
153 def self.random_password(length=5)
110 chars = 'abcdefghjkmnopqrstuvwxyz'
154 chars = 'abcdefghjkmnopqrstuvwxyz'
111 password = ''
155 password = ''
112 length.times { password << chars[rand(chars.length - 1)] }
156 length.times { password << chars[rand(chars.length - 1)] }
113 password
157 password
114 end
158 end
115
159
116 def self.find_non_admin_with_prefix(prefix='')
160 def self.find_non_admin_with_prefix(prefix='')
117 users = User.find(:all)
161 users = User.find(:all)
@@ -1,18 +1,26
1 <tr class="info-<%= (problem_counter%2==0) ? "even" : "odd" %>">
1 <tr class="info-<%= (problem_counter%2==0) ? "even" : "odd" %>">
2 <td>
2 <td>
3 <%= "#{problem_counter+1}" %>
3 <%= "#{problem_counter+1}" %>
4 </td>
4 </td>
5 <td>
5 <td>
6 <%= "#{problem.full_name} (#{problem.name})" %>
6 <%= "#{problem.full_name} (#{problem.name})" %>
7 <%= link_to "[#{t 'main.problem_desc'}]", problem.url, :popup => true if (problem.url!=nil) and (problem.url!='') %>
7 <%= link_to "[#{t 'main.problem_desc'}]", problem.url, :popup => true if (problem.url!=nil) and (problem.url!='') %>
8 </td>
8 </td>
9 <td align="center">
9 <td align="center">
10 <%= @prob_submissions[problem_counter][:count] %>
10 <%= @prob_submissions[problem_counter][:count] %>
11 </td>
11 </td>
12 <td>
12 <td>
13 - <%= render :partial => 'submission_short',
13 + <span id="problem-form-<%= problem.id %>">
14 - :locals => {
14 + <% form_tag "new_input/#{problem.id}", :method => :post do -%>
15 - :submission => @prob_submissions[problem_counter][:submission],
15 + <input type="submit" value="New input"/>
16 - :problem_name => problem.name }%>
16 + <% end -%>
17 + <% form_tag "download/#{problem.id}", :method => :post do -%>
18 + <input type="submit" value="Download input"/>
19 + <% end -%>
20 + <% form_tag "submit_solution/#{problem.id}", :method => :post do -%>
21 + <input type="file">
22 + <input type="submit" value="Submit solution"/>
23 + <% end -%>
24 + </span>
17 </td>
25 </td>
18 </tr>
26 </tr>
@@ -1,60 +1,60
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 Active Record to incrementally modify your database, and
2 # please use the migrations feature of Active Record 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 => 20100113094740) do
12 + ActiveRecord::Schema.define(:version => 20100118174404) 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 t.boolean "frontpage", :default => false
20 t.boolean "frontpage", :default => false
21 t.boolean "contest_only", :default => false
21 t.boolean "contest_only", :default => false
22 t.string "title"
22 t.string "title"
23 end
23 end
24
24
25 create_table "configurations", :force => true do |t|
25 create_table "configurations", :force => true do |t|
26 t.string "key"
26 t.string "key"
27 t.string "value_type"
27 t.string "value_type"
28 t.string "value"
28 t.string "value"
29 t.datetime "created_at"
29 t.datetime "created_at"
30 t.datetime "updated_at"
30 t.datetime "updated_at"
31 end
31 end
32
32
33 create_table "countries", :force => true do |t|
33 create_table "countries", :force => true do |t|
34 t.string "name"
34 t.string "name"
35 t.datetime "created_at"
35 t.datetime "created_at"
36 t.datetime "updated_at"
36 t.datetime "updated_at"
37 end
37 end
38
38
39 create_table "descriptions", :force => true do |t|
39 create_table "descriptions", :force => true do |t|
40 t.text "body"
40 t.text "body"
41 t.boolean "markdowned"
41 t.boolean "markdowned"
42 t.datetime "created_at"
42 t.datetime "created_at"
43 t.datetime "updated_at"
43 t.datetime "updated_at"
44 end
44 end
45
45
46 create_table "grader_processes", :force => true do |t|
46 create_table "grader_processes", :force => true do |t|
47 t.string "host", :limit => 20
47 t.string "host", :limit => 20
48 t.integer "pid"
48 t.integer "pid"
49 t.string "mode"
49 t.string "mode"
50 t.boolean "active"
50 t.boolean "active"
51 t.datetime "created_at"
51 t.datetime "created_at"
52 t.datetime "updated_at"
52 t.datetime "updated_at"
53 t.integer "task_id"
53 t.integer "task_id"
54 t.string "task_type"
54 t.string "task_type"
55 t.boolean "terminated"
55 t.boolean "terminated"
56 end
56 end
57
57
58 add_index "grader_processes", ["host", "pid"], :name => "index_grader_processes_on_ip_and_pid"
58 add_index "grader_processes", ["host", "pid"], :name => "index_grader_processes_on_ip_and_pid"
59
59
60 create_table "languages", :force => true do |t|
60 create_table "languages", :force => true do |t|
@@ -110,95 +110,107
110
110
111 add_index "roles_users", ["user_id"], :name => "index_roles_users_on_user_id"
111 add_index "roles_users", ["user_id"], :name => "index_roles_users_on_user_id"
112
112
113 create_table "sessions", :force => true do |t|
113 create_table "sessions", :force => true do |t|
114 t.string "session_id"
114 t.string "session_id"
115 t.text "data"
115 t.text "data"
116 t.datetime "updated_at"
116 t.datetime "updated_at"
117 end
117 end
118
118
119 add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
119 add_index "sessions", ["session_id"], :name => "index_sessions_on_session_id"
120 add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
120 add_index "sessions", ["updated_at"], :name => "index_sessions_on_updated_at"
121
121
122 create_table "sites", :force => true do |t|
122 create_table "sites", :force => true do |t|
123 t.string "name"
123 t.string "name"
124 t.boolean "started"
124 t.boolean "started"
125 t.datetime "start_time"
125 t.datetime "start_time"
126 t.datetime "created_at"
126 t.datetime "created_at"
127 t.datetime "updated_at"
127 t.datetime "updated_at"
128 t.integer "country_id"
128 t.integer "country_id"
129 t.string "password"
129 t.string "password"
130 end
130 end
131
131
132 create_table "submissions", :force => true do |t|
132 create_table "submissions", :force => true do |t|
133 t.integer "user_id"
133 t.integer "user_id"
134 t.integer "problem_id"
134 t.integer "problem_id"
135 t.integer "language_id"
135 t.integer "language_id"
136 t.text "source"
136 t.text "source"
137 t.binary "binary"
137 t.binary "binary"
138 t.datetime "submitted_at"
138 t.datetime "submitted_at"
139 t.datetime "compiled_at"
139 t.datetime "compiled_at"
140 t.text "compiler_message"
140 t.text "compiler_message"
141 t.datetime "graded_at"
141 t.datetime "graded_at"
142 t.integer "points"
142 t.integer "points"
143 t.text "grader_comment"
143 t.text "grader_comment"
144 t.integer "number"
144 t.integer "number"
145 t.string "source_filename"
145 t.string "source_filename"
146 end
146 end
147
147
148 add_index "submissions", ["user_id", "problem_id", "number"], :name => "index_submissions_on_user_id_and_problem_id_and_number", :unique => true
148 add_index "submissions", ["user_id", "problem_id", "number"], :name => "index_submissions_on_user_id_and_problem_id_and_number", :unique => true
149 add_index "submissions", ["user_id", "problem_id"], :name => "index_submissions_on_user_id_and_problem_id"
149 add_index "submissions", ["user_id", "problem_id"], :name => "index_submissions_on_user_id_and_problem_id"
150
150
151 create_table "tasks", :force => true do |t|
151 create_table "tasks", :force => true do |t|
152 t.integer "submission_id"
152 t.integer "submission_id"
153 t.datetime "created_at"
153 t.datetime "created_at"
154 t.integer "status"
154 t.integer "status"
155 t.datetime "updated_at"
155 t.datetime "updated_at"
156 end
156 end
157
157
158 + create_table "test_pair_assignments", :force => true do |t|
159 + t.integer "user_id"
160 + t.integer "problem_id"
161 + t.integer "test_pair_id"
162 + t.integer "test_pair_number"
163 + t.integer "request_number"
164 + t.datetime "created_at"
165 + t.datetime "updated_at"
166 + t.boolean "submitted"
167 + end
168 +
158 create_table "test_pairs", :force => true do |t|
169 create_table "test_pairs", :force => true do |t|
159 t.integer "problem_id"
170 t.integer "problem_id"
160 t.text "input"
171 t.text "input"
161 t.text "solution"
172 t.text "solution"
162 t.datetime "created_at"
173 t.datetime "created_at"
163 t.datetime "updated_at"
174 t.datetime "updated_at"
175 + t.integer "number"
164 end
176 end
165
177
166 create_table "test_requests", :force => true do |t|
178 create_table "test_requests", :force => true do |t|
167 t.integer "user_id"
179 t.integer "user_id"
168 t.integer "problem_id"
180 t.integer "problem_id"
169 t.integer "submission_id"
181 t.integer "submission_id"
170 t.string "input_file_name"
182 t.string "input_file_name"
171 t.string "output_file_name"
183 t.string "output_file_name"
172 t.string "running_stat"
184 t.string "running_stat"
173 t.integer "status"
185 t.integer "status"
174 t.datetime "updated_at"
186 t.datetime "updated_at"
175 t.datetime "submitted_at"
187 t.datetime "submitted_at"
176 t.datetime "compiled_at"
188 t.datetime "compiled_at"
177 t.text "compiler_message"
189 t.text "compiler_message"
178 t.datetime "graded_at"
190 t.datetime "graded_at"
179 t.string "grader_comment"
191 t.string "grader_comment"
180 t.datetime "created_at"
192 t.datetime "created_at"
181 t.float "running_time"
193 t.float "running_time"
182 t.string "exit_status"
194 t.string "exit_status"
183 t.integer "memory_usage"
195 t.integer "memory_usage"
184 end
196 end
185
197
186 add_index "test_requests", ["user_id", "problem_id"], :name => "index_test_requests_on_user_id_and_problem_id"
198 add_index "test_requests", ["user_id", "problem_id"], :name => "index_test_requests_on_user_id_and_problem_id"
187
199
188 create_table "users", :force => true do |t|
200 create_table "users", :force => true do |t|
189 t.string "login", :limit => 50
201 t.string "login", :limit => 50
190 t.string "full_name"
202 t.string "full_name"
191 t.string "hashed_password"
203 t.string "hashed_password"
192 t.string "salt", :limit => 5
204 t.string "salt", :limit => 5
193 t.string "alias"
205 t.string "alias"
194 t.string "email"
206 t.string "email"
195 t.integer "site_id"
207 t.integer "site_id"
196 t.integer "country_id"
208 t.integer "country_id"
197 t.boolean "activated", :default => false
209 t.boolean "activated", :default => false
198 t.datetime "created_at"
210 t.datetime "created_at"
199 t.datetime "updated_at"
211 t.datetime "updated_at"
200 end
212 end
201
213
202 add_index "users", ["login"], :name => "index_users_on_login", :unique => true
214 add_index "users", ["login"], :name => "index_users_on_login", :unique => true
203
215
204 end
216 end
@@ -54,81 +54,84
54 Dir.mkdir extract_dir
54 Dir.mkdir extract_dir
55 rescue Errno::EEXIST
55 rescue Errno::EEXIST
56 end
56 end
57
57
58 if ext=='.tar.gz' or ext=='.tgz'
58 if ext=='.tar.gz' or ext=='.tgz'
59 cmd = "tar -zxvf #{testdata_filename} -C #{extract_dir}"
59 cmd = "tar -zxvf #{testdata_filename} -C #{extract_dir}"
60 elsif ext=='.tar'
60 elsif ext=='.tar'
61 cmd = "tar -xvf #{testdata_filename} -C #{extract_dir}"
61 cmd = "tar -xvf #{testdata_filename} -C #{extract_dir}"
62 elsif ext=='.zip'
62 elsif ext=='.zip'
63 cmd = "unzip -o #{testdata_filename} -d #{extract_dir}"
63 cmd = "unzip -o #{testdata_filename} -d #{extract_dir}"
64 else
64 else
65 return nil
65 return nil
66 end
66 end
67
67
68 system(cmd)
68 system(cmd)
69
69
70 files = Dir["#{extract_dir}/**/*1*.in"]
70 files = Dir["#{extract_dir}/**/*1*.in"]
71 return nil if files.length==0
71 return nil if files.length==0
72
72
73 return File.dirname(files[0])
73 return File.dirname(files[0])
74 end
74 end
75
75
76 def save_testdata_file(tempfile)
76 def save_testdata_file(tempfile)
77 ext = TestdataImporter.long_ext(tempfile.original_filename)
77 ext = TestdataImporter.long_ext(tempfile.original_filename)
78 testdata_filename = File.join(Dir.tmpdir,"#{@problem.name}#{ext}")
78 testdata_filename = File.join(Dir.tmpdir,"#{@problem.name}#{ext}")
79
79
80 return nil if tempfile==""
80 return nil if tempfile==""
81
81
82 if tempfile.instance_of?(Tempfile)
82 if tempfile.instance_of?(Tempfile)
83 tempfile.close
83 tempfile.close
84 FileUtils.move(tempfile.path,testdata_filename)
84 FileUtils.move(tempfile.path,testdata_filename)
85 else
85 else
86 File.open(testdata_filename, "wb") do |f|
86 File.open(testdata_filename, "wb") do |f|
87 f.write(tempfile.read)
87 f.write(tempfile.read)
88 end
88 end
89 end
89 end
90
90
91 return testdata_filename
91 return testdata_filename
92 end
92 end
93
93
94 def import_test_pairs(dirname)
94 def import_test_pairs(dirname)
95 test_num = 1
95 test_num = 1
96 while FileTest.exists? "#{dirname}/#{test_num}.in"
96 while FileTest.exists? "#{dirname}/#{test_num}.in"
97 in_filename = "#{dirname}/#{test_num}.in"
97 in_filename = "#{dirname}/#{test_num}.in"
98 sol_filename = "#{dirname}/#{test_num}.sol"
98 sol_filename = "#{dirname}/#{test_num}.sol"
99
99
100 break if not FileTest.exists? sol_filename
100 break if not FileTest.exists? sol_filename
101
101
102 + puts "#{dirname}"
103 +
102 test_pair = TestPair.new(:input => open(in_filename).read,
104 test_pair = TestPair.new(:input => open(in_filename).read,
103 :solution => open(sol_filename).read,
105 :solution => open(sol_filename).read,
106 + :number => test_num,
104 :problem => @problem)
107 :problem => @problem)
105 break if not test_pair.save
108 break if not test_pair.save
106
109
107 test_num += 1
110 test_num += 1
108 end
111 end
109 return test_num > 1
112 return test_num > 1
110 end
113 end
111
114
112 def import_problem_description(dirname)
115 def import_problem_description(dirname)
113 html_files = Dir["#{dirname}/*.html"]
116 html_files = Dir["#{dirname}/*.html"]
114 markdown_files = Dir["#{dirname}/*.md"] + Dir["#{dirname}/*.markdown"]
117 markdown_files = Dir["#{dirname}/*.md"] + Dir["#{dirname}/*.markdown"]
115 if (html_files.length != 0) or (markdown_files.length != 0)
118 if (html_files.length != 0) or (markdown_files.length != 0)
116 description = @problem.description || Description.new
119 description = @problem.description || Description.new
117
120
118 if html_files.length != 0
121 if html_files.length != 0
119 filename = html_files[0]
122 filename = html_files[0]
120 description.markdowned = false
123 description.markdowned = false
121 else
124 else
122 filename = markdown_files[0]
125 filename = markdown_files[0]
123 description.markdowned = true
126 description.markdowned = true
124 end
127 end
125
128
126 description.body = open(filename).read
129 description.body = open(filename).read
127 description.save
130 description.save
128 @problem.description = description
131 @problem.description = description
129 @problem.save
132 @problem.save
130 return "\nProblem description imported from #{filename}."
133 return "\nProblem description imported from #{filename}."
131 end
134 end
132 end
135 end
133
136
134 end
137 end
You need to be logged in to leave comments. Login now