Sha256: c046b9c665cfe5e340605699e602486113ee3f91e746401a5f0654694ae90fff

Contents?: true

Size: 927 Bytes

Versions: 24

Compression:

Stored size: 927 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.string :description, 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

24 entries across 24 versions & 1 rubygems

Version Path
workhorse-1.2.20 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.17 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.17.rc2 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.17.rc1 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.17.rc0 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.16 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.15 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.14 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.13 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.12 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.11 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.10 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.9 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.8 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.7 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.6 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.5 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.4 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.3 lib/generators/workhorse/templates/create_table_jobs.rb
workhorse-1.2.2 lib/generators/workhorse/templates/create_table_jobs.rb