Changeset 14848 for trunk/DataCheck

Timestamp:

02/04/13 06:10:54 (12 years ago)

Author:

Daniela Dorner

Message:

fill moon info only if available

File:

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

trunk/DataCheck/Processing/FillMoonInfo.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)
 
 source `dirname $0`/../Sourcefile.sh
@@ -13 +13 @@
 # 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"` \
+        `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 $auxdata -mindepth 3 -type d | sort -r | sed "s/\${auxdata_for_sed}//g" | sed -e 's/^\///'` )
@@ -33 +33 @@
    # get file numbers from DB
    #   but only for not-corrupted files
-   query="SELECT fRunID from RunInfo WHERE fNight="$runnumber" AND NOT ISNULL(fRightAscension) AND NOT ISNULL(fDeclination) "
+   #query="SELECT fRunID from RunInfo WHERE fNight="$runnumber" AND NOT ISNULL(fRightAscension) AND NOT ISNULL(fDeclination) "
+   query="SELECT fRunID from RunInfo WHERE fNight="$runnumber" AND NOT ISNULL(fRunStart) "
    #query=$query" AND fRunTypeKEY=6 "
    if [ "$doupdate" = "no" ]
@@ -54 +55 @@
       
       # get input info from DB 
-      query="SELECT fRightAscension, fDeclination, fRunStart from RunInfo "
+      query="SELECT if (isnull(fRightAscension), 999, fRightAscension), "
+      query=$query" if (isnull(fDeclination), 999, fDeclination), "
+      query=$query" fRunStart from RunInfo "
       query=$query" WHERE fNight="$runnumber" AND fRunID="$filenum
       info=( `sendquery` )
       echo ${info[@]}
       #echo "/home/fact/FACT++.db/moon "${info[2]} ${info[3]}" --ra=${info[0]} --dec=${info[1]} 2>/dev/null"
-      lightinfo=( `/home/fact/FACT++.db/moon "${info[2]} ${info[3]}" --ra=${info[0]} --dec=${info[1]} 2>/dev/null` )
+      if [ "${info[0]}" == "999" ] && [ "${info[1]}" == "999" ]
+      then 
+         lightinfo=( `/home/fact/FACT++.upgrade/moon "${info[2]} ${info[3]}" 2>/dev/null` )
+      else
+         lightinfo=( `/home/fact/FACT++.upgrade/moon "${info[2]} ${info[3]}" --ra=${info[0]} --dec=${info[1]} 2>/dev/null` )
+      fi
+      # return values of the programm
+      # timestamp sunzd moon-visible moondisk moonzd angletomoon angletosun
       echo ${lightinfo[@]}
       
       # build query to update runinfo in DB
-      query="UPDATE RunInfo SET fSunZenithDistance="${lightinfo[2]}", fMoonDisk="${lightinfo[4]}", fMoonZenithDistance="${lightinfo[5]}", fAngleToMoon="${lightinfo[6]}
+      query="UPDATE RunInfo SET fSunZenithDistance="${lightinfo[2]}", fMoonDisk="${lightinfo[4]}
+      query=$query", fMoonZenithDistance="${lightinfo[5]}
+      echo $query
+      if [ "${info[0]}" != "999" ] && [ "${info[1]}" != "999" ]
+      then 
+         query=$query", fAngleToMoon="${lightinfo[6]}
+         query=$query", fAngleToSun="${lightinfo[7]}
+      fi
       # add where condition
       query=$query" WHERE fNight="$runnumber" AND fRunID="$filenum
       echo $query
-      
       # send query to DB
       sendquery >/dev/null