Changeset 19495 for trunk/DataCheck/Tools
- Timestamp:
- 04/11/19 15:34:52 (6 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/DataCheck/Tools/fill_r750.sh
r19424 r19495 5 5 dbname=factdata 6 6 # fill only corrected R750 7 short="yes" # comment line to fill also reference values7 #short="yes" # comment line to fill also reference values 8 8 9 9 # setup for zd- and th-correction: … … 121 121 254.6 #87 122 122 251.5 #88 123 249.0 #89 123 249.4 #89 124 251.9 #90 125 249.4 #91 126 240.0 #92 (current period) 124 127 ) 125 128 … … 129 132 for (( i=0; i < ${#rates[@]} ; i++)) 130 133 do 134 echo "Filling P"$i 131 135 if [ "${rates[$i]}" = "0.0" ] 132 136 then … … 136 140 fi 137 141 query="UPDATE RunInfo SET fR750Ref="$rate" WHERE fPeriod="$i 138 #echo$query139 mysql --defaults-file=$sqlpw - u operator -h 10.0.100.21 $dbname -s -e "$query"142 echo " "$query 143 mysql --defaults-file=$sqlpw -s -e "$query" 140 144 done 141 145 146 echo "Filling split periods..." 142 147 # several periods are split: 143 148 # update the values for those 144 149 # 71b 145 150 query="UPDATE RunInfo SET fR750Ref=250.0 WHERE fPeriod=71 AND fNight>20170726" 151 echo " "$query 146 152 mysql --defaults-file=$sqlpw -s -e "$query" 147 153 # 69b 148 154 query="UPDATE RunInfo SET fR750Ref=253.0 WHERE fPeriod=69 AND fNight>20170524" 155 echo " "$query 149 156 mysql --defaults-file=$sqlpw -s -e "$query" 150 157 # 60a 151 158 query="UPDATE RunInfo SET fR750Ref=239.3 WHERE fPeriod=60 AND fNight<20170901" 159 echo " "$query 152 160 mysql --defaults-file=$sqlpw -s -e "$query" 153 161 # 46a 154 162 query="UPDATE RunInfo SET fR750Ref=271 WHERE fPeriod=46 AND fNight<20150716" 163 echo " "$query 155 164 mysql --defaults-file=$sqlpw -s -e "$query" 156 165 # 24b 157 166 query="UPDATE RunInfo SET fR750Ref=286.2 WHERE fPeriod=24 AND fNight>20131003" 167 echo " "$query 158 168 mysql --defaults-file=$sqlpw -s -e "$query" 159 169
Note:
See TracChangeset
for help on using the changeset viewer.