Contents

#
# Migrate received HearActions to the new SayAction
# Remove parenthesis from subtypes
#
class MassageActionSubtypes < ActiveRecord::Migration
  def change 
    execute "update actions set type='SayAction',  subtype='Email'   where type='HearAction' and subtype='Email (received)'"
    execute "update actions set type='SayAction',  subtype='Phone'   where type='HearAction' and subtype='Phone (received)'"
    execute "update actions set type='SayAction',  subtype='Postal'  where type='HearAction' and subtype='Postal (received)'"

    execute "update actions set                    subtype='Email'   where type='HearAction' and subtype='Email (sent)'"
    execute "update actions set                    subtype='Phone'   where type='HearAction' and subtype='Phone (initiated)'"
    execute "update actions set                    subtype='Postal'  where type='HearAction' and subtype='Postal (sent)'"
  end
end

Version data entries

32 entries across 32 versions & 1 rubygems

Version	Path
artfully_ose-1.2.0.pre.11	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.10	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.9	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.8	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.7	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.6	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.5	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.4	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.3	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.2	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.1	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre	db/migrate/20130412145428_massage_action_subtypes.rb