Contents

require_relative '../ddl_statements/latest_triggered_webhooks'

Sequel.migration do
  up do
    create_or_replace_view(:latest_triggered_webhook_creation_dates, latest_triggered_webhook_creation_dates_v2)
    create_or_replace_view(:latest_triggered_webhook_ids, latest_triggered_webhook_ids_v2)
    create_or_replace_view(:latest_triggered_webhooks, latest_triggered_webhooks_v2)
  end

  down do
    create_or_replace_view(:latest_triggered_webhook_ids,
      "select webhook_uuid, consumer_id, provider_id, max(created_at) as latest_triggered_webhook_created_at
      from triggered_webhooks
      group by webhook_uuid, consumer_id, provider_id"
    )

    create_or_replace_view(:latest_triggered_webhooks,
      "select tw.*
      from triggered_webhooks tw
      inner join latest_triggered_webhook_ids ltwi
      on tw.consumer_id = ltwi.consumer_id
      and tw.provider_id = ltwi.provider_id
      and tw.webhook_uuid = ltwi.webhook_uuid
      and tw.created_at = ltwi.latest_triggered_webhook_created_at"
    )

    drop_view(:latest_triggered_webhook_creation_dates)
  end
end

Version data entries

20 entries across 20 versions & 1 rubygems

Version	Path
pact_broker-2.79.1	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.79.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.78.1	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.78.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.77.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.76.2	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.76.1	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.76.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.75.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.74.1	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.74.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.73.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.72.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.71.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.70.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.69.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.68.1	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.68.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.67.0	db/migrations/20180119_update_latest_triggered_webhooks.rb
pact_broker-2.66.0	db/migrations/20180119_update_latest_triggered_webhooks.rb