Contents

# Built in applicators
Hobo.asset_applicators.register /.*\.sql\.gz/ do |file|
  matches = file.match(/^([^\.]+).*\.sql\.gz/)
  db = File.basename(matches[1])

  status = {
    :db_exists => false,
    :db_has_tables => false
  }

  begin
    result = shell(vm_mysql(:db => db) << 'SHOW TABLES; SELECT FOUND_ROWS();', :capture => true)
    status[:db_exists] = true
    status[:db_has_tables] = !(result.split("\n").last.strip == '0')
  rescue Hobo::ExternalCommandError
    # This will fail later with a more useful error message
  end

  if status[:db_exists] && status[:db_has_tables]
    Hobo.ui.warning "Already applied (#{file})"
    next
  end

  if status[:db_exists] && !status[:db_has_tables]
    # Db exists but is empty
    shell(vm_mysql(:mysql => 'mysqladmin', :append => " --force drop #{db.shellescape}"))
  end

  begin
    Hobo.ui.title "Applying mysqldump (#{file})"
    shell(vm_mysql(:mysql => 'mysqladmin', :append => " create #{db.shellescape}"))
    shell(vm_mysql(:auto_echo => false, :db => db) < "zcat #{file.shellescape}")
  rescue Hobo::ExternalCommandError => exception
    Hobo.ui.error "Could not apply #{file} due to the following error:\n"
    Hobo.ui.error File.read(exception.output.path).strip
    raise exception
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
hobo-inviqa-0.0.15	lib/hobo/asset_applicators/sqldump.rb
hobo-inviqa-0.0.14	lib/hobo/asset_applicators/sqldump.rb
hobo-inviqa-0.0.13	lib/hobo/asset_applicators/sqldump.rb
hobo-inviqa-0.0.11	lib/hobo/asset_applicators/sqldump.rb