Sha256: 00c1586709b331c3c146550005df6932757e9d44d0714752f588a84f7f0fdde8

Contents?: true

Size: 480 Bytes

Versions: 1

Compression:

Stored size: 480 Bytes

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