#!/bin/sh

source /app/tools/common/lib/.shell_globals

EXEC=1

dd=$(date "+%Y%m%d")
yy=$(date "+%Y")
mm=$(date "+%m")

odir="/mnt/mysql/stats/schema-exports/logs/${dd}"

logit "Start $(date)"

start_time=$(date +%s)

runit "mkdir -p ${odir}"
runit "cd /app/tools/admin/cron/db"
runit "./mysql-rm-redshift.pl 1>${odir}/mysql-rm-redshift.log 2>&1"

runit " \
mysql --login-path=admin -D report -Ne \"select db_name from d_db where calc_stat=1 order by 1\"| \
parallel -j 4 \"./mysql-cp-redshift.pl -d {} 1>${odir}/{}.mysql-cp-redshift-${dd}.log 2>&1\" \
"
runit "cd /app/tools/admin/cron/stats"
runit "./redshift-refresh-salestage.pl 1>${odir}/redshift-refresh-salestage.log 2>&1"

end_time=$(date +%s)
elapsed=$(( end_time - start_time ))

logit "Complete $(date) - ${elapsed} secs elapsed "