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

DB=$1
USER=$2

echo Using database: $DB
echo Enter password for $USER:
read -s password

function execute() {
	echo ---------------------------------------- $1
	mysql -u$USER -f -p$password --default-character-set=latin1 $DB < $2
	echo
}

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

execute "Alter table party" alterTableParty.sql
execute "Drop table EmailAddress" dropOldEmailAddressTable.sql
execute "Alter table JustificationMotive" alterTableJustificationMotive.sql

execute "Adding functionalities for Research Unit Site" changes-20070419175100.sql
execute "Adding Sections for Research Unit Site" researchUnitSiteFunctionalities.sql
execute "Edd events to Department Site (functionality)" AddDepartmentEventsFunctionality.sql
execute "Edd events to Department Site (section)" CreateDepartmentEventsSection.sql
execute "Migrating final degree work orientation relations." refactorFinalDegreeWorkOrientationRelations.sql