Sha256: 0d8e2f36b0fc21771e4ca66d4a0331f1d0ad7d55ccb53febb4dee39d3a733d99

Contents?: true

Size: 815 Bytes

Versions: 109

Compression:

Stored size: 815 Bytes

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

109 entries across 109 versions & 1 rubygems

Version Path
pact_broker-2.79.1 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.79.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.78.1 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.78.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.77.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.76.2 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.76.1 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.76.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.75.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.74.1 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.74.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.73.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.72.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.71.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.70.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.69.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.68.1 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.68.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.67.0 db/migrations/000044_populate_verifications_provider_version_id.rb
pact_broker-2.66.0 db/migrations/000044_populate_verifications_provider_version_id.rb