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

echo "use $1" > tmp_table_update.sql

for db_table in linkplu newplu price pricename plu_grid kbd_grid specplu specplu_name department dept_group vat pludescr langname
  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 | /opt/euro-beta/systools/patch_sql | mysql -f -u euro3g -peuro3g $1
rm tmp_table_update.sql
