class PactBroker::DB::DataMigrations::SetCreatedAtForLatestVerifications

Public Class Methods

call(connection) click to toggle source
# File lib/pact_broker/db/data_migrations/set_created_at_for_latest_verifications.rb, line 7
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
columns_exist?(connection) click to toggle source
# File lib/pact_broker/db/data_migrations/set_created_at_for_latest_verifications.rb, line 17
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