61 lines
2.0 KiB
Bash
Executable File
61 lines
2.0 KiB
Bash
Executable File
#!/bin/bash -e
|
|
|
|
#/****************************************************************
|
|
#****** ForeWarn Licensing and / or usage Terms and Conditions *****
|
|
#ForeWarn. The NextGen Insights Solution Platform
|
|
|
|
#Copyright ¿ 2021 COMPEGENCE. All Rights Reserved
|
|
|
|
#ForeWarn is a product of COMPEGENCE.
|
|
|
|
#To be used only with a valid license from COMPEGENCE
|
|
|
|
#www.compegence.com info@compegence.com
|
|
#****************************************************************/
|
|
|
|
HOME="/home/compegence/customer"
|
|
#Directories
|
|
homeDir=$HOME/MMT
|
|
configDir=$homeDir/conf
|
|
input_file=$configDir/etl-config.txt
|
|
declare -A credentials
|
|
while IFS="=" read -r key value; do
|
|
credentials[$key]=$value
|
|
done < <( sed -e '/^\s*$/ d' -e '/^#/ d' $input_file )
|
|
|
|
|
|
user=${credentials[user]}
|
|
password=${credentials[password]}
|
|
host=${credentials[host]}
|
|
db=${credentials[db]}
|
|
protocol=${credentials[protocol]}
|
|
server=${credentials[server]}
|
|
|
|
|
|
psql_base_arg="postgresql://$user:$password@$host/$db"
|
|
|
|
#update fw_jobctl_file_landing
|
|
|
|
|
|
##get file mnemonic count
|
|
file_mnemonic_count_drawbar=$(psql $psql_base_arg -t -c "select count(*) from fw_core.fw_jobctl_file_runschedule where latest_runschedule_flag=true and file_mnemonic like 'DB%' ;")
|
|
echo "file-mnemonic-count is $file_mnemonic_count_drawbar"
|
|
|
|
if [[ $file_mnemonic_count_drawbar -gt 0 ]]; then
|
|
psql $psql_base_arg -t -c "select fw_ods.drawbar_correlation_upload()"
|
|
# else
|
|
# exit 1;
|
|
fi
|
|
|
|
file_mnemonic_count_pto=$(psql $psql_base_arg -t -c "select count(*) from fw_core.fw_jobctl_file_runschedule where latest_runschedule_flag=true and file_mnemonic like 'PTO%';")
|
|
echo "file-mnemonic-count_pto is $file_mnemonic_count_pto"
|
|
|
|
if [[ $file_mnemonic_count_pto -gt 0 ]]; then
|
|
psql $psql_base_arg -t -c "select fw_ods.pto_correlation_upload()"
|
|
# else
|
|
# exit 1;
|
|
fi
|
|
|
|
|
|
|