annotate db/migrate/.svn/text-base/20100129193813_update_mail_notification_values.rb.svn-base @ 866:2cd212a468b6
bug_152
Close obsolete branch bug_152
| author |
Chris Cannam |
| date |
Wed, 11 May 2011 10:08:34 +0100 |
| parents |
94944d00e43c |
| children |
af80e5618e9b |
| rev |
line source |
|
chris@37
|
1 # Patch the data from a boolean change.
|
|
chris@37
|
2 class UpdateMailNotificationValues < ActiveRecord::Migration
|
|
chris@37
|
3 def self.up
|
|
chris@37
|
4 User.update_all("mail_notification = 'all'", "mail_notification IN ('1', 't')")
|
|
chris@37
|
5 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)")
|
|
chris@37
|
6 User.update_all("mail_notification = 'only_my_events'", "mail_notification NOT IN ('all', 'selected')")
|
|
chris@37
|
7 end
|
|
chris@37
|
8
|
|
chris@37
|
9 def self.down
|
|
chris@37
|
10 # No-op
|
|
chris@37
|
11 end
|
|
chris@37
|
12 end
|
