#!/bin/bash
DBNAME=`basename $1 .sql.gz`
rm -f $DBNAME.sql
gunzip $DBNAME.sql.gz

echo "use $1" > tmp_table_update.sql

function patch_sql
{
  systools/patch_sql
#	sed 's/TYPE=MyISAM/ENGINE=MyISAM/g; s/timestamp([0-9]*)/timestamp/g'
}

for db_table in accounts accounts_test objednavka objednavka_test payments pre_payments 
  do

 
     echo "#" >> tmp_table_update.sql
     echo "### Update table $db_table" >> tmp_table_update.sql
     echo "#" >> tmp_table_update.sql
     echo "delete from $db_table;" >> tmp_table_update.sql
     cat $DBNAME.sql | grep "INSERT INTO \`*$db_table\`* " >> tmp_table_update.sql

 
### Old bad restore
#
#    mysqldump -c -t -u euro3g -peuro3g $1 $db_table > systools_actual_table_data.sql
#    echo "drop table $db_table;" >> tmp_table_update.sql
#    FILELINES=`wc -l $DBNAME.sql | awk '{ print $1 }'` 
#    CREATELINE=`grep -n "CREATE TABLE $db_table " $DBNAME.sql | awk -F: '{ print $1 }'`
#    tail -$(( $FILELINES-$CREATELINE+1 )) $DBNAME.sql > $DBNAME.sql.tmp
#    head -`grep -n ") TYPE=" $DBNAME.sql.tmp | head -1 | awk -F: '{ print $1 }'` $DBNAME.sql.tmp >> tmp_table_update.sql
#    cat $DBNAME.sql | grep "INSERT INTO $db_table " >> tmp_table_update.sql
#    cat systools_actual_table_data.sql | grep "INSERT INTO $db_table " >> tmp_table_update.sql
#
###

  done    
rm $DBNAME.sql.tmp
cat tmp_table_update.sql | patch_sql | mysql -f -u euro3g -peuro3g $1
rm tmp_table_update.sql


