Changeset 15298 for trunk/DataCheck/Processing

Timestamp:

04/12/13 11:06:53 (12 years ago)

Author:

Daniela Dorner

Message:

added filling of source key

File:

• trunk/DataCheck/Processing/FillAuxData.sh (modified) (4 diffs)

trunk/DataCheck/Processing/FillAuxData.sh

@@ -90 +90 @@
 #        `date +%Y/%m/%d --date="-156hour"` `date +%Y/%m/%d --date="-180hour"` `date +%Y/%m/%d --date="-204hour"` \
         )
-dates=( "2012/03/25" "2012/03/26" "2012/03/27" "2012/03/28" "2012/03/29" "2012/03/30" "2012/04/10" "2012/04/09" "2012/04/08" "2012/04/06" "2012/04/05" "2012/04/03"  )
 #dates=( `find $ziprawdata -mindepth 3 -type d | sort | sed "s/\${ziprawdata_for_sed}//g" | sed -e 's/^\///'` ) #all available dates in /loc_data/zipraw
 printprocesslog "INFO processing the following night(s): "${dates[@]}
@@ -131 +130 @@
       then 
          printprocesslog "WARN for $trackingfile fverify returned "$tracknumerrors" error(s)."
+      fi
+   fi
+   
+   sourceposfile=$auxdir/$runnumber.DRIVE_CONTROL_SOURCE_POSITION.fits
+   if ! [ -e $sourceposfile ]
+   then 
+      printprocesslog "WARN "$sourceposfile" not found."
+   else
+      sourceposnumerrors=`fverify $sourceposfile 2>/dev/null | grep -o '[0-9][ ]error(s)'  | grep -E -o '[0-9]'`
+      if [ $sourceposnumerrors -gt 0 ]
+      then 
+         printprocesslog "WARN for $sourceposfile fverify returned "$sourceposnumerrors" error(s)."
       fi
    fi
@@ -228 +239 @@
       #fi
 
+      # get information from source_pos file
+      if [ -e $sourceposfile ] && [ $sourceposnumerrors -eq 0 ]
+      then 
+         #sourcename=`${factpath}/fitsdump ${sourceposfile} -c Time -c Name --filter='[1]<'${tstop}  2>/dev/null | tail -1 2>&1 | grep -o -E "['][a-zA-Z0-9\ ]+[']" | sed -e "s/'//g"`
+         sourcename=`/home/fact/FACT++.dbg/fitsdump ${sourceposfile} -c Time -c Name --filter='[1]<'${tstop}  2>/dev/null | tail -1 2>&1 | grep -o -E "['][a-zA-Z0-9\ ]+[']" | sed -e "s/'//g"`
+         #echo "/home/fact/FACT++.dbg/fitsdump ${sourceposfile} -c Time -c Name --filter='[1]<'${tstop}  2>/dev/null | tail -1 2>&1 "
+         #echo $sourcename
+         if [ "$sourcename" == "" ]
+         then
+            printprocesslog "INFO couldn't get sourcename ("$sourcename") from "$sourceposfile" for "$runnumber"_"$filenum
+         else 
+            query="SELECT fSourceKey FROM Source WHERE fSourceName='"$sourcename"'"
+            sourcekey=`sendquery`
+            if [ "$sourcename" == "" ]
+            then
+               printprocesslog "WARN couldn't get sourcekey for source "$sourcename" from DB for "$runnumber"_"$filenum
+            fi 
+            #echo $sourcekey
+         fi
+      fi
+      
       # build query to update runinfo in DB
       query="UPDATE RunInfo SET "
+      # fill source key only if available
+      if ! [ "$sourcekey" = "" ]
+      then
+         query=$query" fSourceKey="$sourcekey", "
+      fi
       
       # get information from tracking
@@ -364 +401 @@
       # add where condition
       query=$query" WHERE fNight="$runnumber" AND fRunID="$filenum
+      #echo $query
 
       # send query to DB