#!/bin/bash
: '
 @vendor    Chorke Academia, Inc.
 @web       https://cdn.chorke.org/docs/academia
 @version   1.0.00
 @since     1.0.00
'

:<<EOF
export ENV_REMOTE='staging'
export SSH_REMOTE_USER='deploy'
export SSH_TUNNEL_USER='deploy'
export SSH_TUNNEL_HOST='dev.xpresscover.io'
export SSH_REMOTE_HOST='dev.xpresscover.io'
bash <(curl -s 'https://cdn.chorke.org/exec/cli/psql/finology/commons/export/remote/db2gz.sh.txt')
EOF


ENV_SERVER='remote'
BKP_SUFFIX_ZIP="$(date +'%Y%m%d_%H%M').sql.gz"
if [ -z "$CLI_DUMP" ];then CLI_DUMP='pg_dump';fi
if [ -z "$ENV_CLIENT" ];then ENV_CLIENT='demo';fi
if [ -z "$ENV_PREFIX" ];then ENV_PREFIX='xpresscover';fi
if [ -z "$RDB_REMOTE_USER" ];then RDB_REMOTE_USER='postgres';fi


if [ -z "$ENV_REMOTE" ];then
    printf -v RDB_REMOTE_TDS    '%s_tds'       "$ENV_PREFIX"
    printf -v RDB_REMOTE_QUOTE  '%s_quote'     "$ENV_PREFIX"
    printf -v RDB_REMOTE_POLICY '%s_policy'    "$ENV_PREFIX"
else
    printf -v RDB_REMOTE_TDS    '%s_tds_%s'    "$ENV_PREFIX" "$ENV_REMOTE"
    printf -v RDB_REMOTE_QUOTE  '%s_quote_%s'  "$ENV_PREFIX" "$ENV_REMOTE"
    printf -v RDB_REMOTE_POLICY '%s_policy_%s' "$ENV_PREFIX" "$ENV_REMOTE"
fi


if [ -z "$SSH_REMOTE_HOST" ];then SSH_REMOTE_HOST='dev.xpresscover.io';fi
if [ -z "$SSH_TUNNEL_HOST" ];then SSH_TUNNEL_HOST="$SSH_REMOTE_HOST";fi
if [ -z "$SSH_TUNNEL_USER" ];then SSH_TUNNEL_USER="$SSH_REMOTE_USER";fi

if [ -z "$SSH_REMOTE_USER" ];then SSH_REMOTE_AUTH="$SSH_REMOTE_HOST"
else printf -v SSH_REMOTE_AUTH '%s@%s' "$SSH_REMOTE_USER" "$SSH_REMOTE_HOST";fi

if [ -z "$SSH_TUNNEL_USER" ];then SSH_TUNNEL_AUTH="$SSH_TUNNEL_HOST"
else printf -v SSH_TUNNEL_AUTH '%s@%s' "$SSH_TUNNEL_USER" "$SSH_TUNNEL_HOST";fi

    
if [ -z "$ENV_REMOTE" ];then
    BKP_PARENT_DIR="$HOME/.finology/xpresscover/var/bkp/$ENV_SERVER/$ENV_CLIENT/production/$(date +'%Y')/$(date +'%Y%m')/$(date +'%Y%m%d')"
    printf -v BKP_LOCALE_TDS    '%s/%s_production_%s' "$BKP_PARENT_DIR" "$RDB_REMOTE_TDS"    "$BKP_SUFFIX_ZIP"
    printf -v BKP_LOCALE_QUOTE  '%s/%s_production_%s' "$BKP_PARENT_DIR" "$RDB_REMOTE_QUOTE"  "$BKP_SUFFIX_ZIP"
    printf -v BKP_LOCALE_POLICY '%s/%s_production_%s' "$BKP_PARENT_DIR" "$RDB_REMOTE_POLICY" "$BKP_SUFFIX_ZIP"
else
    BKP_PARENT_DIR="$HOME/.finology/xpresscover/var/bkp/$ENV_SERVER/$ENV_CLIENT/$ENV_REMOTE/$(date +'%Y')/$(date +'%Y%m')/$(date +'%Y%m%d')"
    printf -v BKP_LOCALE_TDS    '%s/%s_%s' "$BKP_PARENT_DIR" "$RDB_REMOTE_TDS"    "$BKP_SUFFIX_ZIP"
    printf -v BKP_LOCALE_QUOTE  '%s/%s_%s' "$BKP_PARENT_DIR" "$RDB_REMOTE_QUOTE"  "$BKP_SUFFIX_ZIP"
    printf -v BKP_LOCALE_POLICY '%s/%s_%s' "$BKP_PARENT_DIR" "$RDB_REMOTE_POLICY" "$BKP_SUFFIX_ZIP"
fi


function tunnel_export_dbs(){
    printf -v SSH_TUNNEL_TDS    "ssh %s '%s -h localhost -U %s %s'" "$SSH_REMOTE_AUTH" "$CLI_DUMP" "$RDB_REMOTE_USER" "$RDB_REMOTE_TDS"
    printf -v SSH_TUNNEL_QUOTE  "ssh %s '%s -h localhost -U %s %s'" "$SSH_REMOTE_AUTH" "$CLI_DUMP" "$RDB_REMOTE_USER" "$RDB_REMOTE_QUOTE"
    printf -v SSH_TUNNEL_POLICY "ssh %s '%s -h localhost -U %s %s'" "$SSH_REMOTE_AUTH" "$CLI_DUMP" "$RDB_REMOTE_USER" "$RDB_REMOTE_POLICY"

    ssh "$SSH_TUNNEL_AUTH" "$SSH_TUNNEL_TDS"    | gzip > "$BKP_LOCALE_TDS"
    ssh "$SSH_TUNNEL_AUTH" "$SSH_TUNNEL_QUOTE"  | gzip > "$BKP_LOCALE_QUOTE"
    ssh "$SSH_TUNNEL_AUTH" "$SSH_TUNNEL_POLICY" | gzip > "$BKP_LOCALE_POLICY"
}


function remote_export_dbs(){
    ssh "$SSH_REMOTE_AUTH" "$CLI_DUMP -h localhost -U $RDB_REMOTE_USER $RDB_REMOTE_TDS"    | gzip > "$BKP_LOCALE_TDS"
    ssh "$SSH_REMOTE_AUTH" "$CLI_DUMP -h localhost -U $RDB_REMOTE_USER $RDB_REMOTE_QUOTE"  | gzip > "$BKP_LOCALE_QUOTE"
    ssh "$SSH_REMOTE_AUTH" "$CLI_DUMP -h localhost -U $RDB_REMOTE_USER $RDB_REMOTE_POLICY" | gzip > "$BKP_LOCALE_POLICY"
}


function export_dbs(){
    if [ "$SSH_TUNNEL_AUTH" == "$SSH_REMOTE_AUTH" ];then SSH_TUNNEL='OFF';else SSH_TUNNEL='ON';fi
    if [ "$SSH_TUNNEL" == "ON" ];then tunnel_export_dbs;else remote_export_dbs;fi
}


function init(){
    mkdir -p "$BKP_PARENT_DIR"
    if [ -x "$(command -v gzip)" ];then export_dbs
    else printf '\gzip \033[0;31mcommand not found! \033[0m:(\n';fi
}


init