#! /bin/sh
source ~/.bash_profile
#读取文件
sourceFile=$1
destFile="$1.sql"
logFile="$1.sql.log"
if test -f "$destFile"; then
rm $destFile
fi
if test -f "$logFile"; then
rm $logFile
fi
echo "prompt start import;" >> $destFile
echo "set feedback on;" >> $destFile
ac=0
j=0
terminal=""
if test -f "$sourceFile"; then
#循环逐行读取文件内容
for line in $(cat $sourceFile)
do
insertsql="insert when (not exists (select 1 from itx_cp_trankey t where t.termid = "
#echo $line
array=${line//|/ }
i=0
for el in $array
do
if [ $i = 0 ]; then
terminal=$el
insertsql="${insertsql}'${el}')) then into itx_cp_trankey(termid, zmk) select '${el}',"
else
insertsql="${insertsql}'${el}' from dual;"
fi
i=$(($i+1));
#if [ $i -le 1 ]; then
# insertsql="${insertsql}'${el}'"
# if [ $i = 0 ]; then
# insertsql="${insertsql},"
# fi
# i=$(($i+1));
#fi
done
#终端号和密钥都有值才增加到
if [ $i -ge 2 ]; then
echo "prompt $terminal start insert ;" >> $destFile
echo $insertsql >> $destFile
j=$(($j+1));
echo "生成第$j条sql:$insertsql" >> $logFile
else
echo "未生成sql:$line" >> $logFile
fi
ac=$(($ac+1));
echo "处理第$ac条:$line" >> $logFile
done
#添加commit
echo "commit;" >> $destFile
echo "prompt import success;" >> $destFile
fi
echo "create sql success --> $destFile" >> $logFile
shell脚本入门-转换文件格式
最新推荐文章于 2023-09-18 14:23:51 发布