20150319114233_change_default_content_privacy.rb 757 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 
class ChangeDefaultContentPrivacy < ActiveRecord::Migration
  def up
    ids = execute("SELECT id from profiles WHERE NOT public_profile")
    profiles_ids = ids.map { |p| p["id"] }
    unless ids.num_tuples.zero?
      execute("UPDATE articles SET published = (1>2), show_to_followers = (1=1)
      WHERE profile_id IN (#{profiles_ids.join(",")}) AND published")
      blocks = Block.includes(:box).where(:boxes => {:owner_type => "Profile", :owner_id => profiles_ids}).where('type != ?', "MainBlock")
      blocks.each do |block|
        block.display_user = 'followers'
        block.save
      end
    end
    change_column :articles, :show_to_followers, :boolean, :default => true
  end

  def down
    say "this migration can't be reverted"
  end
end