/[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.4 by mocchiut, Thu Sep 7 08:49:29 2006 UTC revision 1.28 by mocchiut, Mon Mar 10 10:58:02 2008 UTC
# Line 5  Line 5 
5  //  //
6  #include <TSystem.h>  #include <TSystem.h>
7  //  //
8    #include <GLTables.h>
9  #include <PamelaDBOperations.h>  #include <PamelaDBOperations.h>
10  #include <YodaProfilerVerl2.h>  #include <YodaProfilerVerl2.h>
11  //  //
# Line 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   default: 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(" -p | --pedantic be strict in checks, exit with error if any problem is found [default: no]\n");
28    printf("\n -tsync number   timesync (s) [default = taken from data]\n");    printf(" -boot number    CPU boot number [default = taken from VarDump]\n");
29    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");
30    printf("\n -clean number   number in seconds after which the fragment table\n");    printf("                 looking at timesync [default]\n");
31    printf("\n                 can be cleaned and runs validated [default = -1 do not clean],\n");    printf(" -no-autoboot    disable previous check\n");
32    printf("\n                 if 0 force cleaning immediatly, if negative do not clean\n");    printf(" -tsync number   timesync (s) [default = taken from data]\n");
33    printf("\n -host           name for the host [default = $PAM_DBHOST or mysql://localhost/pamelaprod]\n");    printf(" -obt0 number    obt at timesync (ms) [default = taken from data]\n");
34    printf("\n -user           username for the DB [default = $PAM_DBUSER or \"anonymous\"] \n");    printf(" -dworbit number number is the downlink orbit number (to be used with non-standard names)\n");
35    printf("\n -psw            password for the DB [default = $PAM_DBPSW or \"\"]\n");    printf(" -static         use static path inside the DB instead of symbolic names\n");
36      //  printf(" -gpamela        shortcut to \"-clean 0 -obt0 1 -tsync 1 -no-autoboot -boot 1 -dworbit 1 -static\"\n");
37      printf(" -gpamela        shortcut to \"-clean 0 -obt0 1 -no-autoboot -dworbit 1 -static\"\n");
38      printf(" -clean number   number in seconds after which the fragment table\n");
39      printf("                 can be cleaned and runs validated [default = -1 do not clean],\n");
40      printf("                 if 0 force cleaning immediatly, if negative do not clean\n");
41      printf(" -remove file    remove file and all related runs and calibrations from DB\n");
42      printf("                 file must be the YODA filename (full path is not needed)\n");
43      printf("                 'same' can be used if in conjuction with -yodaFile\n");
44      printf(" -validate file  validates runs between the two closest calibration to file \n");
45      printf("                 not belonging to file itself. File must be the YODA filename\n");
46      printf("                 'same' can be used if in conjuction with -yodaFile\n");
47      printf(" -cleanfrag file clean run fragments for file only\n");
48      printf("                 File must be the YODA filename\n");
49      printf("                 'same' can be used if in conjuction with -yodaFile\n");
50      printf(" -nofrag         do not leave runs in the fragment table and look for fragments\n");
51      printf("                 in the GL_RUN table.\n");
52      printf(" -f | -force     to be used to reprocess a file or to process a file\n");
53      printf("                 when already validated the surroundings, it is equivalent to:\n");
54      printf("                 -remove same -validate same -cleanfrag same -nofrag\n");
55      printf(" -check          performs some test on the GL_RUN table to check its consistency\n");
56      printf(" -checkfrom idrun performs some test on the GL_RUN table to check its consistency starting from run number idrun\n");
57      printf(" -checkto idrun   performs some test on the GL_RUN table to check its consistency arriving till run number idrun\n");
58      printf(" -host           name of the DB host [default = $PAM_DBHOST or mysql://localhost/pamelaprod]\n");
59      printf(" -user           username for the DB connection [default = $PAM_DBUSER or \"anonymous\"] \n");
60      printf(" -psw            password for the DB connection [default = $PAM_DBPSW or \"\"]\n");
61      printf(" -tle <file>     ascii file containing TLE obtained from celestrak.org or space-track.org [default = no]\n");
62    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");
63    printf("\nExample: \n");    printf("\n Example: \n");
64    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");
65  };  };
66  //  //
67  int main(int numinp, char *inps[]){  int main(int numinp, char *inps[]){
# Line 46  int main(int numinp, char *inps[]){ Line 73  int main(int numinp, char *inps[]){
73    UInt_t boot = 0;    UInt_t boot = 0;
74    UInt_t tsync = 0;    UInt_t tsync = 0;
75    UInt_t obt0 = 0;    UInt_t obt0 = 0;
76    //  Long64_t olderthan = 864000LL;    UInt_t dwinput = 0;
77    Long64_t olderthan = -1LL;    UInt_t chfrom = 0;
78      UInt_t chto = 0;
79      Long64_t olderthan = -1LL;  
80    //    //
81    //    //
82    TString filerawname;    TString filerawname  = "";
83      TString filerootname = "";
84    //    //
85    TString host = "mysql://localhost/pamelaprod";    TString host = "mysql://localhost/pamelaprod";
86    TString user = "anonymous";    TString user = "anonymous";
87    TString password = "";    TString password = "";
88    //    //
89    const char *pamdbhost=gSystem->Getenv("PAM_DBHOST");    TString tlefilename = "";
90    const char *pamdbuser=gSystem->Getenv("PAM_DBUSER");    //
91    const char *pamdbpsw=gSystem->Getenv("PAM_DBPSW");    const char *pamdbhost = gSystem->Getenv("PAM_DBHOST");
92      const char *pamdbuser = gSystem->Getenv("PAM_DBUSER");
93      const char *pamdbpsw = gSystem->Getenv("PAM_DBPSW");
94      if ( !pamdbhost ) pamdbhost = "";
95      if ( !pamdbuser ) pamdbuser = "";
96      if ( !pamdbpsw ) pamdbpsw = "";
97    if ( strcmp(pamdbhost,"") ) host = pamdbhost;    if ( strcmp(pamdbhost,"") ) host = pamdbhost;
98    if ( strcmp(pamdbuser,"") ) user = pamdbuser;    if ( strcmp(pamdbuser,"") ) user = pamdbuser;
99    if ( strcmp(pamdbpsw,"") ) password = pamdbpsw;    if ( strcmp(pamdbpsw,"") ) password = pamdbpsw;
100    //    //
   TString filerootname;  
101    //        //    
102      Bool_t staticp = false;
103    Bool_t beverbose = true;    Bool_t beverbose = true;
104    Bool_t debug = false;    Bool_t debug = false;
105      Bool_t autoboot = true;
106      Bool_t gpamela = false;
107      //
108      Bool_t remove = false;
109      TString remfile = "";
110      //
111      Bool_t forceclean = false;
112      TString fcleanfile = "";
113      //
114      Bool_t validate = false;
115      TString validfile = "";
116      //
117      Bool_t nofrag = false;
118      //
119      Bool_t force = false;
120      //
121      Bool_t check = false;
122      //
123      Bool_t pedantic = false;
124      //
125    Int_t i = 0;    Int_t i = 0;
126    //    //
127    if ( numinp > 1 ){    if ( numinp > 1 ){
# Line 76  int main(int numinp, char *inps[]){ Line 131  int main(int numinp, char *inps[]){
131          exit(0);          exit(0);
132        };        };
133        if ( !strcmp(inps[i],"-h") || !strcmp(inps[i],"--help") ){        if ( !strcmp(inps[i],"-h") || !strcmp(inps[i],"--help") ){
134    
135          usage();          usage();
136          exit(0);          exit(0);
137        };        };
# Line 93  int main(int numinp, char *inps[]){ Line 149  int main(int numinp, char *inps[]){
149          };          };
150          filerootname = (TString)inps[i+1];                filerootname = (TString)inps[i+1];      
151        };        };
152          if ( !strcmp(inps[i],"-remove") ) {
153            if ( numinp-1 < i+1 ){
154              usage();
155              exit(1);
156            };
157            remfile = (TString)inps[i+1];  
158            remove = true;
159          };
160         if ( !strcmp(inps[i],"-cleanfrag") ) {
161            if ( numinp-1 < i+1 ){
162              usage();
163              exit(1);
164            };
165            fcleanfile = (TString)inps[i+1];        
166            forceclean = true;
167          };
168         if ( !strcmp(inps[i],"-validate") ) {
169            if ( numinp-1 < i+1 ){
170              usage();
171              exit(1);
172            };
173            validfile = (TString)inps[i+1];
174            validate = true;
175          };
176          if ( !strcmp(inps[i],"-gpamela") ) {
177            gpamela = true;
178          };
179          if ( !strcmp(inps[i],"-static") ) {
180            staticp = true;
181          };
182          if ( !strcmp(inps[i],"-autoboot") ) {
183            autoboot = true;
184          };
185          if ( !strcmp(inps[i],"-no-autoboot") ) {
186            autoboot = false;
187          };
188        if ( !strcmp(inps[i],"-boot") ) {        if ( !strcmp(inps[i],"-boot") ) {
189          if ( numinp-1 < i+1 ){          if ( numinp-1 < i+1 ){
190            usage();            usage();
# Line 100  int main(int numinp, char *inps[]){ Line 192  int main(int numinp, char *inps[]){
192          };          };
193          boot = atoi(inps[i+1]);          boot = atoi(inps[i+1]);
194        };        };
195          if ( !strcmp(inps[i],"-checkfrom") ) {
196            if ( numinp-1 < i+1 ){
197              usage();
198              exit(1);
199            };
200            chfrom = atoi(inps[i+1]);      
201            check = true;
202          };
203          if ( !strcmp(inps[i],"-checkto") ) {
204            if ( numinp-1 < i+1 ){
205              usage();
206              exit(1);
207            };
208            chto = atoi(inps[i+1]);
209            check = true;
210          };
211        if ( !strcmp(inps[i],"-tsync") ) {        if ( !strcmp(inps[i],"-tsync") ) {
212          if ( numinp-1 < i+1 ){          if ( numinp-1 < i+1 ){
213            usage();            usage();
# Line 114  int main(int numinp, char *inps[]){ Line 222  int main(int numinp, char *inps[]){
222          };          };
223          obt0 = (UInt_t)atoll(inps[i+1]);                  obt0 = (UInt_t)atoll(inps[i+1]);        
224        };        };
225          if ( !strcmp(inps[i],"-dworbit") ) {
226            if ( numinp-1 < i+1 ){
227              usage();
228              exit(1);
229            };
230            dwinput = (UInt_t)atoll(inps[i+1]);    
231          };
232        if ( !strcmp(inps[i],"-clean") ) {        if ( !strcmp(inps[i],"-clean") ) {
233          if ( numinp-1 < i+1 ){          if ( numinp-1 < i+1 ){
234            usage();            usage();
# Line 142  int main(int numinp, char *inps[]){ Line 257  int main(int numinp, char *inps[]){
257          };          };
258          password = (TString)inps[i+1];            password = (TString)inps[i+1];  
259        };        };
260          if ( !strcmp(inps[i],"-tle") ) {
261            if ( numinp-1 < i+1 ){
262              usage();
263              exit(1);
264            };
265            tlefilename = (TString)inps[i+1];
266          };
267        //        //
268        if ( !strcmp(inps[i],"-v") || !strcmp(inps[i],"--verbose") ) beverbose = true;        if ( !strcmp(inps[i],"-v") || !strcmp(inps[i],"--verbose") ) beverbose = true;
269        //        //
# Line 149  int main(int numinp, char *inps[]){ Line 271  int main(int numinp, char *inps[]){
271        //        //
272        if ( !strcmp(inps[i],"-g") || !strcmp(inps[i],"--debug") ) debug = true;        if ( !strcmp(inps[i],"-g") || !strcmp(inps[i],"--debug") ) debug = true;
273        //        //
274          if ( !strcmp(inps[i],"-f") || !strcmp(inps[i],"-force") ) force = true;
275          //
276          if ( !strcmp(inps[i],"-p") || !strcmp(inps[i],"--pedantic") ) pedantic = true;
277          //
278          if ( !strcmp(inps[i],"-nofrag") ) nofrag = true;
279          //
280          if ( !strcmp(inps[i],"-check") ) check = true;
281          //
282        i++;        i++;
283      };      };
284    } else {    } else {
# Line 169  int main(int numinp, char *inps[]){ Line 299  int main(int numinp, char *inps[]){
299      dup2(nul,2);      dup2(nul,2);
300    };    };
301    //    //
302    // Start:    if ( !strcmp(filerootname.Data(),"") ){
303        if ( (validate && !strcmp(validfile.Data(),"same")) ||
304             (remove && !strcmp(remfile.Data(),"same")) ||
305             (forceclean && !strcmp(fcleanfile.Data(),"same")) || force ){
306          printf("\n ERROR IN INPUT PARAMETERS \n");
307          usage();
308          exit(1);  
309        };
310      } else {
311        if ( validate && !strcmp(validfile.Data(),"same") ) validfile =  (TString)gSystem->BaseName(filerootname.Data());
312        if ( remove && !strcmp(remfile.Data(),"same") ) remfile =  (TString)gSystem->BaseName(filerootname.Data());
313        if ( forceclean && !strcmp(fcleanfile.Data(),"same") ) fcleanfile =  (TString)gSystem->BaseName(filerootname.Data());
314      };
315      //
316      if ( force ){
317        nofrag = true;
318        forceclean = true;
319        remove = true;
320        validate = true;    
321        fcleanfile = (TString)gSystem->BaseName(filerootname.Data());
322        remfile = fcleanfile;
323        validfile = fcleanfile;
324      };
325      //
326      const char *paml0 = gSystem->Getenv("PAM_L0");
327      const char *paml2 = gSystem->Getenv("PAM_L2");
328      const char *pamraw = gSystem->Getenv("PAM_RAW");
329      if ( !paml0 || !paml2 || !pamraw ){
330        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");
331        staticp = true;
332      };
333      //
334      //
335      GL_TABLES *glt = new GL_TABLES(host,user,password);
336      //
337      if ( gpamela ){
338        //    //    -clean 0 -obt0 1 -tsync 1 -boot 1 -dworbit 1
339        //    -clean 0 -obt0 1 -dworbit 1
340        if ( olderthan < 0LL ) olderthan = 0LL;
341        if ( !obt0 ) obt0 = 1;
342        //    if ( !tsync ) tsync = 1;    
343        //    if ( !boot ) boot = 1;
344        if ( !dwinput ) dwinput = 1;
345        staticp = true;
346        autoboot = false;
347      };
348      //
349      if ( filerawname == "" && filerootname != "" ){
350        filerawname = "/not_given/"+(TString)gSystem->BaseName(filerootname.Data());
351        filerawname = filerawname.ReplaceAll(".root",5,".pam",4);
352        //    printf("filerawname %s \n",filerawname.Data());
353      };
354    //    //
355      // Start:
356    TString message;    TString message;
357    char *version = YodaProfilerInfo(false);    char *version = YodaProfilerInfo(false);
358    PamelaDBOperations *pamDB = 0;    PamelaDBOperations *pamDB = 0;
359    UInt_t sizeofwar = 10;    UInt_t sizeofwar = 12;
360    UInt_t WAR[10];    UInt_t WAR[12];
361    memset(WAR, 0, 10*sizeof(UInt_t));    memset(WAR, 0, sizeofwar*sizeof(UInt_t));
362    //    //
363    printf("\n Welcome to the PAMELA YodaProfiler, version %s \n\n",version);    printf("\n Welcome to the PAMELA YodaProfiler, version %s \n\n",version);
364    try{    try{
# Line 185  int main(int numinp, char *inps[]){ Line 367  int main(int numinp, char *inps[]){
367      // Create pamDB object and open SQL connection      // Create pamDB object and open SQL connection
368      //-------------------------------------------------------------------------------------------      //-------------------------------------------------------------------------------------------
369      if ( beverbose ) printf(" 1 => Initialize and open SQL connection \n");      if ( beverbose ) printf(" 1 => Initialize and open SQL connection \n");
370      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);
371      pamDB->CheckFile();      pamDB->CheckConnection();
     pamDB->SetOlderThan(olderthan);  
372      //-------------------------------------------------------------------------------------------      //-------------------------------------------------------------------------------------------
373      //      //
374      //-------------------------------------------------------------------------------------------      pamDB->SetNoFrag(nofrag);
375      //Insert a Raw file in GL_RAW      pamDB->SetAutoBoot(autoboot);
376      //-------------------------------------------------------------------------------------------      pamDB->SetPedantic(pedantic);
     if ( beverbose ) printf(" 2 => Insert a RAW file in GL_RAW \n");  
     WAR[0] = pamDB->insertPamelaRawFile();  
     //-------------------------------------------------------------------------------------------  
     //-------------------------------------------------------------------------------------------    
     //Update a single GL_RAW record with its BOOT_NUMBER  
     //-------------------------------------------------------------------------------------------  
     if ( beverbose ) printf(" 3 => Update a single GL_RAW record with its BOOT_NUMBER \n");  
     WAR[3] = pamDB->assignBOOT_NUMBER();  
     //    if ( WAR[3] ) pamDB->SetNOBOOT(true);  
     if ( WAR[3] && WAR[3] != 1 ) throw -9;  
     //-------------------------------------------------------------------------------------------  
     //  
     //-------------------------------------------------------------------------------------------  
     //Insert an entry in GL_TIMESYNC  
     //-------------------------------------------------------------------------------------------  
     if ( beverbose ) printf(" 4 => Insert an entry in GL_TIMESYNC \n");  
     WAR[1] = pamDB->insertPamelaGL_TIMESYNC();  
     //-------------------------------------------------------------------------------------------  
377      //      //
378      //-------------------------------------------------------------------------------------------      if ( remove ){
379      //Insert unpack ROOT file in GL_ROOT          //-------------------------------------------------------------------------------------------
380      //-------------------------------------------------------------------------------------------        // Remove a file and, on cascade, all that follows from the DB
381      if ( beverbose ) printf(" 5 => Insert unpack ROOT file in GL_ROOT \n");        //-------------------------------------------------------------------------------------------
382      WAR[2] = pamDB->insertPamelaRootFile();        if ( beverbose ) printf(" X => Remove file %s from DB \n",((TString)gSystem->BaseName(remfile)).Data());
383      //-------------------------------------------------------------------------------------------        WAR[11] = pamDB->removeFile((TString)gSystem->BaseName(remfile.Data()));
384          //-------------------------------------------------------------------------------------------
385        };    
386        //
387        if( pamDB->InsertRaw() ){
388          //-------------------------------------------------------------------------------------------
389          //Insert a Raw file in GL_RAW
390          //-------------------------------------------------------------------------------------------
391          if ( beverbose ) printf(" 2 => Insert a RAW file in GL_RAW \n");
392          WAR[0] = pamDB->insertPamelaRawFile();
393          //-------------------------------------------------------------------------------------------
394        };
395      //      //
396        if( pamDB->InsertRoot() ){
397          //          
398          if( !pamDB->InsertRaw() )printf("=> RAW file not inserted --- the DB might not ( yet ) be filled correctly \n");
399          pamDB->CheckFile();
400          //
401          //-------------------------------------------------------------------------------------------
402          //Insert an entry in GL_TIMESYNC
403          //-------------------------------------------------------------------------------------------
404          if ( beverbose ) printf(" 3 => Insert an entry in GL_TIMESYNC \n");
405          WAR[1] = pamDB->insertPamelaGL_TIMESYNC();
406          //-------------------------------------------------------------------------------------------
407          //
408          //-------------------------------------------------------------------------------------------  
409          //Update a single GL_RAW record with its BOOT_NUMBER
410          //-------------------------------------------------------------------------------------------
411          if ( beverbose ) printf(" 4 => Update a single GL_RAW record with its BOOT_NUMBER \n");
412          WAR[3] = pamDB->assignBOOT_NUMBER();
413          if ( WAR[3] && WAR[3] != 1 && WAR[3] != 8 ) throw -9;
414          //-------------------------------------------------------------------------------------------
415          //
416          //-------------------------------------------------------------------------------------------
417          //Insert unpack ROOT file in GL_ROOT  
418          //-------------------------------------------------------------------------------------------
419          if ( beverbose ) printf(" 5 => Insert unpack ROOT file in GL_ROOT \n");
420          WAR[2] = pamDB->insertPamelaRootFile();
421          //-------------------------------------------------------------------------------------------
422          //
423          //-------------------------------------------------------------------------------------------      
424          //Insert in GL_RUN runs information records relative to a single unpack
425          //-------------------------------------------------------------------------------------------
426          if ( beverbose ) printf(" 6 => Scan physics and store runs in the GL_RUN table\n");
427          WAR[4] = pamDB->insertPamelaRUN();
428          //-------------------------------------------------------------------------------------------    
429            
430          //-------------------------------------------------------------------------------------------
431          //Insert in GL_CALO_CALIB calibration information records relative to a single unpack
432          //-------------------------------------------------------------------------------------------
433          if ( beverbose ) printf(" 7 => Insert calorimeter calibrations in the GL_CALO_CALIB table\n");
434          WAR[5] = pamDB->insertCALO_CALIB();
435          //-------------------------------------------------------------------------------------------    
436    
437      //-------------------------------------------------------------------------------------------              if ( !gpamela ){
438      //Insert in GL_RUN runs information records relative to a single unpack          //---------------------------------------------------------------------------------------------------------------------
439      //-------------------------------------------------------------------------------------------          //Insert in GL_CALOPULSE_CALIB calibration PULSE information records relative to a single unpack (only for real data!)
440      if ( beverbose ) printf(" 6 => Scan physics and store runs in the GL_RUN table\n");          //---------------------------------------------------------------------------------------------------------------------
441      WAR[4] = pamDB->insertPamelaRUN();          if ( beverbose ) printf(" 7b => Insert calorimeter pulse calibrations in the GL_CALOPULSE_CALIB table\n");
442      //-------------------------------------------------------------------------------------------              WAR[5] += pamDB->insertCALOPULSE_CALIB();
443            //-------------------------------------------------------------------------------------------    
444      //-------------------------------------------------------------------------------------------        };
     //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();  
     //-------------------------------------------------------------------------------------------      
445    
446      //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
447      //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
448      //-------------------------------------------------------------------------------------------        //-------------------------------------------------------------------------------------------
449      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");
450      WAR[7] = pamDB->insertS4_CALIB();        WAR[6] = pamDB->insertTRK_CALIB();
451      //-------------------------------------------------------------------------------------------            //-------------------------------------------------------------------------------------------    
452            
453          //-------------------------------------------------------------------------------------------
454          //Insert in GL_S4_CALIB calibration information records relative to a single unpack
455          //-------------------------------------------------------------------------------------------
456          if ( beverbose ) printf(" 9 => Insert S4 calibrations in the GL_S4_CALIB table\n");
457          WAR[7] = pamDB->insertS4_CALIB();
458          //-------------------------------------------------------------------------------------------    
459        };
460        //
461        if ( forceclean ){
462          //-------------------------------------------------------------------------------------------
463          //Clean the GL_RUN_FRAGMENTS for the given file
464          //-------------------------------------------------------------------------------------------
465          if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table for file %s \n",fcleanfile.Data());
466          WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS((TString)gSystem->BaseName(fcleanfile.Data()));
467        };
468        //
469        //
470        if ( validate ){
471          //-------------------------------------------------------------------------------------------
472          //Validate runs
473          //-------------------------------------------------------------------------------------------
474          if ( beverbose ) printf(" 11 => Validate runs table for file %s \n",validfile.Data());
475          WAR[9] = pamDB->ValidateRuns((TString)gSystem->BaseName(validfile.Data()));
476          //-------------------------------------------------------------------------------------------    
477        };
478        //
479        pamDB->CheckValidate(olderthan);
480        //
481        if( pamDB->Validate() ){  
482          //-------------------------------------------------------------------------------------------
483          //Clean the GL_RUN_FRAGMENTS
484          //-------------------------------------------------------------------------------------------
485          if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table (earlier than %s) \n",pamDB->GetCleanTime() );
486          WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS();
487          //-------------------------------------------------------------------------------------------    
488          //-------------------------------------------------------------------------------------------
489          //Validate runs
490          //-------------------------------------------------------------------------------------------
491          if ( beverbose ) printf(" 11 => Validate runs (earlier than %s)\n",pamDB->GetCleanTime());
492          WAR[9] = pamDB->ValidateRuns();
493          //-------------------------------------------------------------------------------------------    
494        };
495    
496      //-------------------------------------------------------------------------------------------      if(! tlefilename.IsNull() ) {
497      //Clean the GL_RUN_FRAGMENTS        //----------------------------------------------
498      //-------------------------------------------------------------------------------------------        //Populate GL_TLE table using the file provided
499      if ( beverbose ) printf(" 10 => Clean the GL_RUN_FRAGMENTS table\n");        //----------------------------------------------
500      WAR[8] = pamDB->CleanGL_RUN_FRAGMENTS();        if ( beverbose ) printf(" 12 => Insert TLE elements in the GL_TLE table from file %s \n",tlefilename.Data());
501      //-------------------------------------------------------------------------------------------            WAR[10] = pamDB->populateTLE();
502        }
503    
504      //-------------------------------------------------------------------------------------------      if ( check ){
505      //Validate runs        //----------------------------------------------
506      //-------------------------------------------------------------------------------------------        //Check GL_RUN table consistency
507      if ( beverbose ) printf(" 11 => Validate runs\n");        //----------------------------------------------
508      WAR[9] = pamDB->ValidateRuns();        if ( beverbose ) printf(" 13 => Check GL_RUN table consistency\n");
509      //-------------------------------------------------------------------------------------------            UInt_t ch = pamDB->Check(chfrom,chto);
510              if ( !ch ){
511            printf(" GL_RUN table seems ok!\n");
512          } else {
513            printf(" Problems found in the GL_RUN table!\n");
514          };
515        };
516            
517    } catch (Int_t exc) {    } catch (Int_t exc) {
518      signal = exc;      signal = exc;
519      switch(exc){      switch(exc){
# Line 271  int main(int numinp, char *inps[]){ Line 523  int main(int numinp, char *inps[]){
523      case -4: message += " Error querying DB"; break;      case -4: message += " Error querying DB"; break;
524      case -5: message += " Inconsistent OBT/pkt_num"; break;      case -5: message += " Inconsistent OBT/pkt_num"; break;
525      case -6: message += " The file is not in the database"; break;      case -6: message += " The file is not in the database"; break;
526        case -7: message += " Cannot open TLE file"; break;
527      case -8: message += " Event file is empty"; break;      case -8: message += " Event file is empty"; break;
528      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;
529      case -10: message += " No results from DB"; break;      case -10: message += " No results from DB"; break;
# Line 290  int main(int numinp, char *inps[]){ Line 543  int main(int numinp, char *inps[]){
543      case -24: message += " No CalibS4 tree in Level0 file"; break;      case -24: message += " No CalibS4 tree in Level0 file"; break;
544      case -25: message += " Cannot find the run just inserted"; break;      case -25: message += " Cannot find the run just inserted"; break;
545      case -26: message += " Raw file not found looking for VarDump"; break;      case -26: message += " Raw file not found looking for VarDump"; break;
546        case -27: message += " Cannot determine downlink orbit, wrong filename format?"; break;
547        case -28: message += " Cannot assign a RUN ID unique number!"; break;
548        case -29: message += " No VarDump and impossible to find a consistent BOOT number, use the -boot option to override"; break;
549        case -30: message += " Old database selected, no GL_CALOPULSE_CALIB table in the DB!"; break;
550        case -31: message += " No CalibCalPulse1 tree in Level0 file"; break;
551        case -32: message += " No CalibCalPulse2 tree in Level0 file"; break;
552        case -66: message += " PEDANTIC: REPETITION"; break;
553        case -67: message += " PEDANTIC: TIMESYNC ALREADY INSERTED"; break;
554        case -68: message += " PEDANTIC: NO TIMESYNC IN THE FILE"; break;
555        case -69: message += " PEDANTIC: RUN FRAGMENT ALREADY INSERTED"; break;
556        case -70: message += " PEDANTIC: RUN ALREADY INSERTED"; break;
557        case -71: message += " PEDANTIC: OVERLAPPING RUNS (FIRST)"; break;
558        case -72: message += " PEDANTIC: OVERLAPPING RUNS (LAST)"; break;
559        case -73: message += " PEDANTIC: CALO CALIB ALREADY INSERTED"; break;
560        case -74: message += " PEDANTIC: CALO CALIB REPEATED"; break;
561        case -75: message += " PEDANTIC: CALOPULSE1 CALIB ALREADY INSERTED"; break;
562        case -76: message += " PEDANTIC: CALOPULSE1 CALIB REPEATED"; break;
563        case -77: message += " PEDANTIC: CALOPULSE2 CALIB ALREADY INSERTED"; break;
564        case -78: message += " PEDANTIC: CALOPULSE2 CALIB REPEATED"; break;
565        case -79: message += " PEDANTIC: TRK1 CALIB REPEATED"; break;
566        case -80: message += " PEDANTIC: TRK CALIB ALREADY INSERTED"; break;
567        case -81: message += " PEDANTIC: S4 CALIB ALREADY INSERTED"; break;
568        case -82: message += " PEDANTIC: S4 CALIB REPEATED"; break;
569        case -83: message += " PEDANTIC: CLEANING ERROR, RUN ALREADY INSERTED IN THE GL_RUN TABLE"; break;
570      default: message += " Unidentified error"; break;      default: message += " Unidentified error"; break;
571      };      };
572      printf("\n");      printf("\n");
# Line 322  int main(int numinp, char *inps[]){ Line 599  int main(int numinp, char *inps[]){
599              else if ( bit == 2 ) message += "=> No runheaders in the file\n";              else if ( bit == 2 ) message += "=> No runheaders in the file\n";
600              else if ( bit == 3 ) message += "=> No runtrailers in the file\n";              else if ( bit == 3 ) message += "=> No runtrailers in the file\n";
601              else if ( bit == 4 ) message += "=> No mcmd inclination in the file\n";              else if ( bit == 4 ) message += "=> No mcmd inclination in the file\n";
602                else if ( bit == 5 ) message += "=> Inconsistent PKT/OBT sequence\n";
603                else if ( bit == 6 ) message += "=> No physics events in the file\n";
604                else if ( bit == 7 ) message += "=> Less than 2 physics events in the file\n";
605              else  message += "=> Unidentified insertTimeSync warning\n";              else  message += "=> Unidentified insertTimeSync warning\n";
606            };            };
607          };          };
# Line 342  int main(int numinp, char *inps[]){ Line 622  int main(int numinp, char *inps[]){
622              if ( bit == 0 ) message += "=> BOOT number already inserted\n";//              if ( bit == 0 ) message += "=> BOOT number already inserted\n";//
623              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";//
624              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";//
625                else if ( bit == 3 ) message += "=> No VarDump! autoboot option used\n";//
626              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";//
627              else message += "=> Unidentified assignBOOTnumber warning\n";              else message += "=> Unidentified assignBOOTnumber warning\n";
628            };            };
# Line 354  int main(int numinp, char *inps[]){ Line 635  int main(int numinp, char *inps[]){
635              if      ( bit == 0 ) message += "=> Inconsistent PKT/OBT sequence\n";              if      ( bit == 0 ) message += "=> Inconsistent PKT/OBT sequence\n";
636              else if ( bit == 1 ) message += "=> No physics events in the file\n";              else if ( bit == 1 ) message += "=> No physics events in the file\n";
637              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";
638                else if ( bit == 3 ) message += "=> Not supported yet: run with no events, no runtrailer, no runheader\n";
639                else if ( bit == 4 ) message += "=> File with no events, no runtrailers, no runheaders\n";
640              else  message += "=> Unidentified insertPamelaRun warning\n";              else  message += "=> Unidentified insertPamelaRun warning\n";
641            };            };
642          };          };
# Line 393  int main(int numinp, char *inps[]){ Line 676  int main(int numinp, char *inps[]){
676          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
677            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
678              if      ( bit == 0 ) message += "=> Skip the GL_RUN_FRAGMENTS table cleaning\n";              if      ( bit == 0 ) message += "=> Skip the GL_RUN_FRAGMENTS table cleaning\n";
679                if      ( bit == 1 ) message += "=> Problems retrieving ROOT ID from DB\n";
680              else  message += "=> Unidentified CleanGL_RUN_FRAGMENTS warning\n";              else  message += "=> Unidentified CleanGL_RUN_FRAGMENTS warning\n";
681            };            };
682          };          };
# Line 402  int main(int numinp, char *inps[]){ Line 686  int main(int numinp, char *inps[]){
686          for (UInt_t bit=0; bit<32; bit++){          for (UInt_t bit=0; bit<32; bit++){
687            if ( WAR[j] & (1 << bit) ){            if ( WAR[j] & (1 << bit) ){
688              if      ( bit == 0 ) message += "=> Skip the run validation \n";              if      ( bit == 0 ) message += "=> Skip the run validation \n";
689                if      ( bit == 1 ) message += "=> Problems retrieving ROOT ID from DB\n";
690              else  message += "=> Unidentified ValidateRuns warning\n";              else  message += "=> Unidentified ValidateRuns warning\n";
691            };            };
692          };          };
693        };        };
694          //
695          if ( j == 10 ){ // populateTLE
696            for (UInt_t bit=0; bit<32; bit++){
697              if ( WAR[j] & (1 << bit) ){
698                if      ( bit == 0 ) message += "=> TLE insertion failed\n";
699                if      ( bit == 1 ) message += "=> No new TLE available\n";
700                else  message += "=> Unidentified populateTle warning\n";
701              };
702            };
703          };
704          //
705          if ( j == 11 ){ // removeFile
706            for (UInt_t bit=0; bit<32; bit++){
707              if ( WAR[j] & (1 << bit) ){
708                if      ( bit == 0 ) message += "=> No file to delete from DB \n";
709                else  message += "=> Unidentified populateTle warning\n";
710              };
711            };
712          };
713      };      };
714    };    };
715    //    //
# Line 419  int main(int numinp, char *inps[]){ Line 723  int main(int numinp, char *inps[]){
723    //---------------------------------------------------------------------------------------    //---------------------------------------------------------------------------------------
724    // Close and exit    // Close and exit
725    //---------------------------------------------------------------------------------------    //---------------------------------------------------------------------------------------
726    if ( beverbose ) printf(" 12 => Free objects and close SQL connection \n");    if ( beverbose ) printf(" 13 => Free objects and close SQL connection \n");
727    pamDB->Close();    pamDB->Close();
728    //    //
729      if ( debug ) printf(" Total number of queries through GLTABLES: %u \n",glt->GetNqueries());
730      delete glt;
731      //
732    printf("\n");    printf("\n");
733    printf(" Finished, exiting...\n");    printf(" Finished, exiting...\n");
734    printf("\n");    printf("\n");
Legend:
Removed from v.1.4  
changed lines
  Added in v.1.28
  ViewVC Help
Powered by ViewVC 1.1.23