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

44 entries across 44 versions & 1 rubygems

Version	Path
pact_broker-2.96.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.95.1	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.95.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.94.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.93.4	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.93.3	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.93.2	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.93.1	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.93.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.92.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.91.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.90.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.89.1	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.89.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.88.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.87.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.86.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.85.1	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.85.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb
pact_broker-2.84.0	db/migrations/000020_add_pact_version_content_sha_to_all_pacts_view.rb