#!/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 "Create ExpectationEvaluationGroup Table" createTableExpectationEvaluationGroup.sql
executeWithTempFile "Move TeacherPersonalExpectations Old Periods To Unique Table" moveExpectationsPeriodsToNewTable.sql
execute "Drop TeacherPersonalExpectations Old Periods tables" removeOldPeriodsTables.sql
execute "alter table AssiduousnessClosedMonth" alterTableAssiduousnessClosedMonth.sql
execute "Fixing DFA candidacy Posting Rules" FixDFACandidacyPostingRules.sql

execute "Create email table" createEmailTable.sql
execute "Alter Table WorkScheduleType" alterTableWorkScheduleType.sql