#!/bin/sh
#
# Here we are considering testdump1.sql as old mysql dump of database
# and testdump2.sql as latest mysql dump file to be changed to hence
# forth there will be two methods or functions to insert missing
# columns from new mysql dump to database, and also deleting new
# Columns from database which are not present in new mysql dump.
#
#
# Test purpose testdump1.sql and testdump2.sql has one table each with
# few columns names missing.
#
#
value1=0
value2=0

while read line1
do
       value1=`expr $value1 + 1`
#       the abovel ine gives the number of line in the file
done < testdump1.sql
while read line2
do
        value2=`expr $value2 + 1`
#       the abovel ine gives the number of line in the file
done < testdump2.sql
echo "value1 : $value1"
echo "value2 : $value2"
counter1=0
counter2=0
#
# this below piece of code is used to find columns not present in new database
# and hence will involve method for deleting that column.
#

while read line1
do
#       echo "$line1"
        counter2=0
        while read line2
        do
                if [ "$line1" != "$line2" ]
                then
                        counter2=`expr $counter2 + 1`
                fi
                if [ $counter2 -eq $value2 ]
                then
                        echo "this line not present : $line1"
#                       here calling the delete method
                fi
        done < testdump2.sql
done < testdump1.sql

#
# this below piece of code is used to find columns not present in old database
# and hence will involve method for inserting that column.
#
while read line2
do
#       echo "$line2"
        counter1=0
        while read line1
        do
                if [ "$line1" != "$line2" ]
                then
                        counter1=`expr $counter1 + 1`
                fi


                if [ $counter1 -eq $value1 ]
                then
                        echo "this line not present : $line2"
#                       here calling the insert method
                fi
        done < testdump1.sql
done < testdump2.sql