STEER/TFndDB.h

// @(#)fROOT/STEER:$Name:  $:$Id: TFndDB.h,v 1.13 2007/09/05 16:34:21 Diego_Faso Exp $
// Author: Diego Faso <mailto:faso@to.infn.it>, 2006/07/05

#ifndef FROOT_TFndDB
#define FROOT_TFndDB

//                                                                         //
//                               TFndFeeDB                                 //
//                                                                         //
// Interface to the FINUDA official database.                              //
//                                                                         //

#include "TObject.h"
#include "TSQLServer.h"
#include "TTreeSQL.h"
#include "TSQLResult.h"
#include "TSQLRow.h"

//#define FndDB_TofDB2StartTime 1145138400 // Sun Apr 16 00:00:00 2006
//#define FndDB_Lmd_NewTdcsTime 1045868400 // Sat Feb 22 00:00:00 2003

#include "FROOT.h"
using namespace FROOT;

class TFndDB: public TObject{

  static const Int_t K_N_DbTables = 6;

 private:
  Int_t fDebug;   
  TSQLServer *fDBServ; 
  TTreeSQL *fSqlTree[K_N_DbTables]; 
  TSQLResult *fCurRes; 
  TSQLRow *fCurRow; 

  Bool_t fIsThere; 

  Int_t fTofAdcSlab[K_N_Tof_AdcMod][K_N_Tof_AdcCha]; // TOF-ADC: Slab number
  Int_t fTofAdcSide[K_N_Tof_AdcMod][K_N_Tof_AdcCha]; // TOF-ADC: side flag (0:p-side ; 1:e-side)
  Int_t fTofTdcSlab[K_N_Tof_TdcMod][K_N_Tof_TdcCha]; // TOF-TDC: Slab number
  Int_t fTofTdcSide[K_N_Tof_TdcMod][K_N_Tof_TdcCha]; // TOF-TDC: side flag (0:p-side ; 1:e-side)
  Int_t fTofMtSlab[K_N_Tof_TdcMod][K_N_Tof_TdcCha];  // Slab Number


 private:

  Int_t FetchTofRunInfo(Bool_t verbose,const Int_t &run_time);
  Int_t FetchSilRunInfo(Bool_t verbose,Int_t run_time);
  Int_t FetchLmdRunInfo(Bool_t verbose,Int_t run_time);
  Int_t FetchStbRunInfo(Bool_t verbose,Int_t run_time);
  
  Int_t FetchTofCalibInfo(const Bool_t &verbose);
  Int_t FetchLmdCalibInfo(const Bool_t &verbose);
  Int_t FetchStbCalibInfo(const Bool_t &verbose);

  void PrintCurRow(Int_t row_num,Int_t print_mode);

 public:
  enum EFndDbTables {DBTAB_TOF_FEE = 0, DBTAB_TOF_CALIB, DBTAB_TOF_OFFSET, DBTAB_SIL_FEE, DBTAB_LMD_FEE, DBTAB_STB_FEE };
  enum EFndQueryPrintMode { Q_SILENT = 0, Q_GENINFO, Q_COMPACT, Q_DETAILED, Q_MYSQL_STYLE };

  TFndDB();
  ~TFndDB();

  Int_t ConnectToHost(const TString &server,TString user="finuda",TString passwd="",Int_t timeout = 3,Int_t n_trials = 10);
  void DisconnectFromHost();
  Bool_t IsConnected(){ return fDBServ->IsConnected(); }
  Bool_t IsThere() {return fIsThere;}     // Is there a database link?

  TSQLServer *GetDBServer() { return fDBServ; }
  TTreeSQL *GetSqlTree(Int_t table) { return fSqlTree[table];} // see the EFndDbTables

  Int_t FetchRunInfo(Bool_t verbose,UInt_t run_time=0,Bool_t also_calib=kTRUE);
  Int_t LoadAllInfo(Bool_t verbose,TString TofDB_str="TofDB2");
  Int_t UnloadAllInfo();

  TSQLResult* Query(TString DB_name,TString QueryStr,Int_t print_mode=(Int_t)(Q_SILENT));

  // static methods for channel/numbering comversions
  static void Tof_ChNum_To_DetChan(const Int_t &ch,Int_t &layer,Int_t &slab){
    // according to official DB numbering
    slab = ch % 100;
    layer = 1 + ((ch - slab) / 100);
  }
  
  static Int_t Tof_ChannelToDBNumbering(const Int_t &layer,const Int_t &slab){
    // layer:  [1;2]
    // slab:   [1,12] [1,72] (TOFINO TOFONE)
    return (Int_t)( ((layer-1) * 100) + slab );
  }
    
  static void Lmd_ChNum_To_DetChan(const Int_t &ch,Int_t &lay,Int_t &dch_num,Int_t &wire_num,Int_t &wirenode){
    // according to official DB numbering
    // wirenode is needed by the geometry manager
    Int_t tmp_val = ch;
    lay = (ch - (ch%1000))/1000;
    tmp_val -= 1000*lay;
    dch_num = (tmp_val - (tmp_val%100))/100;
    tmp_val -=  -(100*dch_num);
    wire_num = tmp_val%100;
    
    //
    // --- before fROOT-9.0
    /*     wirenode = wire_num-1; */
    /*     wirenode = wirenode + (Int_t)(wire_num/2); */
    /*     wirenode = wirenode *2; */
    /*     wirenode -= 2* (1- (Int_t)(wire_num%2)); */
    //
    //
    // --- after fROOT-9.0 (gcc-4/gfortran used for re-rceating geometry from fidarc 603)
    wirenode = wire_num-1;
    wirenode = wirenode + (Int_t)(wire_num/2);
    //    wirenode = wirenode ;
    wirenode -= (1- (Int_t)(wire_num%2));
  }
  
  static Int_t Lmd_ChannelToDBNumbering(const Int_t &lay,const Int_t &ch,const Int_t &wire){
    // lay:  [1;2]
    // ch:   [1,8]
    // wire: [1,12] (inner) ; [1,22] (outer)
    // wire == 0 is used by the external node
    
    Int_t channel = -1;
    channel = (Int_t)(
                      lay * 1000 +
                      ch  * 100  +
                      wire
                      );
    return channel;
  }

  static Int_t Lmd_ChannelToDBNumbering(const Int_t &cham,const Int_t &wire){
    // ch:   [11,18];[21,28] ===> inner;outer
    // wire: [1,12] (inner) ; [1,22] (outer)
    // wire == 0 is used by the external node
    
    Int_t ch = cham % 10;
    Int_t lay = (cham - ch) / 10;
    Int_t channel = -1;
    channel = (Int_t)(
                      lay * 1000 +
                      ch  * 100  +
                      wire
                      );
    return channel;
  }
  
  static void Stb_ChNum_To_DetChan(const Int_t &ch,Int_t &crown,Int_t &tube,Int_t &wirenode){
    // according to official DB numbering
    // wirenode is needed by the geometry manager
    Int_t tmp_val = ch;
    crown = (ch - (ch%1000))/1000;
    tmp_val -= 1000*crown;
    tube = tmp_val;
    
    wirenode = (tube *2) - (1 + crown%2);
    if(crown>=5) wirenode+= (2* K_N_STB_TUBES);
  }
  
  static Int_t Stb_ChannelToDBNumbering(const Int_t &crown,const Int_t &tube){
    // crown:  [1;6]
    // tube:   [1,404]
    return (Int_t)( crown * 1000 + tube );
  }
  
  
  ClassDef(TFndDB,1)
};
#endif // FROOT_TFndDB

---