Sha256: 816bc8938f1a4361c0566622bcc87b9168aeaa04f78a960d9975a451a203b5b1

Contents?: true

Size: 886 Bytes

Versions: 26

Compression:

Stored size: 886 Bytes

Contents

class CreateTableJobs < ActiveRecord::Migration
  def change
    create_table :jobs, force: true do |t|
      t.string :state, null: false, default: 'waiting'
      t.string :queue, null: true
      t.binary :handler, null: false, limit: 4_294_967_295

      t.string :locked_by
      t.datetime :locked_at

      t.datetime :started_at

      t.datetime :succeeded_at
      t.datetime :failed_at
      t.text :last_error, limit: 4_294_967_295

      t.integer :priority, null: false
      t.datetime :perform_at, null: true

      t.timestamps null: false
    end

    if oracle?
      add_index :jobs, :queue
      add_index :jobs, :state
    else
      add_index :jobs, :queue, length: 191
      add_index :jobs, :state, length: 191
    end
    add_index :jobs, :perform_at
  end

  private

  def oracle?
    ActiveRecord::Base.connection.adapter_name == 'OracleEnhanced'
  end
end

Version data entries

26 entries across 26 versions & 1 rubygems

Version Path
workhorse-1.0.1 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.0.0 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.0.0.beta2 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.0.0.beta1 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.0.0.beta0 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.9 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.8 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.7 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.6 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.5 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.4 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.3 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.2 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.1 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.6.0 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.5.1 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.5.0 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.4.0 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.3.9 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-0.3.8 lib/generators/workhorse/templates/create_table_jobs.rb