Contents

Sequel.migration do
  up do
    from(:temp_integrations).insert(
      [:consumer_id, :consumer_name, :provider_id, :provider_name, :created_at],
      from(:pact_publications)
        .select(
          :consumer_id,
          Sequel[:c][:name].as(:consumer_name),
          :provider_id,
          Sequel[:p][:name].as(:provider_name),
          Sequel[:c][:created_at]
        ).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

  down do

  end
end

Version data entries

36 entries across 36 versions & 1 rubygems

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