Changeset 7459 for trunk/MagicSoft/Mars/datacenter/macros/fillsinope.C

Timestamp:

01/10/06 13:44:29 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/macros/fillsinope.C (modified) (7 diffs)

trunk/MagicSoft/Mars/datacenter/macros/fillsinope.C

@@ -30 +30 @@
 //
 // This macro is used to read the sinope output files sinope*.txt
+// For each run sinope is run twice: once for the data events and once for the
+// calibration events. The pulse position and height is checked. The output is
+// stored in a sinope*.root and a sinope*.txt file. The files for data events
+// are marked with -dat and the ones for calibration events with -cal.
+// From the txt files the result is extracted and inserted into the database
+// in the table DataCheck, which stores the datacheck results.
+// As the column names in the database differ only by the addition 'Interlaced'
+// which is given to columns corresponding to the calibration events, the
+// files can be processed with the same function.
 //
 // Usage:
@@ -87 +96 @@
     TEnv env(fname);
 
+    //build query
     TString query="UPDATE DataCheck SET ";
 
+    //array with part of column names
     TString values[9] = { "Events" , "HasSignal" , "HasPedestal" , "PositionSignal" , "PositionFWHM" , "PositionAsym" , "HeightSignal" , "HeightFWHM" , "HeightAsym" };
 
+    //get values from the file add them to query
     TString str;
     for (Int_t i=0 ; i<9 ; i++)
@@ -118 +130 @@
 
     cout << "Q: " << query << endl;
+    //insert information into db
     TSQLResult *res = serv.Query(query);
     if (!res)
@@ -146 +159 @@
     cout << endl;
 
+    //get date of run from database
     TString query(Form("SELECT DATE_FORMAT(ADDDATE(fRunStart, Interval 13 HOUR), '%%Y/%%m/%%d') FROM RunData WHERE fRunNumber=%d",
                        runno));
@@ -162 +176 @@
     delete res;
 
+    //insert entry for the run into the database in the table DataCheck, if it is not yet existing
     if (!ExistStr(serv, "fRunNumber", "DataCheck", Form("%d", runno)))
     {
         query=Form("INSERT DataCheck SET fRunNumber=%d", runno);
 
-        cout << "U:" << query << endl;
         res = serv.Query(query);
         if (!res)
@@ -175 +189 @@
     }
 
+    //get filenames of sinope output files
     TString fname(Form("%s/sinope/%s/sinope-dat%08d.txt",
                        datapath.Data(), date.Data(), runno));
@@ -183 +198 @@
 
     Int_t rc=0;
+    //process dat-file
     rc=Process(serv, fname, runno, kFALSE, dummy);
     if (rc==0)
         return rc;
 
+    //process cal-file
     rc=Process(serv, fnamecal, runno, kTRUE, dummy);
     return rc;