backup script

gistfile1.txt

namespace :mirror do
  desc "Mirror production database"
  task :production do
    app = "skilledup-academy-staging"
    production_database = "skilledup-academy-production::DATABASE_URL"
    heroku_command("pg:reset DATABASE_URL", app)
    transfer_database("#{production_database} DATABASE_URL", app)
    heroku_command("run rake db:migrate", app)
  end

  def transfer_database(command, app)
    heroku_command("pgbackups:transfer #{command}", app)
  end

  def heroku_command(command, app)
    `heroku #{command} -a #{app} --confirm #{app}`
  end
end