Contents

class AddStiToSettings < ActiveRecord::Migration
  def self.up
    execute "UPDATE settings set category='Setting::Auth' where category='Auth'"
    execute "UPDATE settings set category='Setting::General' where category='General'"
    execute "UPDATE settings set category='Setting::Puppet' where category='Puppet'"
    execute "UPDATE settings set category='Setting::Provisioning' where category='Provisioning'"
    add_index :settings, :category
  end

  def self.down
    execute "UPDATE settings set category='Auth' where category='Setting::Auth'"
    execute "UPDATE settings set category='General' where category='Setting::General'"
    execute "UPDATE settings set category='Puppet' where category='Setting::Puppet'"
    execute "UPDATE settings set category='Provisioning' where category='Setting::Provisioning'"
    remove_index :settings, :category
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
foreman_discovery-1.0.0	test/foreman_app/db/migrate/20130417110127_add_sti_to_settings.rb
foreman_discovery-1.0.0.rc4	test/foreman_app/db/migrate/20130417110127_add_sti_to_settings.rb
foreman_discovery-1.0.0.rc3	test/foreman_app/db/migrate/20130417110127_add_sti_to_settings.rb
foreman_discovery-1.0.0.rc2	test/foreman_app/db/migrate/20130417110127_add_sti_to_settings.rb
foreman_discovery-1.0.0.rc1	test/foreman_app/db/migrate/20130417110127_add_sti_to_settings.rb