/[PAMELA software]/YodaProfiler/src/GLTables.cpp

Diff of /YodaProfiler/src/GLTables.cpp

Parent Directory | Revision Log | View Patch Patch

-revision 1.11 by mocchiut,
Fri Sep 22 09:18:06 2006 UTC
+revision 1.12 by mocchiut,
Tue Oct 17 15:20:04 2006 UTC
 Line 6
   */
  //
  #include <sstream>
+ #include <iostream>
  //
  #include <TFile.h>
  #include <TTree.h>
-Line 13
+Line 14
  #include <PscuHeader.h>
  //
  #include <GLTables.h>
+ #include <cTle.h>
  //
  ClassImp(GL_TRK_CALIB);
  ClassImp(GL_RUN);
-Line 21 
 ClassImp(GL_PARAM);
+Line 23 
 ClassImp(GL_PARAM);
  ClassImp(GL_S4_CALIB);
  ClassImp(GL_CALO_CALIB);
  ClassImp(GL_TIMESYNC);
+ ClassImp(GL_TLE);
  //
  using namespace std;
-Line 155 
 GL_TIMESYNC::GL_TIMESYNC(){
+Line 158 
 GL_TIMESYNC::GL_TIMESYNC(){
    OBT0     = 0;
    TIMESYNC = 0;
    TYPE     = 0;
- }// ****************************************************
+ }
+ GL_TLE::GL_TLE(){
+ }
+ // ****************************************************
  void GL_RUN::SetEV_FROM(UInt_t evfrom){
    EV_FROM = evfrom;
-Line 1223 
 TString GL_TIMESYNC::UnConvertTime(TStri
+Line 1230 
 TString GL_TIMESYNC::UnConvertTime(TStri
    //
    return(rtime);
  }
+ // ****************************************************
+ /**
+  * Function to query the GL_TLE table of the DB.
+  *
+  * time is the unix time for which a good tle is requested.
+  *
+  * Return the pointer to a cTle object that has the closest and
+  * previous date compared with time.
+  *
+  * If errors occurs it returns NULL.
+  */
+ cTle* GL_TLE::Query_GL_TLE(UInt_t time, TSQLServer *dbc){
+   stringstream myquery;
+   myquery.str("");
+   myquery << "SELECT TLE1, TLE2, TLE3 FROM GL_TLE "
+           << "WHERE FROM_TIME < FROM_UNIXTIME(" << time << ") ORDER BY FROM_TIME DESC LIMIT 1;";
+   return Query_GL_TLE_go(myquery.str(), dbc);
+ }
+ // ****************************************************
+ /**
+  * Function to query the GL_TLE table of the DB.
+  *
+  * date is a datetime format YYYY-MM-DD hh:mm:ss for which a good tle
+  * is requested.
+  *
+  * Return the pointer to a cTle object that has the closest and
+  * previous date compared with time.
+  *
+  * If errors occurs it returns NULL.
+  */
+ cTle* GL_TLE::Query_GL_TLE(TString date, TSQLServer *dbc){
+   stringstream myquery;
+   myquery.str("");
+   myquery << "SELECT TLE1, TLE2, TLE3 FROM GL_TLE "
+           << "WHERE FROM_TIME < '" << date.Data() << "' ORDER BY FROM_TIME DESC LIMIT 1;";
+   return Query_GL_TLE_go(myquery.str(), dbc);
+ }
+ // ****************************************************
+ /**
+  * Private function used by Query_GL_TLE methods.
+  *
+  * myquery is the query string.
+  *
+  * Return the pointer to a cTle object that has the closest and
+  * previous date compared with time.
+  *
+  * If errors occurs it returns NULL.
+  */
+ cTle* GL_TLE::Query_GL_TLE_go(TString myquery, TSQLServer *dbc){
+   cTle *tle;
+   string tle1, tle2, tle3;
+   // MySQL variables
+   TSQLResult *result;
+   TSQLRow *row;
+   result = dbc->Query(myquery.Data());
+   if(! result->GetRowCount() ) return NULL;
+   row = result->Next();
+   tle1 = row->GetField(0);
+   tle2 = row->GetField(1);
+   tle3 = row->GetField(2);
+   tle = new cTle(tle1, tle2, tle3);
+   delete result;
+   delete row;
+   return tle;
+ }

 Legend:



Removed from v.1.11
 


changed lines


 
Added in v.1.12
 Legend:



Removed from v.1.11
 


changed lines


 
Added in v.1.12
-Removed from v.1.11
+Added in v.1.12

	ViewVC Help
Powered by ViewVC 1.1.23