Heroku DB Download

README

requirement: your db name must have the same name as your app. (it does not have  _development on the name)

save this script in a common folder outside your project.

db.rb

#!/usr/bin/env ruby
require "thor"

class MyCLI < Thor
  desc "download", "production database"
  def download(remote = 'production')
    puts "Downloading... #{remote}"
    system "heroku pg:backups capture --remote #{remote}"
    system "curl `heroku pg:backups public-url --remote #{remote}` -o #{remote}.dump"
    puts "Done!"
  end

  desc "restore", "load dump in dev database"
  def restore(remote = 'production', db = Dir.pwd.split("/").last)
    system "ps ax | grep postgres: | grep #{db} | cut -c1-8 | xargs kill"
    system "dropdb #{db}; createdb #{db}"
    system "pg_restore --verbose --clean --no-acl --no-owner -d #{db} #{remote}.dump"
    system "touch tmp/restart.txt"
  end
  desc 'dr', 'download and restore'
  def dr(remote = 'production')
    download remote
    restore remote
  end
end

MyCLI.start(ARGV)