Specify settings in mysql launchctl plist file

mysqlopts.rb

#!/usr/bin/env ruby

plist_file = File.expand_path('~/Library/LaunchAgents/homebrew.mxcl.mysql.plist')

File.open(plist_file, 'r+') do |f|
  contents = f.read

  args_end     = '  </array>' # this is kinda brittle, but whatever
  charset_opt  = '    <string>--character-set-server=latin1</string>'
  collate_opt  = '    <string>--collation-server=latin1_swedish_ci</string>'
  sql_mode_opt = '    <string>--sql-mode=NO_ENGINE_SUBSTITUTION</string>'

  contents.sub!(args_end, [charset_opt,  args_end].join("\n")) unless contents.include?('character-set-server')
  contents.sub!(args_end, [collate_opt,  args_end].join("\n")) unless contents.include?('collation-server')
  contents.sub!(args_end, [sql_mode_opt, args_end].join("\n")) unless contents.include?('sql-mode')

  f.rewind
  f.write(contents)
end