#!/bin/sh
# -----------------------------------------------------------------------------
#
#   Runs sql scripts to update database from previous release.
#
# -----------------------------------------------------------------------------
#

if [ $# -ne 2 ]
then
  echo "Usage: `basename $0` database_name database_user"
  exit 0
fi


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 Professorship"  AlterTableProfessorship.sql
execute "Alter table Orientation" AlterTableOrientation.sql
execute "Create table OrientationTeacher" CreateTableOrientationTeacher.sql
execute "Alter Shift ShiftProfessorship and SchoolClass" AlterShiftShiftProfessorshipSchoolClass.sql
execute "Update Shift ShiftProfessorship and SchoolClass" UpdateShiftShiftProfessorshipSchoolClass.sql
execute "Create teacher statistics table" CreateTableTeacherStatistics.sql
execute "Create ProfessorshipSchoolClass table" CreateTableProfessorshipSchoolClass.sql