Y24-373 - Data migration to update sample_metadata country_of_origin

[neilsycamore]

Two country_of_origin of options ("not applicable: control sample" and "not applicable: sample group") have been identified and Y24-372 created to change these.

The samples in the Sequencescape and MLWH databases requires updating to reflect the changes
not applicable: control sample => missing: control sample
not applicable: sample group => missing: sample group

[neilsycamore]

this method will update samples table in SS & MLWH

def update_country_of_origin(old_id,new_id)
  ActiveRecord::Base.transaction do
    data = Sample::Metadata.where(country_of_origin: old_id)
    data.each {|sm| sm.update!(country_of_origin: new_id)}
  end
end