Contents

class AddForeignKeysToDiagnosticos < ActiveRecord::Migration[5.0]
  def up
    ActiveRecord::Base.connection.execute(
        "UPDATE diagnosticos SET consulta_id = null WHERE consulta_id NOT IN (SELECT id FROM consultas)"
    )

    add_foreign_key :diagnosticos, :consultas, on_delete: :cascade
    add_foreign_key :diagnosticos, :cids, on_delete: :cascade
  end

  def down
    remove_foreign_key :diagnosticos, :consultas
    remove_foreign_key :diagnosticos, :cids
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
omniauth-sabia-1.0.1	db/migrate/20170524131536_add_foreign_keys_to_diagnosticos.rb