20100129193813_update_mail_notification_values.rb
12 lines
| 583 B
| text/x-ruby
|
RubyLexer
|
r4102 | # Patch the data from a boolean change. | ||
class UpdateMailNotificationValues < ActiveRecord::Migration | ||||
def self.up | ||||
|
r4254 | User.update_all("mail_notification = 'all'", "mail_notification IN ('1', 't')") | ||
User.update_all("mail_notification = 'selected'", "EXISTS (SELECT 1 FROM #{Member.table_name} WHERE #{Member.table_name}.mail_notification = #{connection.quoted_true} AND #{Member.table_name}.user_id = #{User.table_name}.id)") | ||||
User.update_all("mail_notification = 'only_my_events'", "mail_notification NOT IN ('all', 'selected')") | ||||
|
r4102 | end | ||
def self.down | ||||
# No-op | ||||
end | ||||
end | ||||