#!/opt/bin/tcsh
#
# to be cronned once a day at 6 am CA

setenv SYBASE /u/sybase
setenv CVS_RSH ssh
eval `/u/sybase/.ssh/fsa -c metabase`

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

	cd work
        ./sybdump YAKUZA metabase sa SecretPassword
	mv $HOME/work/metabase/*.dat $HOME/cvs/metabase
	mv $HOME/work/metabase/*.sql $HOME/cvs/metabase/YAKUZA
	mv $HOME/work/metabase/*.csh $HOME/cvs/metabase/YAKUZA
        cd $HOME/cvs/metabase
        source YAKUZA/Extract.metabase.csh
	foreach f (Respondents.dat SurveyAnswers.dat SurveySummary.dat)
		mv $f Survey
	end

#	sort these to prevent silly conflicts with waiaha

	/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

#	and now commit!
	cvs commit -m "Automatic YAKUZA archiving by cron job on oyabun"