Sha256: 8915dad08314e6bad9ccc0986b3a535302d6440e90d6e3da90978bd6e36d3c39

Contents?: true

Size: 670 Bytes

Versions: 27

Compression:

Stored size: 670 Bytes

Contents

class AddEnvironmentsSubscribedToToUsers < ActiveRecord::Migration
  def up
    add_column :users, :environments_subscribed_to, :string, :null => false, :default => ""

    User.reset_column_information

    User.find_each do |user|
      user.environments_subscribed_to = User.connection.select_values("SELECT environment_name FROM user_notifications WHERE user_id=#{user.id} GROUP BY environment_name HAVING COUNT(id)>0") & Houston.config.environments
      puts "#{user.name} is subscribed to release notices for #{user.environments_subscribed_to.to_sentence}"
      user.save
    end
  end

  def down
    remove_column :users, :environments_subscribed_to
  end
end

Version data entries

27 entries across 27 versions & 1 rubygems

Version Path
houston-core-0.9.2 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.9.1 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.9.0 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.9.0.rc1 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.8.4 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.8.3 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.8.2 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.8.1 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.8.0 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.8.0.pre2 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.8.0.pre db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.7.0 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.7.0.beta4 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.7.0.beta3 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.7.0.beta2 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.7.0.beta db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.6.3 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.6.2 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.6.1 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb
houston-core-0.6.0 db/migrate/20130416020627_add_environments_subscribed_to_to_users.rb