Changeset 19031 for trunk/DataCheck/Tools/get_data.sh

Timestamp:

06/27/18 03:20:49 (6 years ago)

Author:

Daniela Dorner

Message:

fixed bug

File:

• trunk/DataCheck/Tools/get_data.sh (modified) (3 diffs)

trunk/DataCheck/Tools/get_data.sh

@@ -24 +24 @@
    # time range and source
    where=" WHERE fSourceKey="$source" AND fNight BETWEEN "$nightmin" AND "$nightmax
+   where=$where" AND NOT ISNULL(fNumExcEvts) "
    # some sanity checks
    where=$where" AND fRunTypeKey=1 "
@@ -158 +159 @@
       fi
       queryext=$queryext" "$time" as time, "$start" as start, "$stop" as stop, "
-      queryext=$queryext" round("$correxcrate", 1) as correxcrate, round($flux, "$fluxprec") as flux, "
+      queryext=$queryext" round("$correxcrate", 1) as correxcrate, round("$flux", "$fluxprec") as flux, "
       queryext=$queryext" "$deltat" as deltat, round("$ontime", 1) as ontime, "
-      queryext=$queryext" round("$correxcrateerr", 1) as correxcrateerr, round($fluxerr, "$fluxprec") as fluxerr, "
+      queryext=$queryext" round("$correxcrateerr", 1) as correxcrateerr, round("$fluxerr", "$fluxprec") as fluxerr, "
       queryext=$queryext" round("$significance", 1) as significance "
       
@@ -244 +245 @@
 # db
 sqlpw=/home/$USER/.mysql.pw # file with mysql credentials
-host=lp-fact
-#host=10.0.100.21
+#host=lp-fact
+host=10.0.100.21
 #host=localhost
 dbname=factdata # name of database