class Sandbox

Public Class Methods

new(dir) click to toggle source
# File lib/db_helper/sandbox.rb, line 4
def initialize(dir)
  @dir = dir
end

Public Instance Methods

import(file) click to toggle source
# File lib/db_helper/sandbox.rb, line 8
def import(file)
  if file.end_with?('tar.gz')
    import_innobackup(file)
  elsif file.end_with?('sql.gz')
    import_sql(file)
  else
    raise "Unrecognised file format for #{file}."
  end
end
import_innobackup(file) click to toggle source
# File lib/db_helper/sandbox.rb, line 26
def import_innobackup(file)
  if File.exist?(data_new = File.join(@dir, 'data.new'))
    command "rm -rf #{data_new}"
  end
  command File.join(@dir,'start')
  command "mkdir #{data_new}"
  command "mv #{File.join(@dir, file)} #{File.join(data_new, file)}"
  command "cd #{data_new} && tar -xzf #{file}"
  command "rm #{File.join(data_new, file)}"
  command File.join(@dir,'stop')
  command "rm -rf #{File.join(@dir,'data')}"
  command "mv #{data_new} #{File.join(@dir,'data')}"
  command File.join(@dir,'start')
end
import_sql(file) click to toggle source
# File lib/db_helper/sandbox.rb, line 18
def import_sql(file)
  command "gunzip #{File.join(@dir, file)}"
  command File.join(@dir, 'start')
  db_name = file.gsub(/_[0-9]{4}.*/, '')
  command "#{File.join(@dir, 'use')} #{db_name} < #{File.join(@dir, file.sub('.gz',''))}"
  command "rm #{File.join(@dir, file.sub('.gz',''))}"
end