#!/bin/sh

DB=$1
DBH=/home/onyx/database/$1
PWD=`pwd`

cd $DBH

shift

for x
do
	if [ ! -f /usr/local/postgres/tmp/$x.unload ]
	then
	    echo Unloading $DB $x
	    cp $DBH/$x~ /usr/local/postgres/tmp/$x.unload
	    echo "done."
	fi

	echo "Loading Postgres $x"
	echo

	(	echo "destroy $x"
		echo '\p\g'

		echo "create $x ("
		sed 's/^[^_]*_//' < $x@ |
		awk "-F	" '
		{	t="text";
			$2="";
			if ($3 == "int") {
				t="int";
				$2=4;
				}
			if ($3 == "calc") {
				t="float";
				$2=8;
				}
			if (NR != 1) printf ",\n";
			printf "\t%s = %s%s",$1,t,$2;
			} '
		echo "	)"
		echo '\p\g'
	
		echo "copy $x from \"/usr/local/postgres/tmp/$x.unload\""
		echo '\p\g'

		) | monitor $DB
	echo "done."
done

cd $PWD
