#!/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 "Fix table types." fixTableTypes.sql

execute "Change SiteTemplate and use of functionality sections" changeSite.sql
execute "Delete some UnitSite functionalities and change availability of others" deleteUnitSiteFunctionalities.sql
execute "Prepare migration of FunctionalitySections to UnitSites" prepareUnitSiteTemplateSections.sql
executeWithTempFile "Create new sections in all UnitSites" copyUnitSiteTemplateSections.sql
execute "Delete remaining sections from UnitSite's templates" deleteUnitSiteTemplateSections.sql
execute "Remove unused columns from UnitSite" removeColumnsFromUnitSite.sql