#!/bin/bash

OLDDIR=`pwd`

cd /opt/euro-beta

DBNAME=`cat eurodb.ini | grep Database | cut -d= -f2`
DBHOST=`cat eurodb.ini | grep Host | cut -d= -f2`
STATION=`./systools/get_eurodb_config_val "ModemSystemName"`
export WITH_CLIENTS=`./systools/get_eurodb_config_val "ReportWithClientDB"`
BACKUPFILE=/tmp/report_dir/`date +%Y_%m_%d_%H_%M_`$STATION.sql.gz
mkdir /tmp/report_dir 2>/dev/null
rm -f $BACKUPFILE 

function filter
{
  if [ "$WITH_CLIENTS" = "1" ] ; then
    cat -
  else
    systools/anonymize_db
  fi
}

{
echo "#########################################################################" 
echo "###" 
echo "### Generated by backup_eurodb on "`date`
echo "### Station name: $STATION"
echo "### DB name: $DBNAME"
echo "### DB host: $DBHOST"
echo "###"
echo "#########################################################################"
echo "  "
echo "  "

echo "drop database $DBNAME;" 
echo "create database $DBNAME;" 
echo "use $DBNAME" 

mysqldump -f -c --add-drop-table --add-locks -u euro3g -peuro3g $DBNAME | filter 
} | gzip > $BACKUPFILE


cd $OLDDIR
