Dave Jarvis' Repositories

#!/bin/bash
echo "This is to be run on the development machine."

JAR=$HOME/bin/apgdiff/apgdiff-2.4.jar
HOST_PRD=recipefiddle.com

DB_PRD=production
DB_DEV=development
DB_PRD_RF=$DB_PRD/recipe.sql
DB_DEV_RF=$DB_DEV/recipe.sql
DB_PRD_RB=$DB_PRD/recipe-book.sql
DB_DEV_RB=$DB_DEV/recipe-book.sql

# Production is "original".
# Development is "new".

echo "Export development PostgreSQL database ..."
sudo su - postgres -c "./db-dump.sh"

echo "Copy database to $DB_DEV ..."
cp /tmp/*.sql $DB_DEV

echo "Export production PostgreSQL database ..."
ssh -t -p 65222 $HOST_PRD 'sudo su - postgres -c ./db-dump.sh'
echo "Download production PostgreSQL database ..."
scp -P 65222 $HOST_PRD:/tmp/*.sql $DB_PRD

echo "Building database migration script for Recipe Fiddle ..."
java -jar $JAR $DB_PRD_RF $DB_DEV_RF > update-rf.sql
echo "Building database migration script for Recipe Book ..."
java -jar $JAR $DB_PRD_RB $DB_DEV_RB > update-rb.sql

echo "Upload upgrade scripts to production ..."
scp -P 65222 *.sql $HOST_PRD:/tmp