#!/usr/bin/ksh
# *****************************************************************************
#  Script Name:  sftp_dump_files.ksh
#  Description:  Performs sFTP put of exported dump files
#
#  Syntax:
#   sftp_dump_files.ksh -d <lv_dbname> -r <lv_rfc>
#
#  Required parameters:
#     lv_dbname      - name of schema dump to sFTP
#     lv_rfc            - change number [ format CHGXXXX ]
# *****************************************************************************
#
# Execute to setup global variables
. ${APPS}/db_batch/common/.batchenv
# *****************************************************************************
#  Function - Display parameter usage and terminate the job
# *****************************************************************************
CMD=`basename $0`
display_usage()
{
   echo "==============================================================================="
   echo "Script Name:  ${CMD}"
   echo "Description:  Performs sFTP put of exported dump files"
   echo ""
   echo "Usage:"
   echo "   ${CMD} -r <lv_rfc>"
   echo ""
   echo "Required parameters:"
   echo "   lv_dbname      - name of database dump to sFTP"
   echo "   lv_rfc            - change number [ format CHGXXXX ]"
   echo "==============================================================================="
   exit 1
}
# *****************************************************************************
#  Parse input parameter
# *****************************************************************************
set -- $(getopt u:r: $*)
if [ $? -ne 0 ]
then
   echo "ERROR: Insufficient arguments."
   display_usage
fi
count_r=0
for o in $(getopt u:r: $*)
do
   case $o in
      -u) lv_dbname="$2"; count_u=$(expr $count_u \+ 1); shift 2;;
      -r) lv_rfc="$2"; count_r=$(expr $count_r \+ 1); shift 2;;
      --) shift; break;;
   esac
done
#  Abort if there are insufficient arguments
if [ $count_u -ne 1 ] || [ $count_r -ne 1 ]
then
   echo "ERROR: Insufficient arguments."
   display_usage
fi
#  Export local variables and force uppercase
export lv_dbname="`echo ${lv_dbname} | tr '[:lower:]' '[:upper:]'`"
export lv_rfc="`echo ${lv_rfc} | tr '[:lower:]' '[:upper:]'`"
# *****************************************************************************
#  Setup local step variables
# *****************************************************************************
#  Local job variables
export lv_job_path="${DBBATCH}/CR/${lv_rfc}"
export lv_common_path="${lv_job_path}/common"
export lv_shell_path="${lv_job_path}/shell"
export lv_sql_path="${lv_job_path}/sql"
export lv_log_path="${lv_job_path}/log"
mkdir -p ${lv_common_path} ${lv_shell_path} ${lv_sql_path} ${lv_log_path}
#  Setup local step variables
lv_step_name=sftp_dump_files
lv_step_log_file=${lv_log_path}/${lv_step_name}.log
# Additional local variables
lv_retcode=0
lv_exitcode=0
# *****************************************************************************
#  Main part of the step script (sFTP put from ${LOCAL_HOST} to ${REMOTE_HOST})
# *****************************************************************************
echo "*** `date` Begin executing ${CMD} ***" | tee ${lv_step_log_file}
????????????????????????????????????
Here i have to put FOR or WHILE LOOP
# Loop through for all databases (eg: central ltts pass rd1 rpt1 teraview1 tvstage workdb)
# Skip if the one database does not exist
????????????????????????????????????

#  sFTP dump file if it exists
if [ -f ${LOCAL_EXPORT}/${lv_rfc}_${lv_dbname}.dump ]
then
   echo "Local Host: " ${LOCAL_HOST} | tee -a ${lv_step_log_file}
   echo "Local Files:" | tee -a ${lv_step_log_file}
   ls -lrt ${lv_rfc}_*.dump | tee -a ${lv_step_log_file}
   echo "" | tee -a ${lv_step_log_file}
   echo "Remote Host: " ${REMOTE_HOST} | tee -a ${lv_step_log_file}
   #  sftp the script if it is for EXPORT
   sftp sybase@${REMOTE_HOST} << EOF >> ${lv_step_log_file} 2>&1
      lcd ${LOCAL_EXPORT}
      cd ${REMOTE_EXPORT}
      mput -p ${DUMPATH}/${lv_dbname}/${lv_dbname}*.dump
      ls -lart
   quit
EOF
else
   echo "FAILURE : Dump file ${LOCAL_EXPORT}/${lv_rfc}_${lv_dbname}.dump does not exist." | tee -a ${lv_step_log_file}
   echo "*** `date` Failed while executing ${CMD} ***" | tee -a ${lv_step_log_file}
   exit 1
fi
echo "*** `date` Finish executing ${CMD} ***" | tee -a ${lv_step_log_file}
#++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
# Final:
#   Following are executed only all the previous steps are executed successfully to update
#   successful status in log files and notify recipient through email
#++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
echo "${lv_job_name} on ${SERVERNAME} finished at `date`" >> ${lv_job_log_file}
#++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
# Exit batch script with return code
#++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
exit ${lv_exitcode}