#!/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 "Removing STUDENT_NUMBER from DGES_FILE_ENTRY table." RemoveColumnStudentNumberFromDGESFileEntryTable.sql execute "Removing STUDENT_NUMBER from CANDIDACY table." RemoveColumnStudentNumberFromCandidacyTable.sql execute "Setting the code 9019 to degree Ciência Política." SetCodeInDegreeCienciaPolitica.sql