server.sh

delphi控件的使用

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

History_Data_Directory=""
History_Log_Directory=""


RUN_CONFIG="${Current_Work_Directory}/bin/server.cfg"
DATABASE_FILE="${Current_Work_Directory}/bin/database.cfg"
REGION_FILE="${Current_Work_Directory}/bin/region.cfg"
DEBUG_FILE="${Current_Work_Directory}/log/run.log"


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

	Config_Info=`cat $RUN_CONFIG`

	History_Data_Directory=`echo $Config_Info | cut -f 1 -d'|'`
	History_Log_Directory=`echo $Config_Info | cut -f 2 -d'|'`

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

		Region_ID=`echo $i | cut -f 1 -d'|'`
		Region_Data_Directory=`echo $i | cut -f 2 -d'|'`

		Source_PWD=`pwd`
		cd $Region_Data_Directory

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

			Database_Name=`echo $j | cut -f 1 -d'|'`
			Table_Name=`echo $j | cut -f 2 -d'|'`

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

			if [ ! -r $Compress_File ]; then
				echo "Table: ["$Table_Name"] .Z File Not Exist?" >> $History_Log_Directory"/"$CURR_DATE"_"$Region_ID".log"
				continue
			fi
			compress -d $Compress_File

			if [ ! -r $Text_File ]; then
				echo "Table: ["$Table_Name"] .txt File Not Exist?" >> $History_Log_Directory"/"$CURR_DATE"_"$Region_ID".log"
				continue
			fi

			if [ ! -s $Text_File ]; then
				echo "Table: ["$Table_Name"] .txt IS NULL?" >> $History_Log_Directory"/"$CURR_DATE"_"$Region_ID".log"
				continue
			fi

${Informix_Directory}/dbaccess <<!
	database $Database_Name;
	load from $Text_File insert into $Table_Name;
!

			echo "Table: ["$Table_Name"] Load OK!" >> $History_Log_Directory"/"$CURR_DATE"_"$Region_ID".log"
			mv $Text_File $History_Data_Directory > /dev/null
		done

		cd $Source_PWD
	done
}

rm -rf $DEBUG_FILE > /dev/null

if [ ! -r $RUN_CONFIG ]; then
	echo "ERROR_001:  Open File "$RUN_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 $REGION_FILE ]; then
	echo "ERROR_003:  Open File "$REGION_FILE" Failed at [main.mnu]?\n" >> $DEBUG_FILE
	exit -1
	fi

sleep 5

LOADFILE

exit 0