#!/usr/bin/sh
# DB-Refiling Tables & Records Checking
# ---Old file ---New file


#Set default file(s)

if [ "" = "" ]
then
old_file="actdb.prn"
else
old_file=
fi

if [ "" = "" ]
then
new_file="actdbnew.prn"
else
new_file=
fi

#Check if the two files are exist

cd /mfg/ptmp
if [ ! -f ./$old_file ]
then 
echo "Warning: $old_file does not exist!"
exit 
fi
if [ ! -f ./$new_file ]
then
echo "Warning: $new_file does not exist!"
exit 
fi

echo "Start checking tables......"

# Get old tables
more $old_file|grep -v "mgdbrp.p"|grep -v "Networks" >./$$.dbref
more $$.dbref|grep -v "/"|grep -v "root"|tr -d "," >./$$.dbref1
awk '>=0 && <=10000000 {print  " " }' $$.dbref1 >./$$.dbref1i
old_tbl=`more $$.dbref1i|wc -l`

# Get new tables
more $new_file|grep -v "mgdbrp.p"|grep -v "Networks" >./$$.dbref
more $$.dbref|grep -v "/"|grep -v "root"|tr -d "," >./$$.dbref2
awk ' >=0 &&  <= 10000000 {print  " " }' $$.dbref2 >./$$.dbref2i
new_tbl=`more $$.dbref2i |wc -l`

echo "There are $old_tbl tables in the old DB!"
echo "There are $new_tbl tables in the new DB!"

echo "Done!"

if [ $old_tbl -eq $new_tbl ]
then
echo "Congratulation, the number of the tables is same!"
else
echo "Error: the number of the tables is different!"
fi

echo ""
echo "Start checking records......"

nerror=0

# Check records of each table
awk ' >= 0 &&  <= 10000000 {print  " " }' $$.dbref1i |while read tlo cnto
do
cntn=`grep -i "^$tlo " $$.dbref2i|awk '{print }'`
if [ ! "$cntn" = "$cnto" ]
then
echo "The records of $tlo changed! "$cntn" <== "$cnto"" 
let nerror=$nerror+1
fi
done

echo "Done!"

if [ $nerror -ne 0 ]
then
echo "Errors:there are $nerror table(s)' records different!"
else
echo "Contrats! Records dump & load OK."
fi

# Clearing temp
rm $$.dbref
rm $$.dbref1
rm $$.dbref2
rm $$.dbref1i
rm $$.dbref2i
unset old_file
unset new_file
unset old_tbl
unset new_tbl
unset nerror