Changeset 7657

Timestamp:

04/26/06 10:53:56 (19 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

Location:

trunk/MagicSoft/Mars

Files:

• Changelog (modified) (2 diffs)
• datacenter/macros/fillstar.C (modified) (6 diffs)
• datacenter/macros/setupdb.C (modified) (1 diff)

trunk/MagicSoft/Mars/Changelog

@@ -19 +19 @@
                                                  -*-*- END OF LINE -*-*-
 
+ 2006/04/26 Daniela Dorner
+
+   * datacenter/macros/fillstar.C, datacenter/macros/setupdb.C:
+     - added four new columns to the table Star
+
+
+
  2006/04/24 Thomas Bretz
 
@@ -213 +220 @@
      - added zd angle range and observation period
 
-   * datacenter/db/sequencE.php:
+   * datacenter/db/sequence.php:
      - added rel. ontime
 

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

@@ -207 +207 @@
 
 
+    g = (TGraph*)arr.FindObjectInCanvas("NumStars", "TGraph", "MHPointing");
+    if (!g)
+    {
+        cout << "WARNING - Reading of NumStars failed." << endl;
+        return 2;
+    }
+
+    Double_t numstarmean = g->GetMean(2);
+    TString numstarsmean = Form("%5.1f", numstarmean);
+    Double_t numstarrms = g->GetRMS(2);
+    TString numstarsrms = Form("%5.1f", numstarrms);
+
+    g = (TGraph*)arr.FindObjectInCanvas("Brigtness", "TGraph", "MHPointing");
+    if (!g)
+    {
+        cout << "WARNING - Reading of SkyBrightness failed." << endl;
+        return 2;
+    }
+
+    Double_t brightnessmean = g->GetMean(2);
+    TString skybrightnessmean = Form("%5.1f", brightnessmean);
+    Double_t brightnessrms = g->GetRMS(2);
+    TString skybrightnessrms = Form("%5.1f", brightnessrms);
+
+
     TString sequence = fname(TRegexp("star[0-9]+[.]root$"));
     if (sequence.IsNull())
@@ -227 +252 @@
     cout << "  Rate after ImgCl [Hz] " << datarate  << endl;
     cout << "  Maximum Humidity [%]  " << maxhum    << endl;
+    cout << "  Number of Stars       " << numstarsmean      << " +/- " << numstarsrms       << endl;
+    cout << "  Skybrightness         " << skybrightnessmean << " +/- " << skybrightnessrms  << endl;
 
     TString query;
@@ -241 +268 @@
                      " fDataRate=%d, "
                      " fMaxHumidity=%s ,"
+                     " fNumStarsMean=%s ,"
+                     " fNumStarsRMS=%s ,"
+                     " fBrightnessMean=%s ,"
+                     " fBrightnessRMS=%s ,"
                      " fInhomogeneity=%s ",
                      seq, islands.Data(), ratio.Data(),
@@ -246 +277 @@
                      muonrate.Data(), PSF.Data(),
                      datarate, maxhum.Data(),
+                     numstarsmean.Data(), numstarsrms.Data(),
+                     skybrightnessmean.Data(), skybrightnessrms.Data(),
                      inhomogen.Data());
     }
@@ -259 +292 @@
                      " fDataRate=%d, "
                      " fMaxHumidity=%s, "
+                     " fNumStarsMean=%s ,"
+                     " fNumStarsRMS=%s ,"
+                     " fBrightnessMean=%s ,"
+                     " fBrightnessRMS=%s ,"
                      " fInhomogeneity=%s "
                      " WHERE fSequenceFirst=%d ",
@@ -265 +302 @@
                      muonrate.Data(), PSF.Data(),
                      datarate, maxhum.Data(),
+                     numstarsmean.Data(), numstarsrms.Data(),
+                     skybrightnessmean.Data(), skybrightnessrms.Data(),
                      inhomogen.Data(), seq);
     }
+
+    cout << "Q: " << query << endl;
 
     if (dummy)

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

@@ -579 +579 @@
          "  fMaxHumidity        FLOAT(6,1)            NOT NULL,"
          "  fInhomogeneity      FLOAT(5,1)            NOT NULL,"
+         "  fNumStarsMean       FLOAT(5,1)            NOT NULL,"
+         "  fNumStarsRMS        FLOAT(5,1)            NOT NULL,"
+         "  fBrightnessMean     FLOAT(5,1)            NOT NULL,"
+         "  fBrightnessRMS      FLOAT(5,1)            NOT NULL,"
          "  fLastUpdate         TIMESTAMP"
          ")"));