Script: Assign biogeographic regions from localities

[jonkerz]

See #695

• Run script - https://antcat.org/activities/96271

Script

EDIT_SUMMARY = 'Assign biogeographic regions from localities, see %github1128'
ANTCATBOT = User.find_by!(name: 'AntCatBot')

RequestStore.store[:current_request_uuid] = SecureRandom.uuid
PaperTrail.request.whodunnit = ANTCATBOT.id

protonyms = Protonym.joins(:name).
  where(names: { type: Name::SPECIES_GROUP_NAMES }).
  where(biogeographic_region: nil).where.not(locality: nil).
  where(fossil: false); nil

country_mappings = Protonym.where.not(biogeographic_region: nil).
  where.not(locality: nil).pluck(:locality, :biogeographic_region).to_h; nil

protonyms.each do |protonym|
  locality = protonym.locality
  locality_without_parens = locality.gsub(/\(.*\)/, "").gsub(/[".]/, "").squish

  biogeographic_region =
    country_mappings[locality] ||
    country_mappings[locality.downcase.upcase_first] ||
    country_mappings[locality_without_parens] ||
    country_mappings[locality_without_parens.downcase.upcase_first]

  next unless biogeographic_region

  protonym.update!(biogeographic_region: biogeographic_region)
  protonym.create_activity :update, ANTCATBOT,
    edit_summary: "Assign biogeographic region from locality (#{protonym.locality} --> #{biogeographic_region}), see %github1128"
end; nil

Activity.execute_script_activity User.find_by!(name: 'Fredrik Palmkron'), EDIT_SUMMARY

[bpescador]

sorry, I was thinking there might be a quick fix and not a scrip; I should have pointed out one issue: Mexico includes two bioregions, maybe that list I sent was not clear? Can you look at this one: https://www.antweb.org/bioregionCountryList.do my bad for not keeping up with this.

…

On Fri, Jul 31, 2020 at 9:45 AM Fredrik Palmkron ***@***.***> wrote: See #695 <#695> - Run script Script — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1128>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABP4NHEH66M3375R7YQJKP3R6LYKFANCNFSM4PQRPPTQ> .

-- Brian Fisher Curator of Entomology and Patterson Scholar 55 Music Concourse Drive California Academy of Sciences San Francisco, CA 94118, USA www.fisherlab.org Insects and People <http://ipsio.org> Madagascar Biodiversity Center <http://madagascarbio.org> www.antweb.org ResearchGate <https://www.researchgate.net/profile/Brian_Fisher7>