#!/bin/ksh
#
# script to load all conformance data simultaneously - used to 
#  check for conflicts.  


confBase=$REL_ROOT/tools/src/systemTest/conformance/provisioning
if [[ ! -d $confBase ]]
then
	echo '$REL_ROOT/tools/src/systemTest/conformance does not exist'
	exit 2
fi


tc=$1
delFile=delFile_$$.sql

echo "== delete old data"

		# delete old data
for tab in  \
		policy_selection_rule network_selection_policy \
		ringing_schedule_entry ringing_device_set_entry \
		ringing_device_set mcs_identity_pref mcs_subscriber_pref \
		mcs_subscription status_subscription local_auth_context \
		endpoint device voice_mail_box identity subscriber \
		conference_factory meet_me_conference meet_me_conference_pool \
		conference_resource derived_association domain_replace_chars_rule \
		domain_rule_sequence domain \
		mcs_service_definition 
do
	echo "delete from $tab;" >>$delFile
done

echo "exit;" >>$delFile


sqlplus -S $CSN_DBUSER/$CSN_DBPASS@$CSN_DBSERVICE @$delFile 
rm -f $delFile

sqlplus -S $CSN_DBUSER/$CSN_DBPASS@$CSN_DBSERVICE  \
									< $confBase/mcs_service_definition.sql

echo "== importing"
for testPath in $(ls $confBase/core*.sql)
do
		# convert to suite name
	tc=${testPath#$confBase/core_}
	tc=${tc%.sql}
	echo "=== importing $tc"

	for ftype in domain core local_auth_context
	do
		fname=$confBase/${ftype}_${tc}.sql

		if [[ $ftype = local_auth_context ]]
		then
			if [[ -f $fname.tmpl ]]
			then
				sed -e 's/md5(.*),/null,/' $fname.tmpl >$fname

				sqlplus -S $CSN_DBUSER/$CSN_DBPASS@$CSN_DBSERVICE <$fname

				rm -f $fname
			fi
		else
			if [[ -f $fname ]]
			then
				sqlplus -S $CSN_DBUSER/$CSN_DBPASS@$CSN_DBSERVICE <$fname
				#echo "@$fname" | \
				# sqlplus $CSN_DBUSER/$CSN_DBPASS@$CSN_DBSERVICE

			fi
		fi
	done
done
echo "== done"
