--- YodaProfiler/inc/PamelaDBOperations.h	2006/09/11 16:38:18	1.4
+++ YodaProfiler/inc/PamelaDBOperations.h	2006/11/27 14:25:34	1.10
@@ -3,9 +3,8 @@
 
 #include <iostream>
 #include <list>
-//
+
 #include <TSQLServer.h>
-//
 #include <EventHeader.h>
 #include <PscuHeader.h>
 #include <mcmd/McmdEvent.h>
@@ -19,11 +18,12 @@
 #include <varDump/VarDumpEvent.h>
 #include <varDump/VarDumpRecord.h>
 #include <physics/S4/S4Event.h>
-//
+
 #include <GLTables.h>
 
-using namespace pamela;
+#include <sgp4.h>
 
+using namespace pamela;
 
 /**
  * Collections of Pamela specific operations over a database
@@ -49,16 +49,17 @@
     UInt_t tsync;
     UInt_t toffset;
     //
-//    Long64_t olderthan;
+    //    Long64_t olderthan;
+    UInt_t dworbit;
     //
     UInt_t BOOTNO;
     UInt_t obt0;
     UInt_t id;
     UInt_t idroot;
     UInt_t pktfirst;
-    ULong64_t obtfirst;
-    ULong64_t upperobt;
-    UInt_t upperpkt;
+    UInt_t obtfirst;
+    Long64_t upperobt;
+    Long64_t upperpkt;
     UInt_t upperentry;
     Int_t rtev;
     Int_t rhev;
@@ -77,14 +78,19 @@
     //
     Bool_t NOBOOT;
     Bool_t debug;
+
+    // Path to tle file
+    TString tlefilename;
 	
-	// flag to control profiler actions
-	Bool_t INSERT_RAW;
-	Bool_t INSERT_ROOT;
-	Bool_t VALIDATE;
-	
-	TDatime *clean_time;
-		
+    // flag to control profiler actions
+    Bool_t INSERT_RAW;
+    Bool_t INSERT_ROOT;
+    Bool_t VALIDATE;
+    Bool_t NOFRAG;
+    Bool_t AUTOBOOT;
+    
+    TDatime *clean_time;
+    
     //
     typedef std::list<const char*> pcksList;
     static void getPacketsNames(pcksList &pcksNames){
@@ -146,20 +152,32 @@
     void FillClass(Bool_t mishead, Bool_t mistrail, UInt_t firstev, UInt_t lastev);
     void HandleTRK_CALIB(Bool_t pk1, Bool_t pk2);
     //
+    void RemoveCALIBS();
+    void ValidationOFF();
+    void ReArrangeRUNS();
+    void RemoveRUNS();
+    void RemoveFILES();
+    //
     Bool_t IsDebug(){return(debug);};
     Bool_t IsRunAlreadyInserted();
     Bool_t IsRunConsistent(Bool_t mishead, Bool_t mistrail, UInt_t &firstev, UInt_t &lastev);
-	//
-	Bool_t MissingTRK_CALIB(UInt_t t1,UInt_t t2);
-	//
-    UInt_t PKT(UInt_t pkt_num);
+    Bool_t AutoBoot(){return(AUTOBOOT);};
+    //
+    Bool_t MissingTRK_CALIB(UInt_t t1,UInt_t t2);
+    //
+    Long64_t PKT(UInt_t pkt_num);
     //
-    ULong64_t OBT(UInt_t obt);
+    Long64_t OBT(UInt_t obt);
     //
+    UInt_t AssignRunID();
+
+    // GL_TLE related functions
+    int insertTle(cTle*);
+    bool isTlePresent(cTle*);
 
  public: 
     //
-    PamelaDBOperations(TString host, TString user, TString password, TString filerawname, TString filerootname, UInt_t boot, UInt_t tsync, UInt_t obt0, Bool_t debug, Long64_t olderthan); // 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
     //
     void Close(); // destructor
     //
@@ -178,6 +196,10 @@
     void SetCommonGLRUN(UInt_t absth, UInt_t abstt);
     void SetNOBOOT(Bool_t noboot);
     void SetOlderThan(Long64_t oldthan);
+    void SetTLEPath(TString str);
+    void SetOrbitNo();
+    void SetNoFrag(Bool_t nf);
+    void SetAutoBoot(Bool_t nf);
     //
     Bool_t SetID_RAW();
     //
@@ -203,7 +225,7 @@
     TString GetRootName(){return(filerootname);};
     TString GetRawName(){return(filerawname);};
 	
-	const char*  GetCleanTime(){return clean_time->AsSQLString();};
+    const char*  GetCleanTime(){return clean_time->AsSQLString();};
     //
     // Functions
     //
@@ -216,16 +238,25 @@
     Int_t insertTRK_CALIB(); 
     Int_t insertS4_CALIB(); 
     Int_t CleanGL_RUN_FRAGMENTS();
+    Int_t CleanGL_RUN_FRAGMENTS(TString fcleanfile);
     Int_t ValidateRuns();
-	Int_t assignVALIDATION(UInt_t ,Bool_t );
-	//
-//    void OpenFile();
+    Int_t ValidateRuns(TString valfile);
+    Int_t assignVALIDATION(UInt_t ,Bool_t );
+    Int_t removeFile(TString rootfilename);
+    //
+    //    void OpenFile();
+    void CheckValidate(Long64_t olderthan);
     void CheckConnection();
+    void CheckFile();
     //
 	
-	Bool_t InsertRoot(){return(INSERT_ROOT);};
-	Bool_t InsertRaw(){return(INSERT_RAW);};
-	Bool_t Validate(){return(VALIDATE);};
+    Bool_t NoFrag(){return(NOFRAG);};
+    Bool_t InsertRoot(){return(INSERT_ROOT);};
+    Bool_t InsertRaw(){return(INSERT_RAW);};
+    Bool_t Validate(){return(VALIDATE);};
+
+    // Functions for TLE
+    Int_t populateTLE();
 	
 };
 #endif /* PAMELA_DB_OPERATIONS_H */