Shell Programming and Scripting

flag=0
while read linexT
do
                                                 len=${#linexT}
                                                 charlast=${linexT:$len-1:$len}
                                                charfirst=${linexT:0:1}
                                                 if [ "$charlast" = "," ]
                                                 then
                                                      line11=${linexT:0:$len-1}
                                                 else
                                                      line11=$linexT
                                                 fi
                                                 if [ "$charfirst" = ">" ]
                                                 then
                                                           
#                                               here somewhere inbetween i am checking whether 
if flag=0
then
                do someting here
fi
fi
 
                   if [[ "$charfirst" = "<" ]]
                                                 then
                                                         line11=${line11:2:$len}
                                                        echo "missing in second: $line11"
                                                        colname1=$( echo $line11 | awk -F\` '{print $2}' )
                                                       line333=`cat tablextract2.sql | grep -w -i $colname1`
                                                        grep -w -i $colname1 tablextract2.sql | while read line22 ; do
 if [[ `expr match "$line11" ".*PRIMARY KEY.*"` = "0" ]]  &&  [[ `expr match "$line22" ".*PRIMARY KEY.*"` = "0" ]] && [[ "$key1" != "KEY" ]] &&  [[ "$key2" != "KEY" ]] && [[ `expr match "$line11" ".*UNIQUE KEY.*"` = "0" ]]  &&  [[ `expr match "$line22" ".*UNIQUE KEY.*"` = "0" ]]
         then
                                if grep -i -q "auto_increment" <<<$line22
                                then
                                         insert_column "$table_name1" "PRIMARY KEY (\`$colname1\`)"
                                         modify "$table_name1" "$line22"
                                        flag=1
                                        echo "flag: $flag"
                                else
                                         modify "$table_name1" "$line22"
                                fi
fi
done
 
done < tmp.sql

grep -w -i $colname1 tablextract2.sql > /tmp/tmp.$$
while read line; do
  echo "$line"
  flag=1
  echo "flag: $flag"
done < /tmp/tmp.$$
 
echo "flag: $flag"
 
rm -f /tmp/tmp.$$