#!/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 EXECUTION_DEGREE ADD OJB_CONCRETE_CLASS text" AlterExecutionDegreeAddOJBConcreteClassRow.sql
execute "UPDATE EXECUTION_DEGREE SET OJB_CONCRETE_CLASS = 'net.sourceforge.fenixedu.domain.ActualExecutionDegree'" AlterExecutionDegreeSetOJBtoActualExecutionDegree.sql
execute "ALTER TABLE EXECUTION_COURSE ADD OJB_CONCRETE_CLASS text" AlterExecutionCourseAddOJBConcreteClassRow.sql
execute "UPDATE EXECUTION_COURSE SET OJB_CONCRETE_CLASS = 'net.sourceforge.fenixedu.domain.ActualExecutionCourse'" AlterExecutionCourseSetOJBtoActualExecutionCourse.sql
execute "ALTER TABLE PROFESSORSHIPS ADD OJB_CONCRETE_CLASS text" AlterProfessorshipAddOJBConcreteClassRow.sql
execute "UPDATE PROFESSORSHIPS SET OJB_CONCRETE_CLASS = 'net.sourceforge.fenixedu.domain.ActualProfessorship'" AlterProfessorshipSetOJBtoActualExecutionCourse.sql