CLI wrapper for "FLUSH TABLES WITH READ LOCK"; usage mysql_with_ftwrl.rb do_snapshot --db=name

mysql_with_ftwrl.rb

#!/usr/bin/ruby

require 'dbi'

db_name = 'db_test'
db_user = 'username'
db_pass = 'pass1234'
db_host = '127.0.0.1'

exit_status = nil

begin
  dbh = DBI.connect("DBI:Mysql:#{db_name}:#{db_host}", db_user, db_pass)
  dbh.select_all('FLUSH TABLES WITH READ LOCK;')
  system(*ARGV)
  exit_status = $?.to_i >> 8
rescue DBI::DatabaseError => e
  puts "error (#{e.err}): #{e.errstr}"
  exit 1
ensure
  dbh.select_all('UNLOCK TABLES;')
  dbh.disconnect if dbh
end

exit exit_status