#!/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 DISTRICT" AlterTableDistrict.sql
execute "Create table COUNTY" CreateTableCounty.sql
execute "Create table PARISH" CreateTableParish.sql
execute "Populate table DISTRICT" PopulateTableDistrict.sql
execute "Populate table COUNTY" PopulateTableCounty.sql
execute "Populate table PARISH" PopulateTableParish.sql
execute "Modify tables COUNTY and PARISH" ModifyTablesCountyAndParishKeys.sql
execute "Alter table PARTY" AlterTablePartyDistrictFields.sql