| 3 | 
  | 
  | 
| 4 | 
 #include <iostream> | 
 #include <iostream> | 
| 5 | 
 #include <list> | 
 #include <list> | 
| 6 | 
 // | 
  | 
| 7 | 
 #include <TSQLServer.h> | 
 #include <TSQLServer.h> | 
 | 
 #include <TArrayD.h> | 
  | 
 | 
 // | 
  | 
| 8 | 
 #include <EventHeader.h> | 
 #include <EventHeader.h> | 
| 9 | 
 #include <PscuHeader.h> | 
 #include <PscuHeader.h> | 
| 10 | 
 #include <mcmd/McmdEvent.h> | 
 #include <mcmd/McmdEvent.h> | 
| 18 | 
 #include <varDump/VarDumpEvent.h> | 
 #include <varDump/VarDumpEvent.h> | 
| 19 | 
 #include <varDump/VarDumpRecord.h> | 
 #include <varDump/VarDumpRecord.h> | 
| 20 | 
 #include <physics/S4/S4Event.h> | 
 #include <physics/S4/S4Event.h> | 
| 21 | 
 // | 
  | 
| 22 | 
 #include <GLTables.h> | 
 #include <GLTables.h> | 
| 23 | 
  | 
  | 
| 24 | 
 using namespace pamela; | 
 #include <sgp4.h> | 
| 25 | 
  | 
  | 
| 26 | 
  | 
 using namespace pamela; | 
| 27 | 
  | 
  | 
| 28 | 
 /** | 
 /** | 
| 29 | 
  * Collections of Pamela specific operations over a database | 
  * Collections of Pamela specific operations over a database | 
| 49 | 
     UInt_t tsync; | 
     UInt_t tsync; | 
| 50 | 
     UInt_t toffset; | 
     UInt_t toffset; | 
| 51 | 
     // | 
     // | 
| 52 | 
  | 
     //    Long64_t olderthan; | 
| 53 | 
  | 
     UInt_t dworbit; | 
| 54 | 
  | 
     // | 
| 55 | 
     UInt_t BOOTNO; | 
     UInt_t BOOTNO; | 
| 56 | 
     UInt_t obt0; | 
     UInt_t obt0; | 
| 57 | 
     UInt_t id; | 
     UInt_t id; | 
| 78 | 
     // | 
     // | 
| 79 | 
     Bool_t NOBOOT; | 
     Bool_t NOBOOT; | 
| 80 | 
     Bool_t debug; | 
     Bool_t debug; | 
| 81 | 
  | 
  | 
| 82 | 
  | 
     // Path to tle file | 
| 83 | 
  | 
     TString tlefilename; | 
| 84 | 
  | 
          | 
| 85 | 
  | 
     // flag to control profiler actions | 
| 86 | 
  | 
     Bool_t INSERT_RAW; | 
| 87 | 
  | 
     Bool_t INSERT_ROOT; | 
| 88 | 
  | 
     Bool_t VALIDATE; | 
| 89 | 
  | 
      | 
| 90 | 
  | 
     TDatime *clean_time; | 
| 91 | 
  | 
      | 
| 92 | 
     // | 
     // | 
| 93 | 
     typedef std::list<const char*> pcksList; | 
     typedef std::list<const char*> pcksList; | 
| 94 | 
     static void getPacketsNames(pcksList &pcksNames){ | 
     static void getPacketsNames(pcksList &pcksNames){ | 
| 154 | 
     Bool_t IsRunAlreadyInserted(); | 
     Bool_t IsRunAlreadyInserted(); | 
| 155 | 
     Bool_t IsRunConsistent(Bool_t mishead, Bool_t mistrail, UInt_t &firstev, UInt_t &lastev); | 
     Bool_t IsRunConsistent(Bool_t mishead, Bool_t mistrail, UInt_t &firstev, UInt_t &lastev); | 
| 156 | 
     // | 
     // | 
| 157 | 
  | 
     Bool_t MissingTRK_CALIB(UInt_t t1,UInt_t t2); | 
| 158 | 
  | 
     // | 
| 159 | 
     UInt_t PKT(UInt_t pkt_num); | 
     UInt_t PKT(UInt_t pkt_num); | 
| 160 | 
     // | 
     // | 
| 161 | 
     ULong64_t OBT(UInt_t obt); | 
     ULong64_t OBT(UInt_t obt); | 
| 162 | 
     // | 
     // | 
| 163 | 
     TArrayD S4_paramfit(pamela::CalibS4Event *S4CalibEvent); | 
     UInt_t AssignRunID(); | 
| 164 | 
     // | 
  | 
| 165 | 
  | 
     // GL_TLE related functions | 
| 166 | 
  | 
     int insertTle(cTle*); | 
| 167 | 
  | 
     bool isTlePresent(cTle*); | 
| 168 | 
  | 
  | 
| 169 | 
  public:  | 
  public:  | 
| 170 | 
     // | 
     // | 
| 171 | 
     PamelaDBOperations(TString host, TString user, TString password, TString filerawname, TString filerootname, UInt_t boot, UInt_t tsync, UInt_t obt0, Bool_t debug); // constructor | 
     PamelaDBOperations(TString host, TString user, TString password, TString filerawname, TString filerootname, UInt_t boot, UInt_t tsync, UInt_t obt0, Bool_t debug, TString tlefilename); // constructor | 
| 172 | 
     // | 
     // | 
| 173 | 
     void Close(); // destructor | 
     void Close(); // destructor | 
| 174 | 
     // | 
     // | 
| 186 | 
     void SetObt0(UInt_t ts);  | 
     void SetObt0(UInt_t ts);  | 
| 187 | 
     void SetCommonGLRUN(UInt_t absth, UInt_t abstt); | 
     void SetCommonGLRUN(UInt_t absth, UInt_t abstt); | 
| 188 | 
     void SetNOBOOT(Bool_t noboot); | 
     void SetNOBOOT(Bool_t noboot); | 
| 189 | 
  | 
     void SetOlderThan(Long64_t oldthan); | 
| 190 | 
  | 
     void SetTLEPath(TString str); | 
| 191 | 
  | 
     void SetOrbitNo(); | 
| 192 | 
     // | 
     // | 
| 193 | 
     Bool_t SetID_RAW(); | 
     Bool_t SetID_RAW(); | 
| 194 | 
     // | 
     // | 
| 213 | 
     TString GetRootPath(){return((TString)gSystem->DirName(filerootname.Data())+'/');}; | 
     TString GetRootPath(){return((TString)gSystem->DirName(filerootname.Data())+'/');}; | 
| 214 | 
     TString GetRootName(){return(filerootname);}; | 
     TString GetRootName(){return(filerootname);}; | 
| 215 | 
     TString GetRawName(){return(filerawname);}; | 
     TString GetRawName(){return(filerawname);}; | 
| 216 | 
  | 
          | 
| 217 | 
  | 
         const char*  GetCleanTime(){return clean_time->AsSQLString();}; | 
| 218 | 
     // | 
     // | 
| 219 | 
     // Functions | 
     // Functions | 
| 220 | 
     // | 
     // | 
| 226 | 
     Int_t insertCALO_CALIB();  | 
     Int_t insertCALO_CALIB();  | 
| 227 | 
     Int_t insertTRK_CALIB();  | 
     Int_t insertTRK_CALIB();  | 
| 228 | 
     Int_t insertS4_CALIB();  | 
     Int_t insertS4_CALIB();  | 
| 229 | 
     // | 
     Int_t CleanGL_RUN_FRAGMENTS(); | 
| 230 | 
     void OpenFile(); | 
     Int_t ValidateRuns(); | 
| 231 | 
  | 
     Int_t assignVALIDATION(UInt_t ,Bool_t ); | 
| 232 | 
  | 
     // | 
| 233 | 
  | 
     //    void OpenFile(); | 
| 234 | 
  | 
     void CheckValidate(Long64_t olderthan); | 
| 235 | 
  | 
     void CheckConnection(); | 
| 236 | 
     void CheckFile(); | 
     void CheckFile(); | 
| 237 | 
     // | 
     // | 
| 238 | 
  | 
          | 
| 239 | 
  | 
     Bool_t InsertRoot(){return(INSERT_ROOT);}; | 
| 240 | 
  | 
     Bool_t InsertRaw(){return(INSERT_RAW);}; | 
| 241 | 
  | 
     Bool_t Validate(){return(VALIDATE);}; | 
| 242 | 
  | 
  | 
| 243 | 
  | 
     // Functions for TLE | 
| 244 | 
  | 
     Int_t populateTLE(); | 
| 245 | 
  | 
          | 
| 246 | 
 }; | 
 }; | 
| 247 | 
 #endif /* PAMELA_DB_OPERATIONS_H */ | 
 #endif /* PAMELA_DB_OPERATIONS_H */ |