Contents

# frozen_string_literal: true

class AddBlogIds < ActiveRecord::Migration[4.2]
  class Blog < ActiveRecord::Base; end
  class Content < ActiveRecord::Base; end
  class Sidebar < ActiveRecord::Base; end

  def up
    add_column :contents, :blog_id, :integer
    add_column :sidebars, :blog_id, :integer

    if Content.any? || Sidebar.any?
      default_blog_id = Blog.order(:id).first.id

      Content.update_all("blog_id = #{default_blog_id}")
      Sidebar.update_all("blog_id = #{default_blog_id}")
    end

    change_column :sidebars, :blog_id, :integer, null: false
  end

  def down
    if adapter_name == "PostgreSQL"
      indexes(:contents).each do |index|
        remove_index(:contents, name: index.name) if /blog_id/.match?(index.name)
      end
    else
      begin
        remove_index :contents, :blog_id
      rescue
        nil
      end
    end
    remove_column :contents, :blog_id
    remove_column :sidebars, :blog_id
  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version	Path
publify_core-9.2.10	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.9	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.8	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.7	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.6	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.5	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.4	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.3	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.2	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.1	db/migrate/20150808052637_add_blog_ids.rb
publify_core-9.2.0	db/migrate/20150808052637_add_blog_ids.rb