. $EMPRESSPATH/config/options

TMP=testout.raw

empsql $MSTESTDB < script > $TMP 2>&1
echo '' >> $TMP

case $MSSYS_PLATFORM in
 SYS_OS_WIN32)

	# pwd of mks toolkit produces a path like:
	# D:/empress/db
	# However, Empress converted the database name to be:
	# D:\empress\db
	# We need to make the sed script to have the same database name.

	cat > sedscript <<EOM
s;$MSTESTDB;DB;g
s;  Encrypted;;g
EOM

	sed -e 's;/;\\\\;g' < sedscript > sedscript.tmp
	mv sedscript.tmp sedscript

	cat >> sedscript <<EOM
s;$XDB;DB;g
s;$MSTESTDB;DB;g
s;  Encrypted;;g
EOM
	;;
    SYS_OS_UNIX_QNX)
	cat > sedscript <<EOM
s;//$NODE/;/;
s;$MSTESTDB;DB;g
s;$MSNETTESTDB;DB;g
s;  Encrypted;;g
EOM
	;;
    *)
	cat > sedscript <<EOM
s;$MSTESTDB;DB;g
s;$MSNETTESTDB;DB;g
s;  Encrypted;;g
EOM
	;;
esac

cat >> sedscript <<'EOM'
s/\(e[+-]\)00\([0-9][0-9]\)/\1\2/g
s/\(e[+-]\)0\([0-9][0-9]\)/\1\2/g
s/*     a1               a2  a3/*     a1             a2  a3/
s;  Encrypted;;g
/Creator/d
/Record size:/d
/Table #:/d
EOM

case $MSPACKAGE in
 eXcalibur)
	cat >> sedscript <<EOM
s/eXcalibur/Empress/g
EOM
	;;
esac

sed -f sedscript < $TMP > testout

