Class: CreateDuctworkExecutions

Inherits:
Ductwork::Migration show all
Defined in:
lib/generators/ductwork/install/templates/db/create_ductwork_executions.rb

Constant Summary

Constants included from Ductwork::MigrationHelper

Ductwork::MigrationHelper::AVAILABILITY_CLAIM_INDEX_NAME, Ductwork::MigrationHelper::AVAILABILITY_CLAIM_INDEX_NAMES, Ductwork::MigrationHelper::AVAILABILITY_CLAIM_INDEX_NAME_V2

Instance Method Summary collapse

Methods included from Ductwork::MigrationHelper

#add_availability_claim_index, #add_index_online, #belongs_to, #create_ductwork_table, #drop_invalid_index, #ensure_ddl_transaction_disabled!, #mysql?, #postgresql?, #remove_availability_claim_index, #remove_index_online, #swap_availability_claim_index, #uuid_column_type

Instance Method Details

#change ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
# File 'lib/generators/ductwork/install/templates/db/create_ductwork_executions.rb', line 4

def change
  create_ductwork_table :ductwork_executions do |table|
    belongs_to(
      table,
      :job,
      index: true,
      null: false,
      foreign_key: { to_table: :ductwork_jobs }
    )
    belongs_to(
      table,
      :process,
      index: true,
      null: true,
      foreign_key: { to_table: :ductwork_processes }
    )
    table.timestamp :started_at, null: false
    table.timestamp :completed_at
    table.integer :retry_count, null: false
    table.integer :crash_count, null: false
    table.timestamps null: false
  end

  add_index :ductwork_executions, %i[job_id created_at]
end