Contents

Sequel.migration do
  up do
    from(:triggered_webhooks).where(webhook_id: nil).each do | triggered_webhook |
      from(:webhook_executions).where(triggered_webhook_id: triggered_webhook[:id]).delete
      from(:triggered_webhooks).where(id: triggered_webhook[:id]).delete
    end

    from(:webhook_executions).where(webhook_id: nil, triggered_webhook_id: nil).delete
  end

  # TODO
  # alter_table(:triggered_webhooks) do
  #  set_column_not_null(:webhook_id)
  # end

  down do
  end
end

Version data entries

153 entries across 153 versions & 1 rubygems

Version	Path
pact_broker-2.14.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.13.1	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.13.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.12.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.11.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.10.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.9.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.9.0.beta.5	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.8.0.beta.5	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.8.0.beta.4	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.7.0.beta.3	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.7.0.beta.2	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.7.0.beta.1	db/migrations/42_delete_orphan_webhook_data.rb