Changeset 19228 for trunk/DataCheck

Timestamp:

09/11/18 15:15:39 (6 years ago)

Author:

Daniela Dorner

Message:

added reference values for last periods

File:

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

trunk/DataCheck/Tools/fill_r750.sh

@@ -87 +87 @@
        248.3 #80
        244.0 #81
-       247.2 #82
+       247.3 #82
+       245.2 #83
+       236.0 #84
+       231.6 #85
        )
 
@@ -106 +109 @@
 # 71b
 query="UPDATE RunInfo SET fR750Ref=250.0 WHERE fPeriod=69 AND fNight>20170726"
-mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query" 
+mysql --defaults-file=$sqlpw -s -e "$query" 
 # 69b
 query="UPDATE RunInfo SET fR750Ref=253.0 WHERE fPeriod=69 AND fNight>20170524"
-mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query" 
+mysql --defaults-file=$sqlpw -s -e "$query" 
 # 60a
 query="UPDATE RunInfo SET fR750Ref=239.3 WHERE fPeriod=60 AND fNight<20170901"
-mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query" 
+mysql --defaults-file=$sqlpw -s -e "$query" 
 # 46a
 query="UPDATE RunInfo SET fR750Ref=271 WHERE fPeriod=46 AND fNight<20150716"
-mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query" 
+mysql --defaults-file=$sqlpw -s -e "$query" 
 # 24b
 query="UPDATE RunInfo SET fR750Ref=286.2 WHERE fPeriod=24 AND fNight>20131003"
-mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query" 
+mysql --defaults-file=$sqlpw -s -e "$query" 
 
 zd="cos(fZenithDistanceMean/180*Pi())"
@@ -129 +132 @@
 query=$query" WHERE fRunTypeKey=1 AND NOT (("$min")/("$cor"))=0"
 echo $query
-mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query" 
+mysql --defaults-file=$sqlpw -s -e "$query"