Class: PactBroker::DB::DataMigrations::SetExtraColumnsForTags

Inherits:
Object
  • Object
show all
Extended by:
Helpers
Defined in:
lib/pact_broker/db/data_migrations/set_extra_columns_for_tags.rb

Class Method Summary collapse

Methods included from Helpers

column_exists?, columns_exist?

Class Method Details

.call(connection) ⇒ Object 



9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
 
# File 'lib/pact_broker/db/data_migrations/set_extra_columns_for_tags.rb', line 9

def self.call(connection)
  if columns_exist?(connection, :tags, [:version_id, :pacticipant_id]) &&
      columns_exist?(connection, :versions, [:id, :pacticipant_id])
    connection[:tags].where(pacticipant_id: nil).update(
      pacticipant_id: connection[:versions].select(:pacticipant_id)
                        .where(Sequel[:versions][:id] => Sequel[:tags][:version_id])
    )
  end

  if columns_exist?(connection, :tags, [:version_id, :version_order]) &&
      columns_exist?(connection, :versions, [:id, :order])
    connection[:tags].where(version_order: nil).update(
      version_order: connection[:versions].select(:order)
                        .where(Sequel[:versions][:id] => Sequel[:tags][:version_id])
    )
  end
end