Changeset 17097

Timestamp:

09/06/13 16:08:40 (11 years ago)

Author:

Daniela Dorner

Message:

usage of getdates function, prepared script to be used in RunMoreNights.sh, added 4 new variables, cleanup

File:

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

trunk/DataCheck/Processing/FillEffectiveOn.sh

@@ -1 +1 @@
 #!/bin/bash
 
-# option 
-doupdate="yes" # update all entries (needed when new fields have been added)
-#doupdate="no" # fill only entries which are not yet existing (default)
-
+# option whether to fill all row or only those where information is missing
+# $doupdate might be given as environment variable
+if [ "$doupdate" = "" ]
+then
+   doupdate="yes" # update all entries (needed when new fields have been added)
+   doupdate="no" # fill only entries which are not yet existing (default)
+fi
 
 source `dirname $0`/../Sourcefile.sh
@@ -11 +14 @@
 logfile=$runlogpath"/EffectiveOn-"$datetime".log"
 date >> $logfile
-
-echo $logfile
 
 # setup to use ftools
@@ -24 +25 @@
 fi
 
-
-# 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="-156hour"` `date +%Y/%m/%d --date="-180hour"` `date +%Y/%m/%d --date="-204hour"` \
-        )
-dates=( `find -L $ziprawdata -mindepth 3 -type d | sort -r | sed "s/\${ziprawdata_for_sed}//g" | sed -e 's/^\///'` ) #all available dates in /loc_data/zipraw
-
-#dates=( "2012/11/19" )
+# get dates
+if [ "$certaindate" != "" ]
+then
+   getdates $certaindate
+else
+   # get all night
+   #getdates "all"
+   # get last 6 nights
+   getdates 6
+fi
+
 
 printprocesslog "INFO processing the following night(s): "${dates[@]}
 echo  `date`": processing the following night(s): "${dates[@]} >> $logfile 2>&1
-
-echo ${dates[@]}
 
 cd $mars
@@ -51 +52 @@
 #      continue
 #   fi
+#   echo $auxdir" @ "`date` 
 
    # check if aux files are available from that night
@@ -74 +76 @@
    fi
 
-   echo "run ontime.C for night "$runnumber
    # get file numbers from DB
    #   but only for not-corrupted files
@@ -91 +92 @@
    fi
 
-   #echo ${filenumbers[@]}
    # fill auxiliary information for files
    for filenum in ${filenumbers[@]}
@@ -204 +204 @@
       query=$query" WHERE fNight="$runnumber" AND fRunID="$filenum
 
-      echo $query
-      #echo "EffectiveOn:${effectiveon[0]} # RMSEffectiveOn:${effectiveon[1]} # SumOnTime:${effectiveon[2]} # TriggerTimeOver125:${effectiveon[3]}"
       #send query to DB
       sendquery >/dev/null