Changeset 18472 for trunk/DataCheck

Timestamp:

04/22/16 21:19:43 (9 years ago)

Author:

Daniela Dorner

Message:

implemented filling of fact period

File:

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

trunk/DataCheck/Processing/FillMoonInfo.sh

@@ -38 +38 @@
    fi
    printprocesslog "INFO processing date "$date
+   echo "INFO processing date "$date
 
    # get file numbers from DB
@@ -77 +78 @@
       
       # build query to update runinfo in DB
-      query="UPDATE RunInfo SET fSunZenithDistance="${lightinfo[2]}", fMoonDisk="${lightinfo[4]}
-      query=$query", fMoonZenithDistance="${lightinfo[5]}
+      query="UPDATE RunInfo SET fSunZenithDistance="${lightinfo[2]}", fPeriod="${lightinfo[3]}", fMoonDisk="${lightinfo[5]}
+      query=$query", fMoonZenithDistance="${lightinfo[6]}
       if [ "${info[0]}" != "999" ] && [ "${info[1]}" != "999" ]
       then 
-         query=$query", fAngleToMoon="${lightinfo[6]}
-         query=$query", fAngleToSun="${lightinfo[7]}
+         query=$query", fAngleToMoon="${lightinfo[7]}
+         query=$query", fAngleToSun="${lightinfo[8]}
       fi
       # add where condition