Contents

Sequel.migration do
  up do
    # consumer_id and provider_id are redundant by avoid making extra joins when creating views
    rows = from(:verifications).select_group(
          Sequel[:verifications][:consumer_id],
          Sequel[:verifications][:pact_version_id],
          Sequel[:verifications][:provider_id],
          Sequel[:verifications][:provider_version_id])
        .select_append{ max(verifications[id]).as(verification_id) }

    # The danger with this migration is that a verification created by an old node will be lost
    from(:latest_verification_id_for_pact_version_and_provider_version).insert(rows)
  end

  down do
    from(:latest_verification_id_for_pact_version_and_provider_version).delete
  end
end

Version data entries

122 entries across 122 versions & 1 rubygems

Version	Path
pact_broker-2.39.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.38.1	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.38.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.37.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.36.1	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.36.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.35.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.34.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.33.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.32.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.31.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.30.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.29.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.27.6	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.27.5	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.27.4	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.27.3	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.27.2	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.27.0	db/migrations/20180724_migrate_latest_verification_ids.rb
pact_broker-2.26.1	db/migrations/20180724_migrate_latest_verification_ids.rb