Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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
Add Comment
Please, Sign In to add comment