Changeset 19424 for trunk/DataCheck/Tools

Timestamp:

01/08/19 14:28:21 (6 years ago)

Author:

Daniela Dorner

Message:

added comments and functionality to fill only corrected R750 and not reference values

File:

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

trunk/DataCheck/Tools/fill_r750.sh

@@ -1 +1 @@
 #!/bin/bash
 
+# setup
 sqlpw=/home/$USER/.mysql.pw.op
 dbname=factdata
+# fill only corrected R750
+short="yes" # comment line to fill also reference values
+
+# setup for zd- and th-correction: 
+zd="cos(fZenithDistanceMean/180*Pi())"
+min="TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn/60"
+cor="pow("$zd", 1.94)*exp((1-1/"$zd")*0.331)*exp(2.39*(1-"$zd"))"
+
+# fill corrected R750
+echo ""
+echo "Filling the corrected R750 to the DB..."
+query="UPDATE RunInfo SET "
+query=$query" fR750Cor=round(fNumThreshold750/("$min")/("$cor"),2) "
+query=$query" WHERE fRunTypeKey=1 AND NOT (("$min")/("$cor"))=0"
+echo $query
+mysql --defaults-file=$sqlpw -s -e "$query" 
+
+# todo: replace this by trigger in DB (finalize correction formula for this)
+
+if [ "$short" == "yes" ]
+then
+   echo ""
+   echo "Exit (short=yes)" 
+   exit
+fi
+
 
 # reference values for corrected R750
@@ -97 +124 @@
        )
 
+# fill reference values
+echo ""
+echo "Filling the reference values for the corrected R750 for "${#rates[@]}" periods to the DB..."
 for (( i=0; i < ${#rates[@]} ; i++)) 
 do
@@ -106 +136 @@
    fi
    query="UPDATE RunInfo SET fR750Ref="$rate" WHERE fPeriod="$i
-   echo $query
+   #echo $query
    mysql --defaults-file=$sqlpw -u operator -h 10.0.100.21 $dbname -s -e "$query" 
 done
 
 # several periods are split: 
+#   update the values for those
 # 71b
 query="UPDATE RunInfo SET fR750Ref=250.0 WHERE fPeriod=71 AND fNight>20170726"
@@ -127 +158 @@
 mysql --defaults-file=$sqlpw -s -e "$query" 
 
-zd="cos(fZenithDistanceMean/180*Pi())"
-min="TIME_TO_SEC(TIMEDIFF(fRunStop,fRunStart))*fEffectiveOn/60"
-cor="pow("$zd", 1.94)*exp((1-1/"$zd")*0.331)*exp(2.39*(1-"$zd"))"
 
-# fill corrected R750
-query="UPDATE RunInfo SET "
-query=$query" fR750Cor=round(fNumThreshold750/("$min")/("$cor"),2) "
-query=$query" WHERE fRunTypeKey=1 AND NOT (("$min")/("$cor"))=0"
-echo $query
-mysql --defaults-file=$sqlpw -s -e "$query" 
+echo ""
+echo "Done"