Changeset 15604 for trunk/DataCheck/Processing

Timestamp:

05/13/13 16:00:23 (12 years ago)

Author:

mknoetig

Message:

add fTriggerRateTimeOverx and TriggerRateRms to FillEffectiveOn.sh

File:

• trunk/DataCheck/Processing/FillEffectiveOn.sh (modified) (5 diffs)

trunk/DataCheck/Processing/FillEffectiveOn.sh

@@ -3 +3 @@
 # option 
 doupdate="yes" # update all entries (needed when new fields have been added)
-doupdate="no" # fill only entries which are not yet existing (default)
+#doupdate="no" # fill only entries which are not yet existing (default)
 
 
@@ -27 +27 @@
 # get last 3, 6 or 9 nights
 dates=( `date +%Y/%m/%d --date="-12hour"` `date +%Y/%m/%d --date="-36hour"` `date +%Y/%m/%d --date="-60hour"` \
-#        `date +%Y/%m/%d --date="-84hour"` `date +%Y/%m/%d --date="-108hour"` `date +%Y/%m/%d --date="-132hour"` \
+        `date +%Y/%m/%d --date="-84hour"` `date +%Y/%m/%d --date="-108hour"` `date +%Y/%m/%d --date="-132hour"` \
 #        `date +%Y/%m/%d --date="-156hour"` `date +%Y/%m/%d --date="-180hour"` `date +%Y/%m/%d --date="-204hour"` \
         )
@@ -161 +161 @@
          if [ "${effectiveon[3]}" == "" ]
          then
+            query=$query", fTriggerRateTimeOver100=NULL"
+         else
+            query=$query", fTriggerRateTimeOver100="${effectiveon[3]}
+         fi
+         if [ "${effectiveon[4]}" == "" ]
+         then
             query=$query", fTriggerRateTimeOver125=NULL"
          else
-            query=$query", fTriggerRateTimeOver125="${effectiveon[3]}
+            query=$query", fTriggerRateTimeOver125="${effectiveon[4]}
+         fi
+         if [ "${effectiveon[5]}" == "" ]
+         then
+            query=$query", fTriggerRateTimeOver150=NULL"
+         else
+            query=$query", fTriggerRateTimeOver150="${effectiveon[5]}
+         fi
+         if [ "${effectiveon[6]}" == "" ]
+         then
+            query=$query", fTriggerRateTimeOver175=NULL"
+         else
+            query=$query", fTriggerRateTimeOver175="${effectiveon[6]}
+         fi
+         if [ "${effectiveon[7]}" == "" ]
+         then
+            query=$query", fTriggerRateRms=NULL"
+         else
+            query=$query", fTriggerRateRms="${effectiveon[7]}
          fi
       else
@@ -169 +193 @@
          query=$query", fEffectiveOnRms=NULL"
          query=$query", fOnTime=NULL"
+         query=$query", fTriggerRateTimeOver100=NULL"
          query=$query", fTriggerRateTimeOver125=NULL"
+         query=$query", fTriggerRateTimeOver150=NULL"
+         query=$query", fTriggerRateTimeOver175=NULL"
+         query=$query", fTriggerRateRms=NULL"
+
       fi
       
@@ -175 +204 @@
       query=$query" WHERE fNight="$runnumber" AND fRunID="$filenum
 
-      #echo $query
+      echo $query
       #echo "EffectiveOn:${effectiveon[0]} # RMSEffectiveOn:${effectiveon[1]} # SumOnTime:${effectiveon[2]} # TriggerTimeOver125:${effectiveon[3]}"
       #send query to DB