# 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