data.rake

  namespace :sync do
    desc "Backs up heroku database and restores it locally"
    task production: :environment do
      Bundler.with_clean_env do
        system("heroku pgbackups:capture --expire --remote production")
        timestamp = Time.now.utc.strftime("%Y%m%d%H%M%S")
        system("curl -o ../pgbackups/production_#{timestamp}.dump --create-dirs `heroku pgbackups:url --remote production`")
        last_backup = Dir.entries("../pgbackups").last
        database = Rails.configuration.database_configuration[Rails.env]['database']
        system("pg_restore --verbose --clean --no-acl --no-owner -d #{database} ../pgbackups/#{last_backup}")
      end
    end
  end