#!/bin/bash

. ../rules/bash.rules

usage() {
               echo "usage : dumpStruct.sh -o <filename>"
}

while true
do
  case $1 in
    -o) outputfile=$2
        shift 2
        ;;
    -h) usage
        exit 0
        ;;
     *)
	break
        ;;
  esac
done

if [ -z "$outputfile" ] 
then
                usage
                exit 1
fi

listOfTable=`(echo ${DBPWD};) | psql -At -U ${DBUSER} -d ${DBNAME} -c "\d" -h ${DBHOST}| egrep "^struct" | awk -F'|' '{print $1;}'`

(echo ${DBUSER};echo ${DBPWD};) | pg_dump -u -s ${DBNAME} -h ${DBHOST} \
	| grep -v 'Username:' \
	| grep -v '\connect' \
	| grep -v 'CREATE SEQUENCE' \
	| grep -v 'CREATE TRUSTED' \
	| perl -p ${SHELLDIR}/vireUid.pl \
	> ${outputfile}

for i in $listOfTable ; do
    #  echo "Doing pg_dump -u -aD ${DBNAME} -h ${DBHOST} -t ${i}"
    (echo ${DBUSER}; echo ${DBPWD};) | pg_dump -u -aD ${DBNAME} -h ${DBHOST} -t ${i} \
	| grep -v 'Username:' \
	| grep -v '\connect' \
	| perl -p ${SHELLDIR}/vireUid.pl \
	>> ${outputfile}
    done ;

echo Done.