Changeset 19521 for trunk/DataCheck

Timestamp:

05/28/19 11:39:09 (5 years ago)

Author:

Daniela Dorner

Message:

added new alert type for incoming alerts

File:

• trunk/DataCheck/QuickLook/FlareAlerts.sh (modified) (3 diffs)

trunk/DataCheck/QuickLook/FlareAlerts.sh

@@ -70 +70 @@
 #cu="20.0"
 #cu="CUQLA(fNight)"
-cu="Avg(fCU)"
+cu="fCU"
 corr="1"
 # missing: corrected excessrates
@@ -92 +92 @@
    query=$query"ROUND(ExcErr(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM("$ontime")*3600*SUM(fNumExcEvts)/SUM(fNumExcEvts*"$corr"), 2) AS corexcrateerr, " # correctionfactor = exc / exc_cor, put here correction factor
    query=$query"ROUND(LiMa(SUM(fNumSigEvts), SUM(fNumBgEvts)),2) AS signif, "
-   query=$query"ROUND(SUM(fNumExcEvts)/SUM("$ontime")*3600/"$cu",2) AS cu, " 
-   query=$query"ROUND(ExcErr(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM("$ontime")*3600/"$cu", 2) AS cuerr, " # make value time dependent
-   query=$query"ROUND(SUM(fNumExcEvts*"$corr")/SUM("$ontime")*3600/"$cu",2) as corcu, " # make value time dependent # put here correction factor
-   query=$query"ROUND(ExcErr(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM("$ontime")*3600*SUM(fNumExcEvts)/SUM(fNumExcEvts*"$corr")/"$cu", 2) AS corcuerr, " # correctionfactor = exc / exc_cor # make value time dependent # put here correction factor
+   query=$query"ROUND(SUM(fNumExcEvts)/SUM("$ontime")*3600/AVG("$cu"),2) AS cu, " 
+   query=$query"ROUND(ExcErr(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM("$ontime")*3600/AVG("$cu"), 2) AS cuerr, " # make value time dependent
+   query=$query"ROUND(SUM(fNumExcEvts*"$corr")/SUM("$ontime")*3600/AVG("$cu"),2) as corcu, " # make value time dependent # put here correction factor
+   query=$query"ROUND(ExcErr(SUM(fNumSigEvts), SUM(fNumBgEvts))/SUM("$ontime")*3600*SUM(fNumExcEvts)/SUM(fNumExcEvts*"$corr")/AVG("$cu"), 2) AS corcuerr, " # correctionfactor = exc / exc_cor # make value time dependent # put here correction factor
    query=$query"MIN(fZenithDistanceMin) as zdmin, MAX(fZenithDistanceMax) as zdmax, "
    query=$query"MIN("$threshold") as thmin, MAX("$threshold") as thmax "
@@ -720 +720 @@
    evaluate_result
    
+   # Automatic Follow-Ups
+   triggertype=6
+   printprocesslog "INFO check for [Automatic Follow-Ups]" 
+   query="SELECT Count(*) FROM Schedule WHERE fSTART BETWEEN DATE_ADD(DATE_FORMAT("$night", '%Y-%m-%d'), INTERVAL +18 HOUR)"
+   query=$query" AND DATE_ADD(DATE_FORMAT("$night", '%Y-%m-%d'), INTERVAL +35 HOUR) AND fUser='ToO' AND fSourceKey="$sourcekey
+   #echo $query
+   numtoo=`sendquery`
+   if [ $numtoo -gt 0 ]
+   then
+      echo "Found "$numtoo" ToO(s) for "$sourcename >> $logfile
+      case $sourcekey in 
+        1|2|7) echo "standard monitoring source ("$sourcekey")" >> $logfile
+               ;;
+        [0-9][0-9][0-9][0-9]) echo "new source ("$sourcekey")" >> $logfile
+               ;;
+        *)     echo "some other source ("$sourcekey")" >> $logfile
+               ;;
+      esac
+      triggerfile=$flarealertspath"/"$night"-"$numtoo"-source"$sourcekey".trigger"$triggertype
+      donetriggerfile=$triggerfile".done"
+      touch $triggerfile
+      echo "Found "$numtoo" ToOs." > $triggerfile
+      # write new file only if old files do not agree
+      if [ -e $donetriggerfile ]
+      then
+         diff $donetriggerfile $triggerfile >/dev/null
+         checkstatus=`echo $?`
+         if [ $checkstatus -eq 0 ]
+         then
+            echo "  alert already done "$donetriggerfile >> $logfile
+            i=`echo $i +1 | bc -l`
+            continue
+         fi
+      fi
+      if ! [ -e $donetriggerfile ] 
+      then 
+         query="INSERT FlareAlerts.FlareTriggers SET fTriggerInserted=Now(), fNight="$night", fRunID="$numtoo", fTriggerType="$triggertype", fSourceKey="$sourcekey", fBinning=NULL"
+         echo $query
+         sendquery >> $logfile
+         mv $triggerfile $donetriggerfile
+      fi
+   fi
+   
    echo "" >> $logfile
    echo "" >> $logfile