Contents

class AddSearchOutputOptions < ActiveRecord::Migration
  def up
    add_column :searches, :output_individuals, :boolean
    add_column :searches, :output_households, :boolean
    add_column :searches, :output_companies, :boolean

    execute "update searches set output_individuals = true where person_type = 'Individual'"
    execute "update searches set output_companies = true where person_type = 'Company'"

    remove_column :searches, :person_type
  end

  def down
    add_column :searches, :person_type, :string

    execute "update searches set person_type = 'Individual' where output_individuals = true"
    execute "update searches set person_type = 'Company' where output_companies = true"

    remove_column :searches, :output_companies
    remove_column :searches, :output_households
    remove_column :searches, :output_individuals

  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version	Path
artfully_ose-1.3.0.pre4	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.3.0.pre3	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.3.0.pre2	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.3.0.pre1	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.2.0	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.2.0.beta.1	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.2.0.alpha.2	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.2.0.alpha.1	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.2.0.pre.27	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.2.0.pre.26	db/migrate/20131022183913_add_search_output_options.rb
artfully_ose-1.2.0.pre.24	db/migrate/20131022183913_add_search_output_options.rb