Contents

Sequel.migration do
  up do
    create_view(:latest_verification_numbers,
      "SELECT pact_version_id, MAX(number) latest_number
          FROM verifications
          GROUP BY pact_version_id")

    # The most recent verification for each pact version
    create_or_replace_view(:latest_verifications,
      "SELECT v.id, v.number, v.success, v.provider_version, v.build_url, v.pact_version_id, v.execution_date, v.created_at
        FROM verifications v
        INNER JOIN latest_verification_numbers lv ON v.pact_version_id = lv.pact_version_id AND v.number = lv.latest_number"
    )
  end
end

Version data entries

166 entries across 166 versions & 1 rubygems

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