Contents

Sequel.migration do
  change do
    # Removes 'overwritten' pacts and verifications from the matrix
    # (ie. only show latest pact revision for each consumer version and
    # latest verification for each provider version)
    # Must include lines where verification_id is null so that we don't
    # lose the unverified pacts.
    # In this view there will be one row for each consumer version/provider version
    create_view(:latest_matrix,
      "SELECT matrix.* FROM matrix
      INNER JOIN latest_verification_id_for_consumer_version_and_provider_version AS lv
      ON ((matrix.consumer_version_id = lv.consumer_version_id)
      AND (matrix.provider_version_id = lv.provider_version_id)
      AND ((matrix.verification_id = lv.latest_verification_id)))

      UNION

      select matrix.* 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
      where verification_id is null
      "
    )
  end
end

Version data entries

139 entries across 139 versions & 1 rubygems

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