shell编程_数据移植

#! /bin/bash

table_name=$2
db_typde=$1
file_dir=$HOME/ta_trans_data/${table_name}
#fileList=`ls -l ${file_dir}|awk '$5==0 {print $9}'`
fileList=`ls ${file_dir}`
#echo "Ŀ¼:${fileList}"
i=1
for filename in ${fileList}
do
	if [ -f ${file_dir}/${filename} ]
	then	
		echo "${filename}"
		file_number=`echo ${filename}|awk -F'.' '{print $1}'|awk -F'_' '{print $NF}'`
		#echo ${file_number}
		if [ ${file_number} = "0" ]
		then
			echo "trade1"
		elif [ ${file_number} = "1" ]
		then
			echo "trade2"
		elif [ ${file_number} = "2" ]
		then
			echo "trade3"
                elif [ ${file_number} = "3" ]
                then
                        echo "trade4"
                elif [ ${file_number} = "4" ]
                then
                        echo "trade5"
		elif [ ${file_number} = "5" ]
                then
                        echo "trade6"
		elif [ ${file_number} = "6" ]
                then
                        echo "trade7"
                elif [ ${file_number} = "7" ]
                then
                        echo "trade8"
		else
			echo "trade not exist"
			exit -1
		fi
	fi
done

　　

 

传入，一个参数（表名），一个参数（库的类型），去对应的目录下找文件。