Contents

require 'digest/sha1'
require_relative 'migration_helper'

Sequel.migration do
  change do
    create_or_replace_view(:latest_pact_consumer_version_orders,
      "select provider_id, consumer_id, max(consumer_version_order) as latest_consumer_version_order
      from all_pacts
      group by provider_id, consumer_id"
    )

    create_or_replace_view(:latest_pacts,
      "select ap.*
      from all_pacts ap
      inner join latest_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

159 entries across 159 versions & 1 rubygems

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