#! /bin/bash
cd /var/www/html/mrp
PGPASSFILE=".pgpassSteve"
export PGPASSFILE
TMPFILE=`mktemp checkitemsite.XXXXXXXXX --tmpdir=/tmp`
SQLFILE="${TMPFILE}.sql"
NEWESTFILE="${TMPFILE}.timestamp"
CREATEFILE="create-itemsite.sql"
LASTTIMESTAMP=`cat data/itemsiteTimestamp`
data/psql -U admin -h localhost -p 5432 pelican >${NEWESTFILE} <<EOF
select max(invhist_transdate) from invhist;
EOF
NEWESTTIMESTAMP=`grep '^ 20' ${NEWESTFILE} | sed -e 's/^ //' | awk -F '.' '{print $1}'`
echo "Compare $LASTTIMESTAMP with $NEWESTTIMESTAMP" >> /tmp/checkitemsite.log
if [ "$LASTTIMESTAMP" \< "$NEWESTTIMESTAMP" ];then
	data/pg_dump -U admin -h localhost -p 5432 --data-only --column-inserts --table=itemsite --file=${TMPFILE} pelican
	echo "BEGIN TRANSACTION;" > ${SQLFILE}
	cat ${CREATEFILE} >> ${SQLFILE}
	sed -e 's/^SET/-- SET/' -e 's/ false,/ 0,/g' -e 's/ false)/ 0)/' -e 's/ true,/ 1,/g' -e 's/ true)/ 1)/' < ${TMPFILE} >> ${SQLFILE}
	echo "COMMIT TRANSACTION;" >> ${SQLFILE}
	sqlite3 data/xtuple.db < ${SQLFILE}
	echo "$NEWESTTIMESTAMP" > data/itemsiteTimestamp
#	echo "itemsite updated!"
#else
#	echo "No sync"
fi
if [ -e ${SQLFILE} ]; then /bin/rm ${SQLFILE}; fi
if [ -e ${NEWESTFILE} ]; then /bin/rm ${NEWESTFILE}; fi