Contents

Sequel.migration do
  up do
    run("insert into pact_versions (sha, content, created_at) select sha, content, created_at from pact_version_contents")
    run("update pact_versions set consumer_id = (select consumer_id from all_pacts where pact_version_content_sha = pact_versions.sha limit 1)")
    run("update pact_versions set provider_id = (select provider_id from all_pacts where pact_version_content_sha = pact_versions.sha limit 1)")
    run("delete from pact_versions where consumer_id is null")
  end
end

Version data entries

177 entries across 177 versions & 1 rubygems

Version	Path
pact_broker-2.97.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.96.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.95.1	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.95.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.94.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.93.4	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.93.3	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.93.2	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.93.1	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.93.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.92.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.91.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.90.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.89.1	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.89.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.88.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.87.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.86.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.85.1	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.85.0	db/migrations/000024_populate_pact_versions.rb