client.sh

delphi控件的使用

Current_Work_Directory="/usr/informix"
Informix_Directory="/usr/informix/bin"

Region_ID=""
Region_Host=""
Remote_Host=""
Remote_User=""
Remote_Password=""
Remote_Directory=""
Record_Number=0

DEBUG_FILE="${Current_Work_Directory}/log/run.log"
CLIENT_CONFIG="${Current_Work_Directory}/bin/client.cfg"
DATABASE_FILE="${Current_Work_Directory}/bin/database.cfg"
FTP_FILE="${Current_Work_Directory}/bin/Ftp.sh"

FTPFILE()
{
	CURR_DATE=`date +%Y%m%d`

	Config_Info=`cat $CLIENT_CONFIG`

	Region_ID=`echo $Config_Info | cut -f 1 -d'|'`
	Region_Host=`echo $Config_Info | cut -f 2 -d'|'`
	Remote_Host=`echo $Config_Info | cut -f 3 -d'|'`
	Remote_User=`echo $Config_Info | cut -f 4 -d'|'`
	Remote_Password=`echo $Config_Info | cut -f 5 -d'|'`
	Remote_Directory=`echo $Config_Info | cut -f 6 -d'|'`
	Record_Number=`echo $Config_Info | cut -f 7 -d'|'`

	FINISH_ALL=0

	for j in `awk 'BEGIN{FS="|";OFS="|"}{print $1,$2,$3,$4}' $DATABASE_FILE`
	do
		if [ ! $j ]; then
			break
		fi

		FINISH_ALL=`expr $FINISH_ALL + 1`

		Database_Name=`echo $j | cut -f 1 -d'|'`
		Table_Field=`echo $j | cut -f 2 -d'|'`
		Table_Name=`echo $j | cut -f 3 -d'|'`
		Table_Option=`echo $j | cut -f 4 -d'|'`

		if [ "$Database_Name" = "NONE" -o "$Table_Name" = "NONE" ]; then
			echo "ERROR: DatabaseName or TableName failed at FTPFILE()?" >> ${Current_Work_Directory}/log/${CURR_DATE}.log
			break
		fi

		SQLString="Select "$Table_Field" from "$Table_Name" "
		if [ "$Table_Option" != "NO" ]; then
			MSQL=`cat ${Current_Work_Directory}/table/${Table_Name}.sql`
			SQLString=$SQLString$MSQL
		fi

		Source_PWD=`pwd`
		cd ${Current_Work_Directory}/data

		Ftp_File=$Region_ID"-"$Table_Name".txt.Z"
		Text_File=$Region_ID"-"$Table_Name".txt"

		rm -rf $Ftp_File > /dev/null
		rm -rf $Text_File > /dev/null

${Informix_Directory}/dbaccess <<!
	database $Database_Name;
	unload to $Text_File $SQLString;
!

		if [ ! -r $Text_File ]; then
			echo "WARNING: Open file "$Text_File" failed at FTPFILE()?" >> ${Current_Work_Directory}/log/${CURR_DATE}.log
			continue
		fi

		if [ ! -s $Text_File ]; then
			echo "WARNING: file "$Text_File" is NULL at FTPFILE()?" >> ${Current_Work_Directory}/log/${CURR_DATE}.log
			continue
		fi

		compress $Text_File

		${Current_Work_Directory}/bin/Ftp.sh $Remote_Host $Remote_User $Remote_Password $Remote_Directory $Ftp_File
		cd $Source_PWD

	done

	if [ $FINISH_ALL -eq $Record_Number ]; then
		echo "OK: at FTPFILE()!" >> ${Current_Work_Directory}/log/${CURR_DATE}.log
	else
		echo "ERROR: Error RecordCount of Table at FTPFILE()?" >> ${Current_Work_Directory}/log/${CURR_DATE}.log
	fi

}

rm -rf $DEBUG_FILE > /dev/null

if [ ! -r $CLIENT_CONFIG ]; then
	echo "ERROR_001:  Open File "$CLIENT_CONFIG" Failed at [main.mnu]?\n" >> $DEBUG_FILE
	exit -1
fi

if [ ! -r $DATABASE_FILE ]; then
	echo "ERROR_002:  Open File "$DATABASE_FILE" Failed at [main.mnu]?\n" >> $DEBUG_FILE
	exit -1
fi

if [ ! -r $FTP_FILE ]; then
	echo "ERROR_003:  Open File "$FTP_FILE" Failed at [main.mnu]?\n" >> $DEBUG_FILE
	exit -1
fi

sleep 5

FTPFILE

exit 0