--- YodaProfiler/inc/PamelaDBOperations.h	2006/08/30 11:18:13	1.1.1.1
+++ YodaProfiler/inc/PamelaDBOperations.h	2006/09/11 16:38:18	1.4
@@ -5,7 +5,6 @@
 #include <list>
 //
 #include <TSQLServer.h>
-#include <TArrayD.h>
 //
 #include <EventHeader.h>
 #include <PscuHeader.h>
@@ -50,6 +49,8 @@
     UInt_t tsync;
     UInt_t toffset;
     //
+//    Long64_t olderthan;
+    //
     UInt_t BOOTNO;
     UInt_t obt0;
     UInt_t id;
@@ -76,6 +77,14 @@
     //
     Bool_t NOBOOT;
     Bool_t debug;
+	
+	// flag to control profiler actions
+	Bool_t INSERT_RAW;
+	Bool_t INSERT_ROOT;
+	Bool_t VALIDATE;
+	
+	TDatime *clean_time;
+		
     //
     typedef std::list<const char*> pcksList;
     static void getPacketsNames(pcksList &pcksNames){
@@ -140,17 +149,17 @@
     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);
     //
     ULong64_t OBT(UInt_t obt);
     //
-    TArrayD S4_paramfit(pamela::CalibS4Event *S4CalibEvent);
-    //
 
  public: 
     //
-    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, Long64_t olderthan); // constructor
     //
     void Close(); // destructor
     //
@@ -168,6 +177,7 @@
     void SetObt0(UInt_t ts); 
     void SetCommonGLRUN(UInt_t absth, UInt_t abstt);
     void SetNOBOOT(Bool_t noboot);
+    void SetOlderThan(Long64_t oldthan);
     //
     Bool_t SetID_RAW();
     //
@@ -192,6 +202,8 @@
     TString GetRootPath(){return((TString)gSystem->DirName(filerootname.Data())+'/');};
     TString GetRootName(){return(filerootname);};
     TString GetRawName(){return(filerawname);};
+	
+	const char*  GetCleanTime(){return clean_time->AsSQLString();};
     //
     // Functions
     //
@@ -203,9 +215,17 @@
     Int_t insertCALO_CALIB(); 
     Int_t insertTRK_CALIB(); 
     Int_t insertS4_CALIB(); 
-    //
-    void OpenFile();
-    void CheckFile();
-    //
+    Int_t CleanGL_RUN_FRAGMENTS();
+    Int_t ValidateRuns();
+	Int_t assignVALIDATION(UInt_t ,Bool_t );
+	//
+//    void OpenFile();
+    void CheckConnection();
+    //
+	
+	Bool_t InsertRoot(){return(INSERT_ROOT);};
+	Bool_t InsertRaw(){return(INSERT_RAW);};
+	Bool_t Validate(){return(VALIDATE);};
+	
 };
 #endif /* PAMELA_DB_OPERATIONS_H */