Shell Programming and Scripting

 
export SQL_DIR=/opt/staffware/server/sql
export LOG_DIR=/opt/staffware/server/logs
export BIN_DIR=/opt/staffware/server/bin
export ORA_BIN_DIR=/opt/oracle/ora817/bin
export ORACLE_HOME=/opt/oracle/ora817
 
SID=
USER=
PASSWD=
 
OUTPUTFILE1=sw_locked_cases_check_1.txt
OUTPUTFILE2=sw_locked_cases_check_2.txt
SORTEDOUTPUTFILE1=sw_locked_cases_check_1s.txt
SORTEDOUTPUTFILE2=sw_locked_cases_check_2s.txt
FINALOUTPUTFILE=sw_locked_cases_checked.txt
 
# Teller in minuten
COUNTDOWN=50
# --------------------------------------------------------------------
 
# Controle of de juiste persoon is ingelogd
echo "Script gestart op `date`"
echo "Je bent ingelogd als `whoami`";
if [ `whoami` != "swadmin" ]; then
echo "Je dient als swadmin ingelogd te zijn om dit script te starten."
exit
fi
 
# Maak outputfiles aan
cat <<EOF >$BIN_DIR/$OUTPUTFILE1
EOF
cat <<EOF >$BIN_DIR/$OUTPUTFILE2
EOF
cat <<EOF >$BIN_DIR/$FINALOUTPUTFILE
EOF
 
# voer SQL query uit - check 1
$ORA_BIN_DIR/sqlplus -s $USER/$PASSWD@$SID <<!>$BIN_DIR/$OUTPUTFILE1
whenever sqlerror exit 2
set heading off
set pages 0
set feedback off
set verify off
SELECT 'swutil UNLOCKMAIL ' || o_queuename || ' ' || o_reqid || ':sw_nimbus_prd01'
FROM staffo
WHERE o_locker IS NOT NULL
ORDER BY O_QUEUENAME
/
!
 
# gebruik countdown variabele om de lengte van de sleep te bepalen
echo
while [[ ${COUNTDOWN} -ge 0 ]]
do
echo "Nog" ${COUNTDOWN} "minuten totdat het script verder gaat."
sleep 60
COUNTDOWN=$(( ${COUNTDOWN} - 1 ))
done
 
# voer SQL query uit - check 2
echo
$ORA_BIN_DIR/sqlplus -s $USER/$PASSWD@$SID <<!>$BIN_DIR/$OUTPUTFILE2
whenever sqlerror exit 2
set heading off
set pages 0
set feedback off
set verify off
SELECT 'swutil UNLOCKMAIL ' || o_queuename || ' ' || o_reqid || ':sw_nimbus_prd01'
FROM staffo
WHERE o_locker IS NOT NULL
ORDER BY O_QUEUENAME
/
!
 
# voer een compare uit
sort $BIN_DIR/$OUTPUTFILE1 > $BIN_DIR/$SORTEDOUTPUTFILE1
sort $BIN_DIR/$OUTPUTFILE2 > $BIN_DIR/$SORTEDOUTPUTFILE2
comm -12 $BIN_DIR/$SORTEDOUTPUTFILE1 $BIN_DIR/$SORTEDOUTPUTFILE2 > $FINALOUTPUTFILE
 
# voer iedere regel in de finaloutputfile uit
while read LINEFROMFILE
do
print `$BIN_DIR/$LINEFROMFILE` "$LINEFROMFILE"
# echo $LINEFROMFILE
done < $BIN_DIR/$FINALOUTPUTFILE
 
echo
OF1=`ls -ltr $OUTPUTFILE1 | awk '{print $8}'` 
OF2=`ls -ltr $OUTPUTFILE2 | awk '{print $8}'` 
#OF2=`date +%R`
echo "Leeftijd controlebestand 1" $OF1
echo "Leeftijd controlebestand 2" $OF2
 
# verwijder de finaloutputfile
echo
echo "Tijdelijke bestanden worden verwijderd." 
rm -rf $BIN_DIR/$OUTPUTFILE1
rm -rf $BIN_DIR/$OUTPUTFILE2
rm -rf $BIN_DIR/$SORTEDOUTPUTFILE1
rm -rf $BIN_DIR/$SORTEDOUTPUTFILE2
rm -rf $BIN_DIR/$FINALOUTPUTFILE