#!/bin/sh
declare MDEBSDIR="/home/ncutler/work/mdebs"
if [ $# -ge 2 ]
then
  if $(`$MDEBSDIR/dbinit_validate $1`)
  then
    if $(`$MDEBSDIR/dbinit_validate $2`)
    then
      if [ $1 -lt $2 ]
      then
	su postgres -c "destroydb $MDEBSDB"
	echo "Old database destroyed."
	createdb $MDEBSDB
	echo "New database created."
	$MDEBSDIR/dbinit_create
	$MDEBSDIR/fiscyear $1 $2
	$MDEBSDIR/load_osnova
	exit 1
      else
	echo "Starting date must be less than ending date!"
      fi
    else
	echo "Invalid ending date"
    fi
  else
    echo "Invalid starting date (at least)"
  fi
else
  echo "Not enough arguments"
fi
echo "Usage: $0 YYYYMMDD YYYYMMDD"
echo "where YYYYMMDD are the starting and ending dates of the fiscal year"
exit 0

