#!/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 "Remove announcements section" changeDegreeSections.sql
execute "Add dissertation section" createDegreeSection.sql


execute "Create Lesson Instance Table 1" createTableLessonInstance1.sql
executeWithTempFile "Create Lesson Instance Table 2" createTableLessonInstance2.sql
executeWithTempFile "Create Lesson Instance Table 3" createTableLessonInstance3.sql
executeWithTempFile "Create Lesson Instance Table 4" createTableLessonInstance4.sql
executeWithTempFile "Create Lesson Instance Table 5" createTableLessonInstance5.sql
executeWithTempFile "Create Lesson Instance Table 6" createTableLessonInstance6.sql