文件字符串替换以及SQL执行工具

最近写的小工具，留着以后做参考

最近写的小工具，留着以后做参考
#########################################
文件字符串替换
#########################################
#!/bin/sh

echo -n "Createdate(例：20201022):"
read  CreateDate
CreateDate_Para=`echo ${CreateDate:0:4}\\\/${CreateDate:4:2}\\\/${CreateDate:6:2}`

echo "Createdate:"`echo ${CreateDate:0:4}\/${CreateDate:4:2}\/${CreateDate:6:2}`

# dev_cap:大文字、例：ABCD
parameter_XXXX=`echo $IoName_Para | tr 'a-z' 'A-Z'`
# dev_low:小文字、例：abcd
parameter_xxxx=`echo $IoName_Para | tr 'A-Z' 'a-z'`
# pro_pre_cap:IO初字母大文字、例：Abcd
parameter_Xxxx=`echo ${IoName_Para:0:1} | tr 'a-z' 'A-Z'`${IoName_Para:1}

for script in `find ./input -name \* -type f -print` 
do
    # 出力ファイル名定義
	outfile=`echo ${script:7} | sed "s/xxxx/$IoName_Para/g"`
	# ファイル内容編集
	cat $script | 
	sed "s/XXXX/$parameter_XXXX/g"               | 
	sed "s/xxxx/$parameter_xxxx/g"               | 
	sed "s/Xxxx/$parameter_Xxxx/g"               | 
	sed "s/YYYY/$Device_Para/g"                  | 
	sed "s/Makers_Para/$Makers_Para/g"           | 
	sed "s/CreateDate_Para/$CreateDate_Para/g"   >./output/${outfile} 
done

#########################################
SQL执行工具
#########################################
#select COLUMN_1,COLUMN_2 from TABLE_1 where 
#(COLUMN_1 = 'オーダーID' AND COLUMN_2 = 'コンテナID')
#OR (COLUMN_1 = 'オーダーID' AND COLUMN_2 = 'コンテナID')
#OR (COLUMN_1 = 'オーダーID' AND COLUMN_2 = 'コンテナID');
# 定義
DBA_USER=${SW_P_ORACLE_USER}
DBA_PWD=${SW_P_ORACLE_USER}
ORACLE_SID=${ORACLE_SID}

para_Array=""
para=""
count=0
strEquality="="

for para in `cat file` 
do
	count=$((${count} + 1))
	if [ `echo "${count} == 1" | bc` == 1 ];
	then
		continue;
	elif [ `echo "${count} == 2" | bc` == 1 ];
	then
		para_Array=`echo \(COLUMN_1 $strEquality`\'${para%\,*}\'`echo " "and COLUMN_2``echo $strEquality`\'${para#*\,}\'\)
	else
		para_Array=${para_Array}" OR "`echo \(COLUMN_1 $strEquality`\'${para%\,*}\'`echo " "and COLUMN_2``echo $strEquality`\'${para#*\,}\'\)
	fi
done

# SQLコマンド作成
sql_command="select COLUMN_1,COLUMN_2 from TABLE_1 where ${para_Array};"
echo 実行コマンド：${sql_command}
# 実行且つ出力
sqlplus ${DBA_USER}/${DBA_PWD}@${ORACLE_SID} << EOF
SET ECHO ON
${sql_command}
SET ECHO OFF
EOF