#!/bin/bash
#Simple script backup one table from heroku app and restore to local db.
if [ $# -eq 0]
  then
    echo "Please input the heroku app name."
    echo "Example scriptName.sh heroku-app-name table_name limit-row."
    exit 0
fi
HEROKU_APP=$1
LOCAL_DB_HOST=localhost
LOCAL_DB_NAME=scs-cws-development
LOCAL_DB_USER=nykdev
LOCAL_DB_PWD=nykdev

heroku pg:psql -a $HEROKU_APP  -c "\COPY (SELECT * FROM $2  ORDER BY Id DESC LIMIT $3) TO dump.csv CSV DELIMITER ','"
PGPASSWORD=$LOCAL_DB_PWD psql -h $LOCAL_DB_HOST -U $LOCAL_DB_USER -d $LOCAL_DB_NAME -c "\COPY $2 FROM 'dump.csv' DELIMITER ',' NULL AS '';"