sync heroku dbs

hsync.sh

#!/usr/bin/env bash
remote="${1:-staging}"

capture() {
  heroku pgbackups:capture --expire --remote $1
}

url() {
  heroku pgbackups:url --remote $1
}

if [ $remote = clone ]; then
  capture production
  heroku pgbackups:restore DATABASE `url production` --remote staging --confirm connectsense-staging
else
  capture $remote
  curl -o snapshot.sql `url $remote`
  pg_restore --verbose --clean --no-acl --no-owner -d connect_sense_development snapshot.sql
  rm -f snapshot.sql
fi

echo "now reset passwords:"
echo "User.all.each { |u| u.password = u.password_confirmation = 'password'; u.save }"