Sha256: 72a08a4475787dc14a8f9bbf09747d695b7494d3c58a2eea2ebb129ffe8810b2

Contents?: true

Size: 1 KB

Versions: 1

Compression:

Stored size: 1 KB

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