需求综合

#!/bin/sh

updDatFile=$1

#֧???ͺ????ݲ??????µ???

echo "smType Info upd import: $updDatFile"

cd /NandFlash

echo "CurDir=`pwd`"

getPort()

{

	#Ĭ??485

	ret=4

    #DI;DO;232;485;NET

	echo "$1"

	case "$1" in

	"DI") 

	    ret=1

	;;

	"DO") 

	    ret=2

	;;

	"232") 

	    ret=3

	;;

	"485") 

	    ret=4

	;;

	"NET") 

	    ret=6

	;;

	*)

	    echo "nknow Port"

	;;

	esac

	return ${ret};

}

getSubSys()

{

	#Ĭ????

	ret=0

    #??;1-?е???;2-?????;3-UPS???;4-??ؼ??;5-?¶?ʪ??;6-©ˮ???;7-?յ????;8-???ܿյ?;9-???????;10-??????;11-?Ž??Ŵ?;12-?????Ƶ;13-??????ʾ

	echo "$1"

	case "$1" in

	"1-"*) 

	    ret=1

	;;

	"2-"*) 

	    ret=2

	;;

	"3-"*) 

	    ret=3

	;;

	"4-"*) 

	    ret=4

	;;

	"5-"*) 

	    ret=5

	;;

	"6-"*) 

	    ret=6

	;;

	"7-"*) 

	    ret=7

	;;

	"8-"*) 

	    ret=8

	;;

	"9-"*) 

	    ret=9

	;;

	"10-"*) 

	    ret=10

	;;

	"11-"*) 

	    ret=11

	;;

	"12-"*) 

	    ret=12

	;;

	"13-"*) 

	    ret=13

	;;

	*)

	    echo "unknow subsys"

	;;

	esac

	return ${ret};

}

#https://www.runoob.com/w3cnote/shell-read-line.html

while read line

do

    #echo $line

	#

	#arrData=(${line//,/ }) 

	#echo ${!arrData[@]}

	#

	#echo $line |awk -F, '{print $1}'

	#https://blog.csdn.net/u010003835/article/details/80750003

	#https://blog.csdn.net/jacob107/article/details/87013243

	OLD_IFS="$IFS"

    IFS=";"

    arr=($line)

    IFS="$OLD_IFS"

    nPort=4

    nSubSys=0	

	#https://www.cnblogs.com/xibuhaohao/p/11542169.html

    expr ${arr[0]} "+" 10 &> /dev/null

	if [ $? -eq 0 ];then

	   echo "${arr[0]} ${arr[1]} ${arr[2]} ${arr[3]} ${arr[4]} ${arr[5]} ${arr[6]} ${arr[7]} ${arr[8]} ${arr[9]}"

	   #DI;DO;232;485;NET

	   getPort ${arr[4]}

	   nPort=$?

	   echo "nPort=${nPort}"

	   getSubSys ${arr[9]}

	   nSubSys=$?

	   echo "nSubSys=${nSubSys}"

	   #if [ ]

	   #AI ?豸???ӣ?tbAIDef??

	   #tbSMType?б???Ƿ???????

	   cntIns=$(sqlite3 dbCfg.db3 "select count(*) from tbSMType where Type='${arr[6]}' and Tag1='${arr[7]}'")

	   echo "cntIns: $cntIns"

	   if [ $cntIns -eq 0 ];then

	   #δ????????????

	       echo "new Type"

		   Type=${arr[6]}

		   kind=`expr $Type - $Type % 256`

		   echo "Type: $Type,Kind: $kind"

		   $(sqlite3 dbCfg.db3 "insert into tbSMType values(${Type},${kind},'${arr[2]}','${arr[3]}',${arr[7]},${arr[8]},${nPort},'${arr[5]}',0,0,0,0,0,0,${nSubSys})")

		   #echo "$?"

		   if [ $? -eq 0 ];then

	           echo "Add SM${Type}-${arr[7]} Successe"

	       else

	           echo "Add SM${Type}-${arr[7]} Fail"

	       fi

		   ##

	   else

	   #???????????

	       echo "old Type"

		   Type=${arr[6]}

		   kind=`expr $Type - $Type % 256`

		   echo "Type: $Type,Kind: $kind"

		   $(sqlite3 dbCfg.db3 "update tbSMType set Name='${arr[2]}',Note='${arr[3]}',Ext1=${arr[8]},Port=${nPort},PortDef='${arr[5]}',ASubSys=${nSubSys} where Type=${Type} and Tag1=${arr[7]}")

		   #echo "$?"

		   if [ $? -eq 0 ];then

	           echo "upd SM${Type}-${arr[7]} Successe"

	       else

	           echo "upd SM${$Type}-${arr[7]} Fail"

           fi

		   ##

	   fi

	   #	   

	else

	   echo "${arr[0]} not SMType Info"

	fi

    #echo "${arr[0]} ${arr[1]} ${arr[2]} ${arr[3]} ${arr[4]} ${arr[5]} ${arr[6]} ${arr[7]} ${arr[8]} ${arr[9]}"

	#echo "${arr[0]} ${arr[5]}"

done < $updDatFile