#!/bin/bash
# -----------------------------------------------------------------------------
#
#   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
}

executeWithTempFile "Add New Academic Interval Slots - Step 1" addNewAcademicIntervalSlots1.sql
executeWithTempFile "Add New Academic Interval Slots - Step 2" addNewAcademicIntervalSlots2.sql
executeWithTempFile "Add New Academic Interval Slots - Step 3" addNewAcademicIntervalSlots3.sql
execute "Add New Academic Interval Slots - Step 4" addNewAcademicIntervalSlots4.sql
executeWithTempFile "Add New Role SubClass" alterRoleTable.sql
execute "Add New Role SubClass - Step 2" alterRoleTable2.sql
execute "Alter Table ExecutionCourse add EntryPhase" alterTableExecutionPeriodAddEntryPhase.sql
execute "Roll Back Periods" rollBackPeriods.sql

execute "Add new columns to academic service request table" alterAcademicServiceRequest.sql