学步园

　　Shell将函数作为小型脚本处理，可以像普通脚本那样给其传递参数。默认情况下，脚本中定义的变量都是全局变量。局部变量：local temp。

　　Passing arrays to functions.The art of passing an array variable to a script function can be confusing. If you try to pass the array variable as a single parameter, it won’t work:

$ cat badtest3
#!/bin/bash
# trying to pass an array variable
function testit {
echo "The parameters are: $@"
thisarray=$1
echo "The received array is ${thisarray[*]}"
}
myarray=(1 2 3 4 5)
echo "The original array is: ${myarray[*]}"
testit $myarray
$ ./badtest3
The original array is: 1 2 3 4 5
The parameters are: 1
./badtest3: thisarray[*]: bad array subscript
The received array is
$

　　If you try using the array variable as a function parameter, the function only picks up the first value of the array variable.To solve this problem, you must disassemble the array variable into its individual values, then use the values as function parameters. Inside the function, you can reassemble all of the parameters into a new array variable. Here’s an example of doing this:

$ cat test10
#!/bin/bash
# array variable to function test
function testit {
local newarray
newarray=(`echo "$@"`)
echo "The new array value is: ${newarray[*]}"
}
myarray=(1 2 3 4 5)
echo "The original array is ${myarray[*]}"
testit ${myarray[*]}
$ ./test10
The original array is 1 2 3 4 5
The new array value is: 1 2 3 4 5
$

项目示例：

#!/bin/sh

set -x

#设置数据库相关变量
WORK_DIR=/home/tmn/zhaoxj
SQL_DIR=${WORK_DIR}/sqldir
LOG_DIR=${WORK_DIR}/logdir


#用户名及密码
DB_USER=***
DB_PWD=***
DB_SID=***

#14个地市视图 1千万条数据 多耗时35分钟
CITY_ARR=(V_IMEI_CELL_GPRS_CD V_IMEI_CELL_GPRS_CS V_IMEI_CELL_GPRS_CZ V_IMEI_CELL_GPRS_HH V_IMEI_CELL_GPRS_HY V_IMEI_CELL_GPRS_JS V_IMEI_CELL_GPRS_LD V_IMEI_CELL_GPRS_SY V_IMEI_CELL_GPRS_UY V_IMEI_CELL_GPRS_XT V_IMEI_CELL_GPRS_YY V_IMEI_CELL_GPRS_YZ V_IMEI_CELL_GPRS_ZJ V_IMEI_CELL_GPRS_ZZ)
#终端1  耗时15分钟
TAC_ARR=(F_TACTYPE_CELL_DY F_TACTYPE_CITY_DY F_BUSITAC_TACTYPE_DY)
#终端2  耗时5分钟
TAC_ARR2=( F_TAC_CITY_DY F_TACBRND_CITY_DY F_TEWMTYPE_CITY_DY  F_TAC_CELL_DY F_TACBRND_CELL_DY F_TEWMTYPE_CELL_DY  F_BUSITAC_TEWMTYPE_DY F_BUSITAC_TACBRND_DY)
#用户
USR_ARR=(F_TAC_USER_DY F_LOCKUSER_IMEI_DY F_HIGHALL_CITY_DY)

#根据时间参数 获得分区名称
Partition=P_1D_`echo $1|awk -F- '{print $1$2$3}'`
Timestamp=$1

fuction SumSql {

    local NEWARR
    local tabname
    
    NEWARR=(`echo "$@"`)
    
    for tabname in ${NEWARR[@]}
    do
    {
        LOG_FILE="${LOG_DIR}/${tabname}_`date +%y%m%d` `date +%T`.log"
        echo "(`date +%y-%m-%d` `date +%T`) Start synchro \n" >>$LOG_FILE        
        
        if echo ${tabname} | grep "^V_IMEI_CELL" >/dev/null 2>&1
        then        
           #汇总14个地市视图
           sqlplus -s ${DB_USER}/${DB_PWD}@${DB_SID}  @${SQL_DIR}/F_IMEI_CELL_DY.sql  ${tabname} ${Partition} ${Timestamp} >>$LOG_FILE
        else
           sqlplus -s ${DB_USER}/${DB_PWD}@${DB_SID}  @${SQL_DIR}/${tabname}.sql ${Timestamp} ${Partition} >>$LOG_FILE    
        fi
  
      echo "(`date +%y-%m-%d` `date +%T`) Over synchro  \n" >>$LOG_FILE
    }&
    done
    
    wait    
}

#汇总14个地市基础数据
SumSql ${CITY_ARR[@]}

#汇总终端1
SumSql ${TAC_ARR[@]}

#汇总终端2 
SumSql ${TAC_ARR2[@]}

#汇总用户
SumSql ${USR_ARR[@]}