Changeset 19567 for trunk/DataCheck

Timestamp:

07/24/19 00:06:33 (5 years ago)

Author:

Daniela Dorner

Message:

added values for new periods up to 95, fixed option doupdate

File:

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

trunk/DataCheck/Tools/fill_r750.sh

@@ -4 +4 @@
 sqlpw=/home/$USER/.mysql.pw.op
 dbname=factdata
+#doupdate=92
 
 query="SELECT Max(fPeriod) FROM RunInfo WHERE NOT ISNULL(fR750Cor)"
@@ -12 +13 @@
 pmaxref=`mysql --defaults-file=$sqlpw -s -e "$query" `
 echo "fR750Ref is already filled up to P"$pmaxref
+
+if [ "$doupdate" == "" ]
+then 
+   numstart=$pmaxref
+else
+   numstart=$doupdate
+fi
 
 
@@ -26 +34 @@
 query=$query" fR750Cor=round(fNumThreshold750/("$min")/("$cor"),2) "
 query=$query" WHERE fRunTypeKey=1 AND NOT (("$min")/("$cor"))=0 "
-query=$query" AND fPeriod>="$pmaxcor
+query=$query" AND fPeriod>="$numstart
 echo $query
 mysql --defaults-file=$sqlpw -s -e "$query" 
@@ -123 +131 @@
        251.9 #90
        249.4 #91
-       240.0 #92 (current period)
+       241.8 #92 
+       244.3 #93
+       240.9 #94
+       240.1 #95
        )
 if [ ${#rates[@]} -lt $pmaxref ]
 then 
    ${#rates[@]}" "$pmaxref 
+   "No new reference values available ("$pmaxref")"
    exit
 fi 
-
-if [ "$doupdate" == "yes" ]
-then 
-   numstart=0
-else
-   numstart=$pmaxref
-fi
 
 # fill reference values
 echo ""
 echo "Filling the reference values for the corrected R750 for "${#rates[@]}" periods to the DB..."
+echo "  Starting from period "$numstart 
 for (( i=$numstart; i < ${#rates[@]} ; i++)) 
 do