#!/bin/sh

# Lock all sites first then do: for i in a b c; do $path_to_this_script $i opals|zDev; done
# Finally, unlock all sites.

SITECODE=`echo $1 | tr -d "[:space:]"`
if [ "$SITECODE" == "" ]
then
    echo Missing site code
    exit 1
fi

VER=`echo $2 | tr -d "[:space:]"`
if [ "$VER" == "" ]
then
    echo Missing version.
    exit 2
fi

SRC_DIR=/www/$VER
if [ ! -d $SRC_DIR ]
then
    echo $SRC_DIR: not found
    exit 3
fi

HHH=`grep server_host  /etc/opals/opalsrc | cut -d= -f2`

BU_USER=`grep backup_user /etc/opals/opalsrc | cut -d= -f2`
BU_PASS=`grep backup_pass /etc/opals/opalsrc | cut -d= -f2`

UUU=`grep addsite_user /etc/opals/opalsrc | cut -d= -f2`
PPP=`grep addsite_pass /etc/opals/opalsrc | cut -d= -f2`

OUTDIR=/tmp/branch_update
mkdir -p $OUTDIR/{db,log}

echo
echo Backup SQL database $SITECODE...
mysqldump -h$HHH -u$BU_USER -p$BU_PASS $SITECODE > $OUTDIR/$SITECODE-`date +%Y%m%d-%H%M%S`.sql

echo Update SQL database $SITECODE...
echo "    add pref. form param..."
mysql -h$HHH -uopalsadmin -p$PPP $SITECODE < $SRC_DIR/script/update/20100609/opl_prefFormParam.sql

echo "    updating..."
LOG=$OUTDIR/log/$SITECODE.log
\rm -f $LOG
PERL5LIB=$SRC_DIR/module OPALS_CONF=/etc/opals/conf/$SITECODE $SRC_DIR/script/update/20100609/update_sql_db > $LOG

echo "   dumping database schema after updated..."
UPDATED=$OUTDIR/db/$SITECODE.sql
\rm -f $UPDATED
mysqldump -d -h$HHH -u$BU_USER -p$BU_PASS $SITECODE > $UPDATED

echo done.


exit 0