/[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.6 by mocchiut, Mon Sep 11 19:52:42 2006 UTC revision 1.24 by mocchiut, Mon Apr 30 15:57:07 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]\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 -tsync number   timesync (s) [default = taken from data]\n");    printf(" -autoboot       if no VarDump found try to determine the BOOT number\n");
29    printf("\n -obt0 number    obt at timesync (ms) [default = taken from data]\n");    printf("                 looking at timesync [default]\n");
30    printf("\n -clean number   number in seconds after which the fragment table\n");    printf(" -no-autoboot    disable previous check\n");
31    printf("\n                 can be cleaned and runs validated [default = -1 do not clean],\n");    printf(" -tsync number   timesync (s) [default = taken from data]\n");
32    printf("\n                 if 0 force cleaning immediatly, if negative do not clean\n");    printf(" -obt0 number    obt at timesync (ms) [default = taken from data]\n");
33    printf("\n -host           name for the host [default = $PAM_DBHOST or mysql://localhost/pamelaprod]\n");    printf(" -dworbit number number is the downlink orbit number (to be used with non-standard names)\n");
34    printf("\n -user           username for the DB [default = $PAM_DBUSER or \"anonymous\"] \n");    printf(" -static         use static path inside the DB instead of symbolic names\n");
35    printf("\n -psw            password for the DB [default = $PAM_DBPSW or \"\"]\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("                 can be cleaned and runs validated [default = -1 do not clean],\n");
38      printf("                 if 0 force cleaning immediatly, if negative do not clean\n");
39      printf(" -remove file    remove file and all related runs and calibrations from DB\n");
40      printf("                 file must be the YODA filename (full path is not needed)\n");
41      printf("                 'same' can be used if in conjuction with -yodaFile\n");
42      printf(" -validate file  validates runs between the two closest calibration to file \n");
43      printf("                 not belonging to file itself. File must be the YODA filename\n");
44      printf("                 'same' can be used if in conjuction with -yodaFile\n");
45      printf(" -cleanfrag file clean run fragments for file only\n");
46      printf("                 File must be the YODA filename\n");
47      printf("                 'same' can be used if in conjuction with -yodaFile\n");
48      printf(" -nofrag         do not leave runs in the fragment table and look for fragments\n");
49      printf("                 in the GL_RUN table.\n");
50      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("                 -remove same -validate same -cleanfrag same -nofrag\n");
53      printf(" -check          performs some test on the GL_RUN table to check its consistency\n");
54      printf(" -host           name of the DB host [default = $PAM_DBHOST or mysql://localhost/pamelaprod]\n");
55      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[]){
# Line 46  int main(int numinp, char *inps[]){ Line 69  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    //  Long64_t olderthan = 864000LL;    UInt_t dwinput = 0;
73    Long64_t olderthan = -1LL;    Long64_t olderthan = -1LL;  
     
74    //    //
75    //    //
76    TString filerawname  = "";    TString filerawname  = "";
# Line 58  int main(int numinp, char *inps[]){ Line 80  int main(int numinp, char *inps[]){
80    TString user = "anonymous";    TString user = "anonymous";
81    TString password = "";    TString password = "";
82    //    //
83    const char *pamdbhost=gSystem->Getenv("PAM_DBHOST");    TString tlefilename = "";
84    const char *pamdbuser=gSystem->Getenv("PAM_DBUSER");    //
85    const char *pamdbpsw=gSystem->Getenv("PAM_DBPSW");    const char *pamdbhost = gSystem->Getenv("PAM_DBHOST");
86      const char *pamdbuser = gSystem->Getenv("PAM_DBUSER");
87      const char *pamdbpsw = gSystem->Getenv("PAM_DBPSW");
88      if ( !pamdbhost ) pamdbhost = "";
89      if ( !pamdbuser ) pamdbuser = "";
90      if ( !pamdbpsw ) pamdbpsw = "";
91    if ( strcmp(pamdbhost,"") ) host = pamdbhost;    if ( strcmp(pamdbhost,"") ) host = pamdbhost;
92    if ( strcmp(pamdbuser,"") ) user = pamdbuser;    if ( strcmp(pamdbuser,"") ) user = pamdbuser;
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;
100      Bool_t gpamela = false;
101      //
102      Bool_t remove = false;
103      TString remfile = "";
104      //
105      Bool_t forceclean = false;
106      TString fcleanfile = "";
107      //
108      Bool_t validate = false;
109      TString validfile = "";
110      //
111      Bool_t nofrag = false;
112      //
113      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 ){
# Line 95  int main(int numinp, char *inps[]){ Line 141  int main(int numinp, char *inps[]){
141          };          };
142          filerootname = (TString)inps[i+1];                filerootname = (TString)inps[i+1];      
143        };        };
144          if ( !strcmp(inps[i],"-remove") ) {
145            if ( numinp-1 < i+1 ){
146              usage();
147              exit(1);
148            };
149            remfile = (TString)inps[i+1];  
150            remove = true;
151          };
152         if ( !strcmp(inps[i],"-cleanfrag") ) {
153            if ( numinp-1 < i+1 ){
154              usage();
155              exit(1);
156            };
157            fcleanfile = (TString)inps[i+1];        
158            forceclean = true;
159          };
160         if ( !strcmp(inps[i],"-validate") ) {
161            if ( numinp-1 < i+1 ){
162              usage();
163              exit(1);
164            };
165            validfile = (TString)inps[i+1];
166            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") ) {
175            autoboot = true;
176          };
177          if ( !strcmp(inps[i],"-no-autoboot") ) {
178            autoboot = false;
179          };
180        if ( !strcmp(inps[i],"-boot") ) {        if ( !strcmp(inps[i],"-boot") ) {
181          if ( numinp-1 < i+1 ){          if ( numinp-1 < i+1 ){
182            usage();            usage();
# Line 116  int main(int numinp, char *inps[]){ Line 198  int main(int numinp, char *inps[]){
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();
# Line 144  int main(int numinp, char *inps[]){ Line 233  int main(int numinp, char *inps[]){
233          };          };
234          password = (TString)inps[i+1];            password = (TString)inps[i+1];  
235        };        };
236          if ( !strcmp(inps[i],"-tle") ) {
237            if ( numinp-1 < i+1 ){
238              usage();
239              exit(1);
240            };
241            tlefilename = (TString)inps[i+1];
242          };
243        //        //
244        if ( !strcmp(inps[i],"-v") || !strcmp(inps[i],"--verbose") ) beverbose = true;        if ( !strcmp(inps[i],"-v") || !strcmp(inps[i],"--verbose") ) beverbose = true;
245        //        //
# Line 151  int main(int numinp, char *inps[]){ Line 247  int main(int numinp, char *inps[]){
247        //        //
248        if ( !strcmp(inps[i],"-g") || !strcmp(inps[i],"--debug") ) debug = true;        if ( !strcmp(inps[i],"-g") || !strcmp(inps[i],"--debug") ) debug = true;
249        //        //
250          if ( !strcmp(inps[i],"-f") || !strcmp(inps[i],"-force") ) force = true;
251          //
252          if ( !strcmp(inps[i],"-nofrag") ) nofrag = true;
253          //
254          if ( !strcmp(inps[i],"-check") ) check = true;
255          //
256        i++;        i++;
257      };      };
258    } else {    } else {
# Line 171  int main(int numinp, char *inps[]){ Line 273  int main(int numinp, char *inps[]){
273      dup2(nul,2);      dup2(nul,2);
274    };    };
275    //    //
276      if ( !strcmp(filerootname.Data(),"") ){
277        if ( (validate && !strcmp(validfile.Data(),"same")) ||
278             (remove && !strcmp(remfile.Data(),"same")) ||
279             (forceclean && !strcmp(fcleanfile.Data(),"same")) || force ){
280          printf("\n ERROR IN INPUT PARAMETERS \n");
281          usage();
282          exit(1);  
283        };
284      } else {
285        if ( validate && !strcmp(validfile.Data(),"same") ) validfile =  (TString)gSystem->BaseName(filerootname.Data());
286        if ( remove && !strcmp(remfile.Data(),"same") ) remfile =  (TString)gSystem->BaseName(filerootname.Data());
287        if ( forceclean && !strcmp(fcleanfile.Data(),"same") ) fcleanfile =  (TString)gSystem->BaseName(filerootname.Data());
288      };
289      //
290      if ( force ){
291        nofrag = true;
292        forceclean = true;
293        remove = true;
294        validate = true;    
295        fcleanfile = (TString)gSystem->BaseName(filerootname.Data());
296        remfile = fcleanfile;
297        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;
331    UInt_t sizeofwar = 10;    UInt_t sizeofwar = 12;
332    UInt_t WAR[10];    UInt_t WAR[12];
333    memset(WAR, 0, 10*sizeof(UInt_t));    memset(WAR, 0, sizeofwar*sizeof(UInt_t));
334    //    //
335    printf("\n Welcome to the PAMELA YodaProfiler, version %s \n\n",version);    printf("\n Welcome to the PAMELA YodaProfiler, version %s \n\n",version);
336    try{    try{
# Line 187  int main(int numinp, char *inps[]){ Line 339  int main(int numinp, char *inps[]){
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,olderthan);      pamDB = new PamelaDBOperations(host,user,password,filerawname,filerootname,boot,tsync,obt0,debug,tlefilename,dwinput,staticp);
343          pamDB->CheckConnection();      pamDB->CheckConnection();
344                //-------------------------------------------------------------------------------------------
 //      pamDB->SetOlderThan(olderthan);//deve stare qui?  
         //-------------------------------------------------------------------------------------------  
345      //      //
346        pamDB->SetNoFrag(nofrag);
347        pamDB->SetAutoBoot(autoboot);
348        //
349        if ( remove ){
350          //-------------------------------------------------------------------------------------------
351          // Remove a file and, on cascade, all that follows from the DB
352          //-------------------------------------------------------------------------------------------
353          if ( beverbose ) printf(" X => Remove file %s from DB \n",((TString)gSystem->BaseName(remfile)).Data());
354          WAR[11] = pamDB->removeFile((TString)gSystem->BaseName(remfile.Data()));
355          //-------------------------------------------------------------------------------------------
356        };    
357        //
358        if( pamDB->InsertRaw() ){
359          //-------------------------------------------------------------------------------------------
360          //Insert a Raw file in GL_RAW
361          //-------------------------------------------------------------------------------------------
362          if ( beverbose ) printf(" 2 => Insert a RAW file in GL_RAW \n");
363          WAR[0] = pamDB->insertPamelaRawFile();
364          //-------------------------------------------------------------------------------------------
365        };
366        //
367        if( pamDB->InsertRoot() ){
368          //          
369          if( !pamDB->InsertRaw() )printf("=> RAW file not inserted --- the DB might not ( yet ) be filled correctly \n");
370          pamDB->CheckFile();
371          //
372          //-------------------------------------------------------------------------------------------
373          //Insert an entry in GL_TIMESYNC
374          //-------------------------------------------------------------------------------------------
375          if ( beverbose ) printf(" 3 => Insert an entry in GL_TIMESYNC \n");
376          WAR[1] = pamDB->insertPamelaGL_TIMESYNC();
377          //-------------------------------------------------------------------------------------------
378          //
379          //-------------------------------------------------------------------------------------------  
380          //Update a single GL_RAW record with its BOOT_NUMBER
381          //-------------------------------------------------------------------------------------------
382          if ( beverbose ) printf(" 4 => Update a single GL_RAW record with its BOOT_NUMBER \n");
383          WAR[3] = pamDB->assignBOOT_NUMBER();
384          if ( WAR[3] && WAR[3] != 1 && WAR[3] != 8 ) throw -9;
385          //-------------------------------------------------------------------------------------------
386          //
387          //-------------------------------------------------------------------------------------------
388          //Insert unpack ROOT file in GL_ROOT  
389          //-------------------------------------------------------------------------------------------
390          if ( beverbose ) printf(" 5 => Insert unpack ROOT file in GL_ROOT \n");
391          WAR[2] = pamDB->insertPamelaRootFile();
392          //-------------------------------------------------------------------------------------------
393          //
394          //-------------------------------------------------------------------------------------------      
395          //Insert in GL_RUN runs information records relative to a single unpack
396          //-------------------------------------------------------------------------------------------
397          if ( beverbose ) printf(" 6 => Scan physics and store runs in the GL_RUN table\n");
398          WAR[4] = pamDB->insertPamelaRUN();
399          //-------------------------------------------------------------------------------------------    
400                    
401          if(pamDB->InsertRaw()){        //-------------------------------------------------------------------------------------------
402                  //-------------------------------------------------------------------------------------------        //Insert in GL_CALO_CALIB calibration information records relative to a single unpack
403                  //Insert a Raw file in GL_RAW        //-------------------------------------------------------------------------------------------
404                  //-------------------------------------------------------------------------------------------        if ( beverbose ) printf(" 7 => Insert calorimeter calibrations in the GL_CALO_CALIB table\n");
405                  if ( beverbose ) printf(" 2 => Insert a RAW file in GL_RAW \n");        WAR[5] = pamDB->insertCALO_CALIB();
406                  WAR[0] = pamDB->insertPamelaRawFile();        //-------------------------------------------------------------------------------------------    
                 //-------------------------------------------------------------------------------------------  
         };  
   
         if(pamDB->InsertRoot()){  
                   
                 if(!pamDB->InsertRaw())printf("=> RAW file not inserted --- the DB might not ( yet ) be filled correctlly \n");  
                 //-------------------------------------------------------------------------------------------    
                 //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;  
                 //-------------------------------------------------------------------------------------------  
                 //  
                 //-------------------------------------------------------------------------------------------  
                 //Insert an entry in GL_TIMESYNC  
                 //-------------------------------------------------------------------------------------------  
                 if ( beverbose ) printf(" 4 => Insert an entry in GL_TIMESYNC \n");  
                 WAR[1] = pamDB->insertPamelaGL_TIMESYNC();  
                 //-------------------------------------------------------------------------------------------  
                 //  
                 //-------------------------------------------------------------------------------------------  
                 //Insert unpack ROOT file in GL_ROOT    
                 //-------------------------------------------------------------------------------------------  
                 if ( beverbose ) printf(" 5 => Insert unpack ROOT file in GL_ROOT \n");  
                 WAR[2] = pamDB->insertPamelaRootFile();  
                 //-------------------------------------------------------------------------------------------  
                 //  
                 //-------------------------------------------------------------------------------------------        
                 //Insert in GL_RUN runs information records relative to a single unpack  
                 //-------------------------------------------------------------------------------------------  
                 if ( beverbose ) printf(" 6 => Scan physics and store runs in the GL_RUN table\n");  
                 WAR[4] = pamDB->insertPamelaRUN();  
                 //-------------------------------------------------------------------------------------------      
           
                 //-------------------------------------------------------------------------------------------  
                 //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();  
                 //-------------------------------------------------------------------------------------------      
           
                 //-------------------------------------------------------------------------------------------  
                 //Insert in GL_S4_CALIB calibration information records relative to a single unpack  
                 //-------------------------------------------------------------------------------------------  
                 if ( beverbose ) printf(" 9 => Insert S4 calibrations in the GL_S4_CALIB table\n");  
                 WAR[7] = pamDB->insertS4_CALIB();  
                 //-------------------------------------------------------------------------------------------      
         };  
407                    
408          if(pamDB->Validate()){          //-------------------------------------------------------------------------------------------
409                          //Insert in GL_TRK_CALIB calibration information records relative to a single unpack
410                  //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
411                  //Clean the GL_RUN_FRAGMENTS        if ( beverbose ) printf(" 8 => Insert tracker calibrations in the GL_TRK_CALIB table\n");
412                  //-------------------------------------------------------------------------------------------        WAR[6] = pamDB->insertTRK_CALIB();
413                  if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table (before %s) \n",pamDB->GetCleanTime() );        //-------------------------------------------------------------------------------------------    
                 WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS();  
                 //-------------------------------------------------------------------------------------------      
414                    
415                  //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
416                  //Validate runs        //Insert in GL_S4_CALIB calibration information records relative to a single unpack
417                  //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
418                  if ( beverbose ) printf(" 11 => Validate runs (before %s)\n",pamDB->GetCleanTime());        if ( beverbose ) printf(" 9 => Insert S4 calibrations in the GL_S4_CALIB table\n");
419                  WAR[9] = pamDB->ValidateRuns();        WAR[7] = pamDB->insertS4_CALIB();
420                  //-------------------------------------------------------------------------------------------            //-------------------------------------------------------------------------------------------    
421          };      };
422        //
423        if ( forceclean ){
424          //-------------------------------------------------------------------------------------------
425          //Clean the GL_RUN_FRAGMENTS for the given file
426          //-------------------------------------------------------------------------------------------
427          if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table for file %s \n",fcleanfile.Data());
428          WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS((TString)gSystem->BaseName(fcleanfile.Data()));
429        };
430        //
431        //
432        if ( validate ){
433          //-------------------------------------------------------------------------------------------
434          //Validate runs
435          //-------------------------------------------------------------------------------------------
436          if ( beverbose ) printf(" 11 => Validate runs table for file %s \n",validfile.Data());
437          WAR[9] = pamDB->ValidateRuns((TString)gSystem->BaseName(validfile.Data()));
438          //-------------------------------------------------------------------------------------------    
439        };
440        //
441        pamDB->CheckValidate(olderthan);
442        //
443        if( pamDB->Validate() ){  
444          //-------------------------------------------------------------------------------------------
445          //Clean the GL_RUN_FRAGMENTS
446          //-------------------------------------------------------------------------------------------
447          if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table (earlier than %s) \n",pamDB->GetCleanTime() );
448          WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS();
449          //-------------------------------------------------------------------------------------------    
450          //-------------------------------------------------------------------------------------------
451          //Validate runs
452          //-------------------------------------------------------------------------------------------
453          if ( beverbose ) printf(" 11 => Validate runs (earlier than %s)\n",pamDB->GetCleanTime());
454          WAR[9] = pamDB->ValidateRuns();
455          //-------------------------------------------------------------------------------------------    
456        };
457    
458        if(! tlefilename.IsNull() ) {
459          //----------------------------------------------
460          //Populate GL_TLE table using the file provided
461          //----------------------------------------------
462          if ( beverbose ) printf(" 12 => Insert TLE elements in the GL_TLE table from file %s \n",tlefilename.Data());
463          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;
# Line 284  int main(int numinp, char *inps[]){ Line 485  int main(int numinp, char *inps[]){
485      case -4: message += " Error querying DB"; break;      case -4: message += " Error querying DB"; break;
486      case -5: message += " Inconsistent OBT/pkt_num"; break;      case -5: message += " Inconsistent OBT/pkt_num"; break;
487      case -6: message += " The file is not in the database"; break;      case -6: message += " The file is not in the database"; break;
488        case -7: message += " Cannot open TLE file"; break;
489      case -8: message += " Event file is empty"; break;      case -8: message += " Event file is empty"; break;
490      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;
491      case -10: message += " No results from DB"; break;      case -10: message += " No results from DB"; break;
# Line 303  int main(int numinp, char *inps[]){ Line 505  int main(int numinp, char *inps[]){
505      case -24: message += " No CalibS4 tree in Level0 file"; break;      case -24: message += " No CalibS4 tree in Level0 file"; break;
506      case -25: message += " Cannot find the run just inserted"; break;      case -25: message += " Cannot find the run just inserted"; break;
507      case -26: message += " Raw file not found looking for VarDump"; break;      case -26: message += " Raw file not found looking for VarDump"; break;
508        case -27: message += " Cannot determine downlink orbit, wrong filename format?"; break;
509        case -28: message += " Cannot assign a RUN ID unique number!"; break;
510        case -29: message += " No VarDump and impossible to find a consistent BOOT number, use the -boot option to override"; break;
511      default: message += " Unidentified error"; break;      default: message += " Unidentified error"; break;
512      };      };
513      printf("\n");      printf("\n");
# Line 335  int main(int numinp, char *inps[]){ Line 540  int main(int numinp, char *inps[]){
540              else if ( bit == 2 ) message += "=> No runheaders in the file\n";              else if ( bit == 2 ) message += "=> No runheaders in the file\n";
541              else if ( bit == 3 ) message += "=> No runtrailers in the file\n";              else if ( bit == 3 ) message += "=> No runtrailers in the file\n";
542              else if ( bit == 4 ) message += "=> No mcmd inclination in the file\n";              else if ( bit == 4 ) message += "=> No mcmd inclination in the file\n";
543                else if ( bit == 5 ) message += "=> Inconsistent PKT/OBT sequence\n";
544                else if ( bit == 6 ) message += "=> No physics events in the file\n";
545                else if ( bit == 7 ) message += "=> Less than 2 physics events in the file\n";
546              else  message += "=> Unidentified insertTimeSync warning\n";              else  message += "=> Unidentified insertTimeSync warning\n";
547            };            };
548          };          };
# Line 355  int main(int numinp, char *inps[]){ Line 563  int main(int numinp, char *inps[]){
563              if ( bit == 0 ) message += "=> BOOT number already inserted\n";//              if ( bit == 0 ) message += "=> BOOT number already inserted\n";//
564              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";//
565              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";//
566                else if ( bit == 3 ) message += "=> No VarDump! autoboot option used\n";//
567              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";//
568              else message += "=> Unidentified assignBOOTnumber warning\n";              else message += "=> Unidentified assignBOOTnumber warning\n";
569            };            };
# Line 367  int main(int numinp, char *inps[]){ Line 576  int main(int numinp, char *inps[]){
576              if      ( bit == 0 ) message += "=> Inconsistent PKT/OBT sequence\n";              if      ( bit == 0 ) message += "=> Inconsistent PKT/OBT sequence\n";
577              else if ( bit == 1 ) message += "=> No physics events in the file\n";              else if ( bit == 1 ) message += "=> No physics events in the file\n";
578              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";
579                else if ( bit == 3 ) message += "=> Not supported yet: run with no events, no runtrailer, no runheader\n";
580                else if ( bit == 4 ) message += "=> File with no events, no runtrailers, no runheaders\n";
581              else  message += "=> Unidentified insertPamelaRun warning\n";              else  message += "=> Unidentified insertPamelaRun warning\n";
582            };            };
583          };          };
# Line 406  int main(int numinp, char *inps[]){ Line 617  int main(int numinp, char *inps[]){
617          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
618            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
619              if      ( bit == 0 ) message += "=> Skip the GL_RUN_FRAGMENTS table cleaning\n";              if      ( bit == 0 ) message += "=> Skip the GL_RUN_FRAGMENTS table cleaning\n";
620                if      ( bit == 1 ) message += "=> Problems retrieving ROOT ID from DB\n";
621              else  message += "=> Unidentified CleanGL_RUN_FRAGMENTS warning\n";              else  message += "=> Unidentified CleanGL_RUN_FRAGMENTS warning\n";
622            };            };
623          };          };
# Line 415  int main(int numinp, char *inps[]){ Line 627  int main(int numinp, char *inps[]){
627          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
628            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
629              if      ( bit == 0 ) message += "=> Skip the run validation \n";              if      ( bit == 0 ) message += "=> Skip the run validation \n";
630                if      ( bit == 1 ) message += "=> Problems retrieving ROOT ID from DB\n";
631              else  message += "=> Unidentified ValidateRuns warning\n";              else  message += "=> Unidentified ValidateRuns warning\n";
632            };            };
633          };          };
634        };        };
635          //
636          if ( j == 10 ){ // populateTLE
637            for (UInt_t bit=0; bit<32; bit++){
638              if ( WAR[j] & (1 << bit) ){
639                if      ( bit == 0 ) message += "=> TLE insertion failed\n";
640                if      ( bit == 1 ) message += "=> No new TLE available\n";
641                else  message += "=> Unidentified populateTle warning\n";
642              };
643            };
644          };
645          //
646          if ( j == 11 ){ // removeFile
647            for (UInt_t bit=0; bit<32; bit++){
648              if ( WAR[j] & (1 << bit) ){
649                if      ( bit == 0 ) message += "=> No file to delete from DB \n";
650                else  message += "=> Unidentified populateTle warning\n";
651              };
652            };
653          };
654      };      };
655    };    };
656    //    //
# Line 432  int main(int numinp, char *inps[]){ Line 664  int main(int numinp, char *inps[]){
664    //---------------------------------------------------------------------------------------    //---------------------------------------------------------------------------------------
665    // Close and exit    // Close and exit
666    //---------------------------------------------------------------------------------------    //---------------------------------------------------------------------------------------
667    if ( beverbose ) printf(" 12 => Free objects and close SQL connection \n");    if ( beverbose ) printf(" 13 => Free objects and close SQL connection \n");
668    pamDB->Close();    pamDB->Close();
669    //    //
670      if ( debug ) printf(" Total number of queries through GLTABLES: %u \n",glt->GetNqueries());
671      delete glt;
672      //
673    printf("\n");    printf("\n");
674    printf(" Finished, exiting...\n");    printf(" Finished, exiting...\n");
675    printf("\n");    printf("\n");

Legend:
Removed from v.1.6  
changed lines
  Added in v.1.24

  ViewVC Help
Powered by ViewVC 1.1.23