#!/usr/bin/bash
HOST="deployment.rehearsal.alpinesmuseum.ungleich.cloud"
cd ~/Desktop/ungleich/alpinesmuseum
ssh app@$HOST "pg_dump -f `date "+%Y-%m-%d".sql`"; scp app@$HOST:/home/app/`date "+%Y-%m-%d".sql` .
echo "SELECT 'DROP TABLE IF EXISTS \"' || tablename || '\" CASCADE;' FROM pg_tables WHERE schemaname = 'public';" | psql -f - -t -d alpines -U app | psql -f - -d alpines -U app
psql -U app -d alpines -f `date "+%Y-%m-%d".sql`
rm -rf `date "+%Y-%m-%d".sql`