/[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.2 by mocchiut, Fri Sep 1 12:47:13 2006 UTC revision 1.26 by mocchiut, Thu Oct 25 13:23:37 2007 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 16  void usage(){ Line 17  void usage(){
17    printf("\nUsage:\n");    printf("\nUsage:\n");
18    printf("\n YodaProfiler [options] -rawFile raw_filename -yodaFile yoda_filename \n");    printf("\n YodaProfiler [options] -rawFile raw_filename -yodaFile yoda_filename \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 Options can be: \n");    printf("\n Options are:\n\n");
22    printf("\n --version       print informations about compilation and exit\n");    printf(" --version       print informations about compilation and exit\n");
23    printf("\n -h | --help     print this help and exit \n");    printf(" -h | --help     print this help and exit \n");
24    printf("\n -v | --verbose  be verbose [default: print nothing on STDOUT]\n");    printf(" -v | --verbose  be verbose [default]\n");
25    printf("\n -g | --debug    be very verbose [default: no]\n");    printf(" -s | --silent   print nothing on STDOUT\n");
26    printf("\n -boot number    CPU boot number [default = taken from VarDump]\n");    printf(" -g | --debug    be very verbose [default: no]\n");
27    printf("\n -tsync number   timesync (s) [default = taken from data]\n");    printf(" -boot number    CPU boot number [default = taken from VarDump]\n");
28    printf("\n -obt0 number    obt at timesync (ms) [default = taken from data]\n");    printf(" -autoboot       if no VarDump found try to determine the BOOT number\n");
29    printf("\n -clean number   number in seconds after which the fragment table\n");    printf("                 looking at timesync [default]\n");
30    printf("\n                 can be cleaned and runs validated [default = 864000 (10 days)],\n");    printf(" -no-autoboot    disable previous check\n");
31    printf("\n                 if 0 force cleaning immediatly, if negative do not clean\n");    printf(" -tsync number   timesync (s) [default = taken from data]\n");
32    printf("\n -host           name for the host [default = mysql://localhost/pamelaprod]\n");    printf(" -obt0 number    obt at timesync (ms) [default = taken from data]\n");
33    printf("\n -user           username for the DB [default = anonymous] \n");    printf(" -dworbit number number is the downlink orbit number (to be used with non-standard names)\n");
34    printf("\n -psw            password for the DB [default = \"\"]\n");    printf(" -static         use static path inside the DB instead of symbolic names\n");
35      //  printf(" -gpamela        shortcut to \"-clean 0 -obt0 1 -tsync 1 -no-autoboot -boot 1 -dworbit 1 -static\"\n");
36      printf(" -gpamela        shortcut to \"-clean 0 -obt0 1 -no-autoboot -dworbit 1 -static\"\n");
37      printf(" -clean number   number in seconds after which the fragment table\n");
38      printf("                 can be cleaned and runs validated [default = -1 do not clean],\n");
39      printf("                 if 0 force cleaning immediatly, if negative do not clean\n");
40      printf(" -remove file    remove file and all related runs and calibrations from DB\n");
41      printf("                 file must be the YODA filename (full path is not needed)\n");
42      printf("                 'same' can be used if in conjuction with -yodaFile\n");
43      printf(" -validate file  validates runs between the two closest calibration to file \n");
44      printf("                 not belonging to file itself. File must be the YODA filename\n");
45      printf("                 'same' can be used if in conjuction with -yodaFile\n");
46      printf(" -cleanfrag file clean run fragments for file only\n");
47      printf("                 File must be the YODA filename\n");
48      printf("                 'same' can be used if in conjuction with -yodaFile\n");
49      printf(" -nofrag         do not leave runs in the fragment table and look for fragments\n");
50      printf("                 in the GL_RUN table.\n");
51      printf(" -force          to be used to reprocess a file or to process a file\n");
52      printf("                 when already validated the surroundings, it is equivalent to:\n");
53      printf("                 -remove same -validate same -cleanfrag same -nofrag\n");
54      printf(" -check          performs some test on the GL_RUN table to check its consistency\n");
55      printf(" -host           name of the DB host [default = $PAM_DBHOST or mysql://localhost/pamelaprod]\n");
56      printf(" -user           username for the DB connection [default = $PAM_DBUSER or \"anonymous\"] \n");
57      printf(" -psw            password for the DB connection [default = $PAM_DBPSW or \"\"]\n");
58      printf(" -tle <file>     ascii file containing TLE obtained from celestrak.org or space-track.org [default = no]\n");
59    printf("\n The order of input files and options does not matter. \n");    printf("\n The order of input files and options does not matter. \n");
60    printf("\nExample: \n");    printf("\n Example: \n");
61    printf("\n YodaProfiler -yodaFile /path/to/raw/files/000_000_00000_cln2.pam -rawFile /path/to/filesfromyoda/000_000_00000_cln2.root -v \n\n");    printf(" YodaProfiler -yodaFile /path/to/raw/files/000_000_00000_cln2.root -rawFile /path/to/filesfromyoda/000_000_00000_cln2.pam -v \n\n");
62  };  };
63  //  //
64  int main(int numinp, char *inps[]){  int main(int numinp, char *inps[]){
# Line 45  int main(int numinp, char *inps[]){ Line 70  int main(int numinp, char *inps[]){
70    UInt_t boot = 0;    UInt_t boot = 0;
71    UInt_t tsync = 0;    UInt_t tsync = 0;
72    UInt_t obt0 = 0;    UInt_t obt0 = 0;
73    Long64_t olderthan = 864000LL;    UInt_t dwinput = 0;
74      Long64_t olderthan = -1LL;  
75    //    //
76    //    //
77    TString filerawname;    TString filerawname  = "";
78      TString filerootname = "";
79    //    //
80    TString host;    TString host = "mysql://localhost/pamelaprod";
81    TString user;    TString user = "anonymous";
82    TString password;    TString password = "";
83      //
84      TString tlefilename = "";
85      //
86      const char *pamdbhost = gSystem->Getenv("PAM_DBHOST");
87      const char *pamdbuser = gSystem->Getenv("PAM_DBUSER");
88      const char *pamdbpsw = gSystem->Getenv("PAM_DBPSW");
89      if ( !pamdbhost ) pamdbhost = "";
90      if ( !pamdbuser ) pamdbuser = "";
91      if ( !pamdbpsw ) pamdbpsw = "";
92      if ( strcmp(pamdbhost,"") ) host = pamdbhost;
93      if ( strcmp(pamdbuser,"") ) user = pamdbuser;
94      if ( strcmp(pamdbpsw,"") ) password = pamdbpsw;
95    //    //
   TString filerootname;  
96    //        //    
97    Bool_t beverbose = false;    Bool_t staticp = false;
98      Bool_t beverbose = true;
99    Bool_t debug = false;    Bool_t debug = false;
100      Bool_t autoboot = true;
101      Bool_t gpamela = false;
102      //
103      Bool_t remove = false;
104      TString remfile = "";
105      //
106      Bool_t forceclean = false;
107      TString fcleanfile = "";
108      //
109      Bool_t validate = false;
110      TString validfile = "";
111      //
112      Bool_t nofrag = false;
113      //
114      Bool_t force = false;
115      //
116      Bool_t check = false;
117      //
118    Int_t i = 0;    Int_t i = 0;
119    //    //
120    if ( numinp > 1 ){    if ( numinp > 1 ){
# Line 67  int main(int numinp, char *inps[]){ Line 124  int main(int numinp, char *inps[]){
124          exit(0);          exit(0);
125        };        };
126        if ( !strcmp(inps[i],"-h") || !strcmp(inps[i],"--help") ){        if ( !strcmp(inps[i],"-h") || !strcmp(inps[i],"--help") ){
127    
128          usage();          usage();
129          exit(0);          exit(0);
130        };        };
# Line 84  int main(int numinp, char *inps[]){ Line 142  int main(int numinp, char *inps[]){
142          };          };
143          filerootname = (TString)inps[i+1];                filerootname = (TString)inps[i+1];      
144        };        };
145          if ( !strcmp(inps[i],"-remove") ) {
146            if ( numinp-1 < i+1 ){
147              usage();
148              exit(1);
149            };
150            remfile = (TString)inps[i+1];  
151            remove = true;
152          };
153         if ( !strcmp(inps[i],"-cleanfrag") ) {
154            if ( numinp-1 < i+1 ){
155              usage();
156              exit(1);
157            };
158            fcleanfile = (TString)inps[i+1];        
159            forceclean = true;
160          };
161         if ( !strcmp(inps[i],"-validate") ) {
162            if ( numinp-1 < i+1 ){
163              usage();
164              exit(1);
165            };
166            validfile = (TString)inps[i+1];
167            validate = true;
168          };
169          if ( !strcmp(inps[i],"-gpamela") ) {
170            gpamela = true;
171          };
172          if ( !strcmp(inps[i],"-static") ) {
173            staticp = true;
174          };
175          if ( !strcmp(inps[i],"-autoboot") ) {
176            autoboot = true;
177          };
178          if ( !strcmp(inps[i],"-no-autoboot") ) {
179            autoboot = false;
180          };
181        if ( !strcmp(inps[i],"-boot") ) {        if ( !strcmp(inps[i],"-boot") ) {
182          if ( numinp-1 < i+1 ){          if ( numinp-1 < i+1 ){
183            usage();            usage();
# Line 105  int main(int numinp, char *inps[]){ Line 199  int main(int numinp, char *inps[]){
199          };          };
200          obt0 = (UInt_t)atoll(inps[i+1]);                  obt0 = (UInt_t)atoll(inps[i+1]);        
201        };        };
202          if ( !strcmp(inps[i],"-dworbit") ) {
203            if ( numinp-1 < i+1 ){
204              usage();
205              exit(1);
206            };
207            dwinput = (UInt_t)atoll(inps[i+1]);    
208          };
209        if ( !strcmp(inps[i],"-clean") ) {        if ( !strcmp(inps[i],"-clean") ) {
210          if ( numinp-1 < i+1 ){          if ( numinp-1 < i+1 ){
211            usage();            usage();
# Line 133  int main(int numinp, char *inps[]){ Line 234  int main(int numinp, char *inps[]){
234          };          };
235          password = (TString)inps[i+1];            password = (TString)inps[i+1];  
236        };        };
237          if ( !strcmp(inps[i],"-tle") ) {
238            if ( numinp-1 < i+1 ){
239              usage();
240              exit(1);
241            };
242            tlefilename = (TString)inps[i+1];
243          };
244        //        //
245        if ( !strcmp(inps[i],"-v") || !strcmp(inps[i],"--verbose") ) beverbose = true;        if ( !strcmp(inps[i],"-v") || !strcmp(inps[i],"--verbose") ) beverbose = true;
246        //        //
247          if ( !strcmp(inps[i],"-s") || !strcmp(inps[i],"--silent") ) beverbose = false;
248          //
249        if ( !strcmp(inps[i],"-g") || !strcmp(inps[i],"--debug") ) debug = true;        if ( !strcmp(inps[i],"-g") || !strcmp(inps[i],"--debug") ) debug = true;
250        //        //
251          if ( !strcmp(inps[i],"-f") || !strcmp(inps[i],"-force") ) force = true;
252          //
253          if ( !strcmp(inps[i],"-nofrag") ) nofrag = true;
254          //
255          if ( !strcmp(inps[i],"-check") ) check = true;
256          //
257        i++;        i++;
258      };      };
259    } else {    } else {
# Line 158  int main(int numinp, char *inps[]){ Line 274  int main(int numinp, char *inps[]){
274      dup2(nul,2);      dup2(nul,2);
275    };    };
276    //    //
277    // Start:    if ( !strcmp(filerootname.Data(),"") ){
278        if ( (validate && !strcmp(validfile.Data(),"same")) ||
279             (remove && !strcmp(remfile.Data(),"same")) ||
280             (forceclean && !strcmp(fcleanfile.Data(),"same")) || force ){
281          printf("\n ERROR IN INPUT PARAMETERS \n");
282          usage();
283          exit(1);  
284        };
285      } else {
286        if ( validate && !strcmp(validfile.Data(),"same") ) validfile =  (TString)gSystem->BaseName(filerootname.Data());
287        if ( remove && !strcmp(remfile.Data(),"same") ) remfile =  (TString)gSystem->BaseName(filerootname.Data());
288        if ( forceclean && !strcmp(fcleanfile.Data(),"same") ) fcleanfile =  (TString)gSystem->BaseName(filerootname.Data());
289      };
290      //
291      if ( force ){
292        nofrag = true;
293        forceclean = true;
294        remove = true;
295        validate = true;    
296        fcleanfile = (TString)gSystem->BaseName(filerootname.Data());
297        remfile = fcleanfile;
298        validfile = fcleanfile;
299      };
300      //
301      const char *paml0 = gSystem->Getenv("PAM_L0");
302      const char *paml2 = gSystem->Getenv("PAM_L2");
303      const char *pamraw = gSystem->Getenv("PAM_RAW");
304      if ( !paml0 || !paml2 || !pamraw ){
305        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");
306        staticp = true;
307      };
308      //
309      //
310      GL_TABLES *glt = new GL_TABLES(host,user,password);
311      //
312      if ( gpamela ){
313        //    //    -clean 0 -obt0 1 -tsync 1 -boot 1 -dworbit 1
314        //    -clean 0 -obt0 1 -dworbit 1
315        if ( olderthan < 0LL ) olderthan = 0LL;
316        if ( !obt0 ) obt0 = 1;
317        //    if ( !tsync ) tsync = 1;    
318        //    if ( !boot ) boot = 1;
319        if ( !dwinput ) dwinput = 1;
320        staticp = true;
321        autoboot = false;
322      };
323      //
324      if ( filerawname == "" && filerootname != "" ){
325        filerawname = "/not_given/"+(TString)gSystem->BaseName(filerootname.Data());
326        filerawname = filerawname.ReplaceAll(".root",5,".pam",4);
327        //    printf("filerawname %s \n",filerawname.Data());
328      };
329    //    //
330      // Start:
331    TString message;    TString message;
332    char *version = YodaProfilerInfo(false);    char *version = YodaProfilerInfo(false);
333    PamelaDBOperations *pamDB = 0;    PamelaDBOperations *pamDB = 0;
334    UInt_t sizeofwar = 10;    UInt_t sizeofwar = 12;
335    UInt_t WAR[10];    UInt_t WAR[12];
336    memset(WAR, 0, 10*sizeof(UInt_t));    memset(WAR, 0, sizeofwar*sizeof(UInt_t));
337    //    //
338    printf("\n Welcome to the PAMELA YodaProfiler, version %s \n\n",version);    printf("\n Welcome to the PAMELA YodaProfiler, version %s \n\n",version);
339    try{    try{
# Line 174  int main(int numinp, char *inps[]){ Line 342  int main(int numinp, char *inps[]){
342      // Create pamDB object and open SQL connection      // Create pamDB object and open SQL connection
343      //-------------------------------------------------------------------------------------------      //-------------------------------------------------------------------------------------------
344      if ( beverbose ) printf(" 1 => Initialize and open SQL connection \n");      if ( beverbose ) printf(" 1 => Initialize and open SQL connection \n");
345      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);
346      pamDB->CheckFile();      pamDB->CheckConnection();
     pamDB->SetOlderThan(olderthan);  
     //-------------------------------------------------------------------------------------------  
     //  
     //-------------------------------------------------------------------------------------------  
     //Insert a Raw file in GL_RAW  
     //-------------------------------------------------------------------------------------------  
     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;  
347      //-------------------------------------------------------------------------------------------      //-------------------------------------------------------------------------------------------
348      //      //
349      //-------------------------------------------------------------------------------------------      pamDB->SetNoFrag(nofrag);
350      //Insert an entry in GL_TIMESYNC      pamDB->SetAutoBoot(autoboot);
     //-------------------------------------------------------------------------------------------  
     if ( beverbose ) printf(" 4 => Insert an entry in GL_TIMESYNC \n");  
     WAR[1] = pamDB->insertPamelaGL_TIMESYNC();  
     //-------------------------------------------------------------------------------------------  
351      //      //
352      //-------------------------------------------------------------------------------------------      if ( remove ){
353      //Insert unpack ROOT file in GL_ROOT          //-------------------------------------------------------------------------------------------
354      //-------------------------------------------------------------------------------------------        // Remove a file and, on cascade, all that follows from the DB
355      if ( beverbose ) printf(" 5 => Insert unpack ROOT file in GL_ROOT \n");        //-------------------------------------------------------------------------------------------
356      WAR[2] = pamDB->insertPamelaRootFile();        if ( beverbose ) printf(" X => Remove file %s from DB \n",((TString)gSystem->BaseName(remfile)).Data());
357      //-------------------------------------------------------------------------------------------        WAR[11] = pamDB->removeFile((TString)gSystem->BaseName(remfile.Data()));
358          //-------------------------------------------------------------------------------------------
359        };    
360        //
361        if( pamDB->InsertRaw() ){
362          //-------------------------------------------------------------------------------------------
363          //Insert a Raw file in GL_RAW
364          //-------------------------------------------------------------------------------------------
365          if ( beverbose ) printf(" 2 => Insert a RAW file in GL_RAW \n");
366          WAR[0] = pamDB->insertPamelaRawFile();
367          //-------------------------------------------------------------------------------------------
368        };
369      //      //
370        if( pamDB->InsertRoot() ){
371          //          
372          if( !pamDB->InsertRaw() )printf("=> RAW file not inserted --- the DB might not ( yet ) be filled correctly \n");
373          pamDB->CheckFile();
374          //
375          //-------------------------------------------------------------------------------------------
376          //Insert an entry in GL_TIMESYNC
377          //-------------------------------------------------------------------------------------------
378          if ( beverbose ) printf(" 3 => Insert an entry in GL_TIMESYNC \n");
379          WAR[1] = pamDB->insertPamelaGL_TIMESYNC();
380          //-------------------------------------------------------------------------------------------
381          //
382          //-------------------------------------------------------------------------------------------  
383          //Update a single GL_RAW record with its BOOT_NUMBER
384          //-------------------------------------------------------------------------------------------
385          if ( beverbose ) printf(" 4 => Update a single GL_RAW record with its BOOT_NUMBER \n");
386          WAR[3] = pamDB->assignBOOT_NUMBER();
387          if ( WAR[3] && WAR[3] != 1 && WAR[3] != 8 ) throw -9;
388          //-------------------------------------------------------------------------------------------
389          //
390          //-------------------------------------------------------------------------------------------
391          //Insert unpack ROOT file in GL_ROOT  
392          //-------------------------------------------------------------------------------------------
393          if ( beverbose ) printf(" 5 => Insert unpack ROOT file in GL_ROOT \n");
394          WAR[2] = pamDB->insertPamelaRootFile();
395          //-------------------------------------------------------------------------------------------
396          //
397          //-------------------------------------------------------------------------------------------      
398          //Insert in GL_RUN runs information records relative to a single unpack
399          //-------------------------------------------------------------------------------------------
400          if ( beverbose ) printf(" 6 => Scan physics and store runs in the GL_RUN table\n");
401          WAR[4] = pamDB->insertPamelaRUN();
402          //-------------------------------------------------------------------------------------------    
403            
404          //-------------------------------------------------------------------------------------------
405          //Insert in GL_CALO_CALIB calibration information records relative to a single unpack
406          //-------------------------------------------------------------------------------------------
407          if ( beverbose ) printf(" 7 => Insert calorimeter calibrations in the GL_CALO_CALIB table\n");
408          WAR[5] = pamDB->insertCALO_CALIB();
409          //-------------------------------------------------------------------------------------------    
410    
411      //-------------------------------------------------------------------------------------------              if ( !gpamela ){
412      //Insert in GL_RUN runs information records relative to a single unpack          //---------------------------------------------------------------------------------------------------------------------
413      //-------------------------------------------------------------------------------------------          //Insert in GL_CALOPULSE_CALIB calibration PULSE information records relative to a single unpack (only for real data!)
414      if ( beverbose ) printf(" 6 => Scan physics and store runs in the GL_RUN table\n");          //---------------------------------------------------------------------------------------------------------------------
415      WAR[4] = pamDB->insertPamelaRUN();          if ( beverbose ) printf(" 7b => Insert calorimeter pulse calibrations in the GL_CALOPULSE_CALIB table\n");
416      //-------------------------------------------------------------------------------------------              WAR[5] += pamDB->insertCALOPULSE_CALIB();
417            //-------------------------------------------------------------------------------------------    
418      //-------------------------------------------------------------------------------------------        };
     //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();  
     //-------------------------------------------------------------------------------------------      
   
     //-------------------------------------------------------------------------------------------  
     //Insert in GL_TRK_CALIB calibration information records relative to a single unpack  
     //-------------------------------------------------------------------------------------------  
     if ( beverbose ) printf(" 8 => Insert tracker calibrations in the GL_TRK_CALIB table\n");  
     WAR[6] = pamDB->insertTRK_CALIB();  
     //-------------------------------------------------------------------------------------------      
419    
420      //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
421      //Insert in GL_S4_CALIB calibration information records relative to a single unpack        //Insert in GL_TRK_CALIB calibration information records relative to a single unpack
422      //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
423      if ( beverbose ) printf(" 9 => Insert S4 calibrations in the GL_S4_CALIB table\n");        if ( beverbose ) printf(" 8 => Insert tracker calibrations in the GL_TRK_CALIB table\n");
424      WAR[7] = pamDB->insertS4_CALIB();        WAR[6] = pamDB->insertTRK_CALIB();
425      //-------------------------------------------------------------------------------------------            //-------------------------------------------------------------------------------------------    
426            
427          //-------------------------------------------------------------------------------------------
428          //Insert in GL_S4_CALIB calibration information records relative to a single unpack
429          //-------------------------------------------------------------------------------------------
430          if ( beverbose ) printf(" 9 => Insert S4 calibrations in the GL_S4_CALIB table\n");
431          WAR[7] = pamDB->insertS4_CALIB();
432          //-------------------------------------------------------------------------------------------    
433        };
434        //
435        if ( forceclean ){
436          //-------------------------------------------------------------------------------------------
437          //Clean the GL_RUN_FRAGMENTS for the given file
438          //-------------------------------------------------------------------------------------------
439          if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table for file %s \n",fcleanfile.Data());
440          WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS((TString)gSystem->BaseName(fcleanfile.Data()));
441        };
442        //
443        //
444        if ( validate ){
445          //-------------------------------------------------------------------------------------------
446          //Validate runs
447          //-------------------------------------------------------------------------------------------
448          if ( beverbose ) printf(" 11 => Validate runs table for file %s \n",validfile.Data());
449          WAR[9] = pamDB->ValidateRuns((TString)gSystem->BaseName(validfile.Data()));
450          //-------------------------------------------------------------------------------------------    
451        };
452        //
453        pamDB->CheckValidate(olderthan);
454        //
455        if( pamDB->Validate() ){  
456          //-------------------------------------------------------------------------------------------
457          //Clean the GL_RUN_FRAGMENTS
458          //-------------------------------------------------------------------------------------------
459          if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table (earlier than %s) \n",pamDB->GetCleanTime() );
460          WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS();
461          //-------------------------------------------------------------------------------------------    
462          //-------------------------------------------------------------------------------------------
463          //Validate runs
464          //-------------------------------------------------------------------------------------------
465          if ( beverbose ) printf(" 11 => Validate runs (earlier than %s)\n",pamDB->GetCleanTime());
466          WAR[9] = pamDB->ValidateRuns();
467          //-------------------------------------------------------------------------------------------    
468        };
469    
470      //-------------------------------------------------------------------------------------------      if(! tlefilename.IsNull() ) {
471      //Clean the GL_RUN_FRAGMENTS        //----------------------------------------------
472      //-------------------------------------------------------------------------------------------        //Populate GL_TLE table using the file provided
473      if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table\n");        //----------------------------------------------
474      WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS();        if ( beverbose ) printf(" 12 => Insert TLE elements in the GL_TLE table from file %s \n",tlefilename.Data());
475      //-------------------------------------------------------------------------------------------            WAR[10] = pamDB->populateTLE();
476        }
477    
478      //-------------------------------------------------------------------------------------------      if ( check ){
479      //Validate runs        //----------------------------------------------
480      //-------------------------------------------------------------------------------------------        //Check GL_RUN table consistency
481      if ( beverbose ) printf(" 11 => Validate runs\n");        //----------------------------------------------
482      WAR[9] = pamDB->ValidateRuns();        if ( beverbose ) printf(" 13 => Check GL_RUN table consistency\n");
483      //-------------------------------------------------------------------------------------------            UInt_t ch = pamDB->Check();
484              if ( !ch ){
485            printf(" GL_RUN table seems ok!\n");
486          } else {
487            printf(" Problems found in the GL_RUN table!\n");
488          };
489        };
490            
491    } catch (Int_t exc) {    } catch (Int_t exc) {
492      signal = exc;      signal = exc;
493      switch(exc){      switch(exc){
# Line 260  int main(int numinp, char *inps[]){ Line 497  int main(int numinp, char *inps[]){
497      case -4: message += " Error querying DB"; break;      case -4: message += " Error querying DB"; break;
498      case -5: message += " Inconsistent OBT/pkt_num"; break;      case -5: message += " Inconsistent OBT/pkt_num"; break;
499      case -6: message += " The file is not in the database"; break;      case -6: message += " The file is not in the database"; break;
500        case -7: message += " Cannot open TLE file"; break;
501      case -8: message += " Event file is empty"; break;      case -8: message += " Event file is empty"; break;
502      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;
503      case -10: message += " No results from DB"; break;      case -10: message += " No results from DB"; break;
# Line 279  int main(int numinp, char *inps[]){ Line 517  int main(int numinp, char *inps[]){
517      case -24: message += " No CalibS4 tree in Level0 file"; break;      case -24: message += " No CalibS4 tree in Level0 file"; break;
518      case -25: message += " Cannot find the run just inserted"; break;      case -25: message += " Cannot find the run just inserted"; break;
519      case -26: message += " Raw file not found looking for VarDump"; break;      case -26: message += " Raw file not found looking for VarDump"; break;
520        case -27: message += " Cannot determine downlink orbit, wrong filename format?"; break;
521        case -28: message += " Cannot assign a RUN ID unique number!"; break;
522        case -29: message += " No VarDump and impossible to find a consistent BOOT number, use the -boot option to override"; break;
523        case -30: message += " Old database selected, no GL_CALOPULSE_CALIB table in the DB!"; break;
524        case -31: message += " No CalibCalPulse1 tree in Level0 file"; break;
525        case -32: message += " No CalibCalPulse2 tree in Level0 file"; break;
526      default: message += " Unidentified error"; break;      default: message += " Unidentified error"; break;
527      };      };
528      printf("\n");      printf("\n");
# Line 311  int main(int numinp, char *inps[]){ Line 555  int main(int numinp, char *inps[]){
555              else if ( bit == 2 ) message += "=> No runheaders in the file\n";              else if ( bit == 2 ) message += "=> No runheaders in the file\n";
556              else if ( bit == 3 ) message += "=> No runtrailers in the file\n";              else if ( bit == 3 ) message += "=> No runtrailers in the file\n";
557              else if ( bit == 4 ) message += "=> No mcmd inclination in the file\n";              else if ( bit == 4 ) message += "=> No mcmd inclination in the file\n";
558                else if ( bit == 5 ) message += "=> Inconsistent PKT/OBT sequence\n";
559                else if ( bit == 6 ) message += "=> No physics events in the file\n";
560                else if ( bit == 7 ) message += "=> Less than 2 physics events in the file\n";
561              else  message += "=> Unidentified insertTimeSync warning\n";              else  message += "=> Unidentified insertTimeSync warning\n";
562            };            };
563          };          };
# Line 331  int main(int numinp, char *inps[]){ Line 578  int main(int numinp, char *inps[]){
578              if ( bit == 0 ) message += "=> BOOT number already inserted\n";//              if ( bit == 0 ) message += "=> BOOT number already inserted\n";//
579              else 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";//
580              else 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";//
581                else if ( bit == 3 ) message += "=> No VarDump! autoboot option used\n";//
582              else 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";//
583              else message += "=> Unidentified assignBOOTnumber warning\n";              else message += "=> Unidentified assignBOOTnumber warning\n";
584            };            };
# Line 343  int main(int numinp, char *inps[]){ Line 591  int main(int numinp, char *inps[]){
591              if      ( bit == 0 ) message += "=> Inconsistent PKT/OBT sequence\n";              if      ( bit == 0 ) message += "=> Inconsistent PKT/OBT sequence\n";
592              else if ( bit == 1 ) message += "=> No physics events in the file\n";              else if ( bit == 1 ) message += "=> No physics events in the file\n";
593              else if ( bit == 2 ) message += "=> Less than 2 physics events in the file\n";              else if ( bit == 2 ) message += "=> Less than 2 physics events in the file\n";
594                else if ( bit == 3 ) message += "=> Not supported yet: run with no events, no runtrailer, no runheader\n";
595                else if ( bit == 4 ) message += "=> File with no events, no runtrailers, no runheaders\n";
596              else  message += "=> Unidentified insertPamelaRun warning\n";              else  message += "=> Unidentified insertPamelaRun warning\n";
597            };            };
598          };          };
# Line 382  int main(int numinp, char *inps[]){ Line 632  int main(int numinp, char *inps[]){
632          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
633            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
634              if      ( bit == 0 ) message += "=> Skip the GL_RUN_FRAGMENTS table cleaning\n";              if      ( bit == 0 ) message += "=> Skip the GL_RUN_FRAGMENTS table cleaning\n";
635                if      ( bit == 1 ) message += "=> Problems retrieving ROOT ID from DB\n";
636              else  message += "=> Unidentified CleanGL_RUN_FRAGMENTS warning\n";              else  message += "=> Unidentified CleanGL_RUN_FRAGMENTS warning\n";
637            };            };
638          };          };
# Line 391  int main(int numinp, char *inps[]){ Line 642  int main(int numinp, char *inps[]){
642          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
643            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
644              if      ( bit == 0 ) message += "=> Skip the run validation \n";              if      ( bit == 0 ) message += "=> Skip the run validation \n";
645                if      ( bit == 1 ) message += "=> Problems retrieving ROOT ID from DB\n";
646              else  message += "=> Unidentified ValidateRuns warning\n";              else  message += "=> Unidentified ValidateRuns warning\n";
647            };            };
648          };          };
649        };        };
650          //
651          if ( j == 10 ){ // populateTLE
652            for (UInt_t bit=0; bit<32; bit++){
653              if ( WAR[j] & (1 << bit) ){
654                if      ( bit == 0 ) message += "=> TLE insertion failed\n";
655                if      ( bit == 1 ) message += "=> No new TLE available\n";
656                else  message += "=> Unidentified populateTle warning\n";
657              };
658            };
659          };
660          //
661          if ( j == 11 ){ // removeFile
662            for (UInt_t bit=0; bit<32; bit++){
663              if ( WAR[j] & (1 << bit) ){
664                if      ( bit == 0 ) message += "=> No file to delete from DB \n";
665                else  message += "=> Unidentified populateTle warning\n";
666              };
667            };
668          };
669      };      };
670    };    };
671    //    //
# Line 408  int main(int numinp, char *inps[]){ Line 679  int main(int numinp, char *inps[]){
679    //---------------------------------------------------------------------------------------    //---------------------------------------------------------------------------------------
680    // Close and exit    // Close and exit
681    //---------------------------------------------------------------------------------------    //---------------------------------------------------------------------------------------
682    if ( beverbose ) printf(" 12 => Free objects and close SQL connection \n");    if ( beverbose ) printf(" 13 => Free objects and close SQL connection \n");
683    pamDB->Close();    pamDB->Close();
684    //    //
685      if ( debug ) printf(" Total number of queries through GLTABLES: %u \n",glt->GetNqueries());
686      delete glt;
687      //
688    printf("\n");    printf("\n");
689    printf(" Finished, exiting...\n");    printf(" Finished, exiting...\n");
690    printf("\n");    printf("\n");
Legend:
Removed from v.1.2  
changed lines
  Added in v.1.26
  ViewVC Help
Powered by ViewVC 1.1.23