1 |
mocchiut |
1.1 |
/** |
2 |
|
|
* \file RunGlue.cpp |
3 |
|
|
* \author Emiliano Mocchiutti |
4 |
|
|
* |
5 |
|
|
* The file contains implementation of the methods to query the DB. |
6 |
|
|
*/ |
7 |
|
|
// |
8 |
|
|
#include <sstream> |
9 |
|
|
#include <iostream> |
10 |
|
|
// |
11 |
|
|
#include <TFile.h> |
12 |
|
|
#include <TTree.h> |
13 |
|
|
#include <TTimeStamp.h> |
14 |
mocchiut |
1.5 |
#include <TTreeCloner.h> |
15 |
mocchiut |
1.1 |
#include <RunGlue.h> |
16 |
|
|
// |
17 |
|
|
ClassImp(RunGlue); |
18 |
|
|
// |
19 |
|
|
using namespace std; |
20 |
|
|
|
21 |
|
|
RunGlue::RunGlue() { |
22 |
|
|
this->Clear(); |
23 |
|
|
} |
24 |
|
|
|
25 |
|
|
RunGlue::RunGlue(TSQLServer *da, UInt_t ru, TString di, TString wrkdi) { |
26 |
|
|
fDBG = false; |
27 |
|
|
li = new PamLevel2(); |
28 |
|
|
this->Clear(); |
29 |
|
|
dbc = da; |
30 |
|
|
run = ru; |
31 |
|
|
dir = di; |
32 |
|
|
// |
33 |
|
|
TString wd = gSystem->WorkingDirectory(); |
34 |
|
|
// |
35 |
|
|
outdir = wrkdi; |
36 |
|
|
if ( !strcmp(outdir.Data(),"") ) outdir = wd; |
37 |
|
|
fList = 0; |
38 |
|
|
if ( run ){ |
39 |
|
|
runmode = true; |
40 |
|
|
} else { |
41 |
|
|
runmode = false; |
42 |
|
|
createlist = true; |
43 |
|
|
}; |
44 |
|
|
// |
45 |
|
|
// lList = new TList(); |
46 |
|
|
// |
47 |
|
|
}; |
48 |
|
|
|
49 |
|
|
|
50 |
|
|
void RunGlue::Clear() { |
51 |
|
|
fEnd = false; |
52 |
|
|
run = 0; |
53 |
|
|
dir = ""; |
54 |
|
|
outdir = ""; |
55 |
|
|
fFilename = ""; |
56 |
|
|
}; |
57 |
|
|
|
58 |
|
|
void RunGlue::Clean() { |
59 |
|
|
if ( !merged ) gSystem->Unlink(fFilename); |
60 |
|
|
lList->Delete(); |
61 |
|
|
delete Target; |
62 |
|
|
}; |
63 |
|
|
|
64 |
|
|
void RunGlue::SetDebug(Bool_t dbg) { |
65 |
|
|
fDBG = dbg; |
66 |
|
|
}; |
67 |
|
|
|
68 |
|
|
void RunGlue::SetDList(TString list) { |
69 |
|
|
// |
70 |
|
|
RUN = true; |
71 |
|
|
// |
72 |
|
|
if (list.Contains("-RUN", TString::kIgnoreCase)) RUN = false; |
73 |
|
|
if (list.Contains("-ALL", TString::kIgnoreCase)) RUN = false; |
74 |
|
|
if (list.Contains("+RUN", TString::kIgnoreCase)) RUN = true; |
75 |
|
|
if (list.Contains("+ALL", TString::kIgnoreCase)) RUN = true; |
76 |
|
|
// |
77 |
|
|
fDList = list; |
78 |
|
|
li->SetWhichTrees(fDList); |
79 |
|
|
// |
80 |
|
|
if ( DebugMode() ) printf(" Detector list is %s \n",fDList.Data()); |
81 |
|
|
// |
82 |
|
|
}; |
83 |
|
|
|
84 |
|
|
TList *RunGlue::GetRunList(){ |
85 |
|
|
// |
86 |
|
|
lList = new TList(); |
87 |
|
|
lList->Clear(); |
88 |
|
|
TString thisrun; |
89 |
|
|
TFile *su; |
90 |
|
|
// |
91 |
|
|
TSQLResult *pResult; |
92 |
|
|
TSQLRow *Row; |
93 |
|
|
// |
94 |
|
|
if ( run && runmode ){ |
95 |
|
|
// |
96 |
|
|
// Qurey the GL_RUN table to obtain RUN infos |
97 |
|
|
// |
98 |
|
|
GL_RUN *glrun = new GL_RUN(); |
99 |
|
|
glrun->Query_GL_RUN(run,dbc); |
100 |
|
|
// |
101 |
|
|
// convert RUNHEADER_TIME into a UTC date |
102 |
|
|
// |
103 |
|
|
GL_TIMESYNC *dbtime = new GL_TIMESYNC(); |
104 |
|
|
// |
105 |
|
|
TString UTC="UTC"; |
106 |
|
|
TString rhdate=dbtime->ConvertTime(UTC,glrun->RUNHEADER_TIME); |
107 |
|
|
// |
108 |
|
|
TDatime ti = TDatime(rhdate.Data()); |
109 |
|
|
// |
110 |
|
|
YY=(UInt_t)ti.GetYear(); |
111 |
|
|
MM=(UInt_t)ti.GetMonth(); |
112 |
|
|
DD=(UInt_t)ti.GetDay(); |
113 |
|
|
// |
114 |
|
|
TTimeStamp *llim = new TTimeStamp(YY,MM,DD,0,0,0,0,true,0); |
115 |
|
|
// |
116 |
|
|
UInt_t lowerlimit = llim->GetSec(); |
117 |
|
|
UInt_t upperlimit = lowerlimit + 86401; |
118 |
|
|
// |
119 |
|
|
if ( DebugMode() ) printf(" YY %u MM %u DD %u ll %u ul %u \n",YY,MM,DD,lowerlimit,upperlimit); |
120 |
|
|
// |
121 |
|
|
YY -= 2000; |
122 |
|
|
stringstream tmpf; |
123 |
|
|
tmpf.str(""); |
124 |
|
|
tmpf << "L2PAM"; |
125 |
|
|
if ( YY < 10 ){ |
126 |
|
|
tmpf<< "0" << YY; |
127 |
|
|
} else { |
128 |
|
|
tmpf<< YY; |
129 |
|
|
}; |
130 |
|
|
if ( MM < 10 ){ |
131 |
|
|
tmpf<< "0" << MM; |
132 |
|
|
} else { |
133 |
|
|
tmpf<< MM; |
134 |
|
|
}; |
135 |
|
|
if ( DD < 10 ){ |
136 |
|
|
tmpf << "0" << DD << ".root"; |
137 |
|
|
} else { |
138 |
|
|
tmpf << DD << ".root"; |
139 |
|
|
}; |
140 |
|
|
TString fpath = ""; |
141 |
|
|
if ( !strcmp(outdir,"") ){ |
142 |
|
|
fpath="./"; |
143 |
|
|
} else { |
144 |
|
|
fpath += outdir; |
145 |
|
|
fpath += "/"; |
146 |
|
|
}; |
147 |
|
|
// |
148 |
|
|
fFilename = fpath + tmpf.str().c_str(); |
149 |
|
|
// |
150 |
|
|
printf(" Output filename is %s \n",fFilename.Data()); |
151 |
|
|
// |
152 |
mocchiut |
1.4 |
if ( !this->OpenFile() ){ |
153 |
|
|
fEnd = true; |
154 |
|
|
return(0); |
155 |
|
|
}; |
156 |
|
|
// |
157 |
|
|
stringstream myquery; |
158 |
|
|
myquery.str(""); |
159 |
|
|
myquery << "SELECT ID FROM GL_RUN WHERE RUNHEADER_TIME>=" << (UInt_t)lowerlimit |
160 |
|
|
<< " AND RUNHEADER_TIME<" << (UInt_t)upperlimit << " ORDER BY RUNHEADER_TIME ASC;"; |
161 |
|
|
// |
162 |
|
|
pResult = dbc->Query(myquery.str().c_str()); |
163 |
|
|
for( UInt_t r=0; r < 1000; r++){ |
164 |
|
|
Row = pResult->Next(); |
165 |
|
|
if( Row == NULL ) break; |
166 |
|
|
if ( DebugMode() ) printf(" %u RUN %s \n",r,Row->GetField(0)); |
167 |
|
|
// |
168 |
|
|
thisrun=dir+(TString)Row->GetField(0)+".Level2.root"; |
169 |
|
|
// |
170 |
|
|
if ( DebugMode() ) printf(" Filename is %s \n",thisrun.Data()); |
171 |
|
|
// |
172 |
|
|
su = TFile::Open(thisrun); |
173 |
|
|
if ( li->CheckLevel2File(thisrun) ){ |
174 |
|
|
lList->Add(su); |
175 |
|
|
} else { |
176 |
|
|
if ( DebugMode() ) printf(" RUN %s DISCARDED \n",Row->GetField(0)); |
177 |
|
|
}; |
178 |
|
|
// |
179 |
|
|
}; |
180 |
|
|
// |
181 |
|
|
// |
182 |
mocchiut |
1.1 |
delete glrun; |
183 |
|
|
delete dbtime; |
184 |
|
|
// |
185 |
|
|
}; |
186 |
|
|
// |
187 |
|
|
if ( strcmp(dir.Data(),"" )){ |
188 |
|
|
// |
189 |
|
|
if ( createlist ){ |
190 |
|
|
fList = new TList(); |
191 |
|
|
fDoneList = new TList(); |
192 |
|
|
fNlist = 0; |
193 |
|
|
fNlistdone = 0; |
194 |
|
|
// |
195 |
|
|
// read files in the directory |
196 |
|
|
// |
197 |
|
|
if ( DebugMode() ) printf("\n No input run given\n Check for existing root files. \n"); |
198 |
|
|
// |
199 |
|
|
TSystemDirectory *datadir = new TSystemDirectory(gSystem->BaseName(dir),dir); |
200 |
|
|
TList *temp = datadir->GetListOfFiles(); |
201 |
|
|
// |
202 |
|
|
TIter next(temp); |
203 |
|
|
TSystemFile *questo = 0; |
204 |
|
|
// |
205 |
|
|
while ( (questo = (TSystemFile*)next()) ) { |
206 |
|
|
TString name = questo->GetName(); |
207 |
|
|
if( name.EndsWith(".Level2.root") ){ |
208 |
|
|
char *fullpath0; |
209 |
|
|
gSystem->IsFileInIncludePath(name,&fullpath0); |
210 |
|
|
TString fullpath = fullpath0; |
211 |
|
|
// |
212 |
|
|
if ( DebugMode() ) printf(" fullpath = %s name %s \n",fullpath.Data(),name.Data()); |
213 |
|
|
// |
214 |
|
|
// |
215 |
|
|
su = TFile::Open(fullpath); |
216 |
|
|
if ( li->CheckLevel2File((TString)fullpath) ){ |
217 |
|
|
fList->Add(su); |
218 |
|
|
fNlist++; |
219 |
|
|
} else { |
220 |
|
|
if ( DebugMode() ) printf(" RUN %s DISCARDED \n",fullpath.Data()); |
221 |
|
|
}; |
222 |
|
|
// |
223 |
|
|
}; |
224 |
|
|
}; |
225 |
|
|
createlist = false; |
226 |
|
|
nrun = 0; |
227 |
|
|
}; |
228 |
|
|
// |
229 |
|
|
// |
230 |
|
|
// |
231 |
|
|
Bool_t stop = true; |
232 |
|
|
UInt_t drun = 0; |
233 |
|
|
while ( nrun < fNlist && stop ){ |
234 |
|
|
TString myrun = (TString)((TString)(gSystem->BaseName(((TFile*)fList->At(nrun))->GetName()))).ReplaceAll(".Level2.root",12,"",0); |
235 |
|
|
if ( DebugMode() ) printf(" nrun %u myrun is %s \n",nrun,(myrun.ReplaceAll(".Level2.root",12,"",0)).Data()); |
236 |
|
|
run = (UInt_t)(myrun.Atoi()); |
237 |
|
|
nrun++; |
238 |
|
|
// |
239 |
|
|
TString donerun = ""; |
240 |
|
|
for (UInt_t ll=0; ll<fNlistdone; ll++){ |
241 |
|
|
donerun = ""; |
242 |
|
|
donerun = (TString)((TString)(gSystem->BaseName(((TFile*)fDoneList->At(ll))->GetName()))).ReplaceAll(".Level2.root",12,"",0); |
243 |
|
|
if ( DebugMode() ) printf(" donerun is %s \n",(donerun.ReplaceAll(".Level2.root",12,"",0)).Data()); |
244 |
|
|
drun = (UInt_t)(donerun.Atoi()); |
245 |
|
|
// |
246 |
|
|
if ( run == drun ) goto jump; |
247 |
|
|
// |
248 |
|
|
}; |
249 |
|
|
// |
250 |
|
|
stop = false; |
251 |
|
|
// |
252 |
|
|
jump: |
253 |
|
|
drun = 0; |
254 |
|
|
// |
255 |
|
|
}; |
256 |
|
|
// |
257 |
|
|
if ( nrun >= fNlist && stop ){ |
258 |
|
|
fEnd = true; |
259 |
|
|
return(0); |
260 |
|
|
}; |
261 |
|
|
// |
262 |
|
|
// Qurey the GL_RUN table to obtain RUN infos |
263 |
|
|
// |
264 |
|
|
printf(" PROCESSING RUN %u AND ITS FRIENDS\n",run); |
265 |
|
|
GL_RUN *glrun = new GL_RUN(); |
266 |
|
|
glrun->Query_GL_RUN(run,dbc); |
267 |
|
|
// |
268 |
|
|
// convert RUNHEADER_TIME into a UTC date |
269 |
|
|
// |
270 |
|
|
GL_TIMESYNC *dbtime = new GL_TIMESYNC(); |
271 |
|
|
// |
272 |
|
|
TString UTC="UTC"; |
273 |
|
|
TString rhdate=dbtime->ConvertTime(UTC,glrun->RUNHEADER_TIME); |
274 |
|
|
// |
275 |
|
|
TDatime ti = TDatime(rhdate.Data()); |
276 |
|
|
// |
277 |
|
|
YY=(UInt_t)ti.GetYear(); |
278 |
|
|
MM=(UInt_t)ti.GetMonth(); |
279 |
|
|
DD=(UInt_t)ti.GetDay(); |
280 |
|
|
// |
281 |
|
|
TTimeStamp *llim = new TTimeStamp(YY,MM,DD,0,0,0,0,true,0); |
282 |
|
|
// |
283 |
|
|
UInt_t lowerlimit = llim->GetSec(); |
284 |
|
|
UInt_t upperlimit = lowerlimit + 86401; |
285 |
|
|
// |
286 |
|
|
if ( DebugMode() ) printf(" YY %u MM %u DD %u ll %u ul %u \n",YY,MM,DD,lowerlimit,upperlimit); |
287 |
|
|
// |
288 |
|
|
YY -= 2000; |
289 |
|
|
stringstream tmpf; |
290 |
|
|
tmpf.str(""); |
291 |
|
|
tmpf << "L2PAM"; |
292 |
|
|
if ( YY < 10 ){ |
293 |
|
|
tmpf<< "0" << YY; |
294 |
|
|
} else { |
295 |
|
|
tmpf<< YY; |
296 |
|
|
}; |
297 |
|
|
if ( MM < 10 ){ |
298 |
|
|
tmpf<< "0" << MM; |
299 |
|
|
} else { |
300 |
|
|
tmpf<< MM; |
301 |
|
|
}; |
302 |
|
|
if ( DD < 10 ){ |
303 |
|
|
tmpf << "0" << DD << ".root"; |
304 |
|
|
} else { |
305 |
|
|
tmpf << DD << ".root"; |
306 |
|
|
}; |
307 |
|
|
TString fpath = ""; |
308 |
|
|
if ( !strcmp(outdir,"") ){ |
309 |
|
|
fpath="./"; |
310 |
|
|
} else { |
311 |
|
|
fpath += outdir; |
312 |
|
|
fpath += "/"; |
313 |
|
|
}; |
314 |
|
|
// |
315 |
|
|
fFilename = fpath + tmpf.str().c_str(); |
316 |
|
|
// |
317 |
|
|
printf(" Output filename is %s \n",fFilename.Data()); |
318 |
|
|
// |
319 |
mocchiut |
1.4 |
if ( !this->OpenFile() ) return(0); |
320 |
|
|
// |
321 |
|
|
stringstream myquery; |
322 |
|
|
myquery.str(""); |
323 |
|
|
myquery << "SELECT ID FROM GL_RUN WHERE RUNHEADER_TIME>=" << (UInt_t)lowerlimit |
324 |
|
|
<< " AND RUNHEADER_TIME<" << (UInt_t)upperlimit << " ORDER BY RUNHEADER_TIME ASC;"; |
325 |
|
|
// |
326 |
|
|
pResult = dbc->Query(myquery.str().c_str()); |
327 |
|
|
for( UInt_t r=0; r < 1000; r++){ |
328 |
|
|
Row = pResult->Next(); |
329 |
|
|
if( Row == NULL ) break; |
330 |
|
|
if ( DebugMode() ) printf(" %u RUN %s \n",r,Row->GetField(0)); |
331 |
|
|
// |
332 |
|
|
thisrun=dir+(TString)Row->GetField(0)+".Level2.root"; |
333 |
|
|
// |
334 |
|
|
if ( DebugMode() ) printf(" Filename is %s \n",thisrun.Data()); |
335 |
|
|
// |
336 |
|
|
su = TFile::Open(thisrun); |
337 |
|
|
if ( su ){ |
338 |
|
|
TFile *su0 = TFile::Open(thisrun); |
339 |
|
|
fDoneList->Add(su0); |
340 |
|
|
fNlistdone++; |
341 |
|
|
}; |
342 |
|
|
if ( li->CheckLevel2File(thisrun) ){ |
343 |
|
|
lList->Add(su); |
344 |
|
|
if ( DebugMode() ) printf(" RUN %s ADDED \n",Row->GetField(0)); |
345 |
|
|
} else { |
346 |
|
|
if ( DebugMode() ) printf(" RUN %s DISCARDED \n",Row->GetField(0)); |
347 |
|
|
}; |
348 |
|
|
// |
349 |
|
|
}; |
350 |
|
|
// |
351 |
mocchiut |
1.1 |
if ( DebugMode() ){ |
352 |
|
|
UInt_t ll = 0; |
353 |
|
|
while ( (TFile*)lList->At(ll) ){ |
354 |
|
|
TString donerun = ""; |
355 |
|
|
donerun = (TString)((TString)(gSystem->BaseName(((TFile*)lList->At(ll))->GetName()))).ReplaceAll(".Level2.root",12,"",0); |
356 |
|
|
printf(" XXX file is %s \n",donerun.Data()); |
357 |
|
|
ll++; |
358 |
|
|
// |
359 |
|
|
}; |
360 |
|
|
}; |
361 |
|
|
// |
362 |
|
|
delete glrun; |
363 |
|
|
delete dbtime; |
364 |
|
|
// |
365 |
|
|
}; |
366 |
|
|
// |
367 |
|
|
// is it the end? |
368 |
|
|
// |
369 |
|
|
if ( runmode ){ |
370 |
|
|
fEnd = true; |
371 |
|
|
} else { |
372 |
|
|
// |
373 |
|
|
// did we use all the run in the directory? if so exit |
374 |
|
|
// |
375 |
|
|
if ( nrun >= fNlist ) fEnd = true; |
376 |
|
|
}; |
377 |
|
|
// |
378 |
|
|
return(lList); |
379 |
|
|
}; |
380 |
|
|
|
381 |
|
|
Bool_t RunGlue::OpenFile(){ |
382 |
|
|
// |
383 |
mocchiut |
1.4 |
fOpen = false; |
384 |
mocchiut |
1.1 |
printf(" Check if output file already exists \n"); |
385 |
mocchiut |
1.7 |
ifstream myfile; |
386 |
|
|
myfile.open((this->GetFilename()).Data()); |
387 |
|
|
if ( myfile ){ |
388 |
|
|
// Target = TFile::Open((this->GetFilename()).Data(), "READ" ); |
389 |
|
|
// |
390 |
|
|
// if ( Target ){ |
391 |
|
|
// Target->Close(); |
392 |
|
|
myfile.close(); |
393 |
mocchiut |
1.1 |
printf("Error opening target file, %s already exist!\n",(this->GetFilename()).Data()); |
394 |
|
|
return(false); |
395 |
|
|
} else { |
396 |
|
|
// |
397 |
|
|
printf(" Output file does not exist, creating it\n"); |
398 |
|
|
// |
399 |
mocchiut |
1.5 |
Long64_t maxsize = 99900000000LL; |
400 |
mocchiut |
1.1 |
// |
401 |
|
|
Target = TFile::Open((this->GetFilename()).Data(), "RECREATE" ); |
402 |
mocchiut |
1.3 |
//fastMethod = kTRUE; |
403 |
|
|
fastMethod = kFALSE; |
404 |
mocchiut |
1.1 |
// |
405 |
|
|
// |
406 |
|
|
if ( !Target || Target->IsZombie()) { |
407 |
|
|
printf("Error opening target file (does %s exist?)\n",(this->GetFilename()).Data()); |
408 |
|
|
exit(1); |
409 |
|
|
} |
410 |
|
|
// |
411 |
|
|
TTree::SetMaxTreeSize(maxsize); |
412 |
mocchiut |
1.5 |
Target->SetCompressionLevel(2); |
413 |
mocchiut |
1.1 |
// |
414 |
mocchiut |
1.4 |
fOpen = true; |
415 |
mocchiut |
1.1 |
return(true); |
416 |
|
|
// |
417 |
|
|
}; |
418 |
|
|
// |
419 |
|
|
return(true); |
420 |
|
|
// |
421 |
|
|
}; |
422 |
|
|
|
423 |
|
|
|
424 |
|
|
void RunGlue::DeleteRunFiles(TList *dlist){ |
425 |
|
|
// |
426 |
|
|
TString donerun = ""; |
427 |
|
|
// |
428 |
|
|
printf(" Deleting runs: \n"); |
429 |
|
|
// |
430 |
|
|
UInt_t ll = 0; |
431 |
|
|
// |
432 |
|
|
while ( (TFile*)dlist->At(ll) ){ |
433 |
|
|
donerun = (TString)(((TFile*)dlist->At(ll))->GetName()); |
434 |
|
|
gSystem->Unlink(donerun); |
435 |
|
|
printf(" Deleted file is %s \n",donerun.Data()); |
436 |
|
|
ll++; |
437 |
|
|
// |
438 |
|
|
}; |
439 |
|
|
}; |
440 |
|
|
|
441 |
|
|
void RunGlue::UpdateDB(TList *dlist){ |
442 |
|
|
// |
443 |
|
|
TSQLResult *pResult; |
444 |
|
|
TSQLRow *Row; |
445 |
|
|
stringstream myquery; |
446 |
|
|
// |
447 |
|
|
TString donerun = ""; |
448 |
|
|
// |
449 |
|
|
if ( DebugMode() ) printf(" Updating GL_RUN: \n"); |
450 |
|
|
// |
451 |
|
|
UInt_t ll = 0; |
452 |
|
|
UInt_t idl2 = 0; |
453 |
mocchiut |
1.2 |
UInt_t idr = 0; |
454 |
mocchiut |
1.1 |
// |
455 |
|
|
// |
456 |
|
|
myquery.str(""); |
457 |
mocchiut |
1.2 |
myquery << "select ID from GL_RAW where NAME='level2 files';"; |
458 |
|
|
if ( DebugMode() ) printf(" query is %s \n",myquery.str().c_str()); |
459 |
|
|
// |
460 |
|
|
pResult = dbc->Query(myquery.str().c_str()); |
461 |
|
|
if ( !pResult ){ |
462 |
|
|
printf(" ERROR QUERYING ON DB!\n"); |
463 |
|
|
return; |
464 |
|
|
}; |
465 |
|
|
Row = pResult->Next(); |
466 |
|
|
if( Row == NULL ){ |
467 |
|
|
printf(" ERROR QUERYING THE DB!\n"); |
468 |
|
|
return; |
469 |
|
|
} else { |
470 |
|
|
idr = (UInt_t)atoll(Row->GetField(0)); |
471 |
|
|
}; |
472 |
|
|
// |
473 |
|
|
myquery.str(""); |
474 |
mocchiut |
1.9 |
// myquery << "insert into GL_ROOT (ID_RAW,PATH,NAME) values (" << idr << ",'" << outdir.Data() << "','" << ((TString)gSystem->BaseName(this->GetFilename())).Data() << "');"; |
475 |
|
|
myquery << "insert into GL_ROOT (ID_RAW,PATH,NAME) values (" << idr << ",'$PAM_L2','" << ((TString)gSystem->BaseName(this->GetFilename())).Data() << "');"; |
476 |
mocchiut |
1.1 |
if ( DebugMode() ) printf(" query is %s \n",myquery.str().c_str()); |
477 |
|
|
// |
478 |
|
|
pResult = dbc->Query(myquery.str().c_str()); |
479 |
|
|
if ( !pResult ){ |
480 |
|
|
printf(" ERROR WRITING ON DB!\n"); |
481 |
|
|
return; |
482 |
|
|
}; |
483 |
|
|
myquery.str(""); |
484 |
|
|
myquery << "select ID from GL_ROOT where NAME='" << ((TString)gSystem->BaseName(this->GetFilename())).Data() << "';"; |
485 |
|
|
if ( DebugMode() ) printf(" query is %s \n",myquery.str().c_str()); |
486 |
|
|
// |
487 |
|
|
pResult = dbc->Query(myquery.str().c_str()); |
488 |
|
|
if ( !pResult ){ |
489 |
|
|
printf(" ERROR WRITING ON DB!\n"); |
490 |
|
|
return; |
491 |
|
|
}; |
492 |
|
|
Row = pResult->Next(); |
493 |
|
|
if( Row == NULL ){ |
494 |
|
|
printf(" ERROR QUERYING THE DB!\n"); |
495 |
|
|
return; |
496 |
|
|
} else { |
497 |
|
|
idl2 = (UInt_t)atoll(Row->GetField(0)); |
498 |
|
|
}; |
499 |
|
|
// |
500 |
|
|
// |
501 |
|
|
// |
502 |
|
|
UInt_t drun = 0; |
503 |
|
|
// |
504 |
|
|
while ( (TFile*)dlist->At(ll) ){ |
505 |
|
|
donerun = ""; |
506 |
|
|
donerun = (TString)((TString)(gSystem->BaseName(((TFile*)dlist->At(ll))->GetName()))).ReplaceAll(".Level2.root",12,"",0); |
507 |
|
|
drun = (UInt_t)(donerun.Atoi()); |
508 |
|
|
// |
509 |
|
|
if ( DebugMode() ) printf(" Run is %s \n",donerun.Data()); |
510 |
|
|
// |
511 |
|
|
myquery.str(""); |
512 |
|
|
myquery << "update GL_RUN set ID_ROOT_L2=" << idl2 << " where ID=" << drun << ";"; |
513 |
|
|
if ( DebugMode() ) printf(" query is %s \n",myquery.str().c_str()); |
514 |
|
|
// |
515 |
|
|
pResult = dbc->Query(myquery.str().c_str()); |
516 |
|
|
if ( !pResult ){ |
517 |
|
|
printf(" ERROR WRITING ON DB!\n"); |
518 |
|
|
return; |
519 |
|
|
}; |
520 |
|
|
// |
521 |
|
|
ll++; |
522 |
|
|
// |
523 |
|
|
}; |
524 |
|
|
}; |
525 |
|
|
|
526 |
|
|
// |
527 |
|
|
// method stolen to ROOT's "hadd" and modified |
528 |
|
|
// |
529 |
|
|
void RunGlue::MergeRootfile(TList *sourcelist) { |
530 |
|
|
// |
531 |
|
|
merged = false; |
532 |
|
|
// |
533 |
|
|
TDirectory *target = Target; |
534 |
|
|
// |
535 |
|
|
if ( DebugMode() ) printf("\nTarget path is: %s \n",target->GetPath()); |
536 |
|
|
// |
537 |
|
|
TString path( (char*)strstr( target->GetPath(), ":" ) ); |
538 |
|
|
path.Remove(0,2); |
539 |
|
|
// |
540 |
|
|
TDirectory *first_source = (TDirectory*)sourcelist->First(); |
541 |
|
|
THashList allNames; |
542 |
|
|
// |
543 |
|
|
while ( first_source ){ |
544 |
|
|
// |
545 |
|
|
TDirectory *current_sourcedir = first_source->GetDirectory(path); |
546 |
|
|
// |
547 |
|
|
if ( !current_sourcedir ){ |
548 |
|
|
first_source = (TDirectory*)sourcelist->After(first_source); |
549 |
|
|
continue; |
550 |
|
|
} |
551 |
|
|
// |
552 |
|
|
// loop over all keys in this directory |
553 |
|
|
// |
554 |
mocchiut |
1.6 |
TChain *globChain = 0; |
555 |
mocchiut |
1.1 |
TIter nextkey( current_sourcedir->GetListOfKeys() ); |
556 |
mocchiut |
1.5 |
TKey *key = 0; |
557 |
|
|
TKey *oldkey = 0; |
558 |
mocchiut |
1.1 |
TH1::AddDirectory(kFALSE); // gain time, do not add the objects in the list in memory |
559 |
|
|
// |
560 |
|
|
while ( (key = (TKey*)nextkey()) ) { |
561 |
|
|
// |
562 |
mocchiut |
1.5 |
// printf(" target ls \n"); |
563 |
|
|
// Target->ls(); |
564 |
|
|
// |
565 |
mocchiut |
1.1 |
if ( current_sourcedir == target ) break; |
566 |
|
|
// |
567 |
mocchiut |
1.5 |
if ( oldkey && !strcmp(oldkey->GetName(),key->GetName()) ) continue; //keep only the highest cycle number for each key |
568 |
mocchiut |
1.1 |
// |
569 |
mocchiut |
1.5 |
if ( allNames.FindObject(key->GetName()) ) continue; |
570 |
mocchiut |
1.1 |
// |
571 |
|
|
if ( DebugMode() ) printf(" Key name is -%s- \n",key->GetName()); |
572 |
|
|
// |
573 |
|
|
// |
574 |
|
|
// |
575 |
pamela |
1.8 |
if ( !strcmp(key->GetName(),"Tracker") && !li->IsTRK2() && !li->IsTRK1() && !li->IsTRKh() ) continue; |
576 |
mocchiut |
1.1 |
// |
577 |
pamela |
1.8 |
if ( !strcmp(key->GetName(),"Calorimeter") && !li->IsCAL2() && !li->IsCAL1() ) continue; |
578 |
mocchiut |
1.1 |
// |
579 |
pamela |
1.8 |
if ( !strcmp(key->GetName(),"ToF") && !li->IsTOF() ) continue; |
580 |
mocchiut |
1.1 |
// |
581 |
pamela |
1.8 |
if ( !strcmp(key->GetName(),"Trigger") && !li->IsTRG() ) continue; |
582 |
mocchiut |
1.1 |
// |
583 |
pamela |
1.8 |
if ( !strcmp(key->GetName(),"Anticounter") && !li->IsAC() ) continue; |
584 |
mocchiut |
1.1 |
// |
585 |
pamela |
1.8 |
if ( !strcmp(key->GetName(),"S4") && !li->IsS4() ) continue; |
586 |
mocchiut |
1.1 |
// |
587 |
pamela |
1.8 |
if ( !strcmp(key->GetName(),"NeutronD") && !li->IsND() ) continue; |
588 |
mocchiut |
1.1 |
// |
589 |
pamela |
1.8 |
if ( !strcmp(key->GetName(),"OrbitalInfo") && !li->IsORB() ) continue; |
590 |
mocchiut |
1.1 |
// |
591 |
pamela |
1.8 |
if ( !strcmp(key->GetName(),"Run") && !li->IsRUN() ) continue; |
592 |
mocchiut |
1.1 |
// |
593 |
|
|
if ( strcmp(key->GetName(),"Calorimeter") && strcmp(key->GetName(),"Tracker") && strcmp(key->GetName(),"ToF") && strcmp(key->GetName(),"Trigger") && strcmp(key->GetName(),"Anticounter") && strcmp(key->GetName(),"S4") && strcmp(key->GetName(),"NeutronD") && strcmp(key->GetName(),"OrbitalInfo") && strcmp(key->GetName(),"Run") && strcmp(key->GetName(),"ProcessID0") ){ |
594 |
|
|
if ( DebugMode() ) printf(" ERROR UNKNOWN KEY %s !\n",key->GetName()); |
595 |
|
|
continue; |
596 |
|
|
}; |
597 |
|
|
// |
598 |
|
|
allNames.Add(new TObjString(key->GetName())); |
599 |
|
|
// |
600 |
|
|
// read object from first source file |
601 |
|
|
// |
602 |
|
|
current_sourcedir->cd(); |
603 |
|
|
TObject *obj = key->ReadObj(); |
604 |
|
|
// |
605 |
|
|
if ( obj->IsA()->InheritsFrom("TTree") ){ |
606 |
|
|
// |
607 |
|
|
// loop over all source files create a chain of Trees "globChain" |
608 |
|
|
// |
609 |
|
|
TString obj_name; |
610 |
|
|
// |
611 |
|
|
if ( path.Length() ) { |
612 |
|
|
obj_name = path + "/" + obj->GetName(); |
613 |
|
|
} else { |
614 |
|
|
obj_name = obj->GetName(); |
615 |
|
|
}; |
616 |
|
|
// |
617 |
|
|
globChain = new TChain(obj_name); |
618 |
|
|
// |
619 |
mocchiut |
1.6 |
globChain->SetCacheSize(0); |
620 |
|
|
// |
621 |
mocchiut |
1.1 |
globChain->Add(first_source->GetName()); |
622 |
|
|
// |
623 |
|
|
TFile *nextsource = (TFile*)sourcelist->After( first_source ); |
624 |
|
|
// |
625 |
|
|
while ( nextsource ) { |
626 |
|
|
// |
627 |
|
|
//do not add to the list a file that does not contain this Tree |
628 |
|
|
// |
629 |
|
|
TFile *curf = TFile::Open(nextsource->GetName()); |
630 |
|
|
// |
631 |
|
|
if ( curf ) { |
632 |
|
|
// |
633 |
|
|
Bool_t mustAdd = kFALSE; |
634 |
|
|
// |
635 |
|
|
if (curf->FindKey(obj_name)) { |
636 |
|
|
// |
637 |
|
|
mustAdd = kTRUE; |
638 |
|
|
// |
639 |
|
|
} else { |
640 |
|
|
// |
641 |
|
|
//we could be more clever here. No need to import the object |
642 |
|
|
//we are missing a function in TDirectory |
643 |
|
|
// |
644 |
|
|
TObject *aobj = curf->Get(obj_name); |
645 |
|
|
// |
646 |
|
|
if ( aobj ){ |
647 |
|
|
mustAdd = kTRUE; |
648 |
|
|
delete aobj; |
649 |
|
|
}; |
650 |
|
|
}; |
651 |
|
|
if (mustAdd) { |
652 |
|
|
globChain->Add(nextsource->GetName()); |
653 |
|
|
}; |
654 |
|
|
}; |
655 |
|
|
delete curf; |
656 |
|
|
nextsource = (TFile*)sourcelist->After(nextsource); |
657 |
|
|
}; |
658 |
|
|
// |
659 |
mocchiut |
1.5 |
delete nextsource; |
660 |
|
|
// |
661 |
mocchiut |
1.1 |
} else { |
662 |
|
|
// |
663 |
|
|
// object is of no type that we know or can handle |
664 |
|
|
// |
665 |
|
|
if ( DebugMode() ) cout << "Unknown object type, name: " |
666 |
|
|
<< obj->GetName() << " title: " << obj->GetTitle() << endl; |
667 |
|
|
}; |
668 |
|
|
// |
669 |
|
|
// now write the merged histogram (which is "in" obj) to the target file |
670 |
|
|
// note that this will just store obj in the current directory level, |
671 |
|
|
// which is not persistent until the complete directory itself is stored |
672 |
|
|
// by "target->Write()" below |
673 |
|
|
// |
674 |
|
|
if ( obj ){ |
675 |
|
|
// |
676 |
|
|
target->cd(); |
677 |
|
|
// |
678 |
|
|
if( obj->IsA()->InheritsFrom("TTree") ) { |
679 |
|
|
// |
680 |
mocchiut |
1.5 |
Long64_t nfiles = 0; |
681 |
mocchiut |
1.1 |
if ( fastMethod ){ |
682 |
mocchiut |
1.5 |
// globChain->Merge(target->GetFile(),0,"C keep fast"); |
683 |
|
|
nfiles=this->Mergy((TChain*)globChain,target->GetFile(),0,"C keep fast"); |
684 |
mocchiut |
1.1 |
} else { |
685 |
mocchiut |
1.5 |
//globChain->Merge(target->GetFile(),0,"C keep"); |
686 |
|
|
nfiles=this->Mergy((TChain*)globChain,target->GetFile(),0,"C keep"); |
687 |
mocchiut |
1.1 |
}; |
688 |
|
|
// |
689 |
|
|
merged = true; |
690 |
|
|
// |
691 |
mocchiut |
1.5 |
if ( DebugMode() ){ |
692 |
|
|
printf(" Merged %i files\n",(int)nfiles); |
693 |
|
|
globChain->ls(); |
694 |
|
|
}; |
695 |
mocchiut |
1.1 |
// |
696 |
|
|
delete globChain; |
697 |
mocchiut |
1.5 |
// return; |
698 |
mocchiut |
1.1 |
// |
699 |
|
|
} else { |
700 |
|
|
// |
701 |
|
|
// obj->Write( key->GetName() ); // <================================================================================== |
702 |
|
|
// |
703 |
|
|
}; |
704 |
|
|
}; |
705 |
mocchiut |
1.5 |
delete obj; |
706 |
mocchiut |
1.1 |
oldkey = key; |
707 |
|
|
}; |
708 |
|
|
// |
709 |
|
|
first_source = (TDirectory*)sourcelist->After(first_source); |
710 |
|
|
// |
711 |
|
|
}; |
712 |
|
|
// save modifications to target file |
713 |
mocchiut |
1.5 |
// |
714 |
mocchiut |
1.1 |
target->SaveSelf(kTRUE); |
715 |
|
|
// |
716 |
mocchiut |
1.5 |
}; |
717 |
|
|
|
718 |
|
|
|
719 |
|
|
Long64_t RunGlue::Mergy(TChain *mychain, TFile* file, Int_t basketsize, Option_t* option){ |
720 |
|
|
// We must have been passed a file, we will use it |
721 |
|
|
// later to reset the compression level of the branches. |
722 |
|
|
if (!file) { |
723 |
|
|
// FIXME: We need an error message here. |
724 |
|
|
return 0; |
725 |
|
|
} |
726 |
|
|
|
727 |
|
|
// Options |
728 |
|
|
Bool_t fastClone = kFALSE; |
729 |
|
|
TString opt = option; |
730 |
|
|
opt.ToLower(); |
731 |
|
|
if (opt.Contains("fast")) { |
732 |
|
|
fastClone = kTRUE; |
733 |
|
|
} |
734 |
|
|
|
735 |
|
|
// The chain tree must have a list of branches |
736 |
|
|
// because we may try to change their basket |
737 |
|
|
// size later. |
738 |
|
|
TObjArray* lbranches = mychain->GetListOfBranches(); |
739 |
|
|
if (!lbranches) { |
740 |
|
|
// FIXME: We need an error message here. |
741 |
|
|
return 0; |
742 |
|
|
} |
743 |
|
|
|
744 |
|
|
// The chain must have a current tree because |
745 |
|
|
// that is the one we will clone. |
746 |
|
|
// if (!fTree) { |
747 |
|
|
// -- LoadTree() has not yet been called, no current tree. |
748 |
|
|
// FIXME: We need an error message here. |
749 |
|
|
// return 0; |
750 |
|
|
// } |
751 |
|
|
|
752 |
|
|
// Copy the chain's current tree without |
753 |
|
|
// copying any entries, we will do that later. |
754 |
|
|
TTree* newTree = mychain->CloneTree(0); |
755 |
|
|
if (!newTree) { |
756 |
|
|
// FIXME: We need an error message here. |
757 |
|
|
return 0; |
758 |
|
|
} |
759 |
|
|
|
760 |
|
|
// Strip out the (potential) directory name. |
761 |
|
|
// FIXME: The merged chain may or may not have the |
762 |
|
|
// same name as the original chain. This is |
763 |
|
|
// bad because the chain name determines the |
764 |
|
|
// names of the trees in the chain by default. |
765 |
|
|
newTree->SetName(gSystem->BaseName(mychain->GetName())); |
766 |
|
|
|
767 |
|
|
// FIXME: Why do we do this? |
768 |
|
|
// newTree->SetAutoSave(-1); |
769 |
|
|
newTree->SetAutoSave(900000000000000LL); |
770 |
|
|
|
771 |
|
|
// Circularity is incompatible with merging, it may |
772 |
|
|
// force us to throw away entries, which is not what |
773 |
|
|
// we are supposed to do. |
774 |
|
|
newTree->SetCircular(0); |
775 |
|
|
|
776 |
|
|
// Reset the compression level of the branches. |
777 |
|
|
if (opt.Contains("c")) { |
778 |
|
|
TBranch* branch = 0; |
779 |
|
|
TIter nextb(newTree->GetListOfBranches()); |
780 |
|
|
while ((branch = (TBranch*) nextb())) { |
781 |
|
|
branch->SetCompressionLevel(file->GetCompressionLevel()); |
782 |
|
|
} |
783 |
|
|
} |
784 |
|
|
|
785 |
|
|
// Reset the basket size of the branches. |
786 |
|
|
if (basketsize > 1000) { |
787 |
|
|
TBranch* branch = 0; |
788 |
|
|
TIter nextb(newTree->GetListOfBranches()); |
789 |
|
|
while ((branch = (TBranch*) nextb())) { |
790 |
|
|
branch->SetBasketSize(basketsize); |
791 |
|
|
} |
792 |
|
|
} |
793 |
|
|
|
794 |
|
|
Long64_t nentries = mychain->GetEntriesFast(); |
795 |
|
|
|
796 |
|
|
// Copy the entries. |
797 |
|
|
if (fastClone) { |
798 |
|
|
// For each tree in the chain. |
799 |
|
|
for (Long64_t i = 0; i < nentries; i += mychain->GetTree()->GetEntries()) { |
800 |
|
|
if (mychain->LoadTree(i) < 0) { |
801 |
|
|
break; |
802 |
|
|
} |
803 |
|
|
TTreeCloner cloner(mychain->GetTree(), newTree, option); |
804 |
|
|
if (cloner.IsValid()) { |
805 |
|
|
newTree->SetEntries(newTree->GetEntries() + mychain->GetTree()->GetEntries()); |
806 |
|
|
cloner.Exec(); |
807 |
|
|
} else { |
808 |
|
|
if (mychain->GetFile()) { |
809 |
|
|
printf("Merge Skipped file %s\n", mychain->GetFile()->GetName()); |
810 |
|
|
// } else { |
811 |
|
|
// Warning("Merge", "Skipped file number %d\n", fTreeNumber); |
812 |
|
|
} |
813 |
|
|
} |
814 |
|
|
} |
815 |
|
|
} else { |
816 |
|
|
for (Long64_t i = 0; i < nentries; i++) { |
817 |
|
|
if (mychain->GetEntry(i) <= 0) { |
818 |
|
|
break; |
819 |
|
|
} |
820 |
|
|
newTree->Fill(); |
821 |
|
|
} |
822 |
|
|
} |
823 |
|
|
|
824 |
|
|
// Write the new tree header. |
825 |
|
|
newTree->Write(); |
826 |
|
|
|
827 |
|
|
// Get our return value. |
828 |
|
|
Int_t nfiles = newTree->GetFileNumber() + 1; |
829 |
|
|
|
830 |
|
|
// Close and delete the current file of the new tree. |
831 |
|
|
if (!opt.Contains("keep")) { |
832 |
|
|
// FIXME: What happens to fDirectory in newTree here? |
833 |
|
|
delete newTree->GetCurrentFile(); |
834 |
|
|
} |
835 |
|
|
return nfiles; |
836 |
mocchiut |
1.1 |
} |