|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
#!/bin/bash
tflag=0
rflag=0
gflag=0
while getopts 'trgh' OPTION
do
case $OPTION in
t) tflag=1
;;
r) rflag=1
;;
g) gflag=1
;;
h) echo "Usage: [-tr] L1_KEY"
echo " -t: print TSC key"
echo " -r: print RS keys"
echo " -g: GT RS keys only"
exit
;;
esac
done
shift $(($OPTIND - 1))
getColumnFromL1Key()
{
COLUMN=$1
DB="cms_omds_lb"
USER="cms_trg_r"
# PASSWORD_FILE=$HOME/secure/$USER.txt
PASSWORD_FILE=/nfshome0/centraltspro/secure/$USER.txt
PASSWORD=`cat $PASSWORD_FILE`
RESULT=`sqlplus -s <<!
$USER/$PASSWORD@$DB
SET FEEDBACK OFF;
SET HEADING OFF;
SET LINESIZE 500;
select $COLUMN
from CMS_TRG_L1_CONF.L1_CONF_DETAILS_VIEW
where L1_KEY='$L1_KEY';
!`
echo $RESULT
}
if [[ $# != 1 ]]; then
echo "Usage:"
echo "$0 <L1 key>"
exit 1
fi
L1_KEY=$1
if [ ${tflag} -eq 1 ]
then
TSC_KEY=`getColumnFromL1Key TSC_KEY`
echo ${TSC_KEY}
fi
if [ ${rflag} -eq 1 ]
then
GT_RS_FINAL_OR_ALGO_KEY=`getColumnFromL1Key GT_RS_FINAL_OR_ALGO_KEY`
GT_RS_FINAL_OR_TECH_KEY=`getColumnFromL1Key GT_RS_FINAL_OR_TECH_KEY`
GT_RS_VETO_TECH_KEY=`getColumnFromL1Key GT_RS_VETO_TECH_KEY`
GT_RS_KEY=`getColumnFromL1Key GT_RS_KEY`
GMT_RS_KEY=`getColumnFromL1Key GMT_RS_KEY`
GCT_RS_KEY=`getColumnFromL1Key GCT_RS_KEY`
RCT_RS_KEY=`getColumnFromL1Key RCT_RS_KEY`
DTTF_RS_KEY=`getColumnFromL1Key DTTF_RS_KEY`
echo "L1GtTriggerMaskAlgoTrigRcdKey=$GT_RS_FINAL_OR_ALGO_KEY L1GtTriggerMaskTechTrigRcdKey=$GT_RS_FINAL_OR_TECH_KEY L1GtTriggerMaskVetoTechTrigRcdKey=$GT_RS_VETO_TECH_KEY L1GtPrescaleFactorsAlgoTrigRcdKey=$GT_RS_KEY L1GtPrescaleFactorsTechTrigRcdKey=$GT_RS_KEY L1MuGMTChannelMaskRcdKey=$GMT_RS_KEY L1GctChannelMaskRcdKey=$GCT_RS_KEY L1RCTChannelMaskRcdKey=$RCT_RS_KEY L1MuDTTFMasksRcdKey=$DTTF_RS_KEY"
fi
if [ ${gflag} -eq 1 ]
then
GT_RS_FINAL_OR_ALGO_KEY=`getColumnFromL1Key GT_RS_FINAL_OR_ALGO_KEY`
GT_RS_FINAL_OR_TECH_KEY=`getColumnFromL1Key GT_RS_FINAL_OR_TECH_KEY`
GT_RS_VETO_TECH_KEY=`getColumnFromL1Key GT_RS_VETO_TECH_KEY`
GT_RS_KEY=`getColumnFromL1Key GT_RS_KEY`
echo "L1GtTriggerMaskAlgoTrigRcdKey=$GT_RS_FINAL_OR_ALGO_KEY L1GtTriggerMaskTechTrigRcdKey=$GT_RS_FINAL_OR_TECH_KEY L1GtTriggerMaskVetoTechTrigRcdKey=$GT_RS_VETO_TECH_KEY L1GtPrescaleFactorsAlgoTrigRcdKey=$GT_RS_KEY L1GtPrescaleFactorsTechTrigRcdKey=$GT_RS_KEY"
fi
exit 0
EOF
|