import_heroku_db

#!/bin/bash

APPNAME=$1
DBNAME=$2
WAITING="=============================================================="
echo "Cloning database from heroku app $APPNAME."
echo "Note: You must have heroku toolbelt and postgres installed."
echo $WAITING

echo "Capturing new backup with --expire option"
heroku pgbackups:capture --expire --app $APPNAME
echo $WAITING

DBFILE="$HOME/desktop/latest.dump"

echo "Downloading db to your desktop as latest.dump"
curl -o $DBFILE `heroku pgbackups:url --app $APPNAME`
echo $WAITING

echo "Importing db to Rails dev database"
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U $USER -d $DBNAME $DBFILE

echo "Removing desktop db file."
rm $DBFILE

echo "Script Complete!"