Contents

require_relative "../ddl_statements"

Sequel.migration do
  up do
    create_view(:latest_verification_ids_for_consumer_version_tags, LATEST_VERIFICATION_IDS_FOR_CONSUMER_VERSION_TAGS_V1)

    # The most recent verification for each consumer/consumer version tag/provider
    latest_verifications = from(:verifications)
      .select(
        Sequel[:lv][:consumer_id],
        Sequel[:lv][:provider_id],
        Sequel[:lv][:consumer_version_tag_name],
        Sequel[:pv][:sha].as(:pact_version_sha),
        Sequel[:prv][:number].as(:provider_version_number),
        Sequel[:prv][:order].as(:provider_version_order),
        )
      .select_append{ verifications.* }
      .join(:latest_verification_ids_for_consumer_version_tags,
        {
          Sequel[:verifications][:id] => Sequel[:lv][:latest_verification_id],
        }, { table_alias: :lv })
      .join(:versions,
        {
          Sequel[:verifications][:provider_version_id] => Sequel[:prv][:id]
        }, { table_alias: :prv })
      .join(:pact_versions,
        {
          Sequel[:verifications][:pact_version_id] => Sequel[:pv][:id]
        }, { table_alias: :pv })

    create_or_replace_view(:latest_verifications_for_consumer_version_tags, latest_verifications)
  end

  down do
    drop_view(:latest_verifications_for_consumer_version_tags)
    drop_view(:latest_verification_ids_for_consumer_version_tags)
  end
end

Version data entries

48 entries across 48 versions & 1 rubygems

Version	Path
pact_broker-2.114.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.113.2	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.113.1	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.113.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.112.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.111.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.109.1	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.109.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.108.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.107.1	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.107.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.107.0.beta.1	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.106.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.105.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.104.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.103.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.102.2	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.102.1	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.102.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb
pact_broker-2.101.0	db/migrations/20180523_create_latest_verifications_for_consumer_version_tags.rb