#!/bin/sh -v
#
# copy image sql scripts to lambda after making sure last line is 'commit;'
#
# Usage: cpimgdb
#
#$Log: cpimgdb,v $
#Revision 1.5  2006/12/22 22:20:15  secchib
#cd instead of chdir
#
#Revision 1.4  2006/11/17 16:14:48  secchia
#nr - fix for directive
#
#Revision 1.3  2006/11/08 21:24:29  secchia
#nr - add dummy file so there is at least 1
#
#Revision 1.2  2006/10/31 23:07:37  nathan
#postlaunch
#
#Revision 1.1  2006/09/22 18:42:57  nathan
#part of pipeline; called by secchi_reduce.pro
#

cd $SEB_IMG/db
echo "commit" > dummy.script

for file in ./*.script
do 
    lastline=`tail -1 $file |cut -c1-6`
    #echo "lastline=$lastline"
    if [ "$lastline" != commit ]; then
        echo $file
        echo 'commit;' >> $file
    fi
    
done

scchkinsert=/net/lambda/data/mysql/mysql_x/databases/secchi/IMG/INSERTS/POST_LAUNCH

rsync ./scc*.script $scchkinsert

gzip ./*script 
mv ./*.gz ./attic

exit