Contents

require 'digest/sha1'
require_relative 'migration_helper'

Sequel.migration do
  change do
    create_or_replace_view(:all_pacts,
        Sequel::Model.db[:pacts].select(
        Sequel[:pacts][:id],
        Sequel[:c][:id].as(:consumer_id), Sequel[:c][:name].as(:consumer_name),
        Sequel[:cv][:id].as(:consumer_version_id), Sequel[:cv][:number].as(:consumer_version_number), Sequel[:cv][:order].as(:consumer_version_order),
        Sequel[:p][:id].as(:provider_id), Sequel[:p][:name].as(:provider_name),
        Sequel[:pvc][:sha].as(:pact_version_content_sha), Sequel[:pacts][:created_at], Sequel[:pacts][:updated_at]).
        join(:versions, {:id => :version_id}, {:table_alias => :cv, implicit_qualifier: :pacts}).
        join(:pacticipants, {:id => :pacticipant_id}, {:table_alias => :c, implicit_qualifier: :cv}).
        join(:pacticipants, {:id => :provider_id}, {:table_alias => :p, implicit_qualifier: :pacts}).
        join(:pact_version_contents, {:sha => :pact_version_content_sha}, {:table_alias => :pvc, implicit_qualifier: :pacts})
      )

  end
end

Version data entries

127 entries across 127 versions & 1 rubygems

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