Changeset 19495 for trunk/DataCheck

Timestamp:

04/11/19 15:34:52 (6 years ago)

Author:

Daniela Dorner

Message:

added values for new periods

File:

• trunk/DataCheck/Tools/fill_r750.sh (modified) (4 diffs)

trunk/DataCheck/Tools/fill_r750.sh

@@ -5 +5 @@
 dbname=factdata
 # fill only corrected R750
-short="yes" # comment line to fill also reference values
+#short="yes" # comment line to fill also reference values
 
 # setup for zd- and th-correction: 
@@ -121 +121 @@
        254.6 #87
        251.5 #88
-       249.0 #89
+       249.4 #89
+       251.9 #90
+       249.4 #91
+       240.0 #92 (current period)
        )
 
@@ -129 +132 @@
 for (( i=0; i < ${#rates[@]} ; i++)) 
 do
+   echo "Filling P"$i
    if [ "${rates[$i]}" = "0.0" ]
    then 
@@ -136 +140 @@
    fi
    query="UPDATE RunInfo SET fR750Ref="$rate" WHERE fPeriod="$i
-   #echo $query
-   mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query" 
+   echo "  "$query
+   mysql --defaults-file=$sqlpw -s -e "$query" 
 done
 
+echo "Filling split periods..."
 # several periods are split: 
 #   update the values for those
 # 71b
 query="UPDATE RunInfo SET fR750Ref=250.0 WHERE fPeriod=71 AND fNight>20170726"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query" 
 # 69b
 query="UPDATE RunInfo SET fR750Ref=253.0 WHERE fPeriod=69 AND fNight>20170524"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query" 
 # 60a
 query="UPDATE RunInfo SET fR750Ref=239.3 WHERE fPeriod=60 AND fNight<20170901"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query" 
 # 46a
 query="UPDATE RunInfo SET fR750Ref=271 WHERE fPeriod=46 AND fNight<20150716"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query" 
 # 24b
 query="UPDATE RunInfo SET fR750Ref=286.2 WHERE fPeriod=24 AND fNight>20131003"
+   echo "  "$query
 mysql --defaults-file=$sqlpw -s -e "$query"