shell demo

#! /bin/bash

# shell demo

# 输入量测ID和遥测表名，能够输出更新此量测ID在遥测表中各数据域的SQL语句。

# 例如./a.sh 量测ID值 遥测表

# 输出update 遥测表名 SET data_0_0 = 1,

# SET DATA_0_1 = 2,....

HOURS=24

MINUTES=60

#if [ 2 != $# ]

#then

#   echo "usage:./Demo.sh 量测ID值 遥测表"

#   return -1

#fi

if [ "$#" -ne "2" ]; then 

    echo "usage: $0 <量测ID值> <遥测表>" 

    exit 2   

fi

updateID=$1

tableName=$2

# echo head

echo "update $tableName SET "

# use loop to print update SQL

hour=0

minute=0

tmp=0

#echo "data_$hour:$minute = $tmp "

#echo""

while [ $hour -lt $HOURS ]

do

    hour=`expr $hour + 1`    #echo "hour=$hour"

    minute=0

    while [ $minute -lt $MINUTES ]

    do

        minute=`expr $minute + 1`

        tmp=`expr $tmp + 1`

        echo -n  "data_$hour"

        echo "_$minute = $tmp "

    done

done

# echo tail

echo "where ID = $updateID "