Script: Add gender to genera with blank gender

[jonkerz]

Clears (batch 1) of https://antcat.org/database_scripts/genus_gender_endings_to_update_by_script

• Run script - Done: https://antcat.org/activities?id=53567&page=1#activity-53567

EDIT_SUMMARY = 'Add gender to genera with blank gender, see %github997'
ANTCATBOT = User.find_by!(name: 'AntCatBot')

# For activities and PaperTrail.
RequestStore.store[:current_request_uuid] = SecureRandom.uuid
PaperTrail.request.whodunnit = ANTCATBOT.id

# ---

def endings
  {
    feminine: %w[idris myrma ponera pone formica myrmica gaster ella ia ula],
    masculine: %w[myrmex oides ius],
    neuter: %w[omma noma ium]
  }
end

def blank_to_feminine
  endings_regex = endings[:feminine].join('|')
  Genus.joins(:name).
    where("names.gender IS NULL").where("name_cache REGEXP ?", "#{endings_regex}$").
    order_by_name
end

def blank_to_masculine
  endings_regex = endings[:masculine].join('|')
  Genus.joins(:name).
    where("names.gender IS NULL").where("name_cache REGEXP ?", "#{endings_regex}$").
    order_by_name
end

def blank_to_neuter
  endings_regex = endings[:neuter].join('|')
  Genus.joins(:name).
    where("names.gender IS NULL").where("name_cache REGEXP ?", "#{endings_regex}$").
    order_by_name
end

blank_to_feminine.each do |genus|
  name = genus.name
  name.update!(gender: 'feminine')
  name.create_activity :update, ANTCATBOT, edit_summary: "Set gender to 'feminine', see %github997"
end

blank_to_masculine.each do |genus|
  name = genus.name
  name.update!(gender: 'masculine')
  name.create_activity :update, ANTCATBOT, edit_summary: "Set gender to 'masculine', see %github997"
end

blank_to_neuter.each do |genus|
  name = genus.name
  name.update!(gender: 'neuter')
  name.create_activity :update, ANTCATBOT, edit_summary: "Set gender to 'neuter', see %github997"
end

# ---

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

[jonkerz]

Clears (batch 2) of https://antcat.org/database_scripts/genus_gender_endings_to_update_by_script

• Run script - Done: https://antcat.org/activities?id=53776&page=1#activity-53776

EDIT_SUMMARY = 'Add gender to genera with blank gender, batch 2, see %github997'
ANTCATBOT = User.find_by!(name: 'AntCatBot')

# For activities and PaperTrail.
RequestStore.store[:current_request_uuid] = SecureRandom.uuid
PaperTrail.request.whodunnit = ANTCATBOT.id

# ---

def endings
  {
    feminine: %w[a e opsis lepis],
    masculine: %w[er es ops os us],
    neuter: %w[on um]
  }
end

def blank_to_feminine
  endings_regex = endings[:feminine].join('|')
  Genus.joins(:name).
    where("names.gender IS NULL").where("name_cache REGEXP ?", "(#{endings_regex})$").
    order_by_name
end

def blank_to_masculine
  endings_regex = endings[:masculine].join('|')
  Genus.joins(:name).
    where("names.gender IS NULL").where("name_cache REGEXP ?", "(#{endings_regex})$").
    order_by_name
end

def blank_to_neuter
  endings_regex = endings[:neuter].join('|')
  Genus.joins(:name).
    where("names.gender IS NULL").where("name_cache REGEXP ?", "(#{endings_regex})$").
    order_by_name
end

blank_to_feminine.each do |genus|
  name = genus.name
  name.update!(gender: 'feminine')
  name.create_activity :update, ANTCATBOT, edit_summary: "Set gender to 'feminine', see %github997"
end

blank_to_masculine.each do |genus|
  name = genus.name
  name.update!(gender: 'masculine')
  name.create_activity :update, ANTCATBOT, edit_summary: "Set gender to 'masculine', see %github997"
end

blank_to_neuter.each do |genus|
  name = genus.name
  name.update!(gender: 'neuter')
  name.create_activity :update, ANTCATBOT, edit_summary: "Set gender to 'neuter', see %github997"
end

# ---

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