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 |
|
---|
73 | class MPlot : public MParContainer
|
---|
74 | {
|
---|
75 | private:
|
---|
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 |
|
---|
229 | public:
|
---|
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 |
|
---|
288 | void 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 |
|
---|
349 | int 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 |
|
---|
380 | int 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 | }
|
---|