Changeset 18661 for trunk/DataCheck

Timestamp:

11/02/16 03:27:27 (8 years ago)

Author:

Daniela Dorner

Message:

fixed issue with times stamps that occured since update of gate and mysql version

File:

• trunk/DataCheck/Processing/CheckRawData.sh (modified) (3 diffs)

trunk/DataCheck/Processing/CheckRawData.sh

@@ -244 +244 @@
                # for very old data, but gives problems for newer data
                #runstart=`$factpath/fitsdump -h $file  2>/dev/null | grep DATE | grep -v 'DATE-' | grep -E -o '20[1-9][0-9][\-][01][0-9][\-][0-3][0-9]T[0-2][0-9]:[0-6][0-9]:[0-6][0-9][.][0-9]{6}'`
-               runstart="0000-00-00 00:00:00"
+               #runstart="0000-00-00 00:00:00"
+               runstart=
             else
                runstart=$runstart2
@@ -260 +261 @@
                # for very old data, but gives problems for newer data
                #runstop=`stat $file  2>/dev/null | grep Modify | grep -E -o '20[1-9][0-9][\-][01][0-9][\-][0-3][0-9][ ][0-2][0-9]:[0-6][0-9]:[0-6][0-9][.][0-9]{9}'`
-               runstop="0000-00-00 00:00:00"
+               #runstop="0000-00-00 00:00:00"
+               runstop=
             else
                runstop=$runstop2
@@ -320 +322 @@
       if [ "$filenotclosed" == "no" ]
       then 
-         query=$query", fRunStart='"$runstart"', fRunStop='"$runstop"'"
+         if [ "$runstart" == "" ]
+         then 
+            query=$query", fRunStart=NULL"
+         else
+            query=$query", fRunStart='"$runstart"'"
+         fi
+         if [ "$runstop" == "" ]
+         then 
+            query=$query", fRunStop=NULL"
+         else
+            query=$query", fRunStop='"$runstop"'"
+         fi
          if [ "$numevents" != "" ]
          then