Contents

# frozen_string_literal: true
class RemoveSiteIdFromNodes < ActiveRecord::Migration[5.2]
  def up
    remove_foreign_key :alchemy_nodes, :alchemy_sites
    remove_index :alchemy_nodes, :site_id
    remove_column :alchemy_nodes, :site_id, :integer, null: false
  end

  def down
    add_column :alchemy_nodes, :site_id, :integer, null: true
    sql = <<~SQL
      UPDATE alchemy_nodes
      SET site_id = (
        SELECT alchemy_languages.site_id FROM alchemy_languages WHERE alchemy_nodes.language_id = alchemy_languages.id
      ) WHERE
      EXISTS (
        SELECT *
        FROM alchemy_languages
        WHERE alchemy_languages.id = alchemy_nodes.language_id
      );
    SQL

    connection.execute(sql)
    change_column :alchemy_nodes, :site_id, :integer, null: false
    add_index :alchemy_nodes, :site_id
    add_foreign_key :alchemy_nodes, :alchemy_sites, column: :site_id
  end
end

Version data entries

58 entries across 58 versions & 1 rubygems

Version	Path
alchemy_cms-5.3.8	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.3.7	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.3.6	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.3.5	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.3.4	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.3.3	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.3.2	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.3.1	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.3.0	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.2.7	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.2.6	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.1.10	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.0.10	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-6.0.0.pre.rc4	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-6.0.0.pre.rc3	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.2.5	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.1.9	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.0.9	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.2.4	db/migrate/20200504210159_remove_site_id_from_nodes.rb
alchemy_cms-5.1.8	db/migrate/20200504210159_remove_site_id_from_nodes.rb