/[PAMELA software]/YodaProfiler/src/YodaProfiler.cpp
ViewVC logotype

Diff of /YodaProfiler/src/YodaProfiler.cpp

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by mocchiut, Wed Aug 30 11:18:13 2006 UTC revision 1.27 by mocchiut, Wed Feb 6 12:22:02 2008 UTC
# Line 5  Line 5 
5  //  //
6  #include <TSystem.h>  #include <TSystem.h>
7  //  //
8    #include <GLTables.h>
9  #include <PamelaDBOperations.h>  #include <PamelaDBOperations.h>
10  #include <YodaProfilerVerl2.h>  #include <YodaProfilerVerl2.h>
11  //  //
# Line 14  using namespace std; Line 15  using namespace std;
15  //  //
16  void usage(){  void usage(){
17    printf("\nUsage:\n");    printf("\nUsage:\n");
18    printf("\n YodaProfiler [-v | --verbose] [-h | --help] [--version] -rawFile raw_filename -yodaFile yoda_filename \n");    printf("\n YodaProfiler [options] -rawFile raw_filename -yodaFile yoda_filename \n");
   printf("\n            [-host host] [-user username] [-psw password] \n");  
   printf("\n --version       print informations about compilation and exit\n");  
   printf("\n -h | --help     print this help and exit \n");  
   printf("\n -v | --verbose  be verbose [default: print nothing on STDOUT]\n");  
   printf("\n -g | --debug    be very verbose [default: no]\n");  
19    printf("\n -rawFile        full path to the raw file\n");    printf("\n -rawFile        full path to the raw file\n");
20    printf("\n -yodaFile       full path to the YODA file\n");    printf(  " -yodaFile       full path to the YODA file\n");
21    printf("\n -boot number    CPU boot number [default = taken from VarDump]\n");    printf("\n Options are:\n\n");
22    printf("\n -tsync number   timesync (s) [default = taken from data]\n");    printf(" --version       print informations about compilation and exit\n");
23    printf("\n -obt0 number    obt at timesync (ms) [default = taken from data]\n");    printf(" -h | --help     print this help and exit \n");
24    printf("\n -host           name for the host [default = mysql://localhost/pamelaprod]\n");    printf(" -v | --verbose  be verbose [default]\n");
25    printf("\n -user           username for the DB [default = anonymous] \n");    printf(" -s | --silent   print nothing on STDOUT\n");
26    printf("\n -psw            password for the DB [default = \"\"]\n");    printf(" -g | --debug    be very verbose [default: no]\n");
27    printf("\nExamples: \n");    printf(" -p | --pedantic be strict in checks, exit with error if any problem is found [default: no]\n");
28    printf("\n YodaProfiler -rawFile /path/to/raw/files/000_000_00000_cln2.pam -yodaFile /path/to/filesfromyoda/000_000_00000_cln2.root \n\n");    printf(" -boot number    CPU boot number [default = taken from VarDump]\n");
29      printf(" -autoboot       if no VarDump found try to determine the BOOT number\n");
30      printf("                 looking at timesync [default]\n");
31      printf(" -no-autoboot    disable previous check\n");
32      printf(" -tsync number   timesync (s) [default = taken from data]\n");
33      printf(" -obt0 number    obt at timesync (ms) [default = taken from data]\n");
34      printf(" -dworbit number number is the downlink orbit number (to be used with non-standard names)\n");
35      printf(" -static         use static path inside the DB instead of symbolic names\n");
36      //  printf(" -gpamela        shortcut to \"-clean 0 -obt0 1 -tsync 1 -no-autoboot -boot 1 -dworbit 1 -static\"\n");
37      printf(" -gpamela        shortcut to \"-clean 0 -obt0 1 -no-autoboot -dworbit 1 -static\"\n");
38      printf(" -clean number   number in seconds after which the fragment table\n");
39      printf("                 can be cleaned and runs validated [default = -1 do not clean],\n");
40      printf("                 if 0 force cleaning immediatly, if negative do not clean\n");
41      printf(" -remove file    remove file and all related runs and calibrations from DB\n");
42      printf("                 file must be the YODA filename (full path is not needed)\n");
43      printf("                 'same' can be used if in conjuction with -yodaFile\n");
44      printf(" -validate file  validates runs between the two closest calibration to file \n");
45      printf("                 not belonging to file itself. File must be the YODA filename\n");
46      printf("                 'same' can be used if in conjuction with -yodaFile\n");
47      printf(" -cleanfrag file clean run fragments for file only\n");
48      printf("                 File must be the YODA filename\n");
49      printf("                 'same' can be used if in conjuction with -yodaFile\n");
50      printf(" -nofrag         do not leave runs in the fragment table and look for fragments\n");
51      printf("                 in the GL_RUN table.\n");
52      printf(" -f | -force     to be used to reprocess a file or to process a file\n");
53      printf("                 when already validated the surroundings, it is equivalent to:\n");
54      printf("                 -remove same -validate same -cleanfrag same -nofrag\n");
55      printf(" -check          performs some test on the GL_RUN table to check its consistency\n");
56      printf(" -host           name of the DB host [default = $PAM_DBHOST or mysql://localhost/pamelaprod]\n");
57      printf(" -user           username for the DB connection [default = $PAM_DBUSER or \"anonymous\"] \n");
58      printf(" -psw            password for the DB connection [default = $PAM_DBPSW or \"\"]\n");
59      printf(" -tle <file>     ascii file containing TLE obtained from celestrak.org or space-track.org [default = no]\n");
60      printf("\n The order of input files and options does not matter. \n");
61      printf("\n Example: \n");
62      printf(" YodaProfiler -yodaFile /path/to/raw/files/000_000_00000_cln2.root -rawFile /path/to/filesfromyoda/000_000_00000_cln2.pam -v \n\n");
63  };  };
64  //  //
65  int main(int numinp, char *inps[]){  int main(int numinp, char *inps[]){
# Line 41  int main(int numinp, char *inps[]){ Line 71  int main(int numinp, char *inps[]){
71    UInt_t boot = 0;    UInt_t boot = 0;
72    UInt_t tsync = 0;    UInt_t tsync = 0;
73    UInt_t obt0 = 0;    UInt_t obt0 = 0;
74      UInt_t dwinput = 0;
75      Long64_t olderthan = -1LL;  
76    //    //
77    //    //
78    TString filerawname;    TString filerawname  = "";
79      TString filerootname = "";
80    //    //
81    TString host;    TString host = "mysql://localhost/pamelaprod";
82    TString user;    TString user = "anonymous";
83    TString password;    TString password = "";
84      //
85      TString tlefilename = "";
86      //
87      const char *pamdbhost = gSystem->Getenv("PAM_DBHOST");
88      const char *pamdbuser = gSystem->Getenv("PAM_DBUSER");
89      const char *pamdbpsw = gSystem->Getenv("PAM_DBPSW");
90      if ( !pamdbhost ) pamdbhost = "";
91      if ( !pamdbuser ) pamdbuser = "";
92      if ( !pamdbpsw ) pamdbpsw = "";
93      if ( strcmp(pamdbhost,"") ) host = pamdbhost;
94      if ( strcmp(pamdbuser,"") ) user = pamdbuser;
95      if ( strcmp(pamdbpsw,"") ) password = pamdbpsw;
96    //    //
   TString filerootname;  
97    //        //    
98    Bool_t beverbose = false;    Bool_t staticp = false;
99      Bool_t beverbose = true;
100    Bool_t debug = false;    Bool_t debug = false;
101      Bool_t autoboot = true;
102      Bool_t gpamela = false;
103      //
104      Bool_t remove = false;
105      TString remfile = "";
106      //
107      Bool_t forceclean = false;
108      TString fcleanfile = "";
109      //
110      Bool_t validate = false;
111      TString validfile = "";
112      //
113      Bool_t nofrag = false;
114      //
115      Bool_t force = false;
116      //
117      Bool_t check = false;
118      //
119      Bool_t pedantic = false;
120      //
121    Int_t i = 0;    Int_t i = 0;
122    //    //
123    if ( numinp > 1 ){    if ( numinp > 1 ){
# Line 62  int main(int numinp, char *inps[]){ Line 127  int main(int numinp, char *inps[]){
127          exit(0);          exit(0);
128        };        };
129        if ( !strcmp(inps[i],"-h") || !strcmp(inps[i],"--help") ){        if ( !strcmp(inps[i],"-h") || !strcmp(inps[i],"--help") ){
130    
131          usage();          usage();
132          exit(0);          exit(0);
133        };        };
# Line 79  int main(int numinp, char *inps[]){ Line 145  int main(int numinp, char *inps[]){
145          };          };
146          filerootname = (TString)inps[i+1];                filerootname = (TString)inps[i+1];      
147        };        };
148          if ( !strcmp(inps[i],"-remove") ) {
149            if ( numinp-1 < i+1 ){
150              usage();
151              exit(1);
152            };
153            remfile = (TString)inps[i+1];  
154            remove = true;
155          };
156         if ( !strcmp(inps[i],"-cleanfrag") ) {
157            if ( numinp-1 < i+1 ){
158              usage();
159              exit(1);
160            };
161            fcleanfile = (TString)inps[i+1];        
162            forceclean = true;
163          };
164         if ( !strcmp(inps[i],"-validate") ) {
165            if ( numinp-1 < i+1 ){
166              usage();
167              exit(1);
168            };
169            validfile = (TString)inps[i+1];
170            validate = true;
171          };
172          if ( !strcmp(inps[i],"-gpamela") ) {
173            gpamela = true;
174          };
175          if ( !strcmp(inps[i],"-static") ) {
176            staticp = true;
177          };
178          if ( !strcmp(inps[i],"-autoboot") ) {
179            autoboot = true;
180          };
181          if ( !strcmp(inps[i],"-no-autoboot") ) {
182            autoboot = false;
183          };
184        if ( !strcmp(inps[i],"-boot") ) {        if ( !strcmp(inps[i],"-boot") ) {
185          if ( numinp-1 < i+1 ){          if ( numinp-1 < i+1 ){
186            usage();            usage();
# Line 91  int main(int numinp, char *inps[]){ Line 193  int main(int numinp, char *inps[]){
193            usage();            usage();
194            exit(1);            exit(1);
195          };          };
196          tsync = atoi(inps[i+1]);                  tsync = (UInt_t)atoll(inps[i+1]);      
197        };        };
198        if ( !strcmp(inps[i],"-obt0") ) {        if ( !strcmp(inps[i],"-obt0") ) {
199          if ( numinp-1 < i+1 ){          if ( numinp-1 < i+1 ){
200            usage();            usage();
201            exit(1);            exit(1);
202          };          };
203          obt0 = atoi(inps[i+1]);          obt0 = (UInt_t)atoll(inps[i+1]);        
204          };
205          if ( !strcmp(inps[i],"-dworbit") ) {
206            if ( numinp-1 < i+1 ){
207              usage();
208              exit(1);
209            };
210            dwinput = (UInt_t)atoll(inps[i+1]);    
211          };
212          if ( !strcmp(inps[i],"-clean") ) {
213            if ( numinp-1 < i+1 ){
214              usage();
215              exit(1);
216            };
217            olderthan = (Long64_t)atoll(inps[i+1]);
218        };        };
219        if ( !strcmp(inps[i],"-host") ) {        if ( !strcmp(inps[i],"-host") ) {
220          if ( numinp-1 < i+1 ){          if ( numinp-1 < i+1 ){
# Line 121  int main(int numinp, char *inps[]){ Line 237  int main(int numinp, char *inps[]){
237          };          };
238          password = (TString)inps[i+1];            password = (TString)inps[i+1];  
239        };        };
240          if ( !strcmp(inps[i],"-tle") ) {
241            if ( numinp-1 < i+1 ){
242              usage();
243              exit(1);
244            };
245            tlefilename = (TString)inps[i+1];
246          };
247        //        //
248        if ( !strcmp(inps[i],"-v") || !strcmp(inps[i],"--verbose") ) beverbose = true;        if ( !strcmp(inps[i],"-v") || !strcmp(inps[i],"--verbose") ) beverbose = true;
249        //        //
250          if ( !strcmp(inps[i],"-s") || !strcmp(inps[i],"--silent") ) beverbose = false;
251          //
252        if ( !strcmp(inps[i],"-g") || !strcmp(inps[i],"--debug") ) debug = true;        if ( !strcmp(inps[i],"-g") || !strcmp(inps[i],"--debug") ) debug = true;
253        //        //
254          if ( !strcmp(inps[i],"-f") || !strcmp(inps[i],"-force") ) force = true;
255          //
256          if ( !strcmp(inps[i],"-p") || !strcmp(inps[i],"--pedantic") ) pedantic = true;
257          //
258          if ( !strcmp(inps[i],"-nofrag") ) nofrag = true;
259          //
260          if ( !strcmp(inps[i],"-check") ) check = true;
261          //
262        i++;        i++;
263      };      };
264    } else {    } else {
# Line 146  int main(int numinp, char *inps[]){ Line 279  int main(int numinp, char *inps[]){
279      dup2(nul,2);      dup2(nul,2);
280    };    };
281    //    //
282    // Start:    if ( !strcmp(filerootname.Data(),"") ){
283        if ( (validate && !strcmp(validfile.Data(),"same")) ||
284             (remove && !strcmp(remfile.Data(),"same")) ||
285             (forceclean && !strcmp(fcleanfile.Data(),"same")) || force ){
286          printf("\n ERROR IN INPUT PARAMETERS \n");
287          usage();
288          exit(1);  
289        };
290      } else {
291        if ( validate && !strcmp(validfile.Data(),"same") ) validfile =  (TString)gSystem->BaseName(filerootname.Data());
292        if ( remove && !strcmp(remfile.Data(),"same") ) remfile =  (TString)gSystem->BaseName(filerootname.Data());
293        if ( forceclean && !strcmp(fcleanfile.Data(),"same") ) fcleanfile =  (TString)gSystem->BaseName(filerootname.Data());
294      };
295      //
296      if ( force ){
297        nofrag = true;
298        forceclean = true;
299        remove = true;
300        validate = true;    
301        fcleanfile = (TString)gSystem->BaseName(filerootname.Data());
302        remfile = fcleanfile;
303        validfile = fcleanfile;
304      };
305      //
306      const char *paml0 = gSystem->Getenv("PAM_L0");
307      const char *paml2 = gSystem->Getenv("PAM_L2");
308      const char *pamraw = gSystem->Getenv("PAM_RAW");
309      if ( !paml0 || !paml2 || !pamraw ){
310        printf(" WARNING: to use symbolic paths in DB you must set up PAM_L0, PAM_L2 and PAM_RAW env var!\n Using static paths\n");
311        staticp = true;
312      };
313      //
314      //
315      GL_TABLES *glt = new GL_TABLES(host,user,password);
316      //
317      if ( gpamela ){
318        //    //    -clean 0 -obt0 1 -tsync 1 -boot 1 -dworbit 1
319        //    -clean 0 -obt0 1 -dworbit 1
320        if ( olderthan < 0LL ) olderthan = 0LL;
321        if ( !obt0 ) obt0 = 1;
322        //    if ( !tsync ) tsync = 1;    
323        //    if ( !boot ) boot = 1;
324        if ( !dwinput ) dwinput = 1;
325        staticp = true;
326        autoboot = false;
327      };
328      //
329      if ( filerawname == "" && filerootname != "" ){
330        filerawname = "/not_given/"+(TString)gSystem->BaseName(filerootname.Data());
331        filerawname = filerawname.ReplaceAll(".root",5,".pam",4);
332        //    printf("filerawname %s \n",filerawname.Data());
333      };
334    //    //
335      // Start:
336    TString message;    TString message;
337    char *version = YodaProfilerInfo(false);    char *version = YodaProfilerInfo(false);
338    PamelaDBOperations *pamDB = 0;    PamelaDBOperations *pamDB = 0;
339    UInt_t sizeofwar = 10;    UInt_t sizeofwar = 12;
340    UInt_t WAR[10];    UInt_t WAR[12];
341    memset(WAR, 0, 10*sizeof(UInt_t));    memset(WAR, 0, sizeofwar*sizeof(UInt_t));
342    //    //
343    printf("\n Welcome to the PAMELA SuperYodaProfiler, version %s \n\n",version);    printf("\n Welcome to the PAMELA YodaProfiler, version %s \n\n",version);
344    try{    try{
345      //      //
346      //-------------------------------------------------------------------------------------------      //-------------------------------------------------------------------------------------------
347      // Create pamDB object and open SQL connection      // Create pamDB object and open SQL connection
348      //-------------------------------------------------------------------------------------------      //-------------------------------------------------------------------------------------------
349      if ( beverbose ) printf(" 1 => Create pamDB object and open SQL connection \n");      if ( beverbose ) printf(" 1 => Initialize and open SQL connection \n");
350      pamDB = new PamelaDBOperations(host,user,password,filerawname,filerootname,boot,tsync,obt0,debug);      pamDB = new PamelaDBOperations(host,user,password,filerawname,filerootname,boot,tsync,obt0,debug,tlefilename,dwinput,staticp,gpamela);
351      pamDB->CheckFile();      pamDB->CheckConnection();
352      //-------------------------------------------------------------------------------------------      //-------------------------------------------------------------------------------------------
353      //      //
354      //-------------------------------------------------------------------------------------------      pamDB->SetNoFrag(nofrag);
355      //Insert a Raw file in GL_RAW      pamDB->SetAutoBoot(autoboot);
356      //-------------------------------------------------------------------------------------------      pamDB->SetPedantic(pedantic);
     if ( beverbose ) printf(" 2 => Insert a RAW file in GL_RAW \n");  
     WAR[0] = pamDB->insertPamelaRawFile();  
     //-------------------------------------------------------------------------------------------  
     //-------------------------------------------------------------------------------------------    
     //Update a single GL_RAW record with its BOOT_NUMBER  
     //-------------------------------------------------------------------------------------------  
     if ( beverbose ) printf(" 3 => Update a single GL_RAW record with its BOOT_NUMBER \n");  
     WAR[3] = pamDB->assignBOOT_NUMBER();  
     //    if ( WAR[3] ) pamDB->SetNOBOOT(true);  
     if ( WAR[3] && WAR[3] != 1 ) throw -9;  
     //-------------------------------------------------------------------------------------------  
357      //      //
358      //-------------------------------------------------------------------------------------------      if ( remove ){
359      //Insert an entry in GL_TIMESYNC        //-------------------------------------------------------------------------------------------
360      //-------------------------------------------------------------------------------------------        // Remove a file and, on cascade, all that follows from the DB
361      if ( beverbose ) printf(" 4 => Insert an entry in GL_TIMESYNC \n");        //-------------------------------------------------------------------------------------------
362      WAR[1] = pamDB->insertPamelaGL_TIMESYNC();        if ( beverbose ) printf(" X => Remove file %s from DB \n",((TString)gSystem->BaseName(remfile)).Data());
363      //-------------------------------------------------------------------------------------------        WAR[11] = pamDB->removeFile((TString)gSystem->BaseName(remfile.Data()));
364      //        //-------------------------------------------------------------------------------------------
365      //-------------------------------------------------------------------------------------------      };    
366      //Insert unpack ROOT file in GL_ROOT        //
367      //-------------------------------------------------------------------------------------------      if( pamDB->InsertRaw() ){
368      if ( beverbose ) printf(" 5 => Insert unpack ROOT file in GL_ROOT \n");        //-------------------------------------------------------------------------------------------
369      WAR[2] = pamDB->insertPamelaRootFile();        //Insert a Raw file in GL_RAW
370      //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
371          if ( beverbose ) printf(" 2 => Insert a RAW file in GL_RAW \n");
372          WAR[0] = pamDB->insertPamelaRawFile();
373          //-------------------------------------------------------------------------------------------
374        };
375      //      //
376        if( pamDB->InsertRoot() ){
377          //          
378          if( !pamDB->InsertRaw() )printf("=> RAW file not inserted --- the DB might not ( yet ) be filled correctly \n");
379          pamDB->CheckFile();
380          //
381          //-------------------------------------------------------------------------------------------
382          //Insert an entry in GL_TIMESYNC
383          //-------------------------------------------------------------------------------------------
384          if ( beverbose ) printf(" 3 => Insert an entry in GL_TIMESYNC \n");
385          WAR[1] = pamDB->insertPamelaGL_TIMESYNC();
386          //-------------------------------------------------------------------------------------------
387          //
388          //-------------------------------------------------------------------------------------------  
389          //Update a single GL_RAW record with its BOOT_NUMBER
390          //-------------------------------------------------------------------------------------------
391          if ( beverbose ) printf(" 4 => Update a single GL_RAW record with its BOOT_NUMBER \n");
392          WAR[3] = pamDB->assignBOOT_NUMBER();
393          if ( WAR[3] && WAR[3] != 1 && WAR[3] != 8 ) throw -9;
394          //-------------------------------------------------------------------------------------------
395          //
396          //-------------------------------------------------------------------------------------------
397          //Insert unpack ROOT file in GL_ROOT  
398          //-------------------------------------------------------------------------------------------
399          if ( beverbose ) printf(" 5 => Insert unpack ROOT file in GL_ROOT \n");
400          WAR[2] = pamDB->insertPamelaRootFile();
401          //-------------------------------------------------------------------------------------------
402          //
403          //-------------------------------------------------------------------------------------------      
404          //Insert in GL_RUN runs information records relative to a single unpack
405          //-------------------------------------------------------------------------------------------
406          if ( beverbose ) printf(" 6 => Scan physics and store runs in the GL_RUN table\n");
407          WAR[4] = pamDB->insertPamelaRUN();
408          //-------------------------------------------------------------------------------------------    
409            
410          //-------------------------------------------------------------------------------------------
411          //Insert in GL_CALO_CALIB calibration information records relative to a single unpack
412          //-------------------------------------------------------------------------------------------
413          if ( beverbose ) printf(" 7 => Insert calorimeter calibrations in the GL_CALO_CALIB table\n");
414          WAR[5] = pamDB->insertCALO_CALIB();
415          //-------------------------------------------------------------------------------------------    
416    
417      //-------------------------------------------------------------------------------------------              if ( !gpamela ){
418      //Insert in GL_RUN runs information records relative to a single unpack          //---------------------------------------------------------------------------------------------------------------------
419      //-------------------------------------------------------------------------------------------          //Insert in GL_CALOPULSE_CALIB calibration PULSE information records relative to a single unpack (only for real data!)
420      if ( beverbose ) printf(" 6 => Scan physics and store runs in the GL_RUN table\n");          //---------------------------------------------------------------------------------------------------------------------
421      WAR[4] = pamDB->insertPamelaRUN();          if ( beverbose ) printf(" 7b => Insert calorimeter pulse calibrations in the GL_CALOPULSE_CALIB table\n");
422      //-------------------------------------------------------------------------------------------              WAR[5] += pamDB->insertCALOPULSE_CALIB();
423            //-------------------------------------------------------------------------------------------    
424      //-------------------------------------------------------------------------------------------        };
     //Insert in GL_CALO_CALIB calibration information records relative to a single unpack  
     //-------------------------------------------------------------------------------------------  
     if ( beverbose ) printf(" 7 => Insert calorimeter calibrations in the GL_CALO_CALIB table\n");  
     WAR[5] = pamDB->insertCALO_CALIB();  
     //-------------------------------------------------------------------------------------------      
425    
426      //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
427      //Insert in GL_TRK_CALIB calibration information records relative to a single unpack        //Insert in GL_TRK_CALIB calibration information records relative to a single unpack
428      //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
429      if ( beverbose ) printf(" 8 => Insert tracker calibrations in the GL_TRK_CALIB table\n");        if ( beverbose ) printf(" 8 => Insert tracker calibrations in the GL_TRK_CALIB table\n");
430      WAR[6] = pamDB->insertTRK_CALIB();        WAR[6] = pamDB->insertTRK_CALIB();
431      //-------------------------------------------------------------------------------------------            //-------------------------------------------------------------------------------------------    
432            
433          //-------------------------------------------------------------------------------------------
434          //Insert in GL_S4_CALIB calibration information records relative to a single unpack
435          //-------------------------------------------------------------------------------------------
436          if ( beverbose ) printf(" 9 => Insert S4 calibrations in the GL_S4_CALIB table\n");
437          WAR[7] = pamDB->insertS4_CALIB();
438          //-------------------------------------------------------------------------------------------    
439        };
440        //
441        if ( forceclean ){
442          //-------------------------------------------------------------------------------------------
443          //Clean the GL_RUN_FRAGMENTS for the given file
444          //-------------------------------------------------------------------------------------------
445          if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table for file %s \n",fcleanfile.Data());
446          WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS((TString)gSystem->BaseName(fcleanfile.Data()));
447        };
448        //
449        //
450        if ( validate ){
451          //-------------------------------------------------------------------------------------------
452          //Validate runs
453          //-------------------------------------------------------------------------------------------
454          if ( beverbose ) printf(" 11 => Validate runs table for file %s \n",validfile.Data());
455          WAR[9] = pamDB->ValidateRuns((TString)gSystem->BaseName(validfile.Data()));
456          //-------------------------------------------------------------------------------------------    
457        };
458        //
459        pamDB->CheckValidate(olderthan);
460        //
461        if( pamDB->Validate() ){  
462          //-------------------------------------------------------------------------------------------
463          //Clean the GL_RUN_FRAGMENTS
464          //-------------------------------------------------------------------------------------------
465          if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table (earlier than %s) \n",pamDB->GetCleanTime() );
466          WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS();
467          //-------------------------------------------------------------------------------------------    
468          //-------------------------------------------------------------------------------------------
469          //Validate runs
470          //-------------------------------------------------------------------------------------------
471          if ( beverbose ) printf(" 11 => Validate runs (earlier than %s)\n",pamDB->GetCleanTime());
472          WAR[9] = pamDB->ValidateRuns();
473          //-------------------------------------------------------------------------------------------    
474        };
475    
476      //-------------------------------------------------------------------------------------------      if(! tlefilename.IsNull() ) {
477      //Insert in GL_S4_CALIB calibration information records relative to a single unpack        //----------------------------------------------
478      //-------------------------------------------------------------------------------------------        //Populate GL_TLE table using the file provided
479      if ( beverbose ) printf(" 9 => Insert S4 calibrations in the GL_S4_CALIB table\n");        //----------------------------------------------
480      WAR[7] = pamDB->insertS4_CALIB();        if ( beverbose ) printf(" 12 => Insert TLE elements in the GL_TLE table from file %s \n",tlefilename.Data());
481      //-------------------------------------------------------------------------------------------            WAR[10] = pamDB->populateTLE();
482        }
483    
484        if ( check ){
485          //----------------------------------------------
486          //Check GL_RUN table consistency
487          //----------------------------------------------
488          if ( beverbose ) printf(" 13 => Check GL_RUN table consistency\n");
489          UInt_t ch = pamDB->Check();
490          if ( !ch ){
491            printf(" GL_RUN table seems ok!\n");
492          } else {
493            printf(" Problems found in the GL_RUN table!\n");
494          };
495        };
496            
497    } catch (Int_t exc) {    } catch (Int_t exc) {
498      signal = exc;      signal = exc;
499      switch(exc){      switch(exc){
# Line 233  int main(int numinp, char *inps[]){ Line 503  int main(int numinp, char *inps[]){
503      case -4: message += " Error querying DB"; break;      case -4: message += " Error querying DB"; break;
504      case -5: message += " Inconsistent OBT/pkt_num"; break;      case -5: message += " Inconsistent OBT/pkt_num"; break;
505      case -6: message += " The file is not in the database"; break;      case -6: message += " The file is not in the database"; break;
506        case -7: message += " Cannot open TLE file"; break;
507      case -8: message += " Event file is empty"; break;      case -8: message += " Event file is empty"; break;
508      case -9: message += " No VarDump no BOOT number, use the -boot option to override"; break;      case -9: message += " No VarDump no BOOT number, use the -boot option to override"; break;
509      case -10: message += " No results from DB"; break;      case -10: message += " No results from DB"; break;
# Line 250  int main(int numinp, char *inps[]){ Line 521  int main(int numinp, char *inps[]){
521      case -22: message += " No CalibTrk1 tree in Level0 file"; break;      case -22: message += " No CalibTrk1 tree in Level0 file"; break;
522      case -23: message += " No CalibTrk2 tree in Level0 file"; break;      case -23: message += " No CalibTrk2 tree in Level0 file"; break;
523      case -24: message += " No CalibS4 tree in Level0 file"; break;      case -24: message += " No CalibS4 tree in Level0 file"; break;
524      case -97: message += " Missing runheader not recognized by HandleRun method"; break;      case -25: message += " Cannot find the run just inserted"; break;
525      case -99: message += " THIS CASE HAS NOT YET BEEN IMPLEMENTED"; break;      case -26: message += " Raw file not found looking for VarDump"; break;
526        case -27: message += " Cannot determine downlink orbit, wrong filename format?"; break;
527        case -28: message += " Cannot assign a RUN ID unique number!"; break;
528        case -29: message += " No VarDump and impossible to find a consistent BOOT number, use the -boot option to override"; break;
529        case -30: message += " Old database selected, no GL_CALOPULSE_CALIB table in the DB!"; break;
530        case -31: message += " No CalibCalPulse1 tree in Level0 file"; break;
531        case -32: message += " No CalibCalPulse2 tree in Level0 file"; break;
532        case -66: message += " PEDANTIC: REPETITION"; break;
533        case -67: message += " PEDANTIC: TIMESYNC ALREADY INSERTED"; break;
534        case -68: message += " PEDANTIC: NO TIMESYNC IN THE FILE"; break;
535        case -69: message += " PEDANTIC: RUN FRAGMENT ALREADY INSERTED"; break;
536        case -70: message += " PEDANTIC: RUN ALREADY INSERTED"; break;
537        case -71: message += " PEDANTIC: OVERLAPPING RUNS (FIRST)"; break;
538        case -72: message += " PEDANTIC: OVERLAPPING RUNS (LAST)"; break;
539        case -73: message += " PEDANTIC: CALO CALIB ALREADY INSERTED"; break;
540        case -74: message += " PEDANTIC: CALO CALIB REPEATED"; break;
541        case -75: message += " PEDANTIC: CALOPULSE1 CALIB ALREADY INSERTED"; break;
542        case -76: message += " PEDANTIC: CALOPULSE1 CALIB REPEATED"; break;
543        case -77: message += " PEDANTIC: CALOPULSE2 CALIB ALREADY INSERTED"; break;
544        case -78: message += " PEDANTIC: CALOPULSE2 CALIB REPEATED"; break;
545        case -79: message += " PEDANTIC: TRK1 CALIB REPEATED"; break;
546        case -80: message += " PEDANTIC: TRK CALIB ALREADY INSERTED"; break;
547        case -81: message += " PEDANTIC: S4 CALIB ALREADY INSERTED"; break;
548        case -82: message += " PEDANTIC: S4 CALIB REPEATED"; break;
549        case -83: message += " PEDANTIC: CLEANING ERROR, RUN ALREADY INSERTED IN THE GL_RUN TABLE"; break;
550      default: message += " Unidentified error"; break;      default: message += " Unidentified error"; break;
551      };      };
552      printf("\n");      printf("\n");
# Line 271  int main(int numinp, char *inps[]){ Line 566  int main(int numinp, char *inps[]){
566          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
567            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
568              if ( bit == 0 ) message += "=> RAW file already inserted\n";              if ( bit == 0 ) message += "=> RAW file already inserted\n";
569              else message += "=> Unidentified warning\n";              else message += "=> Unidentified insertPamelaRaw warning\n";
570            };            };
571          };          };
572        };        };
# Line 280  int main(int numinp, char *inps[]){ Line 575  int main(int numinp, char *inps[]){
575          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
576            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
577              if ( bit == 0 ) message += "=> TIMESYNC already inserted\n";              if ( bit == 0 ) message += "=> TIMESYNC already inserted\n";
578              if ( bit == 1 ) message += "=> No mcmd timesync in the file\n";              else if ( bit == 1 ) message += "=> No mcmd timesync in the file\n";
579              else  message += "=> Unidentified warning\n";              else if ( bit == 2 ) message += "=> No runheaders in the file\n";
580                else if ( bit == 3 ) message += "=> No runtrailers in the file\n";
581                else if ( bit == 4 ) message += "=> No mcmd inclination in the file\n";
582                else if ( bit == 5 ) message += "=> Inconsistent PKT/OBT sequence\n";
583                else if ( bit == 6 ) message += "=> No physics events in the file\n";
584                else if ( bit == 7 ) message += "=> Less than 2 physics events in the file\n";
585                else  message += "=> Unidentified insertTimeSync warning\n";
586            };            };
587          };          };
588        };        };
# Line 290  int main(int numinp, char *inps[]){ Line 591  int main(int numinp, char *inps[]){
591          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
592            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
593              if ( bit == 0 ) message += "=> ROOT file already inserted\n";              if ( bit == 0 ) message += "=> ROOT file already inserted\n";
594              else message += "=> Unidentified warning\n";              else message += "=> Unidentified insertPamelaRoot warning\n";
595            };            };
596          };          };
597        };        };
# Line 298  int main(int numinp, char *inps[]){ Line 599  int main(int numinp, char *inps[]){
599        if ( j == 3 ){ // assignBOOTnumber warnings        if ( j == 3 ){ // assignBOOTnumber warnings
600          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
601            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
602              if ( bit == 0 ) message += "=> BOOT number already inserted\n";              if ( bit == 0 ) message += "=> BOOT number already inserted\n";//
603              if ( bit == 1 ) message += "=> VarDump event tree is empty, use the -boot option to override\n";              else if ( bit == 1 ) message += "=> VarDump event tree is empty, use the -boot option to override\n";//
604              if ( bit == 2 ) message += "=> No BOOT number in VarDump(!), use the -boot option to override\n";              else if ( bit == 2 ) message += "=> No BOOT number in VarDump(!), use the -boot option to override\n";//
605              if ( bit == 3 ) message += "=> Raw file not found looking for VarDump, use the -boot option to override\n";              else if ( bit == 3 ) message += "=> No VarDump! autoboot option used\n";//
606              if ( bit == 4 ) message += "=> The file is not in the database looking for VarDump, use the -boot option to override\n";              else if ( bit == 4 ) message += "=> The file is not in the database looking for VarDump, use the -boot option to override\n";//
607              else message += "=> Unidentified warning\n";              else message += "=> Unidentified assignBOOTnumber warning\n";
608            };            };
609          };          };
610        };        };
# Line 311  int main(int numinp, char *inps[]){ Line 612  int main(int numinp, char *inps[]){
612        if ( j == 4 ){ // insertPamelaRUN        if ( j == 4 ){ // insertPamelaRUN
613          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
614            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
615              if      ( bit == 0 ) message += "=> bah already inserted\n";              if      ( bit == 0 ) message += "=> Inconsistent PKT/OBT sequence\n";
616              else if ( bit == 1 ) message += "=> boh already inserted\n";              else if ( bit == 1 ) message += "=> No physics events in the file\n";
617              else  message += "=> Unidentified warning\n";              else if ( bit == 2 ) message += "=> Less than 2 physics events in the file\n";
618                else if ( bit == 3 ) message += "=> Not supported yet: run with no events, no runtrailer, no runheader\n";
619                else if ( bit == 4 ) message += "=> File with no events, no runtrailers, no runheaders\n";
620                else  message += "=> Unidentified insertPamelaRun warning\n";
621            };            };
622          };          };
623        };        };
# Line 321  int main(int numinp, char *inps[]){ Line 625  int main(int numinp, char *inps[]){
625        if ( j == 5 ){ // insertCALO_CALIB        if ( j == 5 ){ // insertCALO_CALIB
626          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
627            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
628              if      ( bit == 0 ) message += "=> bah already inserted\n";              if      ( bit == 0 ) message += "=> No calorimeter calibrations in the file\n";
629              else if ( bit == 1 ) message += "=> boh already inserted\n";              else  message += "=> Unidentified insertCaloCalib warning\n";
             else  message += "=> Unidentified warning\n";  
630            };            };
631          };          };
632        };        };
# Line 332  int main(int numinp, char *inps[]){ Line 635  int main(int numinp, char *inps[]){
635        if ( j == 6 ){ // insertTRACKER_CALIB        if ( j == 6 ){ // insertTRACKER_CALIB
636          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
637            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
638              if      ( bit == 0 ) message += "=> bah already inserted\n";              if      ( bit == 0 ) message += "=> No tracker calibrations in the file\n";
639              else if ( bit == 1 ) message += "=> boh already inserted\n";              else  message += "=> Unidentified insertTrkCalib warning\n";
             else  message += "=> Unidentified warning\n";  
640            };            };
641          };          };
642        };        };
# Line 343  int main(int numinp, char *inps[]){ Line 645  int main(int numinp, char *inps[]){
645        if ( j == 7 ){ // insertS4_CALIB        if ( j == 7 ){ // insertS4_CALIB
646          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
647            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
648              if      ( bit == 0 ) message += "=> bah already inserted\n";              if      ( bit == 0 ) message += "=> No s4 calibrations in the file\n";
649              else if ( bit == 1 ) message += "=> boh already inserted\n";              else  message += "=> Unidentified insertS4calib warning\n";
650              else  message += "=> Unidentified warning\n";            };
651            };
652          };
653          //
654          //
655          if ( j == 8 ){ // CleanGL_RUN_FRAGMENTS
656            for (UInt_t bit=0; bit<32; bit++){
657              if ( WAR[j] & (1 << bit) ){
658                if      ( bit == 0 ) message += "=> Skip the GL_RUN_FRAGMENTS table cleaning\n";
659                if      ( bit == 1 ) message += "=> Problems retrieving ROOT ID from DB\n";
660                else  message += "=> Unidentified CleanGL_RUN_FRAGMENTS warning\n";
661              };
662            };
663          };
664          //
665          if ( j == 9 ){ // ValidateRuns
666            for (UInt_t bit=0; bit<32; bit++){
667              if ( WAR[j] & (1 << bit) ){
668                if      ( bit == 0 ) message += "=> Skip the run validation \n";
669                if      ( bit == 1 ) message += "=> Problems retrieving ROOT ID from DB\n";
670                else  message += "=> Unidentified ValidateRuns warning\n";
671            };            };
672          };          };
673        };        };
674        //        //
675          if ( j == 10 ){ // populateTLE
676            for (UInt_t bit=0; bit<32; bit++){
677              if ( WAR[j] & (1 << bit) ){
678                if      ( bit == 0 ) message += "=> TLE insertion failed\n";
679                if      ( bit == 1 ) message += "=> No new TLE available\n";
680                else  message += "=> Unidentified populateTle warning\n";
681              };
682            };
683          };
684          //
685          if ( j == 11 ){ // removeFile
686            for (UInt_t bit=0; bit<32; bit++){
687              if ( WAR[j] & (1 << bit) ){
688                if      ( bit == 0 ) message += "=> No file to delete from DB \n";
689                else  message += "=> Unidentified populateTle warning\n";
690              };
691            };
692          };
693      };      };
694    };    };
695    //    //
# Line 363  int main(int numinp, char *inps[]){ Line 703  int main(int numinp, char *inps[]){
703    //---------------------------------------------------------------------------------------    //---------------------------------------------------------------------------------------
704    // Close and exit    // Close and exit
705    //---------------------------------------------------------------------------------------    //---------------------------------------------------------------------------------------
706      if ( beverbose ) printf(" 13 => Free objects and close SQL connection \n");
707    pamDB->Close();    pamDB->Close();
708    //    //
709      if ( debug ) printf(" Total number of queries through GLTABLES: %u \n",glt->GetNqueries());
710      delete glt;
711      //
712    printf("\n");    printf("\n");
713    printf(" Finished, exiting...\n");    printf(" Finished, exiting...\n");
714    printf("\n");    printf("\n");
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.27
  ViewVC Help
Powered by ViewVC 1.1.23