#!/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 "Merge Section, Item, and Functionality" MergeSiteElementsAndFunctionalities.sql
execute "Add 'visible' and 'orderInItem' columns to FileItem, change relation with Item" AlterFileItemAndRelation.sql
execute "Refactor GroupAvailability" RefactorGroupAvailability.sql
execute "Add functionalities to execution course site location" AddExecutionCourseSiteFunctionalities.sql
execute "Separate ExecutionCourseSite from Site" CreateExecutionCourseSite.sql
execute "Alter Space Table" alterSpaceTable.sql
execute "Alter table studentTestQuestion" alterTableStudentTestQuestion.sql