#!/bin/zsh

PGBASE=/u/drkp/build/postgresql-8.2.11/obj
PGBIN=$PGBASE/bin
PGDATA=$PGBASE/data

export JAVA_HOME=/usr/lib/jvm/java-6-sun-1.6.0.10

eval `ssh-agent`
ssh-add


echo "Starting postgres"
sudo /etc/init.d/apache2 restart
sudo -u postgres $PGBIN/pg_ctl -D $PGDATA stop
sudo -u postgres $PGBIN/pg_ctl -D $PGDATA start
sleep 5
sudo ln -s /tmp/.s.PGSQL.* /var/run/postgresql

echo "Setting up the database"
./make-properties # small short errors
$PGBIN/createuser -SdR cecchet

$PGBIN/dropdb -U cecchet rubis
cat database/rubis.postgres.sql | $PGBIN/psql -U cecchet postgres
cat database/{categories.sql,regions.sql} | sed 's/#.*//;s/(NULL/(DEFAULT/' | $PGBIN/psql -U cecchet rubis

echo "Running initDB"
make initDB PARAM=all

echo "Running benchmark"
make emulator

echo "Stopping postgres"
sudo -u postgres $PGBIN/pg_ctl -D $PGDATA stop
kill $SSH_AGENT_PID