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.112.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.111.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.109.1	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.109.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.108.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.107.1	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.107.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.107.0.beta.1	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.106.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.105.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.104.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.103.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.102.2	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.102.1	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.102.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.101.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.100.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.99.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.98.0	db/migrations/000042_delete_orphan_webhook_data.rb
pact_broker-2.97.0	db/migrations/000042_delete_orphan_webhook_data.rb