#!/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 "Alter Table DFACandidacy" AlterTableDFACandidacy.sql
executeWithTempFile "Updating DFA Candidacy keys to DFA Candidacy Event" UpdateDFACandidacyKeyToDFACandidacyEvent.sql
execute "Renaming table GratuityExemption to Exemption" RenameGratuityExemptionToExemption.sql
execute "Alter Table Exemption" AlterTableExemption.sql
execute "Drop Table PenaltyExemption" DropTablePenaltyExemption.sql
execute "Creating Table Penalty Exemption Justification" CreateTablePenaltyExemptionJustification.sql
execute "Alter table AccountingEvent" AlterTableAccountingEvent.sql
execute "Create SibsPaymentFileProcessReport" CreateSibsPaymentFileProcesssReport.sql
execute "Fixing Receipt Print Version" FixReceiptPrintVersion.sql