Sha256: 4c992f3a680acbfe906adc0ba4fc4280bd5e92e318aec0730673ddc3aeff9eb9

Contents?: true

Size: 950 Bytes

Versions: 48

Compression:

Stored size: 950 Bytes

Contents

require "pact_broker/db/data_migrations/helpers"

module PactBroker
  module DB
    module DataMigrations
      class SetCreatedAtForLatestPactPublications
        def self.call connection
          # pact ordering goes by creation date of the consumer version
          connection[:latest_pact_publication_ids_for_consumer_versions]
          query = "UPDATE latest_pact_publication_ids_for_consumer_versions
                  SET created_at = (SELECT created_at
                    FROM versions
                    WHERE id = latest_pact_publication_ids_for_consumer_versions.consumer_version_id)
                  WHERE created_at IS NULL"
          connection.run(query)
        end

        def self.columns_exist?(connection)
          column_exists?(connection, :latest_pact_publication_ids_for_consumer_versions, :created_at) &&
            column_exists?(connection, :pact_publications, :created_at)
        end
      end
    end
  end
end

Version data entries

48 entries across 48 versions & 1 rubygems

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