Shell Programming and Scripting

Code:

num=1
dat10=`date "+%m/%d/%Y"  -d "+10 days"`
dat=`date "+%m/%d/%Y"`
set -x
grep "text=.&" /root/Softwares/apache-tomcat-5.5.30/logs/catalina.out|awk -F"from=" '{print $2}'|awk -F"opid" '{print $1}'|sort|uniq > pnos

while read line
do
psql -U poss -d emsver -c "insert into ent(phone_number) values ('$line');"
grep "text=.&" /root/Softwares/apache-tomcat-5.5.30/logs/catalina.out|grep $line|awk -F"text=" '{print $2}'|awk -F "&from" '{print $1}' > services
while read sline
do
psql -U poss -d emsver -c "insert into uiotion(phone_number,service_name,start_date,end_date,last_content_deliver_time) values ('$line','$sline','$dat','$dat10',current_date);"
done < services
num=`wc -l pnos|awk '{print $2}'`
done < pnos

Code:

2132421
3124321421
4214242424
4242421421

pnos_save_file=$HOME/pnos_save_file.txt
num=1
dat10=`date "+%m/%d/%Y"  -d "+10 days"`
dat=`date "+%m/%d/%Y"`
set -x
grep "text=.&" /root/Softwares/apache-tomcat-5.5.30/logs/catalina.out|awk -F"from=" '{print $2}'|awk -F"opid" '{print $1}'|sort|uniq > pnos

if [ ! -f "$pnos_save_file" ]; then
  echo 1 > "$pnos_save_file"
fi

old_start_line=`cat $pnos_save_file`

tail -n +$old_start_line pnos > pnos.tail

while read line
  do
  psql -U poss -d emsver -c "insert into ent(phone_number) values ('$line');"
  grep "text=.&" /root/Softwares/apache-tomcat-5.5.30/logs/catalina.out|grep $line|awk -F"text=" '{print $2}'|awk -F "&from" '{print $1}' > services
  while read sline
    do
    psql -U poss -d emsver -c "insert into uiotion(phone_number,service_name,start_date,end_date,last_content_deliver_time) values ('$line','$sline','$dat','$dat10',current_date);"
    done < services
  num=`wc -l pnos|awk '{print $2}'`
done < pnos.tail

new_start_line=`cat pnos | wc -l`
new_start_line=`expr $new_start_line + 1`
echo $new_start_line > "$pnos_save_file"