Contents

Sequel.migration do
  up 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_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"
    )
  end

  down do
    drop_view(:latest_triggered_webhooks)
    drop_view(:latest_triggered_webhook_ids)
  end
end

Version data entries

157 entries across 157 versions & 1 rubygems

Version	Path
pact_broker-2.113.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.112.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.111.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.109.1	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.109.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.108.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.107.1	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.107.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.107.0.beta.1	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.106.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.105.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.104.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.103.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.102.2	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.102.1	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.102.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.101.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.100.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.99.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb
pact_broker-2.98.0	db/migrations/000040_create_latest_triggered_webhooks_view.rb