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

176 entries across 176 versions & 1 rubygems

Version	Path
pact_broker-2.68.1	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.68.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.67.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.66.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.65.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.64.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.63.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.62.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.61.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.60.1	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.60.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.59.2	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.59.1	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.59.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.58.3	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.58.2	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.58.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.57.0	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.56.1	db/migrations/000024_populate_pact_versions.rb
pact_broker-2.56.0	db/migrations/000024_populate_pact_versions.rb