#!/bin/bash

source ./setfunctions

TRUE=1
FALSE=0

database=dosis
user=shawn
owner=dosis
psql=psql
psqlargs=" -U $owner --quiet "

while getopts ":nl" opt; do
	case ${opt} in
		n)
			NOCONFIRM=${TRUE}
		;;
		l)
			LOADINVENTORY=${TRUE}
		;;
		*)	
	esac
done

shift $(( $OPTIND-1 ))

if [[ ${1} == "loadInventory" ]]; then
	LOADINVENTORY=${TRUE}
fi

# give option 1 will bypass the check
if [[ ${NOCONFIRM} -ne ${TRUE} ]]; then
	echo "Confirm reset dosis errors yes/no"
	read ANSWER 
          case $ANSWER in
		[Yy][Ee][Ss] | [Yy] )
			echo "Dosis Errors Reset Confirmed"
		;;
		*)
			echo "Dosis Errors Reset Canceled"
			exit 1
		;;
          esac
fi

##################################
# Delete the existing table
##################################
echo "Dropping table: error_codes"
${psql} ${psqlargs} ${database} -c "DROP TABLE IF EXISTS error_codes;"

echo "Inputting populateDosisErrors.sql"
${psql} ${psqlargs} ${database} < populateDosisErrors.sql

setPermissions manchac

