Sha256: 99a8980b5bf9b4a0bfc306884e8d0fdc8b8f9edaac81aab1a21de68d3c7af0c5

Contents?: true

Size: 916 Bytes

Versions: 42

Compression:

Stored size: 916 Bytes

Contents

require 'pact_broker/db/data_migrations/helpers'

module PactBroker
  module DB
    module DataMigrations
      class SetCreatedAtForLatestVerifications
        def self.call connection
          connection[:latest_verification_id_for_pact_version_and_provider_version]
          query = "UPDATE latest_verification_id_for_pact_version_and_provider_version
                  SET created_at = (SELECT created_at
                    FROM verifications
                    WHERE id = latest_verification_id_for_pact_version_and_provider_version.verification_id)
                  WHERE created_at is null"
          connection.run(query)
        end

        def self.columns_exist?(connection)
          column_exists?(connection, :latest_verification_id_for_pact_version_and_provider_version, :created_at) &&
            column_exists?(connection, :verifications, :created_at)
        end
      end
    end
  end
end

Version data entries

42 entries across 42 versions & 1 rubygems

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