#!/bin/sh

if [ -d $POSTGRESHOME/data/base/regression ]
then
    destroydb regression
fi

createdb regression
if [ $? -ne 0 ]
then
     createdb failed
     exit 1
fi

monitor regression < create.pq
if [ $? -ne 0 ]
then
     echo the creation script has an error
     exit 1
fi

monitor regression < queries.pq
if [ $? -ne 0 ]
then
     echo the queries script causes an error
     rm -f $POSTGRESHOME/test/regress/stud_emp.data
     rm -f $POSTGRESHOME/test/regress/onek.data
     exit 1
fi

rm -f $POSTGRESHOME/test/regress/stud_emp.data
rm -f $POSTGRESHOME/test/regress/onek.data

monitor regression < errors.pq
if [ $? -ne 0 ]
then
     echo the errors script has an unanticipated problem
     exit 1
fi

monitor regression < destroy.pq
if [ $? -ne 0 ]
then
     echo the destroy script has an error
     exit 1
fi

destroydb regression
if [ $? -ne 0 ]
then
     echo destroydb failed
     exit 1
fi

exit 0