source: trunk/MagicSoft/Mars/datacenter/macros/plotdb.C@ 7437

Last change on this file since 7437 was 7437, checked in by tbretz, 19 years ago
*** empty log message ***
File size: 13.3 KB
Line 
1/* ======================================================================== *\
2!
3! *
4! * This file is part of MARS, the MAGIC Analysis and Reconstruction
5! * Software. It is distributed to you in the hope that it can be a useful
6! * and timesaving tool in analysing Data of imaging Cerenkov telescopes.
7! * It is distributed WITHOUT ANY WARRANTY.
8! *
9! * Permission to use, copy, modify and distribute this software and its
10! * documentation for any purpose is hereby granted without fee,
11! * provided that the above copyright notice appear in all copies and
12! * that both that copyright notice and this permission notice appear
13! * in supporting documentation. It is provided "as is" without express
14! * or implied warranty.
15! *
16!
17!
18! Author(s): Thomas Bretz, 05/2005 <mailto:tbretz@astro.uni-wuerzburg.de>
19! Author(s): Daniela Dorner, 05/2005 <mailto:dorner@astro.uni-wuerzburg.de>
20!
21! Copyright: MAGIC Software Development, 2000-2005
22!
23!
24\* ======================================================================== */
25
26/////////////////////////////////////////////////////////////////////////////
27//
28// plotdb.C
29// ========
30//
31// This macro is used to read quality parameters from the DB and plot them.
32//
33// The parameters are from the following files:
34// calib*.root:mean conversion factor, mean arrival time, rms arrival time
35// (each parameter for inner and outer camera)
36// signal*.root: mean pedestal rms (for inner and outer camera)
37// star*.root: PSF, # of Muons, Effective OnTime, Muon rate,
38// Ratio MC/Data(MuonSize) and mean number of islands
39//
40// In the DB these values are stored in the tables Calibration and Star.
41//
42// Usage:
43// .x plotdb.C --> all values in the DB are plotted
44// You can chose are certain period:
45// .x plotdb.C(25) --> all values from period 25 are plotted
46// or a time period from a certain date to a certain date
47// .x plotdb.C("2004-11-14 00:00:00", "2005-02-28 00:00:00")
48// --> all values from 14.11.2004 0h to 28.2.2005 0h are plotted
49//
50// Make sure, that database and password are corretly set in a resource
51// file called sql.rc and the resource file is found.
52//
53/////////////////////////////////////////////////////////////////////////////
54#include <iostream>
55
56#include <TH1.h>
57#include <TEnv.h>
58#include <TPad.h>
59#include <TLine.h>
60#include <TText.h>
61#include <TFrame.h>
62#include <TStyle.h>
63#include <TGraph.h>
64#include <TCanvas.h>
65#include <TSQLRow.h>
66#include <TSQLResult.h>
67
68#include "MTime.h"
69#include "MAstro.h"
70#include "MSQLServer.h"
71#include "MStatusDisplay.h"
72
73class MPlot : public MParContainer
74{
75private:
76 MSQLServer &fServer;
77
78 TString fRequestFrom;
79 TString fRequestTo;
80 Int_t fRequestPeriod;
81
82 Float_t fPlotMin;
83 Float_t fPlotMax;
84
85 Float_t fHistMin;
86 Float_t fHistMax;
87
88 TString fDescription;
89 TString fNameTab;
90
91 void PlotTable(TSQLResult &res, TString name, Float_t fmin, Float_t fmax, Float_t resolution)
92 {
93 gStyle->SetOptStat(111111);
94
95 TSQLRow *row;
96
97 TGraph g;
98 g.SetNameTitle(name, Form("%s vs Time", name.Data()));
99 g.SetMarkerStyle(kFullDotMedium);
100
101 TGraph g2;
102 g2.SetNameTitle(name, Form("%s vs <Zd>", name.Data()));
103 g2.SetMarkerStyle(kFullDotMedium);
104
105 if (fmax>fmin)
106 {
107 g.SetMinimum(fmin);
108 g.SetMaximum(fmax);
109 g2.SetMinimum(fmin);
110 g2.SetMaximum(fmax);
111 }
112
113 Int_t first = -1;
114 Int_t last = -1;
115
116 while ((row=res.Next()))
117 {
118 const char *date = (*row)[0];
119 const char *zd = (*row)[1];
120 const char *val = (*row)[2];
121 if (!date || !val || !zd)
122 continue;
123
124 MTime t(date);
125 if (!t.SetSqlDateTime(date))
126 continue;
127
128 if (fRequestPeriod>0 && MAstro::GetMagicPeriod(t.GetMjd())!=fRequestPeriod)
129 continue;
130
131 if (first<0)
132 first = TMath::Nint(TMath::Floor(t.GetMjd()));
133 last = TMath::Nint(TMath::Ceil(t.GetMjd()));
134
135 Float_t value = atof(val);
136 Float_t zenith = atof(zd);
137 g.SetPoint(g.GetN(), t.GetAxisTime(), value);
138 g2.SetPoint(g2.GetN(), zenith, value);
139 }
140
141 gROOT->SetSelectedPad(0);
142
143 TString title = fNameTab.IsNull() ? name(name.First('.')+2, name.Length()) : fNameTab;
144 TCanvas &c = fDisplay ? fDisplay->AddTab(title) : *new TCanvas;
145 c.SetFillColor(kWhite);
146 c.SetBorderMode(0);
147 c.Divide(1,2);
148
149 TVirtualPad *pad = gPad;
150 pad->cd(2);
151 gPad->SetBorderMode(0);
152 gPad->SetFrameBorderMode(0);
153 gPad->SetGridy();
154
155 TH1 *h = g.GetHistogram();
156
157 h->SetXTitle("Time");
158 h->SetYTitle(name);
159 h->GetXaxis()->SetTimeDisplay(1);
160
161 g.DrawClone("AP");
162
163 TLine l;
164 TText t;
165 Int_t num=0;
166 l.SetLineStyle(kDotted);
167 l.SetLineColor(kBlue);
168 t.SetTextColor(kBlue);
169 l.SetLineWidth(1);
170 t.SetTextSize(h->GetXaxis()->GetLabelSize());
171 t.SetTextAlign(21);
172 Int_t p0 = MAstro::GetMagicPeriod(first);
173 for (Int_t p = first; p<last; p++)
174 {
175 Int_t p1 = MAstro::GetMagicPeriod(p);
176 if (p1!=p0)
177 {
178 l.DrawLine(MTime(p).GetAxisTime(), h->GetMinimum(), MTime(p).GetAxisTime(), h->GetMaximum());
179 t.DrawText(MTime(p+15).GetAxisTime(), h->GetMaximum(), Form("%d", p1));
180 num++;
181 }
182 p0 = p1;
183 }
184 if (num<4)
185 gPad->SetGridx();
186
187 const Double_t min = fHistMin>fHistMax ? h->GetMinimum()-resolution/2 : fHistMin;
188 const Double_t max = fHistMin>fHistMax ? h->GetMaximum()+resolution/2 : fHistMax;
189
190 pad->cd(1);
191 gPad->SetBorderMode(0);
192 gPad->SetFrameBorderMode(0);
193 gPad->Divide(2,1);
194
195 TVirtualPad *pad2 = gPad;
196 pad2->cd(1);
197 gPad->SetBorderMode(0);
198 gPad->SetFrameBorderMode(0);
199 gPad->SetGridx();
200 gPad->SetGridy();
201
202 const Int_t n = resolution>0 ? TMath::Nint((max-min)/resolution) : 50;
203
204 TH1F hist("Hist", Form("Distribution of %s", fDescription.IsNull() ? name.Data() : fDescription.Data()), n, min, max);
205 hist.SetDirectory(0);
206
207 for (int i=0; i<g.GetN(); i++)
208 hist.Fill(g.GetY()[i]);
209
210 if (fDescription.IsNull())
211 hist.SetXTitle(name);
212 hist.SetYTitle("Counts");
213
214 hist.DrawCopy("");
215
216 pad2->cd(2);
217 gPad->SetBorderMode(0);
218 gPad->SetFrameBorderMode(0);
219 gPad->SetGridy();
220
221 TH1 *h2 = g2.GetHistogram();
222
223 h2->SetXTitle("Zd");
224 h2->SetYTitle(name);
225
226 g2.DrawClone("AP");
227 }
228
229public:
230 MPlot(MSQLServer &server) : fServer(server), fRequestPeriod(-1),
231 fPlotMin(0), fPlotMax(-1), fHistMin(0), fHistMax(-1)
232 {
233 }
234 void SetPlotRange(Float_t min, Float_t max, Int_t n=5)
235 { fPlotMin = min; fPlotMax = max; }
236 void SetHistRange(Float_t min, Float_t max)
237 { fHistMin = min; fHistMax = max; }
238 void SetRequestRange(const char *from="", const char *to="")
239 { fRequestFrom = from; fRequestTo = to; }
240 void SetRequestPeriod(Int_t n=-1)
241 { fRequestPeriod = n; }
242 void SetDescription(const char *d, const char *t=0) { fDescription = d; fNameTab = t; }
243
244 Bool_t Plot(const char *value, Float_t min=0, Float_t max=-1, Float_t resolution=0)
245 {
246 TString named = "Sequences.fRunStart";
247 TString named2 = "(Sequences.fZenithDistanceMin+Sequences.fZenithDistanceMax)/2";
248 TString namev = value;
249 TString join = "fSequenceFirst";
250
251 TString tablev = namev(0, namev.First('.'));
252 TString valuev = namev(namev.First('.')+1, namev.Length());
253
254 TString tabled = named(0, named.First('.'));
255 TString valued = named(named.First('.')+1, named.Length());
256
257 TString query;
258 query = Form("select %s, %s, %s ", valued.Data(), named2.Data(), valuev.Data());
259 query += Form("from %s left join %s ", tabled.Data(), tablev.Data());
260 query += Form("on %s.%s=%s.%s ", tabled.Data(), join.Data(), tablev.Data(), join.Data());
261
262 if (!fRequestFrom.IsNull() && !fRequestTo.IsNull())
263 query += Form("where fRunStart between '%s' and '%s' ",
264 fRequestFrom.Data(), fRequestTo.Data());
265
266 query += "order by fRunStart";
267
268 //cout << "q: " << query << endl;
269
270 TSQLResult *res = fServer.Query(query);
271 if (!res)
272 {
273 cout << "ERROR - Query failed: " << query << endl;
274 return kFALSE;
275 }
276
277 if (max>min)
278 PlotTable(*res, namev, min, max, resolution);
279 else
280 PlotTable(*res, namev, fPlotMin, fPlotMax, resolution);
281
282
283 delete res;
284 return kTRUE;
285 }
286};
287
288void plotall(MPlot &plot)
289{
290 //inner camera
291 //from calib*.root
292 plot.SetDescription("Conversion Factor inner Camera;C_{I} [phe/fadc cnts]", "ConvI");
293 plot.Plot("Calibration.fConvFactorInner", 0, 0.5, 0.001);
294 plot.SetDescription("Mean Arrival Time inner Camera;T_{I} [sl]", "ArrTmI");
295 plot.Plot("Calibration.fArrTimeMeanInner", 0, 9.0, 0.1);
296 plot.SetDescription("RMS Arrival Time inner Camera;\\sigma_{T,I} [sl]", "RmsArrTmI");
297 plot.Plot("Calibration.fArrTimeRmsInner", 0, 2.5, 0.1);
298 //from signal*.root
299 plot.SetDescription("Mean Pedestal RMS inner Camera;\\sigma_{P,I} [phe]", "PedRmsI");
300 plot.Plot("Calibration.fMeanPedRmsInner", 0, 3.5, 0.05);
301 plot.SetDescription("Mean Signal inner Camera;S_{I} [phe]", "SignalI");
302 plot.Plot("Calibration.fMeanSignalInner", 0, 7.0, 0.05);
303 plot.SetDescription("Mean PulsePosCheck (falling edge) inner camera;T [sl]", "ChkPos");
304 plot.Plot("Calibration.fPulsePosCheckMean", 1, 15.0, 0.1);
305 plot.SetDescription("Rms PulsePosCheck (falling edge) inner camera;T [sl]", "ChkRms");
306 plot.Plot("Calibration.fPulsePosCheckRms", 0, 5.0, 0.1);
307 plot.SetDescription("Mean calibrated PulsePos;T", "PulPos");
308 plot.Plot("Calibration.fPulsePosMean", 1, 15.0, 0.1);
309 plot.SetDescription("Rms calibrated PulsePos;T", "PulRms");
310 plot.Plot("Calibration.fPulsePosRms", 0, 2.0, 0.1);
311 //from star*.root
312 //muon
313 plot.SetDescription("Point Spred Function;PSF [mm]");
314 plot.Plot("Star.fPSF", 0, 40, 0.5);
315 plot.SetDescription("Muon Calibration Ratio Data/MC;r [1]", "MuonCal");
316 plot.Plot("Star.fRatio", 0, 200, 0.5);
317 plot.SetDescription("Muon Rate after Muon Cuts;R [Hz]");
318 plot.Plot("Star.fMuonRate", 0, 2.0, 0.05);
319 //quality
320 plot.SetDescription("Camera Inhomogeneity;\\sigma [%]", "Inhom");
321 plot.Plot("Star.fInhomogeneity", 0, 100, 1);
322 //imgpar
323 plot.SetDescription("Mean Number of Islands after cleaning;N [#]", "NumIsl");
324 plot.Plot("Star.fMeanNumberIslands", 0.5, 4.5, 0.01);
325 plot.SetDescription("Measures effective on time;T_{eff} [s]", "EffOn");
326 plot.Plot("Star.fEffOnTime", 0, 10000, 150);
327 plot.SetDescription("Datarate [Hz]", "Rate");
328 plot.Plot("Star.fDataRate", 0, 600, 10);
329 plot.SetDescription("Maximum Humidity [%]", "Hum");
330 plot.Plot("Star.fMaxHumidity", 0, 100, 1);
331 //muon
332 plot.SetDescription("Number of Muons after Muon Cuts;N [#]");
333 plot.Plot("Star.fMuonNumber", 0, 10000, 100);
334 //outer camera
335 //from calib*.root
336 plot.SetDescription("Conversion Factor outer Camera;C_{O} [phe/fadc cnts]", "ConvO");
337 plot.Plot("Calibration.fConvFactorOuter", 0, 2.0, 0.01);
338 plot.SetDescription("Mean Arrival Time outer Camera;T_{O} [sl]", "ArrTmO");
339 plot.Plot("Calibration.fArrTimeMeanOuter", 0, 8.5, 0.1);
340 plot.SetDescription("RMS Arrival Time outer Camera;\\sigma_{T,O} [sl]", "RmsArrTmO");
341 plot.Plot("Calibration.fArrTimeRmsOuter", 0, 2.5, 0.1);
342 //from signal*.root
343 plot.SetDescription("Mean Pedestal RMS outer Camera;\\sigma_{P,O} [phe]", "PedRmsO");
344 plot.Plot("Calibration.fMeanPedRmsOuter", 0, 4.0, 0.05);
345 plot.SetDescription("Mean Signal outer Camera;S_{O} [phe]", "SignalO");
346 plot.Plot("Calibration.fMeanSignalOuter", 0, 4.0, 0.05);
347}
348
349int plotdb(TString from="", TString to="")
350{
351 TEnv env("sql.rc");
352
353 MSQLServer serv(env);
354 if (!serv.IsConnected())
355 {
356 cout << "ERROR - Connection to database failed." << endl;
357 return 0;
358 }
359
360 cout << "plotdb" << endl;
361 cout << "------" << endl;
362 cout << endl;
363 cout << "Connected to " << serv.GetName() << endl;
364 cout << endl;
365
366 MStatusDisplay *d = new MStatusDisplay;
367 d->SetWindowName(serv.GetName());
368 d->SetTitle(serv.GetName());
369
370 MPlot plot(serv);
371 plot.SetDisplay(d);
372 plot.SetRequestRange(from, to);
373 plotall(plot);
374 d->SaveAsRoot("plotdb.root");
375 d->SaveAsPS("plotdb.ps");
376
377 return 1;
378}
379
380int plotdb(Int_t period)
381{
382 TEnv env("sql.rc");
383
384 MSQLServer serv(env);
385 if (!serv.IsConnected())
386 {
387 cout << "ERROR - Connection to database failed." << endl;
388 return 0;
389 }
390
391 cout << "plotdb" << endl;
392 cout << "------" << endl;
393 cout << endl;
394 cout << "Connected to " << serv.GetName() << endl;
395 cout << endl;
396
397 MStatusDisplay *d = new MStatusDisplay;
398 d->SetWindowName(serv.GetName());
399 d->SetTitle(serv.GetName());
400
401 MPlot plot(serv);
402 plot.SetDisplay(d);
403 plot.SetRequestPeriod(period);
404 plotall(plot);
405 d->SaveAsRoot("plotdb.root");
406 d->SaveAsPS("plotdb.ps");
407
408 return 1;
409}
Note: See TracBrowser for help on using the repository browser.