生成批量处理sql

#! /bin/bash


sourcefile=""
lines=800
fillsql=""
suffix=");"


if test ! -z $1
then
        sourcefile=$1
fi


if test ! -z "$2"
then
        fillsql="$2"
fi


if test ! -z $3
then
        lines=$3
fi


if test -d filelist
then
        rm -r filelist
fi


if test -d sqlfile
then
        rm -r sqlfile
fi


mkdir filelist
mkdir sqlfile
cd filelist


split -l $lines -d  ../$sourcefile


filedatalist=$(ls)


for tempfile in $filedatalist
do
        dos2unix $tempfile
        awk 'BEGIN{ORS=","}{print $0>"tempfile2"}' $tempfile
        awk '{print substr($0,0,length($0)-1)>"tempfile3"}' tempfile2
        awk '{print "'"$fillsql"'" $0"'"$suffix"'">>"../sqlfile/tempfile"}' tempfile3 |wc 
done