Contents

Sequel.migration do
  up do
    from(:verifications)
      .select(Sequel[:verifications][:id], :provider_version, :provider_id, Sequel[:verifications][:created_at])
      .join(:pact_versions, {id: :pact_version_id})
      .each do | line |
        version = from(:versions)
          .where(number: line[:provider_version], pacticipant_id: line[:provider_id]).single_record
        version_id = if version
                       version[:id]
                     else
                       from(:versions).insert(
                         number: line[:provider_version],
                         pacticipant_id: line[:provider_id],
                         created_at: line[:created_at],
                         updated_at: line[:created_at]
                       )
                     end
        from(:verifications).where(id: line[:id]).update(provider_version_id: version_id)
      end
  end

  down do
  end
end

Version data entries

45 entries across 45 versions & 1 rubygems

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