summaryrefslogtreecommitdiff
path: root/db/migrate/20140428132845_create_delayed_jobs.rb
diff options
context:
space:
mode:
authorLuke Shumaker <shumakl@purdue.edu>2014-04-28 09:37:52 -0400
committerLuke Shumaker <shumakl@purdue.edu>2014-04-28 09:37:52 -0400
commitf8e9b0349b82278c8fb015037e901dd5a77e30e7 (patch)
treec54eae2919f7d6a8532527ec4db7b33c26b71a71 /db/migrate/20140428132845_create_delayed_jobs.rb
parent8abfaf4ce71dff7294424a7cb37efe4db5e0d581 (diff)
parente08e007a6c50e1959a29a9d18dec8c52146a233c (diff)
Merge branch 'clean2'
Conflicts: app/controllers/tournaments_controller.rb app/views/tournaments/_form.html.erb app/views/tournaments/index.html.erb app/views/tournaments/show.html.erb
Diffstat (limited to 'db/migrate/20140428132845_create_delayed_jobs.rb')
-rw-r--r--db/migrate/20140428132845_create_delayed_jobs.rb22
1 files changed, 22 insertions, 0 deletions
diff --git a/db/migrate/20140428132845_create_delayed_jobs.rb b/db/migrate/20140428132845_create_delayed_jobs.rb
new file mode 100644
index 0000000..ec0dd93
--- /dev/null
+++ b/db/migrate/20140428132845_create_delayed_jobs.rb
@@ -0,0 +1,22 @@
+class CreateDelayedJobs < ActiveRecord::Migration
+ def self.up
+ create_table :delayed_jobs, :force => true do |table|
+ table.integer :priority, :default => 0, :null => false # Allows some jobs to jump to the front of the queue
+ table.integer :attempts, :default => 0, :null => false # Provides for retries, but still fail eventually.
+ table.text :handler, :null => false # YAML-encoded string of the object that will do work
+ table.text :last_error # reason for last failure (See Note below)
+ table.datetime :run_at # When to run. Could be Time.zone.now for immediately, or sometime in the future.
+ table.datetime :locked_at # Set when a client is working on this object
+ table.datetime :failed_at # Set when all retries have failed (actually, by default, the record is deleted instead)
+ table.string :locked_by # Who is working on this object (if locked)
+ table.string :queue # The name of the queue this job is in
+ table.timestamps
+ end
+
+ add_index :delayed_jobs, [:priority, :run_at], :name => 'delayed_jobs_priority'
+ end
+
+ def self.down
+ drop_table :delayed_jobs
+ end
+end