#!/bin/bash
# -----------------------------------------------------------------------------
#
#   Runs sql scripts to update database from previous release.
#
# -----------------------------------------------------------------------------
#

DB=$1
USER=$2
DB_HOST=$3
INSTITUTION=$4

echo Using host=$DB_HOST
echo Using database: $DB
echo Using user $USER:
echo Institution: $INSTITUTION

function execute() {
	if [ -z $3 ] 
		then  
			echo ---------------------------------------- $1 
			mysql -u$USER -f -h$DB_HOST --default-character-set=latin1 $DB < $2 
			echo 
		else 
			if [ "$INSTITUTION" == "$3" ]
			then 
				echo ---------------------------------------- $1 specific for $3
				mysql -u$USER -f -h$DB_HOST --default-character-set=latin1 $DB < $2 
				echo 
			fi
	fi
}

function executeWithTempFile() {
	echo ---------------------------------------- $1
	mysql -u$USER -f -h$DB_HOST --default-character-set=latin1 $DB < $2 > tmp.sql
	mysql -u$USER -f -h$DB_HOST --default-character-set=latin1 $DB < tmp.sql	
	rm tmp.sql
	echo
}

execute "Alter AcademicServiceRequest table" AlterTableAcademicServiceRequest.sql IST
execute "Add table to index assiduousness records." updates.sql
execute "Adding new country" InsertCountry.sql IST
execute "Adding foreign district" InsertForeignDistrict.sql
execute "Adding unique restriction to code on district" AlterTableDistrict.sql
execute "Creating table DistrictSubdivision" CreateTableDistrictSubdivision.sql
execute "Update District Code" UpdateDistrictCodes.sql
execute "updateWeightInOldEnrolments" updateWeightInOldEnrolments.sql IST