Contents

Sequel.migration do
  change do
    create_or_replace_view(:latest_tagged_pact_consumer_version_orders,
      "select provider_id, consumer_id, t.name as tag_name, max(consumer_version_order) as latest_consumer_version_order
      from all_pacts ap
      inner join tags t
      on t.version_id = ap.consumer_version_id
      group by provider_id, consumer_id, t.name"
    )

    create_or_replace_view(:latest_tagged_pacts,
      "select ap.*, lp.tag_name
      from all_pacts ap
      inner join latest_tagged_pact_consumer_version_orders lp
      on ap.consumer_id = lp.consumer_id
        and ap.provider_id = lp.provider_id
        and ap.consumer_version_order = latest_consumer_version_order"
    )
  end
end

Version data entries

202 entries across 202 versions & 1 rubygems

Version	Path
pact_broker-2.114.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.113.2	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.113.1	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.113.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.112.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.111.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.109.1	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.109.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.108.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.107.1	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.107.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.107.0.beta.1	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.106.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.105.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.104.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.103.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.102.2	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.102.1	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.102.0	db/migrations/000022_create_latest_tagged_pacts_view.rb
pact_broker-2.101.0	db/migrations/000022_create_latest_tagged_pacts_view.rb