Changeset 15322

Timestamp:

04/13/13 17:13:11 (12 years ago)

Author:

Daniela Dorner

Message:

fixed bug and improved logging

File:

• trunk/DataCheck/DataCheck/InfoForMWL.sh (modified) (2 diffs)

trunk/DataCheck/DataCheck/InfoForMWL.sh

@@ -10 +10 @@
 printprocesslog "INFO starting $0 $1"
 
+# getting db info for query
 getdbsetup
 
 function get_table()
 {
-   echo "writing "$file" ..."
+   printprocesslog "INFO writing "$file
    query="SELECT Datediff(Max(fRunStop), '1858-11-17') as MJD, "
    query=$query" Date_format(Max(fRunStop), '%Y/%m/%d') as DATE, "
@@ -28 +29 @@
    query=$query" WHERE fSourceKEY="$sourcekey
    query=$query" AND fRunTypeKEY=1 "
+   query=$query" AND fNight BETWEEN "$start" AND "$stop
    query=$query" GROUP BY fNight "
    query=$query" ORDER BY fNight "
    #echo $query
-   echo ""
+   #echo ""
    printprocesslog "DEBUG sendquery QUERY: "$query
+   # sendquery can't be used as it writes everything into a variable
    mysql -s -u $us --password=$pw --host=$ho $db -e " $query " > $file
 }