Contents

class AddSiteIdToPages < ActiveRecord::Migration[5.1]
  def self.up
    add_column :pages, :site_id, :integer, required: true
    add_index :pages, :site_id

    Site.all.each do |site|
      homepage = site.homepage
      homepage.site_id = site.id
      homepage.save
      unless homepage.id == Page.root.id
        homepage.descendants.each do |page|
          page.site_id = site.id
          page.save
        end
      end
    end

  end

  def self.down
    remove_index :pages, site_id
    remove_column :pages, :site_id
  end
end

Version data entries

9 entries across 9 versions & 2 rubygems

Version	Path
trusty-cms-3.3.2	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-3.3.1	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-3.2.1	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-3.3.0	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-3.2.0	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-3.1.11	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-3.1.10	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-3.1.9	db/migrate/026_add_site_id_to_pages.rb
trusty-multi-site-extension-3.1.0	db/migrate/2015032011031415046078_add_site_id_to_pages.rb