Contents

class AddSiteIdToPages < ActiveRecord::Migration[5.2]
  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

123 entries across 123 versions & 1 rubygems

Version	Path
trusty-cms-7.0.18	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.17	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.16	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.14	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.13	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.12	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.15	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.9.1	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.11	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.10	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.9	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.8	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.7	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.6	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.5	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.4	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.3	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-6.3.1	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.2	db/migrate/026_add_site_id_to_pages.rb
trusty-cms-7.0.1	db/migrate/026_add_site_id_to_pages.rb