--- YodaProfiler/src/GLTables.cpp	2006/10/20 11:39:37	1.13
+++ YodaProfiler/src/GLTables.cpp	2006/10/31 15:36:04	1.15
@@ -373,6 +373,272 @@
 
 }
 
+/**
+ * This method delete the run from the "FromTable" table and store it in the GL_RUN_TRASH table
+ * If IDRUN is 0 "this->ID" run is used.
+ *
+ **/
+Int_t GL_RUN::DeleteRun(TSQLServer *dbc,UInt_t IDRUN,TString FromTable){
+  // MySQL variables
+  TSQLResult *pResult;
+  TSQLRow *Row;
+  stringstream myquery;
+  //
+  if ( !IDRUN ) IDRUN = ID;
+  if ( !IDRUN ) return 1;
+  // ----------------
+  myquery.str("");
+  myquery << " INSERT INTO GL_RUN_TRASH (";  
+  myquery << "ID";
+  myquery << ",ID_RUN_FRAG";
+  myquery << ",ID_ROOT_L0";
+  myquery << ",ID_ROOT_L2";
+  myquery << ",RUNHEADER_TIME";
+  myquery << ",RUNTRAILER_TIME";
+  myquery << ",RUNHEADER_OBT";
+  myquery << ",RUNTRAILER_OBT";
+  myquery << ",RUNHEADER_PKT";
+  myquery << ",RUNTRAILER_PKT";
+  myquery << ",BOOT_NUMBER";
+  myquery << ",EV_FROM";
+  myquery << ",EV_TO";
+  myquery << ",NEVENTS";
+  myquery << ",PKT_COUNTER";
+  myquery << ",PKT_READY_COUNTER";
+  myquery << ",COMPILATIONTIMESTAMP";
+  myquery << ",FAV_WRK_SCHEDULE";
+  myquery << ",EFF_WRK_SCHEDULE";
+  myquery << ",PRH_VAR_TRG_MODE_A";
+  myquery << ",PRH_VAR_TRG_MODE_B";
+  myquery << ",ACQ_BUILD_INFO";
+  myquery << ",ACQ_VAR_INFO";
+  myquery << ",RM_ACQ_AFTER_CALIB";
+  myquery << ",RM_ACQ_SETTING_MODE";
+  myquery << ",TRK_CALIB_USED";
+  myquery << ",CAL_DSP_MASK";
+  myquery << ",LAST_TIMESYNC";
+  myquery << ",OBT_TIMESYNC";
+  myquery << ",VALIDATION";
+  myquery << ",INSERT_TIME";
+  myquery << ") SELECT * FROM ";
+  myquery << FromTable.Data();
+  myquery << " WHERE ID=";
+  myquery << (UInt_t)IDRUN << ";";
+  //
+  //  printf("1myquery is %s \n",myquery.str().c_str());
+  //
+  dbc->Query(myquery.str().c_str());
+  //
+  // retrieve this ID_TRASH
+  //
+  myquery.str("");
+  myquery << " SELECT ID_TRASH,ID_ROOT_L0,ID_ROOT_L2 FROM GL_RUN_TRASH ORDER BY ID_TRASH DESC LIMIT 1";  
+  pResult = dbc->Query(myquery.str().c_str());
+  //
+  UInt_t idtrash = 0;
+  UInt_t idl0 = 0;
+  UInt_t idl2 = 0;
+  //
+  Row = pResult->Next();      
+  if( Row != NULL ){
+    idtrash = (UInt_t)atoll(Row->GetField(0));
+    idl0 = (UInt_t)atoll(Row->GetField(1));
+    idl2 = (UInt_t)atoll(Row->GetField(2));    
+  };
+  //
+  TString fileL0 = "";
+  TString fileL2 = "";
+  myquery.str("");
+  myquery << " SELECT NAME FROM GL_ROOT WHERE ID=";
+  myquery <<  idl0 << ";";
+  //
+  //  printf("2myquery is %s \n",myquery.str().c_str());
+  //
+  pResult = dbc->Query(myquery.str().c_str());
+  //
+  Row = pResult->Next();      
+  if( Row != NULL ){
+    fileL0 = (TString)Row->GetField(0);
+  };
+  //
+  //
+  //
+  myquery.str("");
+  myquery << " SELECT NAME FROM GL_ROOT WHERE ID=";
+  myquery << idl2 << ";";
+  //
+  //  printf("3myquery is %s \n",myquery.str().c_str());
+  //
+  pResult = dbc->Query(myquery.str().c_str());
+  //
+  Row = pResult->Next();      
+  if( Row != NULL ){
+    fileL2 = (TString)Row->GetField(0);
+  };
+  //
+  //
+  //
+  myquery.str("");
+  myquery << " UPDATE GL_RUN_TRASH SET FILENAMEL0='";
+  myquery <<  fileL0.Data() << "' where ID_TRASH=";
+  myquery << idtrash << ";";
+  //
+  //  printf("4myquery is %s \n",myquery.str().c_str());
+  //
+  dbc->Query(myquery.str().c_str());
+  //
+  myquery.str("");
+  myquery << " UPDATE GL_RUN_TRASH SET FILENAMEL2='";
+  myquery <<  fileL2.Data() << "' where ID_TRASH=";
+  myquery << idtrash << ";";
+  //
+  //  printf("4myquery is %s \n",myquery.str().c_str());
+  //
+  dbc->Query(myquery.str().c_str());
+  //
+  myquery.str("");
+  myquery << " UPDATE GL_RUN_TRASH SET BELONGED_TO='";
+  myquery <<  FromTable.Data() << "' where ID_TRASH=";
+  myquery << idtrash << ";";
+  //
+  //  printf("4myquery is %s \n",myquery.str().c_str());
+  //
+  //
+  dbc->Query(myquery.str().c_str());
+  //
+  myquery.str("");
+  myquery << " DELETE FROM ";
+  myquery <<  FromTable.Data() << " where ID=";
+  myquery << IDRUN << ";";
+  //
+  //  printf("5myquery is %s \n",myquery.str().c_str());
+  //
+  //
+  dbc->Query(myquery.str().c_str());
+  //
+  return 0;
+};
+
+
+
+/**
+ * This method restore a run from the GL_RUN_TRASH table.
+ * If ID is 0 "this->ID" is used; if "ToTable" is empty BELONG_TO field of GL_RUN_TRASH is used.
+ *
+ **/
+Int_t GL_RUN::RestoreRun(TSQLServer *dbc,UInt_t IDRUN,TString ToTable){
+  // insert into GL_RUN_FRAGMENTS select * FROM GL_RUN where ID=11;
+  //insert into GL_RUN_TRASH VALUES (ID , ID_RUN_FRAG , ID_ROOT_L0 , ID_ROOT_L2 , RUNHEADER_TIME , RUNTRAILER_TIME , RUNHEADER_OBT , RUNTRAILER_OBT , RUNHEADER_PKT , RUNTRAILER_PKT , BOOT_NUMBER , EV_FROM , EV_TO  , NEVENTS , PKT_COUNTER , PKT_READY_COUNTER , COMPILATIONTIMESTAMP , FAV_WRK_SCHEDULE , EFF_WRK_SCHEDULE , PRH_VAR_TRG_MODE_A , PRH_VAR_TRG_MODE_B , ACQ_BUILD_INFO , ACQ_VAR_INFO , RM_ACQ_AFTER_CALIB , RM_ACQ_SETTING_MODE, TRK_CALIB_USED,CAL_DSP_MASK, LAST_TIMESYNC, OBT_TIMESYNC, VALIDATION, INSERT_TIME) select * FROM GL_RUN where ID=11;
+  // MySQL variables
+  TSQLResult *pResult;
+  TSQLRow *Row;
+  stringstream myquery;
+  //
+  if ( !IDRUN ) IDRUN = ID;
+  if ( !IDRUN ) return 1;
+  //
+  if ( !strcmp(ToTable.Data(),"") ){
+    //    
+    myquery.str("");
+    myquery << " SELECT BELONGED_TO FROM GL_RUN_TRASH WHERE ID=";
+    myquery << (UInt_t)IDRUN << ";";
+    //
+    printf(" qui? myquery is %s \n",myquery.str().c_str());
+    //
+    pResult = dbc->Query(myquery.str().c_str());
+    //
+    Row = pResult->Next();      
+    if( Row != NULL ){
+     ToTable = (TString)Row->GetField(0);
+    } else {
+      return 1;
+    };
+  };
+  // ----------------
+  myquery.str("");
+  myquery << " INSERT INTO ";
+  myquery << ToTable.Data();
+  myquery << " (";  
+  myquery << "ID";
+  myquery << ",ID_RUN_FRAG";
+  myquery << ",ID_ROOT_L0";
+  myquery << ",ID_ROOT_L2";
+  myquery << ",RUNHEADER_TIME";
+  myquery << ",RUNTRAILER_TIME";
+  myquery << ",RUNHEADER_OBT";
+  myquery << ",RUNTRAILER_OBT";
+  myquery << ",RUNHEADER_PKT";
+  myquery << ",RUNTRAILER_PKT";
+  myquery << ",BOOT_NUMBER";
+  myquery << ",EV_FROM";
+  myquery << ",EV_TO";
+  myquery << ",NEVENTS";
+  myquery << ",PKT_COUNTER";
+  myquery << ",PKT_READY_COUNTER";
+  myquery << ",COMPILATIONTIMESTAMP";
+  myquery << ",FAV_WRK_SCHEDULE";
+  myquery << ",EFF_WRK_SCHEDULE";
+  myquery << ",PRH_VAR_TRG_MODE_A";
+  myquery << ",PRH_VAR_TRG_MODE_B";
+  myquery << ",ACQ_BUILD_INFO";
+  myquery << ",ACQ_VAR_INFO";
+  myquery << ",RM_ACQ_AFTER_CALIB";
+  myquery << ",RM_ACQ_SETTING_MODE";
+  myquery << ",TRK_CALIB_USED";
+  myquery << ",CAL_DSP_MASK";
+  myquery << ",LAST_TIMESYNC";
+  myquery << ",OBT_TIMESYNC";
+  myquery << ",VALIDATION";
+  myquery << ",INSERT_TIME";
+  myquery << ") SELECT ";
+  myquery << "ID";
+  myquery << ",ID_RUN_FRAG";
+  myquery << ",ID_ROOT_L0";
+  myquery << ",ID_ROOT_L2";
+  myquery << ",RUNHEADER_TIME";
+  myquery << ",RUNTRAILER_TIME";
+  myquery << ",RUNHEADER_OBT";
+  myquery << ",RUNTRAILER_OBT";
+  myquery << ",RUNHEADER_PKT";
+  myquery << ",RUNTRAILER_PKT";
+  myquery << ",BOOT_NUMBER";
+  myquery << ",EV_FROM";
+  myquery << ",EV_TO";
+  myquery << ",NEVENTS";
+  myquery << ",PKT_COUNTER";
+  myquery << ",PKT_READY_COUNTER";
+  myquery << ",COMPILATIONTIMESTAMP";
+  myquery << ",FAV_WRK_SCHEDULE";
+  myquery << ",EFF_WRK_SCHEDULE";
+  myquery << ",PRH_VAR_TRG_MODE_A";
+  myquery << ",PRH_VAR_TRG_MODE_B";
+  myquery << ",ACQ_BUILD_INFO";
+  myquery << ",ACQ_VAR_INFO";
+  myquery << ",RM_ACQ_AFTER_CALIB";
+  myquery << ",RM_ACQ_SETTING_MODE";
+  myquery << ",TRK_CALIB_USED";
+  myquery << ",CAL_DSP_MASK";
+  myquery << ",LAST_TIMESYNC";
+  myquery << ",OBT_TIMESYNC";
+  myquery << ",VALIDATION";
+  myquery << ",INSERT_TIME";
+  myquery << " FROM GL_RUN_TRASH ";
+  myquery << " WHERE BELONGED_TO='GL_RUN_FRAGMENTS' AND ID=";
+  myquery << (UInt_t)IDRUN << ";";
+  //
+  //  printf("5myquery is %s \n",myquery.str().c_str());
+  //
+  dbc->Query(myquery.str().c_str());
+  //
+  //
+  myquery.str("");
+  myquery << " DELETE FROM GL_RUN_TRASH where BELONGED_TO='GL_RUN_FRAGMENTS' AND ID=";
+  myquery << IDRUN << ";";
+  //
+  dbc->Query(myquery.str().c_str());
+  //
+  return 0;
+};
 
 /**
  * Function to fill the GL_RUN  table of the DB.
@@ -999,6 +1265,8 @@
   TSQLResult *pResult;
   TSQLRow *Row;
   stringstream myquery;
+  stringstream rname;
+  rname.str("");
   // ----------------
   myquery.str("");
   myquery << "select ";
@@ -1015,6 +1283,7 @@
       stringstream fname;
       fname.str("");
       fname << Row->GetField(0) << "/" << Row->GetField(1);
+      rname << Row->GetField(1);
       file = new TFile(fname.str().c_str(),"READ");
       idraw = (UInt_t)atoll(Row->GetField(2));
     };
@@ -1036,20 +1305,63 @@
   //
   UInt_t t0 = 0;
   //
-  myquery.str("");
-  myquery << "SELECT OFFSET_DATE FROM GL_RESURS_OFFSET WHERE FROM_ID_RAW<= " 
-      << idraw << " AND TO_ID_RAW >= " 
-      << idraw << ";";
-  pResult = dbc->Query(myquery.str().c_str());
-  if ( pResult ){
+  //
+  stringstream oss;
+  oss.str("");
+  oss << "SELECT OFFSET_DATE FROM GL_RESURS_OFFSET WHERE SPECIAL_FILE='" 
+      << rname.str().c_str() << "';";
+  //  if ( IsDebug() ) printf(" %s \n",oss.str().c_str());
+  pResult = dbc->Query(oss.str().c_str());
+  Row = pResult->Next();
+  //
+  TString name=rname.str().c_str();
+  UInt_t dworbit = 0;
+  Int_t nlength = name.Length();
+  if ( nlength < 5 ) return;
+  TString dwo = 0;
+  for (Int_t i = 0; i<5; i++){
+    dwo.Append(name[i],1);
+  };
+  if ( dwo.IsDigit() ){
+    dworbit = (UInt_t)dwo.Atoi();
+  } else {
+    dwo="";
+    for (Int_t i = 8; i<13; i++){
+      dwo.Append(name[i],1);
+    };     
+    if ( dwo.IsDigit() ) dworbit = (UInt_t)dwo.Atoi();
+  };
+  // if ( IsDebug() ) printf(" Downlink orbit is %i (dwo = %s) \n",dworbit,dwo.Data());  
+  //
+  if ( !Row ){
+    oss.str("");
+    oss << "SELECT OFFSET_DATE FROM GL_RESURS_OFFSET WHERE FROM_ORBIT< " 
+	<< dworbit << " order by FROM_ORBIT desc limit 1;";
+    //    if ( IsDebug() ) printf(" %s \n",oss.str().c_str());
+    pResult = dbc->Query(oss.str().c_str());
     Row = pResult->Next();
-    if ( Row ){
-      //
-      t0 = (UInt_t)TDatime(Row->GetField(0)).Convert();
-      //
+    if ( !Row ){
+      printf(" ERROR FROM GLTables! cannot determine Resurs offset \n");
+      return;
     };
   };
   //
+  t0 = (UInt_t)TDatime(Row->GetField(0)).Convert();
+  //
+  //  myquery.str("");
+  //   myquery << "SELECT OFFSET_DATE FROM GL_RESURS_OFFSET WHERE FROM_ID_RAW<= " 
+  //       << idraw << " AND TO_ID_RAW >= " 
+  //       << idraw << ";";
+  //   pResult = dbc->Query(myquery.str().c_str());
+  //   if ( pResult ){
+  //     Row = pResult->Next();
+  //     if ( Row ){
+  //       //
+  //       t0 = (UInt_t)TDatime(Row->GetField(0)).Convert();
+  //       //
+  //     };
+  //   };
+  //
   //
   // look for the correct timesync entry
   //