#!/bin/sh
# $HEADER:
# 
# wisconsin.sh - populates and runs the wisconsin benchmark on a database
# named "bench".
#

if (test ! -z "$POSTGRESHOME")
then
	PGHOME=$POSTGRESHOME
else
	PGHOME=/usr/postgres
fi

POSTGRES=$PGHOME/bin/postgres
CREATEDB=$PGHOME/bin/createdb

echo ===== creating benchmark database ======

$CREATEDB bench

echo ===== populating initial relations ======

for i in querycreat querycopy querydefineindex queryBprime
do
    $POSTGRES -Q bench < $i > /dev/null
done

for i in query1 query2 query3 query4 query5 query6 query7 query8 query9 \
		 query10 query11 query12 query13 query14 query15 query16 query17 \
		 query18 query19 query26 query27 query28 query29 query30 query31 \
		 query32
do
	echo "Running query $i"
	echo "file contains"
	echo =================================
	cat $i
	echo =================================
	echo
	$POSTGRES -s -Q bench < $i
done