db/migrate/20160310132619_create_missing_locids.rb

	20160310132619_create_missing_locids.rb revision 5a102b3c56d4ac75632c7e9244ee0ce5bdbbf13a
# Several sentences don't have a Loc/Id in our database. This shall fix it.
class CreateMissingLocids < MigrationWithData
  def up
    Sentence.where(locid: nil).select(:id).find_each do |sentence|
      ontology_id = select_attributes(sentence, :ontology_id)[:ontology_id]
      onto_locid = Ontology.where(id: ontology_id).pluck(:locid).first
      sentence_name = select_attributes(sentence, :name)[:name]
      sep = '//'
      sentence_locid = "#{onto_locid}#{sep}#{sentence_name}"
      update_columns(sentence, locid: sentence_locid)
    end

    OntologyMember::Symbol.where(locid: nil).select(:id).find_each do |symbol|
      ontology_id = select_attributes(symbol, :ontology_id)[:ontology_id]
      onto_locid = Ontology.where(id: ontology_id).pluck(:locid).first
      symbol_name = select_attributes(symbol, :name)[:name]
      sep = '//'
      symbol_locid = "#{onto_locid}#{sep}#{symbol_name}"
      update_columns(symbol, locid: symbol_locid)
    end
  end

  def down
    # Nothing to do because missing data was generated.
  end
end