db_setup

#!/bin/sh

# If Bundler exports unhelpful settings, they will mess with our expectations, 
# particularly when we call bundle exec down below. We sidestep this issue by
# unsetting them.

unset BUNDLE_BIN_PATH
unset BUNDLE_GEMFILE
unset RUBYOPT
unset GEM_PATH
unset GEM_HOME

export RAILS_ENV=test

if [[ $# -eq 0 ]]
then
  echo "Running this script manually is discouraged. If you insist, you must pass in each host individually, and run it from the directory of the rails app."
  exit 1
fi

mysql -u root -e 'drop database if exists buffet_causes_test'
mysql -u root -e 'create database buffet_causes_test'

mysql -u root -e 'drop database if exists buffet_wishes_test'
mysql -u root -e 'create database buffet_wishes_test'

bundle exec rake db:migrate # wart here is that we don't migrate wishes

mysqldump --no-data -u root buffet_causes_test > buffet_causes_test.dump
mysqldump --no-data -u root wishes_development > buffet_wishes_test.dump
mysql -u root buffet_wishes_test < buffet_wishes_test.dump

for host in `$@` #Loop through argument list
do
  echo $host
  sh -c "scp buffet_causes_test.dump \
             buffet_wishes_test.dump \
             buffet@$host:~/ &&
         ssh buffet@$host 'mysql -u root -e \"drop database if exists buffet_causes_test\" && \
                           mysql -u root -e \"create database buffet_causes_test\" && \
                           mysql -u root -e \"drop database if exists buffet_wishes_test\" && \
                           mysql -u root -e \"create database buffet_wishes_test\" && \
                           mysql -u root buffet_causes_test < buffet_causes_test.dump && \
                           mysql -u root buffet_wishes_test < buffet_wishes_test.dump'" &
done
wait