Class: PactBroker::DB::DataMigrations::SetCreatedAtForLatestVerifications
- Inherits:
-
Object
- Object
- PactBroker::DB::DataMigrations::SetCreatedAtForLatestVerifications
- Defined in:
- lib/pact_broker/db/data_migrations/set_created_at_for_latest_verifications.rb
Class Method Summary collapse
Class Method Details
.call(connection) ⇒ Object
7 8 9 10 11 12 13 14 15 |
# 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) ⇒ Boolean
17 18 19 20 |
# 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 |