Changeset 19030 for trunk/DataCheck/Tools

Timestamp:

06/27/18 00:42:38 (6 years ago)

Author:

Daniela Dorner

Message:

added host

File:

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

trunk/DataCheck/Tools/get_data.sh

@@ -220 +220 @@
    fi
    #echo "$queryint"
-   mysql --defaults-file=$sqlpw -u root  $dbname -s -e "$queryint" >> $fileint
-   #mysql --defaults-file=$sqlpw -u root  $dbname -e "$queryint" 
+   mysql --defaults-file=$sqlpw -u factread --host=$host $dbname -s -e "$queryint" >> $fileint
+   #mysql --defaults-file=$sqlpw -u factread --host=$host $dbname -e "$queryint" 
    
    
@@ -237 +237 @@
    fi
    #echo "$queryext"
-   mysql --defaults-file=$sqlpw -u root  $dbname -s -e "$queryext" >> $fileext
-   #mysql --defaults-file=$sqlpw -u root  $dbname -e "$queryext"
+   mysql --defaults-file=$sqlpw -u factread --host=$host $dbname -s -e "$queryext" >> $fileext
+   #mysql --defaults-file=$sqlpw -u factread --host=$host $dbname -e "$queryext"
 }
 
@@ -244 +244 @@
 # db
 sqlpw=/home/$USER/.mysql.pw # file with mysql credentials
+host=lp-fact
+#host=10.0.100.21
+#host=localhost
 dbname=factdata # name of database
 # defaults for zd and threshold
@@ -270 +273 @@
 # choose analysis 
 #table="AnalysisResultsAllQLA" # N/A
-#table="AnalysisResultsRunLP" # QLA 
-table="AnalysisResultsRunISDC"  # ISDC
+table="AnalysisResultsRunLP" # QLA 
+#table="AnalysisResultsRunISDC"  # ISDC
 # time range
 nightmin=20111115
@@ -282 +285 @@
 # example (adapt to your needs)
 
-# crab
-source=5
-name="Crab_nightly"
-bin=-1
-get_results
-name="Crab_20min"
-bin=20
-get_results
-name="Crab_period"
-bin=0
-get_results
-name="Crab_season"
-bin=-365
-nightmin=20110716
-nightmax=20180716
+# 501 MAGIC 
+source=2
+name="Mrk501_2014JulAug"
+bin=-1
+nightmin=20140714
+nightmax=20140805
 get_results