#! /bin/sh
# 20110616 masa
# to run
# ruby -I ../xmlconv/lib bin/xmlconvd config="etc/xmlconv.yml"
# access: http://masapharm.xmlconv.bbmb.ch
#
# if there is not the user 'xmlconv2' for the database 'globopharm_xmlconv'
# $ createuser xmlconv2 -P
# refer to: http://dev.ywesee.com/wiki.php/Masa/20110615-setup-globoXmlconvBbmbCh


XMLCONV_DIR='/home/masa/ywesee/xmlconv'
SETUP_DIR='/home/masa/globopharm_xmlconv_setup'
TARGET_DIR='/home/masa/ywesee/globopharm.xmlconv.bbmb.ch'

yyyy=`date -d '1 days ago' +"%Y"`
mm=`date -d '1 days ago' +"%m"`
dd=`date -d '1 days ago' +"%d"`


m=(dummy January February March April May June July August September October November December)
nm=`expr $mm + 0`


git clone ssh://ywesee@scm.ywesee.com/home/ywesee/git/globopharm.xmlconv.bbmb.ch
#git clone ssh://ywesee@scm.ywesee.com/home/ywesee/git/xmlconv

cp -r $SETUP_DIR/bin $TARGET_DIR/
cp -r $XMLCONV_DIR/lib $TARGET_DIR/
cd $TARGET_DIR
pwd
cp $SETUP_DIR/etc/xmlconv.yml etc/


# database
sudo -u postgres dropdb globopharm_xmlconv
sudo -u postgres createdb -E UTF8 -T template0 globopharm_xmlconv

mkdir data
mkdir data/sql

echo ywesee@$WHITIE:/var/backup/whitie/db/postgresql/${m[nm]}-$yyyy/$yyyy-$mm-$dd/21\:00-postgresql_database-globopharm_xmlconv-backup.gz
scp ywesee@$WHITIE:/var/backup/whitie/db/postgresql/${m[nm]}-$yyyy/$yyyy-$mm-$dd/21\:00-postgresql_database-globopharm_xmlconv-backup.gz data/sql/globopharm_xmlconv.$yyyy$mm$dd.sql.gz

zcat data/sql/globopharm_xmlconv.$yyyy$mm$dd.sql.gz | psql -U postgres globopharm_xmlconv