Sha256: 69e68759366d7b8a3885fdfe8c2a0e70367a2c594d38993c52acafb1a8b62826

Contents?: true

Size: 499 Bytes

Versions: 34

Compression:

Stored size: 499 Bytes

Contents

class PopulateEmailAddresses < ActiveRecord::Migration
  def self.up
    t = EmailAddress.connection.quoted_true
    n = EmailAddress.connection.quoted_date(Time.now)

    sql = "INSERT INTO #{EmailAddress.table_name} (user_id, address, is_default, notify, created_on, updated_on)" +
          " SELECT id, mail, #{t}, #{t}, '#{n}', '#{n}' FROM #{User.table_name} WHERE type = 'User' ORDER BY id"
    EmailAddress.connection.execute(sql)
  end

  def self.down
    EmailAddress.delete_all
  end
end

Version data entries

34 entries across 34 versions & 1 rubygems

Version Path
redmine_extensions-0.0.39 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.0.38 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.0.37 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.11 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.10 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.0.36 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.0.34 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.09 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.07 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.06 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.05 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.04 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.03 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.0.33 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.02 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.1.01 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.0.29 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.0.28 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.0.27 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb
redmine_extensions-0.0.24 spec/redmine/db/migrate/20150113211532_populate_email_addresses.rb