Class: Taskr::Models::CreateTaskr

Inherits:

V

• Object
• V
• Taskr::Models::CreateTaskr

Defined in:

lib/taskr/models.rb

Class Method Summary

• .down ⇒ Object
• .up ⇒ Object

Class Method Details

.down ⇒ Object

# File 'lib/taskr/models.rb', line 233

def self.down
  drop_table :taskr_task_action_parameters
  drop_table :taskr_tasks
end

.up ⇒ Object

# File 'lib/taskr/models.rb', line 196

def self.up
  $LOG.info("Migrating database")
  
  create_table :taskr_tasks, :force => true do |t|
    t.column :name, :string, :null => false
    t.column :created_on, :timestamp, :null => false
    t.column :created_by, :string
    
    t.column :schedule_method, :string, :null => false
    t.column :schedule_when, :string, :null => false
    t.column :schedule_options, :text
    
    t.column :scheduler_job_id, :integer
    t.column :last_triggered, :datetime
    t.column :last_triggered_error, :text
  end
  
  add_index :taskr_tasks, [:name], :unique => true
  
  create_table :taskr_task_actions, :force => true do |t|
    t.column :task_id, :integer, :null => false
    t.column :action_class_name, :string, :null => false
    t.column :order, :integer
  end
  
  add_index :taskr_task_actions, [:task_id]
  
  create_table :taskr_task_action_parameters, :force => true do |t|
    t.column :task_action_id, :integer, :null => false
    t.column :name, :string, :null => false
    t.column :value, :text
  end
  
  add_index :taskr_task_action_parameters, [:task_action_id]
  add_index :taskr_task_action_parameters, [:task_action_id, :name]
end