#!/bin/sh
USERNAME=soma365
HOST=foo.bar.com
CURDATE=`date +%b-%d-%Y`
ROOTDIR=/home/foo/services/bar/importer
echo "Starting foo Importer on $CURDATE" >> $ROOTDIR/foo.log
echo "Starting SFTP script" >> $ROOTDIR/foo.log
# Retreive files from SFTP
/usr/local/bin/sftp -o "StrictHostKeyChecking=no" -b $ROOTDIR/sftp.batch $USERNAME@$HOST >> $ROOTDIR/foo.log
echo "SFTP script run finished" >> $ROOTDIR/foo.log
echo "Starting static resource copy" >> $ROOTDIR/foo.log
cp -f -r -v --reply=yes $ROOTDIR/content/* /usr2/local/www/foo-static >> $ROOTDIR/foo.log
echo "Static resource copy finished" >> $ROOTDIR/foo.log
# run sql importer on the xml for each language
echo "Starting xml importer" >> $ROOTDIR/foo.log
for xmllang in $( ls $ROOTDIR/content | grep xml ); do
        /usr/local/jdk1.5.0_10/jre/bin/java -cp $ROOTDIR/lib/ -jar $ROOTDIR/fooimporter.jar $ROOTDIR/content/$xmllang
done
echo "xml import finished" >> $ROOTDIR/foo.log
# make a backup
echo "Making backup" >> $ROOTDIR/foo.log
/usr/local/bin/mysqldump -h dbhost --user=foo_live --password=foo_live foo_live >> $ROOTDIR/content/foo_live_dump.sql
mkdir $ROOTDIR/foo_backup/$CURDATE
tar -pczvf $ROOTDIR/$CURDATE.tgz $ROOTDIR/content/ >> $ROOTDIR/foo.log
mv $ROOTDIR/$CURDATE.tgz $ROOTDIR/foo_backup/$CURDATE/$CURDATE.tgz
echo "Backup complete" >> $ROOTDIR/foo.log
# clean up folders
echo "Cleaning up" >> $ROOTDIR/foo.log
rm -rf $ROOTDIR/content/*
echo "Cleanup finished" >> $ROOTDIR/foo.log
echo "foo Importer on $CURDATE Complete" >> $ROOTDIR/foo.log