| 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 | 
 // | 
 // | 
| 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]\n"); | 
   printf(" -v | --verbose  be verbose [default]\n"); | 
| 25 | 
   printf("\n -s | --silent   print nothing on STDOUT\n"); | 
   printf(" -s | --silent   print nothing on STDOUT\n"); | 
| 26 | 
   printf("\n -g | --debug    be very verbose [default: no]\n"); | 
   printf(" -g | --debug    be very verbose [default: no]\n"); | 
| 27 | 
   printf("\n -boot number    CPU boot number [default = taken from VarDump]\n"); | 
   printf(" -boot number    CPU boot number [default = taken from VarDump]\n"); | 
| 28 | 
   printf("\n -autoboot       if no VarDump found try to determine the BOOT number\n"); | 
   printf(" -autoboot       if no VarDump found try to determine the BOOT number\n"); | 
| 29 | 
   printf("\n                 looking at timesync [default]\n"); | 
   printf("                 looking at timesync [default]\n"); | 
| 30 | 
   printf("\n -no-autoboot    disable previous check\n"); | 
   printf(" -no-autoboot    disable previous check\n"); | 
| 31 | 
   printf("\n -tsync number   timesync (s) [default = taken from data]\n"); | 
   printf(" -tsync number   timesync (s) [default = taken from data]\n"); | 
| 32 | 
   printf("\n -obt0 number    obt at timesync (ms) [default = taken from data]\n"); | 
   printf(" -obt0 number    obt at timesync (ms) [default = taken from data]\n"); | 
| 33 | 
   printf("\n -clean number   number in seconds after which the fragment table\n"); | 
   printf(" -dworbit number number is the downlink orbit number (to be used with non-standard names)\n"); | 
| 34 | 
   printf("\n                 can be cleaned and runs validated [default = -1 do not clean],\n"); | 
   printf(" -static         use static path inside the DB instead of symbolic names\n"); | 
| 35 | 
   printf("\n                 if 0 force cleaning immediatly, if negative do not clean\n"); | 
   printf(" -gpamela        shortcut to \"-clean 0 -obt0 1 -tsync 1 -no-autoboot -boot 1 -dworbit 1 -static\"\n"); | 
| 36 | 
 // | 
   printf(" -clean number   number in seconds after which the fragment table\n"); | 
| 37 | 
   printf("\n -remove file    remove file and all related runs and calibrations from DB\n"); | 
   printf("                 can be cleaned and runs validated [default = -1 do not clean],\n"); | 
| 38 | 
   printf("\n                 file must be the YODA filename (full path is not needed)\n"); | 
   printf("                 if 0 force cleaning immediatly, if negative do not clean\n"); | 
| 39 | 
   printf("\n                 'same' can be used if in conjuction with -yodaFile\n"); | 
   printf(" -remove file    remove file and all related runs and calibrations from DB\n"); | 
| 40 | 
   printf("\n -validate file  validates runs between the two closest calibration to file \n"); | 
   printf("                 file must be the YODA filename (full path is not needed)\n"); | 
| 41 | 
   printf("\n                 not belonging to file itself. File must be the YODA filename\n"); | 
   printf("                 'same' can be used if in conjuction with -yodaFile\n"); | 
| 42 | 
   printf("\n                 'same' can be used if in conjuction with -yodaFile\n"); | 
   printf(" -validate file  validates runs between the two closest calibration to file \n"); | 
| 43 | 
   printf("\n -cleanfrag file clean run fragments for file only\n"); | 
   printf("                 not belonging to file itself. File must be the YODA filename\n"); | 
| 44 | 
   printf("\n                 File must be the YODA filename\n"); | 
   printf("                 'same' can be used if in conjuction with -yodaFile\n"); | 
| 45 | 
   printf("\n                 'same' can be used if in conjuction with -yodaFile\n"); | 
   printf(" -cleanfrag file clean run fragments for file only\n"); | 
| 46 | 
   printf("\n -nofrag         do not leave runs in the fragment table and look for fragments\n"); | 
   printf("                 File must be the YODA filename\n"); | 
| 47 | 
   printf("\n                 in the GL_RUN table.\n"); | 
   printf("                 'same' can be used if in conjuction with -yodaFile\n"); | 
| 48 | 
   printf("\n -force          to be used to reprocess a file or to process a file\n"); | 
   printf(" -nofrag         do not leave runs in the fragment table and look for fragments\n"); | 
| 49 | 
   printf("\n                 when already validated the surroundings, it is equivalent to:\n"); | 
   printf("                 in the GL_RUN table.\n"); | 
| 50 | 
   printf("\n                 -remove same -validate same -cleanfrag same -nofrag\n"); | 
   printf(" -force          to be used to reprocess a file or to process a file\n"); | 
| 51 | 
 //       | 
   printf("                 when already validated the surroundings, it is equivalent to:\n"); | 
| 52 | 
   printf("\n -host           name for the host [default = $PAM_DBHOST or mysql://localhost/pamelaprod]\n"); | 
   printf("                 -remove same -validate same -cleanfrag same -nofrag\n"); | 
| 53 | 
   printf("\n -user           username for the DB [default = $PAM_DBUSER or \"anonymous\"] \n"); | 
   printf(" -check          performs some test on the GL_RUN table to check its consistency\n"); | 
| 54 | 
   printf("\n -psw            password for the DB [default = $PAM_DBPSW or \"\"]\n"); | 
   printf(" -host           name of the DB host [default = $PAM_DBHOST or mysql://localhost/pamelaprod]\n"); | 
| 55 | 
   printf("\n -tle <file>     ascii file containing TLE obtained from celestrak.org or space-track.org [default = no]\n"); | 
   printf(" -user           username for the DB connection [default = $PAM_DBUSER or \"anonymous\"] \n"); | 
| 56 | 
  | 
   printf(" -psw            password for the DB connection [default = $PAM_DBPSW or \"\"]\n"); | 
| 57 | 
  | 
   printf(" -tle <file>     ascii file containing TLE obtained from celestrak.org or space-track.org [default = no]\n"); | 
| 58 | 
   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"); | 
| 59 | 
   printf("\nExample: \n"); | 
   printf("\n Example: \n"); | 
| 60 | 
   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"); | 
| 61 | 
 }; | 
 }; | 
| 62 | 
 // | 
 // | 
| 63 | 
 int main(int numinp, char *inps[]){ | 
 int main(int numinp, char *inps[]){ | 
| 69 | 
   UInt_t boot = 0; | 
   UInt_t boot = 0; | 
| 70 | 
   UInt_t tsync = 0; | 
   UInt_t tsync = 0; | 
| 71 | 
   UInt_t obt0 = 0; | 
   UInt_t obt0 = 0; | 
| 72 | 
  | 
   UInt_t dwinput = 0; | 
| 73 | 
   Long64_t olderthan = -1LL;   | 
   Long64_t olderthan = -1LL;   | 
| 74 | 
   // | 
   // | 
| 75 | 
   // | 
   // | 
| 93 | 
   if ( strcmp(pamdbpsw,"") ) password = pamdbpsw; | 
   if ( strcmp(pamdbpsw,"") ) password = pamdbpsw; | 
| 94 | 
   // | 
   // | 
| 95 | 
   //     | 
   //     | 
| 96 | 
  | 
   Bool_t staticp = false;  | 
| 97 | 
   Bool_t beverbose = true; | 
   Bool_t beverbose = true; | 
| 98 | 
   Bool_t debug = false; | 
   Bool_t debug = false; | 
| 99 | 
   Bool_t autoboot = true; | 
   Bool_t autoboot = true; | 
| 100 | 
  | 
   Bool_t gpamela = false; | 
| 101 | 
   //  | 
   //  | 
| 102 | 
   Bool_t remove = false; | 
   Bool_t remove = false; | 
| 103 | 
   TString remfile = ""; | 
   TString remfile = ""; | 
| 112 | 
   // | 
   // | 
| 113 | 
   Bool_t force = false; | 
   Bool_t force = false; | 
| 114 | 
   // | 
   // | 
| 115 | 
  | 
   Bool_t check = false; | 
| 116 | 
  | 
   // | 
| 117 | 
   Int_t i = 0; | 
   Int_t i = 0; | 
| 118 | 
   // | 
   // | 
| 119 | 
   if ( numinp > 1 ){ | 
   if ( numinp > 1 ){ | 
| 165 | 
         validfile = (TString)inps[i+1];  | 
         validfile = (TString)inps[i+1];  | 
| 166 | 
         validate = true; | 
         validate = true; | 
| 167 | 
       }; | 
       }; | 
| 168 | 
  | 
       if ( !strcmp(inps[i],"-gpamela") ) { | 
| 169 | 
  | 
         gpamela = true; | 
| 170 | 
  | 
       }; | 
| 171 | 
  | 
       if ( !strcmp(inps[i],"-static") ) { | 
| 172 | 
  | 
         staticp = true; | 
| 173 | 
  | 
       }; | 
| 174 | 
       if ( !strcmp(inps[i],"-autoboot") ) { | 
       if ( !strcmp(inps[i],"-autoboot") ) { | 
| 175 | 
         autoboot = true; | 
         autoboot = true; | 
| 176 | 
       }; | 
       }; | 
| 198 | 
         }; | 
         }; | 
| 199 | 
         obt0 = (UInt_t)atoll(inps[i+1]);         | 
         obt0 = (UInt_t)atoll(inps[i+1]);         | 
| 200 | 
       }; | 
       }; | 
| 201 | 
  | 
       if ( !strcmp(inps[i],"-dworbit") ) { | 
| 202 | 
  | 
         if ( numinp-1 < i+1 ){ | 
| 203 | 
  | 
           usage(); | 
| 204 | 
  | 
           exit(1); | 
| 205 | 
  | 
         }; | 
| 206 | 
  | 
         dwinput = (UInt_t)atoll(inps[i+1]);      | 
| 207 | 
  | 
       }; | 
| 208 | 
       if ( !strcmp(inps[i],"-clean") ) { | 
       if ( !strcmp(inps[i],"-clean") ) { | 
| 209 | 
         if ( numinp-1 < i+1 ){ | 
         if ( numinp-1 < i+1 ){ | 
| 210 | 
           usage(); | 
           usage(); | 
| 251 | 
       // | 
       // | 
| 252 | 
       if ( !strcmp(inps[i],"-nofrag") ) nofrag = true; | 
       if ( !strcmp(inps[i],"-nofrag") ) nofrag = true; | 
| 253 | 
       // | 
       // | 
| 254 | 
  | 
       if ( !strcmp(inps[i],"-check") ) check = true; | 
| 255 | 
  | 
       // | 
| 256 | 
       i++; | 
       i++; | 
| 257 | 
     }; | 
     }; | 
| 258 | 
   } else { | 
   } else { | 
| 296 | 
     remfile = fcleanfile; | 
     remfile = fcleanfile; | 
| 297 | 
     validfile = fcleanfile; | 
     validfile = fcleanfile; | 
| 298 | 
   }; | 
   }; | 
| 299 | 
  | 
  | 
| 300 | 
  | 
   const char *paml0 = gSystem->Getenv("PAM_L0"); | 
| 301 | 
  | 
   const char *paml2 = gSystem->Getenv("PAM_L2"); | 
| 302 | 
  | 
   const char *pamraw = gSystem->Getenv("PAM_RAW"); | 
| 303 | 
  | 
   if ( !paml0 || !paml2 || !pamraw ){ | 
| 304 | 
  | 
     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"); | 
| 305 | 
  | 
     staticp = true; | 
| 306 | 
  | 
   }; | 
| 307 | 
  | 
   if ( gpamela ){ | 
| 308 | 
  | 
     //    -clean 0 -obt0 1 -tsync 1 -boot 1 -dworbit 1 | 
| 309 | 
  | 
     if ( olderthan < 0LL ) olderthan = 0LL; | 
| 310 | 
  | 
     if ( !obt0 ) obt0 = 1; | 
| 311 | 
  | 
     if ( !tsync ) tsync = 1; | 
| 312 | 
  | 
     if ( !boot ) boot = 1; | 
| 313 | 
  | 
     if ( !dwinput ) dwinput = 1; | 
| 314 | 
  | 
     staticp = true; | 
| 315 | 
  | 
     autoboot = false; | 
| 316 | 
  | 
   }; | 
| 317 | 
  | 
   // | 
| 318 | 
  | 
   if ( filerawname == "" && filerootname != "" ){ | 
| 319 | 
  | 
     filerawname = "/not_given/"+(TString)gSystem->BaseName(filerootname.Data()); | 
| 320 | 
  | 
     filerawname = filerawname.ReplaceAll(".root",5,".pam",4); | 
| 321 | 
  | 
     //    printf("filerawname %s \n",filerawname.Data()); | 
| 322 | 
  | 
   }; | 
| 323 | 
   // | 
   // | 
| 324 | 
   // Start: | 
   // Start: | 
| 325 | 
   // | 
   // | 
| 326 | 
  | 
   GL_TABLES *glt = new GL_TABLES(host,user,password); | 
| 327 | 
  | 
   // | 
| 328 | 
   TString message; | 
   TString message; | 
| 329 | 
   char *version = YodaProfilerInfo(false); | 
   char *version = YodaProfilerInfo(false); | 
| 330 | 
   PamelaDBOperations *pamDB = 0; | 
   PamelaDBOperations *pamDB = 0; | 
| 339 | 
     // Create pamDB object and open SQL connection | 
     // Create pamDB object and open SQL connection | 
| 340 | 
     //------------------------------------------------------------------------------------------- | 
     //------------------------------------------------------------------------------------------- | 
| 341 | 
     if ( beverbose ) printf(" 1 => Initialize and open SQL connection \n"); | 
     if ( beverbose ) printf(" 1 => Initialize and open SQL connection \n"); | 
| 342 | 
     pamDB = new PamelaDBOperations(host,user,password,filerawname,filerootname,boot,tsync,obt0,debug,tlefilename); | 
     pamDB = new PamelaDBOperations(host,user,password,filerawname,filerootname,boot,tsync,obt0,debug,tlefilename,dwinput,staticp); | 
| 343 | 
     pamDB->CheckConnection(); | 
     pamDB->CheckConnection(); | 
| 344 | 
     //------------------------------------------------------------------------------------------- | 
     //------------------------------------------------------------------------------------------- | 
| 345 | 
     // | 
     // | 
| 462 | 
       if ( beverbose ) printf(" 12 => Insert TLE elements in the GL_TLE table from file %s \n",tlefilename.Data()); | 
       if ( beverbose ) printf(" 12 => Insert TLE elements in the GL_TLE table from file %s \n",tlefilename.Data()); | 
| 463 | 
       WAR[10] = pamDB->populateTLE(); | 
       WAR[10] = pamDB->populateTLE(); | 
| 464 | 
     } | 
     } | 
| 465 | 
  | 
  | 
| 466 | 
  | 
     if ( check ){ | 
| 467 | 
  | 
       //---------------------------------------------- | 
| 468 | 
  | 
       //Check GL_RUN table consistency  | 
| 469 | 
  | 
       //---------------------------------------------- | 
| 470 | 
  | 
       if ( beverbose ) printf(" 13 => Check GL_RUN table consistency\n"); | 
| 471 | 
  | 
       UInt_t ch = pamDB->Check(); | 
| 472 | 
  | 
       if ( !ch ){ | 
| 473 | 
  | 
         printf(" GL_RUN table seems ok!\n"); | 
| 474 | 
  | 
       } else { | 
| 475 | 
  | 
         printf(" Problems found in the GL_RUN table!\n"); | 
| 476 | 
  | 
       }; | 
| 477 | 
  | 
     }; | 
| 478 | 
          | 
          | 
| 479 | 
   } catch (Int_t exc) { | 
   } catch (Int_t exc) { | 
| 480 | 
     signal = exc; | 
     signal = exc; | 
| 662 | 
   if ( beverbose ) printf(" 13 => Free objects and close SQL connection \n"); | 
   if ( beverbose ) printf(" 13 => Free objects and close SQL connection \n"); | 
| 663 | 
   pamDB->Close(); | 
   pamDB->Close(); | 
| 664 | 
   // | 
   // | 
| 665 | 
  | 
   if ( debug ) printf(" Total number of queries through GLTABLES: %u \n",glt->GetNqueries()); | 
| 666 | 
  | 
   delete glt; | 
| 667 | 
  | 
   // | 
| 668 | 
   printf("\n"); | 
   printf("\n"); | 
| 669 | 
   printf(" Finished, exiting...\n"); | 
   printf(" Finished, exiting...\n"); | 
| 670 | 
   printf("\n"); | 
   printf("\n"); |