#!/bin/bash

# defaults
start=$(date +%s)
DATE=$(date +%F)
TARGETFILE_DB=`date +oxid_db_prod_%Y_%m_%d.sql.gz`
CHECK_MARK="\033[0;32m\xE2\x9C\x94\033[0m"
SCRIPTDIR=$(dirname "$0")

cd $SCRIPTDIR

ENV=$(printenv OXID_ENV)
CONFIG="$SCRIPTDIR/../../configurations/$ENV/.config"

if test -f "$CONFIG"; then
    source $CONFIG
else
    echo "No config found. Exiting... $CONFIG ¯\_(ツ)_/¯"
    exit 1
fi

# create dump of pimcore db
echo -n "Exporting database..."
OXID_TABLES="compliancecookies ddmedia oxacceptedterms oxaccessoire2article oxactions oxactions2article oxactions_set1 oxartextends oxartextends_set1 oxarticles oxarticles2shop oxarticles_set1 oxattribute oxattribute2shop oxattribute_set1 oxbenefit oxcategories oxcategories2shop oxcategories_set1 oxcategory2attribute oxcontents oxcontents_set1 oxcounters oxcountry oxcountry_set1 oxdel2delset oxdelivery oxdelivery2shop oxdelivery_set1 oxdeliveryset oxdeliveryset2shop oxdeliveryset_set1 oxdiscount oxdiscount2shop oxdiscount_set1 oxfield2role oxfield2shop oxfield2shop_set1 oxfiles oxlinks oxlinks2shop oxlinks_set1 oxmanufacturers oxmanufacturers2shop oxmanufacturers_set1 oxmediaurls oxmediaurls_set1 oxnews oxnews2shop oxnews_set1 oxobject2action oxobject2article oxobject2attribute oxobject2attribute_set1 oxobject2benefit oxobject2category oxobject2delivery oxobject2discount oxobject2list oxobject2payment oxobject2selectlist oxobject2seodata oxobjectrights oxprice2article oxpricealarm oxratings oxrecommlists oxremark oxreviews oxrolefields oxroles oxselectlist oxselectlist2shop oxselectlist_set1 oxseo oxshops oxshops_set1 oxstates oxstates_set1 oxtplblocks oxtranslation oxvendor oxvendor2shop oxvendor_set1 oxvouchers oxvoucherseries oxvoucherseries2shop oxwrapping oxwrapping2shop oxwrapping_set1" 
mysqldump --column-statistics=0 --host=$MYSQLHOST --user=$MYSQLUSER --password=$MYSQLPASS --add-drop-table --no-data --quick --opt --max_allowed_packet=1000000000 $MYSQLDB $OXID_TABLES | grep -v "50013 DEFINER"| gzip > $TARGETFILE_DB
mysqldump --column-statistics=0 --host=$MYSQLHOST --user=$MYSQLUSER --password=$MYSQLPASS --no-create-info --quick --opt --max_allowed_packet=1000000000 $MYSQLDB $OXID_TABLES | grep -v "50013 DEFINER"| gzip >> $TARGETFILE_DB
SQLSTATUS=$?

if [ $SQLSTATUS -eq 0 ]; then
    echo -e "\\r${CHECK_MARK} Exporting database... DONE"
else
    echo -e "Exporting database... FAILED"
    exit 1
fi

echo -n "moving dump and to exchange Folder"
mv $TARGETFILE_DB /var/www/alko-garden.de/dump

end=$(date +%s)
executiontime=$((end-start))

echo "Oxid database successfully exported to dump directory (took $executiontime seconds)"