RunInfoQuary.cc

Go to the documentation of this file.

#include "DBWriter/CalibPmtWriter.h"
#include "DBWriter/RunInfoQuary.h"
#include "Context/ContextRange.h"

#include "DatabaseInterface/DbiResultPtr.h"
#include "DatabaseInterface/DbiSqlContext.h"

#ifdef I_LIKE_DUPLICITY
#include "DaqRunInfoSvc/DaqRunInfo.h"
#else
#include "genDbi/GDaqRunInfo.h"
#endif

#include "iostream"

using namespace std;

int RunInfoQuary::runNo2ContextRange(int runNo , ContextRange& cr)
{
  //Get all the raw data files
  DbiSqlContext vc("1=1"); //WHERE clause

#ifdef I_LIKE_DUPLICITY
  DbiResultPtr<DaqRunInfo> rp("DaqRunInfo", vc);
#else
  DbiResultPtr<GDaqRunInfo> rp("DaqRunInfo", vc);
#endif

  // Check number of entries in result set
  unsigned int numRows = rp.GetNumRows();
  if (numRows < 1)
  {
    cout<<"No records is found in table DaqRunInfo"<<endl;
    return 0;
  }
#ifdef I_LIKE_DUPLICITY
  const DaqRunInfo* row;
#else
  const GDaqRunInfo* row;
#endif
  unsigned int idx = 0;
  while(idx < numRows)
  {
    row = rp.GetRow(idx);
    if(runNo == row->GetRunNo()) break;
    idx++;
  }
  if(idx == numRows)
  {
    cout<<"no record of "<<runNo<<" run "<<endl;
    return 0;
  }
  DbiResult* res = row->GetOwner();
  const DbiValidityRec vr = res->GetValidityRec();
  cr = vr.GetContextRange();
  return  1;
}

int RunInfoQuary::ContextRange2runNo(const ContextRange& cr)
{
  return 0;
}