This was used to convert component default assignee values if the user has example.com in their address

convert_bugzilla_components.sh

#!/bin/bash
components=$(mysql -BNe 'select * from bugs.components;' | tr '\t' '|')
AMY_ID=277

IFS=$'\n'
for x in $components;do
  component_id=$(echo ${x} | awk -F\| '{print $1}')
  default_assignee_id=$(echo ${x} | awk -F\| '{print $4}')
  default_assignee_email=$(mysql -BNe "select login_name from bugs.profiles where userid = '${default_assignee_id}';")
  example_email=$(echo ${default_assignee_email} | egrep -o 'example\.com')
  [[ -n ${example_email} ]] && example_email=true || example_email=false

  if [[ ${example_email} == "true" ]];then
    echo "Updated component id ${component_id} initialowner from ${default_assignee_id} to ${AMY_ID}"
    mysql -e "UPDATE bugs.components SET initialowner = '${AMY_ID}' WHERE id='${component_id}';"
  fi

   #mysql -e "UPDATE bugs.components SET initialqacontact = NULL WHERE id='${component_id}';"
done