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

:<<EOF
export ENV_CLIENT='demo'
export ENV_LOCALE='staging'
export RDB_LOCALE_USER='postgres'
bash <(curl -s 'https://cdn.chorke.org/exec/cli/psql/finology/commons/export/locale/db2gz.sh.txt')
EOF


ENV_CLIENT='demo'
CLI_DUMP='pg_dump'
ENV_SERVER='locale'
ENV_LOCALE='staging'
BKP_SUFFIX_ZIP="$(date +'%Y%m%d_%H%M').sql.gz"


if [ -z "$ENV_PREFIX" ];then ENV_PREFIX='xpresscover';fi
if [ -z "$RDB_LOCALE_USER" ];then RDB_LOCALE_USER='postgres';fi
if [ -f "$HOME/.finology/xpresscover/var/bkp/.last_env_client" ];then ENV_CLIENT=`cat $HOME/.finology/xpresscover/var/bkp/.last_env_client`;fi
if [ -f "$HOME/.finology/xpresscover/var/bkp/.last_env_locale" ];then ENV_LOCALE=`cat $HOME/.finology/xpresscover/var/bkp/.last_env_locale`;fi


if [ -z "$ENV_LOCALE" ];then
    printf -v RDB_LOCALE_TDS    '%s_tds'       "$ENV_PREFIX"
    printf -v RDB_LOCALE_QUOTE  '%s_quote'     "$ENV_PREFIX"
    printf -v RDB_LOCALE_POLICY '%s_policy'    "$ENV_PREFIX"
else
    printf -v RDB_LOCALE_TDS    '%s_tds_%s'    "$ENV_PREFIX" "$ENV_LOCALE"
    printf -v RDB_LOCALE_QUOTE  '%s_quote_%s'  "$ENV_PREFIX" "$ENV_LOCALE"
    printf -v RDB_LOCALE_POLICY '%s_policy_%s' "$ENV_PREFIX" "$ENV_LOCALE"
fi


if [ -z "$ENV_LOCALE" ];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_LOCALE_TDS"    "$BKP_SUFFIX_ZIP"
    printf -v BKP_LOCALE_QUOTE  '%s/%s_production_%s' "$BKP_PARENT_DIR" "$RDB_LOCALE_QUOTE"  "$BKP_SUFFIX_ZIP"
    printf -v BKP_LOCALE_POLICY '%s/%s_production_%s' "$BKP_PARENT_DIR" "$RDB_LOCALE_POLICY" "$BKP_SUFFIX_ZIP"
else
    BKP_PARENT_DIR="$HOME/.finology/xpresscover/var/bkp/$ENV_SERVER/$ENV_CLIENT/$ENV_LOCALE/$(date +'%Y')/$(date +'%Y%m')/$(date +'%Y%m%d')"
    printf -v BKP_LOCALE_TDS    '%s/%s_%s' "$BKP_PARENT_DIR" "$RDB_LOCALE_TDS"    "$BKP_SUFFIX_ZIP"
    printf -v BKP_LOCALE_QUOTE  '%s/%s_%s' "$BKP_PARENT_DIR" "$RDB_LOCALE_QUOTE"  "$BKP_SUFFIX_ZIP"
    printf -v BKP_LOCALE_POLICY '%s/%s_%s' "$BKP_PARENT_DIR" "$RDB_LOCALE_POLICY" "$BKP_SUFFIX_ZIP"
fi


if [ "$ENV_LOCALE" != 'staging' ];then
    printf -v RDB_LOCALE_TDS    '%s_tds_staging'    "$ENV_PREFIX"
    printf -v RDB_LOCALE_QUOTE  '%s_quote_staging'  "$ENV_PREFIX"
    printf -v RDB_LOCALE_POLICY '%s_policy_staging' "$ENV_PREFIX"
fi


function export_dbs(){
    "$CLI_DUMP" -U "$RDB_LOCALE_USER" "$RDB_LOCALE_TDS"    | gzip > "$BKP_LOCALE_TDS"
    "$CLI_DUMP" -U "$RDB_LOCALE_USER" "$RDB_LOCALE_QUOTE"  | gzip > "$BKP_LOCALE_QUOTE"
    "$CLI_DUMP" -U "$RDB_LOCALE_USER" "$RDB_LOCALE_POLICY" | gzip > "$BKP_LOCALE_POLICY"
}


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


init