通过HDBSQL将当前目录下所有CSV文件导入到HANA的脚本

工作需要每天都要执行相同的导入动作，每天都会生成很多新的CSV文件，直接在STUDIO里手动导入太累，直接写个脚本搞定。

#!/bin/sh  
a = 'pwd'
list_alldir(){  
    for file2 in `ls -a $1`  
    do  
        if [ x"$file2" != x"." -a x"$file2" != x".." ];then  
            if [ -d "$1/$file2" ]
            	then
                	list_alldir "$1/$file2"  
                else
			if [ "${file2##*.}" == "csv" ];then
				$HDBSQL/hdbsql -n localhost -i 0 -u SYSTEM -p manager "IMPORT FROM CSV FILE '$(cd "$(dirname "$0")";pwd)/$1/$file2' INTO TRADITIONAL_MEDIA.CNN1 WITH COLUMN LIST IN FIRST ROW RECORD DELIMITED BY '?\$?' FIELD DELIMITED BY '#\$#'"  
#				echo "IMPORT FROM CSV FILE '$(cd "$(dirname "$0")";pwd)/$1/$file2' INTO TRADITIONAL_MEDIA.CNN WITH COLUMN LIST IN FIRST ROW RECORD DELIMITED BY '?\$?' FIELD DELIMITED BY '#\$#'"  
#				echo "$(cd "$(dirname "$0")";pwd)/$1/$file2"
			fi
            fi  
        fi  
    done  
}  

list_alldir .