TGrCalibration.cxx

Go to the documentation of this file.

//  TGrCalibration.cxx.
#include <iostream>
#include <sstream>

#include <TSQLRow.h>
#include <TMySQLServer.h>
#include <TMySQLResult.h>

#include "TGrCalibration.h"

using std::cerr;
using std::cout;
using std::endl;
using std::stringstream;

TGrCalibration::TGrCalibration(UInt_t channels)
  : fDatabase("mysql://localhost:3306/Online"),
    fAdc(channels), fLeTdc(channels), fCfTdc(channels)
{
}
 
TGrCalibration::~TGrCalibration()
{
}

void TGrCalibration::Clear(const Char_t *option)
{
  fAdc.Clear();
  fLeTdc.Clear();
  fCfTdc.Clear();
  cout << "Clear: TGrCalibration cleared" << endl;
}

void TGrCalibration::Print(const Char_t *option) const
{
  cout << "TGrCalibration:" << endl;
  cout << "ADC calibration: " << endl;
  fAdc.Print();
  cout << "LETDC calibration: " << endl;
  fLeTdc.Print();
  cout << "CFTDC calibration: " << endl;
  fCfTdc.Print();
}

void TGrCalibration::FindCalibration(const Char_t *detectorName)
{
  TMySQLResult *result = GetDatabaseInfo(detectorName);

  if (result) {
    UShort_t channels = fAdc.GetChannels();
    if (static_cast<UInt_t>(result->GetRowCount()) != channels)
      cerr << "FindCalibration: WARNING - rows in database ("
           << result->GetRowCount()    << ") do not match number " << endl
           << "of expected channels (" << channels    << ") for detector "
           << detectorName << " - using default calibration" << endl;
    else if (result->GetFieldCount() != 13)
      cerr << "FindCalibration: WARNING - columns in database ("
           << result->GetFieldCount() << ") do not match number "  << endl
           << "of expected columns (13) for detector " << detectorName
           << " - using default calibration" << endl;
    else {
      for (Int_t i = 0; i < result->GetRowCount(); i++) {
        TSQLRow *row = result->Next();
        stringstream *fields = new stringstream[result->GetFieldCount()];
        for (Int_t i = 0; i < result->GetFieldCount(); i++)
          fields[i] << row->GetField(i);
        UShort_t detectorChannel;
        UShort_t adcMap;
        Short_t adcOffset;
        Float_t  adcGain;
        UShort_t adcHistogramChannel;
        UShort_t leTdcMap;
        Short_t leTdcOffset;
        Float_t  leTdcGain;
        UShort_t leTdcHistogramChannel;
        UShort_t cfTdcMap;
        Short_t cfTdcOffset;
        Float_t  cfTdcGain;
        UShort_t cfTdcHistogramChannel;
        fields[0]  >> detectorChannel;
        fields[1]  >> adcMap;
        fields[2]  >> adcOffset;
        fields[3]  >> adcGain;
        fields[4]  >> adcHistogramChannel;
        fields[5]  >> leTdcMap;
        fields[6]  >> leTdcOffset;
        fields[7]  >> leTdcGain;
        fields[8]  >> leTdcHistogramChannel;
        fields[9]  >> cfTdcMap;
        fields[10] >> cfTdcOffset;
        fields[11] >> cfTdcGain;
        fields[12] >> cfTdcHistogramChannel;
        fAdc.AddToChannel(adcMap, detectorChannel);
        fAdc.AddToMap(detectorChannel, adcMap);
        fAdc.AddToOffset(detectorChannel, adcOffset);
        fAdc.AddToGain(detectorChannel, adcGain);
        fAdc.AddToHistogramMap(detectorChannel, adcHistogramChannel);
        fLeTdc.AddToChannel(leTdcMap, detectorChannel);
        fLeTdc.AddToMap(detectorChannel, leTdcMap);
        fLeTdc.AddToOffset(detectorChannel, leTdcOffset);
        fLeTdc.AddToGain(detectorChannel, leTdcGain);
        fLeTdc.AddToHistogramMap(detectorChannel, leTdcHistogramChannel);
        fCfTdc.AddToChannel(cfTdcMap, detectorChannel);
        fCfTdc.AddToMap(detectorChannel, cfTdcMap);
        fCfTdc.AddToOffset(detectorChannel, cfTdcOffset);
        fCfTdc.AddToGain(detectorChannel, cfTdcGain);
        fCfTdc.AddToHistogramMap(detectorChannel, cfTdcHistogramChannel);
        delete row;
        delete [] fields;
      }
      fAdc.SetBitMask();
      fLeTdc.SetBitMask();
      fCfTdc.SetBitMask();
    }
    delete result;
  } else
    cerr << "FindCalibration: ERROR - could not obtain database information"
         << endl;
}

TMySQLResult * TGrCalibration::GetDatabaseInfo(const Char_t *detectorName)
{
  TMySQLResult *result = 0;
  if (! detectorName) {
    cerr << "GetDatabaseInfo: ERROR - detector name must be set before "
         << "attempting to set the detector calibration" << endl;
  } else {
    string sql("SELECT * FROM ");
    
    sql.append(detectorName);
    sql.append(" ORDER BY `adc map`;");
    TMySQLServer connect(fDatabase.c_str(), "dragon", "dragonTail");
    result = static_cast<TMySQLResult *>(connect.Query(sql.c_str()));
  }
  return result;
}

---