Sha256: 2c83bd73fd2c6be14a02421e11d203ca28d4b624a467ae828fa4907dfd120721
Contents?: true
Size: 895 Bytes
Versions: 29
Compression:
Stored size: 895 Bytes
Contents
# frozen_string_literal: true
class RemoveSiteIdFromNodes < ActiveRecord::Migration[6.0]
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
29 entries across 29 versions & 1 rubygems