Contents

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

    add_foreign_key :consultas, :pacientes, on_delete: :cascade
    add_foreign_key :consultas, :profissionais, on_delete: :cascade
    add_foreign_key :consultas, :unidades_saude, on_delete: :cascade
    add_foreign_key :consultas, :agendamentos, on_delete: :cascade
    add_foreign_key :consultas, :profissionais, column: :supervisor_id, on_delete: :cascade
    add_foreign_key :consultas, :profissionais, column: :aluno_id, on_delete: :cascade
  end

  def down
    remove_foreign_key :consultas, :pacientes
    remove_foreign_key :consultas, :unidades_saude
    remove_foreign_key :consultas, :agendamentos
    remove_foreign_key :consultas, column: :profissional_id
    remove_foreign_key :consultas, column: :supervisor_id
    remove_foreign_key :consultas, column: :aluno_id
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
omniauth-sabia-1.0.1	db/migrate/20170524124536_add_foreign_keys_to_consultas.rb