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.3.0.pre4	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.3.0.pre3	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.3.0.pre2	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.3.0.pre1	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.beta.1	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.alpha.2	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.alpha.1	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.27	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.26	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.24	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.23	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.21	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.20	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.19	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.18	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.17	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.16	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.15	db/migrate/20130412145428_massage_action_subtypes.rb
artfully_ose-1.2.0.pre.12	db/migrate/20130412145428_massage_action_subtypes.rb