Contents

Sequel.migration do
  change do
    # joining with latest_pact_publication_revision_numbers gets rid of the overwritten
    # pact revisions, and the max(verification_id) gets rid of the overwritten
    # verifications
    create_view(:latest_verification_id_for_consumer_version_and_provider_version,
      "select consumer_version_id, provider_version_id, max(verification_id) as latest_verification_id
      from matrix
      inner join latest_pact_publication_revision_numbers lr
        on matrix.consumer_id = lr.consumer_id
        and matrix.provider_id = lr.provider_id
        and matrix.consumer_version_order = lr.consumer_version_order
        and matrix.pact_revision_number = lr.latest_revision_number
        group by consumer_version_id, provider_version_id"
    )
  end
end

Version data entries

153 entries across 153 versions & 1 rubygems

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