class AddDesignerToProducts < ActiveRecord::Migration[5.0]
  def change
    add_column :products, :designer_name, :string
    Product.all.each do |product|
      product.designer_name = product.designer
      product.save!
    end
    remove_column :products, :designer, :string

    add_reference :products, :designer, foreign_key: true
    Product.all.each do |product|
      designer_names = product.designer_name.split(' ')
      first_name = designer_names[0]
      last_name = designer_names[1]

      last_name = "#{last_name} #{designer_names[2]}" if designer_names[2]

      selected_designer = Designer.find_by(first_name: first_name, last_name: last_name)
      selected_designer ? product.update(designer_id: designer.id) : nil
    end
    remove_column :products, :designer_name, :string
  end
end