Contents

Sequel.migration do
  up do
    # The most recent verification for each pact_version
    v = :verifications
    create_or_replace_view(:latest_verifications_for_pact_versions,
      from(v)
        .select(
          Sequel[v][:id],
          Sequel[v][:number],
          Sequel[v][:success],
          Sequel[v][:build_url],
          Sequel[v][:pact_version_id],
          Sequel[v][:execution_date],
          Sequel[v][:created_at],
          Sequel[v][:provider_version_id],
          Sequel[:s][:number].as(:provider_version_number),
          Sequel[:s][:order].as(:provider_version_order),
          Sequel[v][:test_results])
        .join(:latest_verification_ids_for_pact_versions,
          {
            Sequel[v][:pact_version_id] => Sequel[:lv][:pact_version_id],
            Sequel[v][:id] => Sequel[:lv][:latest_verification_id]
          }, { table_alias: :lv })
        .join(:versions,
          {
            Sequel[v][:provider_version_id] => Sequel[:s][:id]
          }, { table_alias: :s })
    )
  end

  down do
    # do nothing - you can't drop columns from a postgres view
  end
end

Version data entries

104 entries across 104 versions & 1 rubygems

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