#!/bin/bash
set -x
if [ $# -ne 1 ]; then
	echo "ERROR: Invalid number of arguments $#"
	echo "Usage: sqlrestore.sh <dump tar file>"
	exit 1
fi

tarfile=$1

if [ -x /sbin/runuser ]
then
    SU=/sbin/runuser
else
    SU=su
fi

rm -f /tmp/vtdump/* > /dev/null 2>&1
rmdir /tmp/vtdump > /dev/null 2>&1

cd /tmp && tar xzf $tarfile

tables="vtls vdrives iscsiconf storagegroup fcconfig fchost expjobs"

#Cleanup table data
for table in $tables; do
	if [ ! -f /tmp/vtdump/${table}.sql ]; then
		continue
	fi
	$SU -l vtdbuser -c "echo 'delete from $table *' | /quadstorvtl/pgsql/bin/psql qsdb > /dev/null 2>&1"
done

for table in $tables; do
	if [ ! -f /tmp/vtdump/${table}.sql ]; then
		continue
	fi
	$SU -l vtdbuser -c "/quadstorvtl/pgsql/bin/psql -f /tmp/vtdump/${table}.sql qsdb > /dev/null 2>&1"
done

#Cleanup again
rm -f /tmp/vtdump/* > /dev/null 2>&1
rmdir /tmp/vtdump > /dev/null 2>&1