Changes between Version 13 and Version 14 of DatabaseBasedAnalysis

Timestamp:

08/03/18 20:38:25 (6 years ago)

Author:

tbretz

Comment:

--

DatabaseBasedAnalysis

@@ -170 +170 @@
 }}}
 
+== Data statistics ==
+
+Now we want to get some statistics about the Crab data between 01/11/2013 and 06/11/2013 and see if we can do simple plots. For this we write the table into a root file.
+
+{{{rootifysql [...] --query " \
+   SELECT               \
+      *                 \
+   FROM                 \
+      RunInfo           \
+   WHERE                \
+      fSourceKey=5      \
+   AND                  \
+      fRunTypeKey=1     \
+   AND                  \
+      FileId BETWEEN 131101000 AND 131107000 \
+   AND                  \
+      fR750Ref/fR750Cor>0.9 \
+   AND                  \
+      fZenithDistanceMax<35 \
+"
+}}}}
+ 
+If the file already exists, either give it a different name (see --help for details) or overwrite it with --force.
+
+The output should look similar to this
+{{{
+Reading global  options from 'fact++.rc'.
+Reading default options from 'rootifysql.rc'.
+
+------------------------ Rootify SQL -------------------------
+Connecting to database...
+Client Version: 5.7.23
+Server Version: 5.7.23-0ubuntu0.18.04.1
+Requesting data...
+Opening file 'rootify.root' [compression=1]...
+Trying to setup 120 branches...
+Configured 115 branches.
+Filling branches...
+317 rows fetched.
+317 rows skipped due to NULL field.
+0 rows filled into tree.
+10 kB written to disk.
+File closed.
+Execution time: 0.0537751s (169.6 us/row)
+--------------------------------------------------------------
+}}}
+
+Per default rows which contain any NULL are not written to the file because all values are converted to a DOUBLE and there is no representation for a NULL-value in double. So, we need to force the output with {{{--ignore-null}}} and will get something like:
+{{{
+Reading global  options from 'fact++.rc'.
+Reading default options from 'rootifysql.rc'.
+
+------------------------ Rootify SQL -------------------------
+Connecting to database...
+Client Version: 5.7.23
+Server Version: 5.7.23-0ubuntu0.18.04.1
+Requesting data...
+Opening file 'rootify.root' [compression=1]...
+Trying to setup 120 branches...
+Configured 115 branches.
+Filling branches...
+317 rows fetched.
+317 rows filled into tree.
+86 kB written to disk.
+File closed.
+Execution time: 0.072247s (227.9 us/row)
+--------------------------------------------------------------
+}}}
+
+Now we can open the file in root and do plots. The easiest ist to use the tree viewer:
+{{{
+root rootify.root
+root [0] 
+Attaching file rootify.root as _file0...
+root [1] TTree *T = (TTree*)_file0->Get("Result");
+root [2] T->StartViewer();
+root [3]
+}}}
+
+Or plot the zenith angle distribution directly:
+{{{
+root rootify.root
+root [0] 
+Attaching file rootify.root as _file0...
+root [1] TTree *T = (TTree*)_file0->Get("Result");
+root [2] T->Draw("fZenithDistanceMean");
+root [3]
+}}}
+
+or zenith angle versus time (Hint: DATETIME columns are converted to Unix-time in seconds):
+
+{{{
+root rootify.root
+root [0] 
+Attaching file rootify.root as _file0...
+root [1] TTree *T = (TTree*)_file0->Get("Result");
+root [2] T->Draw("fZenithDistanceMean:fRunStart");
+root [3]
+}}}
+
+
+
+
+
+
+