#!/bin/bash
# PALOMA DATABASE SHELL SCRIPT

NOW=$(date '+%Y%m%d')
LOGTIME=$(date '+%a %b %d %H:%M %Y')
LOGNAME="LOG_$NOW.log"
MYSQLPASS=""
MYSQLUSER="root"
MYSQLHOST="localhost"
FILENAME="bash_mysql_$NOW.csv"
ZIPNAME="bash_mysql_$NOW.zip"
BASEDIR="/home/sts"

check_error() {
  if [ $? -ne 0 ]; then
    echo "[$LOGTIME] PROCESS STOPPED BECAUSE THERE IS AN ERROR WITH CODE : $?" >> $LOGNAME
    exit $?
  fi
}

cd $BASEDIR && touch $LOGNAME
chmod 666 $LOGNAME

echo "[$LOGTIME] START PROCESS" >> $LOGNAME
echo "[$LOGTIME] CONNECT TO MYSQL" >> $LOGNAME

rm /tmp/$FILENAME

mysql -u root -D paloma_database_sdp -e "SELECT id_produk, style_produk, nama_produk, nama_merek, nama_kategori, \
nama_jenis_produk, nama_gender, nama_warna, nama_ukuran, berat, harga_katalok_zona_1, diskon_member \
FROM produk \
INNER JOIN katalok ON produk.id_katalok = katalok.id_katalok \
INNER JOIN merek ON produk.id_merek = merek.id_merek \
INNER JOIN kategori ON produk.id_kategori = kategori.id_kategori \
INNER JOIN jenis_produk ON produk.id_jenis_produk = jenis_produk.id_jenis_produk \
INNER JOIN gender ON produk.id_gender = gender.id_gender \
INNER JOIN warna ON produk.id_warna = warna.id_warna \
INNER JOIN ukuran ON produk.id_ukuran = ukuran.id_ukuran \
WHERE katalok.status_katalok = 'T' \
AND CURDATE() BETWEEN katalok.periode_awal_katalok AND katalok.periode_akhir_katalok \
INTO OUTFILE '/tmp/$FILENAME' \
FIELDS TERMINATED BY ',' \
ENCLOSED BY '\"' \
LINES TERMINATED BY '\n'"

check_error

echo "[$LOGTIME] EXIT MYSQL" >> $LOGNAME

mv /tmp/$FILENAME $BASEDIR/$FILENAME

echo "[$LOGTIME] COMPRESS STARTING" >> $LOGNAME
cd $BASEDIR/ && zip $ZIPNAME $FILENAME
check_error
chmod 666 $BASEDIR/$ZIPNAME

if [ ! -s "/home/sts/$ZIPNAME" ]; then
echo "[$LOGTIME] FAILED TO DUMP MYSQL" >> $LOGNAME

else
echo "[$LOGTIME] SUCCESS TO DUMP MYSQL" >> $LOGNAME
echo "[$LOGTIME] UPLOAD STARTING" >> $LOGNAME

#/home/sts/google-cloud-sdk/bin/gcloud compute copy-files /home/sts/$ZIPNAME root@paloma-dev:/home/sts/$ZIPNAME --zone asia-east1-a
scp -i /home/sts/.ssh/google_compute_engine -o UserKnownHostsFile=/dev/null -o CheckHostIP=no -o StrictHostKeyChecking=no \
/home/sts/$ZIPNAME sts@130.211.240.0:/home/sts/

check_error
echo "[$LOGTIME] UPLOAD COMPLETE" >> $LOGNAME
fi