#!/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 "Add more title and subtitle to the Thesis file" ChangeThesisFileTable.sql
execute "Change Thesis to accomodate credits distribution and the declaration state" ChangeThesisTable.sql
execute "Separate Scientific Commission from the coordinators of the Degree" RefactorDegreeScientificCommission.sql
execute "Alter table Space" alterTableSpace.sql
execute "Update Table AssiduousnessClosedMonth" updateTableAssiduousnessClosedMonth.sql