#!/opt/bin/tcsh
#

setenv SYBASE /opt/sybase
setenv CVS_RSH ssh
eval `/u/de/.ssh/fsa -c metabase`
unalias mv

#
#       this script must be rwx------

        cd work
        ./sybdump KSUMMIT metabase sa SecretPassword
        mv $HOME/work/metabase/*.dat $HOME/cvs/metabase
        mv $HOME/work/metabase/*.csh $HOME/cvs/metabase/WAIAHA
        mv $HOME/work/metabase/*.sql $HOME/cvs/metabase/WAIAHA

        cd $HOME/cvs/metabase

#	get local dbase copy of files
        source Extract2files.metabase.csh

        /bin/mv Mask.dat Mask.uns
        /bin/mv MaskBlu.dat MaskBlu.uns

        sort -n -t \t Mask.uns > Mask.dat
        sort -n -t \t MaskBlu.uns > MaskBlu.dat

#	save the diffs for diagnostic purposes

	echo "-----------------------------------------------" >>! DiffLog
	echo `date` >> DiffLog
	echo "MASKBLU.DAT" >> DiffLog
	cvs diff -r HEAD MaskBlu.dat >>& DiffLog
	echo "MASK.DAT" >> DiffLog
	cvs diff -r HEAD Mask.dat >>& DiffLog

	/bin/rm Mask.diff MaskBlu.diff
	cvs diff -r HEAD Mask.dat >& Mask.diff
	cvs diff -r HEAD MaskBlu.dat >& MaskBlu.diff

	./WAIAHA/diff2sql MaskBlu.diff
	./WAIAHA/diff2sql Mask.diff

#	update the 2 crucial files
	cvs commit -m "Mask Scan Data Commit from Keck" Notify.MaskBlu.tcl 
	cvs commit -m "Mask Scan Data Commit from Keck" Notify.Mask.tcl 

#	only if you plan to Stomp:
#	and now at your leisure, get the whole enchilada
#	cvs update