Contents

Sequel.migration do
  up do
    transaction do
      drop_view :integrations
      rename_table :temp_integrations, :integrations
    end
  end

  down do
    transaction do
      rename_table :integrations, :temp_integrations
      create_view(:integrations,
        from(:pact_publications)
          .select(
            :consumer_id,
            Sequel[:c][:name].as(:consumer_name),
            :provider_id,
            Sequel[:p][:name].as(:provider_name)
          ).distinct
          .join(:pacticipants, {:id => :consumer_id}, {:table_alias => :c, implicit_qualifier: :pact_publications})
          .join(:pacticipants, {:id => :provider_id}, {:table_alias => :p, implicit_qualifier: :pact_publications})
      )
    end
  end
end

Version data entries

36 entries across 36 versions & 1 rubygems

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