083_set_visible_to_profiles.rb 533 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 
class SetVisibleToProfiles < ActiveRecord::Migration
  def self.up
    templates = []
    Environment.all.each do |e|
      templates << e.settings[:person_template_id]
      templates << e.settings[:enterprise_template_id]
      templates << e.settings[:inactive_enterprise_template_id]
      templates << e.settings[:community_template_id]
    end
    execute "update profiles set visible=(1=1) where id NOT IN (#{templates.compact.join(',')})"
  end

  def self.down
    say("Nothing to undo (cannot recover the data)")
  end
end