#!/bin/bash -v
# Niklaus Giger, ngiger@ywesee.com, June 17 2013

DB_NAME=oddb.org.ruby193
DB_DUMP=/vagrant/db_dumps/pg-db-oddb.org.ruby193-backup.gz
cd /tmp
sudo -u postgres dropdb $DB_NAME 

sudo -u postgres createdb -E UTF8 -T template0 $DB_NAME
if [ $? -ne 0 ] ; then exit 1; fi
mkdir -p data/sql
mkdir -p /opt/downloads
if [ $? -ne 0 ] ; then exit 1; fi

if [ ! -f $DB_DUMP ] 
then
  echo "Cannot find $DB_DUMP. Have look at the get_db_dumps.rb script or get it directly from"
  exit 1
fi

sudo -u postgres psql -c 'create role apache with LOGIN;'
sudo -u postgres psql -c "create role $DB_NAME with LOGIN;"

zcat $DB_DUMP | sudo -u postgres psql $DB_NAME
if [ $? -ne 0 ] ; then exit 1; fi