Script: Convert tax tags in 'synonym of' history items to prott tags

[jonkerz]

TODO:

• Write script
• Run script

These:

• https://antcat.org/database_scripts/convert_tax_tags_to_prott_tags_junior_synonym_of
• https://antcat.org/database_scripts/convert_tax_tags_to_prott_tags_senior_synonym_of

[jonkerz]

Closes https://github.com/calacademy-research/antcat-issues/issues/8

[jonkerz]

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

Batch 1

BATCH = 1
EDIT_SUMMARY = "Convert tax tags in 'synonym of' history items to prott tags [batch #{BATCH}] (junior synonym of), see %github1183"
ANTCATBOT = User.find_by!(name: 'AntCatBot')

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

def replace_with_prott_tag history_item
  puts "ID: #{history_item.id}"
  old_taxt = history_item.taxt.dup

  extracted_taxon = Taxon.find(history_item.ids_from_tax_or_taxac_tags.first)
  new_taxt = old_taxt.sub(
    /\{tax #{extracted_taxon.id}\}/,
    "{prott #{extracted_taxon.protonym.id}}"
  )

  puts "old_taxt: #{old_taxt}".yellow
  puts "new_taxt: #{new_taxt}".green
  puts

  history_item.update!(taxt: new_taxt)
  history_item.create_activity :update, ANTCATBOT, edit_summary: EDIT_SUMMARY
end

items = HistoryItem.where('taxt REGEXP ?', "^Junior synonym of {tax [0-9]+}: {ref [0-9]+}: [0-9]+\.?$"); nil

items.each do |item|
  replace_with_prott_tag item
end; nil

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

[jonkerz]

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

Batch 2

BATCH = 2
EDIT_SUMMARY = "Convert tax tags in 'synonym of' history items to prott tags [batch #{BATCH}] (senior synonym of), see %github1183"
ANTCATBOT = User.find_by!(name: 'AntCatBot')

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

def replace_with_prott_tag history_item
  puts "ID: #{history_item.id}"
  old_taxt = history_item.taxt.dup

  extracted_taxon = Taxon.find(history_item.ids_from_tax_or_taxac_tags.first)
  new_taxt = old_taxt.sub(
    /\{tax #{extracted_taxon.id}\}/,
    "{prott #{extracted_taxon.protonym.id}}"
  )

  puts "old_taxt: #{old_taxt}".yellow
  puts "new_taxt: #{new_taxt}".green
  puts

  history_item.update!(taxt: new_taxt)
  history_item.create_activity :update, ANTCATBOT, edit_summary: EDIT_SUMMARY
end

items = HistoryItem.where('taxt REGEXP ?', "^Senior synonym of {tax [0-9]+}: {ref [0-9]+}: [0-9]+\.?$"); nil

items.each do |item|
  replace_with_prott_tag item
end; nil

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

[jonkerz]

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

Batch 3

BATCH = 3
EDIT_SUMMARY = "Convert tax tags in 'synonym of' history items to prott tags [batch #{BATCH}] (junior synonym of), see %github1183"
ANTCATBOT = User.find_by!(name: 'AntCatBot')

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

def replace_with_prott_tag history_item
  puts "ID: #{history_item.id}"
  old_taxt = history_item.taxt.dup

  extracted_taxon = Taxon.find(history_item.ids_from_taxon_tags.first)
  new_taxt = old_taxt.sub(
    /\{tax #{extracted_taxon.id}\}/,
    "{prott #{extracted_taxon.protonym.id}}"
  )

  puts "old_taxt: #{old_taxt}".yellow
  puts "new_taxt: #{new_taxt}".green
  puts

  history_item.update!(taxt: new_taxt)
  history_item.create_activity :update, ANTCATBOT, edit_summary: EDIT_SUMMARY
end

items = HistoryItem.where('taxt REGEXP ?', "^Junior synonym of {tax [0-9]+}: {ref [0-9]+}: "); nil

items.each do |item|
  replace_with_prott_tag item
end; nil

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

[jonkerz]

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

Batch 4

BATCH = 4
EDIT_SUMMARY = "Convert tax tags in 'synonym of' history items to prott tags [batch #{BATCH}] (senior synonym of), see %github1183"
ANTCATBOT = User.find_by!(name: 'AntCatBot')

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

def replace_with_prott_tag history_item
  puts "ID: #{history_item.id}"
  old_taxt = history_item.taxt.dup

  extracted_taxon = Taxon.find(history_item.ids_from_taxon_tags.first)
  new_taxt = old_taxt.sub(
    /\{tax #{extracted_taxon.id}\}/,
    "{prott #{extracted_taxon.protonym.id}}"
  )

  puts "old_taxt: #{old_taxt}".yellow
  puts "new_taxt: #{new_taxt}".green
  puts

  history_item.update!(taxt: new_taxt)
  history_item.create_activity :update, ANTCATBOT, edit_summary: EDIT_SUMMARY
end

items = HistoryItem.where('taxt REGEXP ?', "^Senior synonym of {tax [0-9]+}: {ref [0-9]+}: "); nil

items.each do |item|
  replace_with_prott_tag item
end; nil

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

[jonkerz]

• Run script

Batch 5

BATCH = 5
EDIT_SUMMARY = "Convert tax tags in 'synonym of' history items to prottac tags [batch #{BATCH}] (junior synonym of), see %github1183"
ANTCATBOT = User.find_by!(name: 'AntCatBot')

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

def replace_with_prott_tag history_item
  puts "ID: #{history_item.id}"
  old_taxt = history_item.taxt.dup

  extracted_taxon = Taxon.find(history_item.ids_from_taxon_tags.first)
  new_taxt = old_taxt.sub(
    /\{taxac #{extracted_taxon.id}\}/,
    "{prottac #{extracted_taxon.protonym.id}}"
  )

  puts "old_taxt: #{old_taxt}".yellow
  puts "new_taxt: #{new_taxt}".green
  puts

  history_item.update!(taxt: new_taxt)
  history_item.create_activity :update, ANTCATBOT, edit_summary: EDIT_SUMMARY
end

items = HistoryItem.where('taxt REGEXP ?', "^Junior synonym of {taxac [0-9]+}: {ref [0-9]+}: "); nil

items.each do |item|
  replace_with_prott_tag item
end; nil

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

• Run script

Batch 6

BATCH = 6
EDIT_SUMMARY = "Convert tax tags in 'synonym of' history items to prottac tags [batch #{BATCH}] (senior synonym of), see %github1183"
ANTCATBOT = User.find_by!(name: 'AntCatBot')

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

def replace_with_prott_tag history_item
  puts "ID: #{history_item.id}"
  old_taxt = history_item.taxt.dup

  extracted_taxon = Taxon.find(history_item.ids_from_taxon_tags.first)
  new_taxt = old_taxt.sub(
    /\{taxac #{extracted_taxon.id}\}/,
    "{prottac #{extracted_taxon.protonym.id}}"
  )

  puts "old_taxt: #{old_taxt}".yellow
  puts "new_taxt: #{new_taxt}".green
  puts

  history_item.update!(taxt: new_taxt)
  history_item.create_activity :update, ANTCATBOT, edit_summary: EDIT_SUMMARY
end

items = HistoryItem.where('taxt REGEXP ?', "^Senior synonym of {taxac [0-9]+}: {ref [0-9]+}: "); nil

items.each do |item|
  replace_with_prott_tag item
end; nil

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