Description:
problems sorted by update time
Commit status:
[Not Reviewed]
References:
Diff options:
Comments:
0 Commit comments
0 Inline Comments
Unresolved TODOs:
There are no unresolved TODOs
Author
Jittat Fakcharoenphol
-
r258:1821e2e3aeb0 - - 4 files changed: 25 inserted, 13 deleted
| @@ -0,0 +1,9 | |||
|
|
1 | + class AddTimestampToProblems < ActiveRecord::Migration | |
|
|
2 | + def self.up | |
|
|
3 | + add_column :problems, :updated_at, :timestamp | |
|
|
4 | + end | |
|
|
5 | + | |
|
|
6 | + def self.down | |
|
|
7 | + remove_column :problems, :updated_at | |
|
|
8 | + end | |
|
|
9 | + end | |
| @@ -37,7 +37,9 | |||
|
|
37 | 37 | end |
|
|
38 | 38 | |
|
|
39 | 39 | def self.find_available_problems |
|
|
40 | - find(:all, :conditions => {:available => true}, :order => "date_added DESC") | |
|
|
40 | + find(:all, | |
|
|
41 | + :conditions => {:available => true}, | |
|
|
42 | + :order => "updated_at DESC") | |
|
|
41 | 43 | end |
|
|
42 | 44 | |
|
|
43 | 45 | # TODO: may try to optimize this using cache |
| @@ -37,6 +37,6 | |||
|
|
37 | 37 | CodejomTimeout.updateProblemMessages(); |
|
|
38 | 38 | CodejomTimeout.registerRefreshEvent(); |
|
|
39 | 39 | |
|
|
40 | - = periodically_call_remote(:url => { :action => 'problems' }, :update => 'problem-list') | |
|
|
40 | + = periodically_call_remote(:url => { :action => 'problems' }, :update => 'problem-list', :frequency => '3') | |
|
|
41 | 41 | |
|
|
42 | 42 | |
| @@ -9,7 +9,7 | |||
|
|
9 | 9 | # |
|
|
10 | 10 | # It's strongly recommended to check this file into your version control system. |
|
|
11 | 11 | |
|
|
12 |
- ActiveRecord::Schema.define(:version => 201002 |
|
|
|
12 | + ActiveRecord::Schema.define(:version => 20100210012432) do | |
|
|
13 | 13 | |
|
|
14 | 14 | create_table "announcements", :force => true do |t| |
|
|
15 | 15 | t.string "author" |
| @@ -84,16 +84,17 | |||
|
|
84 | 84 | end |
|
|
85 | 85 | |
|
|
86 | 86 | create_table "problems", :force => true do |t| |
|
|
87 | - t.string "name", :limit => 30 | |
|
|
88 | - t.string "full_name" | |
|
|
89 | - t.integer "full_score" | |
|
|
90 | - t.date "date_added" | |
|
|
91 | - t.boolean "available" | |
|
|
92 | - t.string "url" | |
|
|
93 | - t.integer "description_id" | |
|
|
94 | - t.boolean "test_allowed" | |
|
|
95 | - t.boolean "output_only" | |
|
|
96 | - t.integer "level", :default => 0 | |
|
|
87 | + t.string "name", :limit => 30 | |
|
|
88 | + t.string "full_name" | |
|
|
89 | + t.integer "full_score" | |
|
|
90 | + t.date "date_added" | |
|
|
91 | + t.boolean "available" | |
|
|
92 | + t.string "url" | |
|
|
93 | + t.integer "description_id" | |
|
|
94 | + t.boolean "test_allowed" | |
|
|
95 | + t.boolean "output_only" | |
|
|
96 | + t.integer "level", :default => 0 | |
|
|
97 | + t.datetime "updated_at" | |
|
|
97 | 98 | end |
|
|
98 | 99 | |
|
|
99 | 100 | create_table "rights", :force => true do |t| |
You need to be logged in to leave comments.
Login now