MODDCCDetailsDat Class Reference

#include <MODDCCDetailsDat.h>

Inheritance diagram for MODDCCDetailsDat:

Public Member Functions
int	getAlmostFullFIFO () const
int	getBlockSize () const
int	getBXNumber () const
int	getDataTimeout () const
int	getEvenParity () const
int	getEventNumber () const
int	getForcedFullSupp () const
int	getFullFIFO () const
int	getHeader () const
int	getOddParity () const
int	getOpticalLink () const
int	getQPLL () const
std::string	getTable ()
	MODDCCDetailsDat ()
void	setAlmostFullFIFO (int x)
void	setBlockSize (int x)
void	setBXNumber (int x)
void	setDataTimeout (int x)
void	setEvenParity (int x)
void	setEventNumber (int x)
void	setForcedFullSupp (int x)
void	setFullFIFO (int x)
void	setHeader (int x)
void	setOddParity (int x)
void	setOpticalLink (int x)
void	setQPLL (int x)
	~MODDCCDetailsDat ()
Public Member Functions inherited from IDBObject
oracle::occi::Connection *	getConn () const
oracle::occi::Environment *	getEnv () const
void	setConnection (oracle::occi::Environment *env, oracle::occi::Connection *conn)
virtual	~IDBObject ()

Private Member Functions
void	fetchData (std::map< EcalLogicID, MODDCCDetailsDat > *fillMap, MODRunIOV *iov) throw (std::runtime_error)
void	prepareWrite () throw (std::runtime_error)
void	writeArrayDB (const std::map< EcalLogicID, MODDCCDetailsDat > *data, MODRunIOV *iov) throw (std::runtime_error)
void	writeDB (const EcalLogicID *ecid, const MODDCCDetailsDat *item, MODRunIOV *iov) throw (std::runtime_error)

Private Attributes
int	m_alff
int	m_blsi
int	m_bxnu
int	m_evnu
int	m_evpa
int	m_fuff
int	m_fusu
int	m_head
int	m_odpa
int	m_opto
int	m_qpll
int	m_tout

Friends
class	EcalCondDBInterface

Additional Inherited Members
Static Public Attributes inherited from IDBObject
static int const	ECALDB_NROWS =1024
Protected Member Functions inherited from IDataItem
void	checkPrepare () throw (std::runtime_error)
void	createReadStatement () throw (std::runtime_error)
void	setPrefetchRowCount (int ncount) throw (std::runtime_error)
void	terminateReadStatement () throw (std::runtime_error)
void	terminateWriteStatement () throw (std::runtime_error)
Protected Member Functions inherited from IDBObject
void	checkConnection () const throw (std::runtime_error)
Protected Attributes inherited from IDataItem
oracle::occi::Statement *	m_readStmt
oracle::occi::Statement *	m_writeStmt
Protected Attributes inherited from IDBObject
oracle::occi::Connection *	m_conn
oracle::occi::Environment *	m_env

Detailed Description

Definition at line 11 of file MODDCCDetailsDat.h.

Constructor & Destructor Documentation

MODDCCDetailsDat::MODDCCDetailsDat

(

)

Definition at line 11 of file MODDCCDetailsDat.cc.

References NULL.

{
  m_env = NULL;
  m_conn = NULL;
  m_writeStmt = NULL;
  m_readStmt = NULL;

   m_qpll=0;
   m_opto=0;
   m_tout=0;
   m_head=0;
   m_evnu=0;
   m_bxnu=0;
   m_evpa=0;
   m_odpa=0;
   m_blsi=0;
   m_alff=0;
   m_fuff=0;
   m_fusu=0;

}

MODDCCDetailsDat::~MODDCCDetailsDat

(

)

Definition at line 35 of file MODDCCDetailsDat.cc.

{
}

Member Function Documentation

void MODDCCDetailsDat::fetchData ( std::map< EcalLogicID, MODDCCDetailsDat > *  fillMap, MODRunIOV *  iov  ) throw ( std::runtime_error )

private

Definition at line 97 of file MODDCCDetailsDat.cc.

References alignCSCRings::e, edm::pset::fillMap(), o2o::iov, AlCaHLTBitMon_ParallelJobs::p, setAlmostFullFIFO(), setBlockSize(), setBXNumber(), setDataTimeout(), setEvenParity(), setEventNumber(), setForcedFullSupp(), setFullFIFO(), setHeader(), setOddParity(), setOpticalLink(), and setQPLL().

{
  this->checkConnection();
  fillMap->clear();

  iov->setConnection(m_env, m_conn);
  int iovID = iov->fetchID();
  if (!iovID) { 
    //  throw(std::runtime_error("MODDCCDetailsDat::writeDB:  IOV not in DB")); 
    return;
  }

  try {

    m_readStmt->setSQL("SELECT cv.name, cv.logic_id, cv.id1, cv.id2, cv.id3, cv.maps_to, "
         " d.qpll_error, d.optical_link, d.data_timeout, d.dcc_header, d.event_number, d.bx_number, d.even_parity, d.odd_parity, d.block_size, d.almost_full_fifo, d.full_fifo, d.forced_full_supp " 
         "FROM channelview cv JOIN "+getTable()+" d "
         "ON cv.logic_id = d.logic_id AND cv.name = cv.maps_to "
         "WHERE d.iov_id = :iov_id");
    m_readStmt->setInt(1, iovID);
    ResultSet* rset = m_readStmt->executeQuery();
    
    std::pair< EcalLogicID, MODDCCDetailsDat > p;
    MODDCCDetailsDat dat;
    while(rset->next()) {
      p.first = EcalLogicID( rset->getString(1),     // name
                 rset->getInt(2),        // logic_id
                 rset->getInt(3),        // id1
                 rset->getInt(4),        // id2
                 rset->getInt(5),        // id3
                 rset->getString(6));    // maps_to

      dat.setQPLL( rset->getInt(7) );
      dat.setOpticalLink( rset->getInt(8) );
      dat.setDataTimeout( rset->getInt(9) );
      dat.setHeader( rset->getInt(10) );
      dat.setEventNumber( rset->getInt(11) );
      dat.setBXNumber( rset->getInt(12) );
      dat.setEvenParity( rset->getInt(13) );
      dat.setOddParity( rset->getInt(14) );
      dat.setBlockSize( rset->getInt(15) );
      dat.setAlmostFullFIFO( rset->getInt(16) );
      dat.setFullFIFO( rset->getInt(17) );
      dat.setForcedFullSupp( rset->getInt(18) );

      p.second = dat;
      fillMap->insert(p);
    }
  } catch (SQLException &e) {
    throw(std::runtime_error("MODDCCDetailsDat::fetchData():  "+e.getMessage()));
  }
}

int MODDCCDetailsDat::getAlmostFullFIFO ( ) const

inline

Definition at line 48 of file MODDCCDetailsDat.h.

References m_alff.

Referenced by writeArrayDB().

{ return m_alff; }

int MODDCCDetailsDat::getBlockSize ( ) const

inline

Definition at line 45 of file MODDCCDetailsDat.h.

References m_blsi.

Referenced by writeArrayDB().

{ return m_blsi; }

int MODDCCDetailsDat::getBXNumber ( ) const

inline

Definition at line 36 of file MODDCCDetailsDat.h.

References m_bxnu.

Referenced by writeArrayDB().

{ return m_bxnu; }

int MODDCCDetailsDat::getDataTimeout ( ) const

inline

Definition at line 27 of file MODDCCDetailsDat.h.

References m_tout.

Referenced by writeArrayDB().

{ return m_tout; }

int MODDCCDetailsDat::getEvenParity ( ) const

inline

Definition at line 39 of file MODDCCDetailsDat.h.

References m_evpa.

Referenced by writeArrayDB().

{ return m_evpa; }

int MODDCCDetailsDat::getEventNumber ( ) const

inline

Definition at line 33 of file MODDCCDetailsDat.h.

References m_evnu.

Referenced by writeArrayDB().

{ return m_evnu; }

int MODDCCDetailsDat::getForcedFullSupp ( ) const

inline

Definition at line 54 of file MODDCCDetailsDat.h.

References m_fusu.

Referenced by writeArrayDB().

{ return m_fusu; }

int MODDCCDetailsDat::getFullFIFO ( ) const

inline

Definition at line 51 of file MODDCCDetailsDat.h.

References m_fuff.

Referenced by writeArrayDB().

{ return m_fuff; }

int MODDCCDetailsDat::getHeader ( ) const

inline

Definition at line 30 of file MODDCCDetailsDat.h.

References m_head.

Referenced by writeArrayDB().

{ return m_head; }

int MODDCCDetailsDat::getOddParity ( ) const

inline

Definition at line 42 of file MODDCCDetailsDat.h.

References m_odpa.

Referenced by writeArrayDB().

{ return m_odpa; }

int MODDCCDetailsDat::getOpticalLink ( ) const

inline

Definition at line 24 of file MODDCCDetailsDat.h.

References m_opto.

Referenced by writeArrayDB().

{ return m_opto; }

int MODDCCDetailsDat::getQPLL ( ) const

inline

Definition at line 21 of file MODDCCDetailsDat.h.

References m_qpll.

Referenced by writeArrayDB().

{ return m_qpll; }

std::string MODDCCDetailsDat::getTable ( )

inlinevirtual

Implements IDataItem.

Definition at line 18 of file MODDCCDetailsDat.h.

{ return "OD_DCC_DETAILS_DAT"; }

void MODDCCDetailsDat::prepareWrite ( ) throw ( std::runtime_error )

privatevirtual

Implements IDataItem.

Definition at line 41 of file MODDCCDetailsDat.cc.

References alignCSCRings::e.

{
  this->checkConnection();

  try {
    m_writeStmt = m_conn->createStatement();
    m_writeStmt->setSQL(" INSERT INTO "+getTable()+" (iov_id, logic_id, "
            " qpll_error, optical_link, data_timeout, dcc_header, event_number, bx_number, "
                        " even_parity, odd_parity, block_size, almost_full_fifo, full_fifo, "
                        " forced_full_supp ) "
            " VALUES (:iov_id, :logic_id, "
            " :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12 ) ");
  } catch (SQLException &e) {
    throw(std::runtime_error("MODDCCDetailsDat::prepareWrite():  "+e.getMessage()));
  }
}

void MODDCCDetailsDat::setAlmostFullFIFO ( int  x )

inline

Definition at line 47 of file MODDCCDetailsDat.h.

References m_alff, and x.

Referenced by fetchData().

{ m_alff = x; }

void MODDCCDetailsDat::setBlockSize ( int  x )

inline

Definition at line 44 of file MODDCCDetailsDat.h.

References m_blsi, and x.

Referenced by fetchData().

{ m_blsi = x; }

void MODDCCDetailsDat::setBXNumber ( int  x )

inline

Definition at line 35 of file MODDCCDetailsDat.h.

References m_bxnu, and x.

Referenced by fetchData().

{ m_bxnu = x; }

void MODDCCDetailsDat::setDataTimeout ( int  x )

inline

Definition at line 26 of file MODDCCDetailsDat.h.

References m_tout, and x.

Referenced by fetchData().

{ m_tout = x; }

void MODDCCDetailsDat::setEvenParity ( int  x )

inline

Definition at line 38 of file MODDCCDetailsDat.h.

References m_evpa, and x.

Referenced by fetchData().

{ m_evpa = x; }

void MODDCCDetailsDat::setEventNumber ( int  x )

inline

Definition at line 32 of file MODDCCDetailsDat.h.

References m_evnu, and x.

Referenced by fetchData().

{ m_evnu = x; }

void MODDCCDetailsDat::setForcedFullSupp ( int  x )

inline

Definition at line 53 of file MODDCCDetailsDat.h.

References m_fusu, and x.

Referenced by fetchData().

{ m_fusu = x; }

void MODDCCDetailsDat::setFullFIFO ( int  x )

inline

Definition at line 50 of file MODDCCDetailsDat.h.

References m_fuff, and x.

Referenced by fetchData().

{ m_fuff = x; }

void MODDCCDetailsDat::setHeader ( int  x )

inline

Definition at line 29 of file MODDCCDetailsDat.h.

References m_head, and x.

Referenced by fetchData().

{ m_head = x; }

void MODDCCDetailsDat::setOddParity ( int  x )

inline

Definition at line 41 of file MODDCCDetailsDat.h.

References m_odpa, and x.

Referenced by fetchData().

{ m_odpa = x; }

void MODDCCDetailsDat::setOpticalLink ( int  x )

inline

Definition at line 23 of file MODDCCDetailsDat.h.

References m_opto, and x.

Referenced by fetchData().

{ m_opto = x; }

void MODDCCDetailsDat::setQPLL ( int  x )

inline

Definition at line 20 of file MODDCCDetailsDat.h.

References m_qpll, and x.

Referenced by fetchData().

{ m_qpll = x; }

void MODDCCDetailsDat::writeArrayDB ( const std::map< EcalLogicID, MODDCCDetailsDat > *  data, MODRunIOV *  iov  ) throw ( std::runtime_error )

private

Definition at line 151 of file MODDCCDetailsDat.cc.

References prof2calltree::count, data, alignCSCRings::e, getAlmostFullFIFO(), getBlockSize(), getBXNumber(), getDataTimeout(), getEvenParity(), getEventNumber(), getForcedFullSupp(), getFullFIFO(), getHeader(), EcalLogicID::getLogicID(), getOddParity(), getOpticalLink(), getQPLL(), o2o::iov, and AlCaHLTBitMon_ParallelJobs::p.

{
  this->checkConnection();
  this->checkPrepare();

  int iovID = iov->fetchID();
  if (!iovID) { throw(std::runtime_error("MODDCCDetailsDat::writeArrayDB:  IOV not in DB")); }


  int nrows=data->size(); 
  int* ids= new int[nrows];
  int* iovid_vec= new int[nrows];
  int* xx1= new int[nrows];
  int* xx2= new int[nrows];
  int* xx3= new int[nrows];
  int* xx4= new int[nrows];
  int* xx5= new int[nrows];
  int* xx6= new int[nrows];
  int* xx7= new int[nrows];
  int* xx8= new int[nrows];
  int* xx9= new int[nrows];
  int* xx10= new int[nrows];
  int* xx11= new int[nrows];
  int* xx12= new int[nrows];

  ub2* ids_len= new ub2[nrows];
  ub2* iov_len= new ub2[nrows];
  ub2* x1_len= new ub2[nrows];
  ub2* x2_len= new ub2[nrows];
  ub2* x3_len= new ub2[nrows];
  ub2* x4_len= new ub2[nrows];
  ub2* x5_len= new ub2[nrows];
  ub2* x6_len= new ub2[nrows];
  ub2* x7_len= new ub2[nrows];
  ub2* x8_len= new ub2[nrows];
  ub2* x9_len= new ub2[nrows];
  ub2* x10_len= new ub2[nrows];
  ub2* x11_len= new ub2[nrows];
  ub2* x12_len= new ub2[nrows];

  const EcalLogicID* channel;
  const MODDCCDetailsDat* dataitem;
  int count=0;
  typedef map< EcalLogicID, MODDCCDetailsDat >::const_iterator CI;
  for (CI p = data->begin(); p != data->end(); ++p) {
        channel = &(p->first);
    int logicID = channel->getLogicID();
    if (!logicID) { throw(std::runtime_error("MODDCCDetailsDat::writeArrayDB:  Bad EcalLogicID")); }
    ids[count]=logicID;
    iovid_vec[count]=iovID;

    dataitem = &(p->second);
    // dataIface.writeDB( channel, dataitem, iov);
    int x1= dataitem->getQPLL();
    int x2= dataitem->getOpticalLink();
    int x3= dataitem->getDataTimeout();
    int x4= dataitem->getHeader();
    int x5= dataitem->getEventNumber();
    int x6= dataitem->getBXNumber();
    int x7= dataitem->getEvenParity();
    int x8= dataitem->getOddParity();
    int x9= dataitem->getBlockSize();
    int x10=dataitem->getAlmostFullFIFO();
    int x11=dataitem->getFullFIFO();
    int x12=dataitem->getForcedFullSupp();

    xx1[count]=x1;
    xx2[count]=x2;
    xx3[count]=x3;
    xx4[count]=x4;
    xx5[count]=x5;
    xx6[count]=x6;
    xx7[count]=x7;
    xx8[count]=x8;
    xx9[count]=x9;
    xx10[count]=x10;
    xx11[count]=x11;
    xx12[count]=x12;


    ids_len[count]=sizeof(ids[count]);
    iov_len[count]=sizeof(iovid_vec[count]);
    
    x1_len[count]=sizeof(xx1[count]);
    x2_len[count]=sizeof(xx2[count]);
    x3_len[count]=sizeof(xx3[count]);
    x4_len[count]=sizeof(xx4[count]);
    x5_len[count]=sizeof(xx5[count]);
    x6_len[count]=sizeof(xx6[count]);
    x7_len[count]=sizeof(xx7[count]);
    x8_len[count]=sizeof(xx8[count]);
    x9_len[count]=sizeof(xx9[count]);
    x10_len[count]=sizeof(xx10[count]);
    x11_len[count]=sizeof(xx11[count]);
    x12_len[count]=sizeof(xx12[count]);

    count++;
     }


  try {
    m_writeStmt->setDataBuffer(1, (dvoid*)iovid_vec, OCCIINT, sizeof(iovid_vec[0]),iov_len);
    m_writeStmt->setDataBuffer(2, (dvoid*)ids, OCCIINT, sizeof(ids[0]), ids_len );
    m_writeStmt->setDataBuffer(3, (dvoid*)xx1, OCCIINT , sizeof(xx1[0]), x1_len );
    m_writeStmt->setDataBuffer(4, (dvoid*)xx2, OCCIINT , sizeof(xx2[0]), x2_len );
    m_writeStmt->setDataBuffer(5, (dvoid*)xx3, OCCIINT , sizeof(xx3[0]), x3_len );
    m_writeStmt->setDataBuffer(6, (dvoid*)xx4, OCCIINT , sizeof(xx4[0]), x4_len );
    m_writeStmt->setDataBuffer(7, (dvoid*)xx5, OCCIINT , sizeof(xx5[0]), x5_len );
    m_writeStmt->setDataBuffer(8, (dvoid*)xx6, OCCIINT , sizeof(xx6[0]), x6_len );
    m_writeStmt->setDataBuffer(9, (dvoid*)xx7, OCCIINT , sizeof(xx7[0]), x7_len );
    m_writeStmt->setDataBuffer(10, (dvoid*)xx8, OCCIINT , sizeof(xx8[0]), x8_len );
    m_writeStmt->setDataBuffer(11, (dvoid*)xx9, OCCIINT , sizeof(xx9[0]), x9_len );
    m_writeStmt->setDataBuffer(12, (dvoid*)xx10, OCCIINT , sizeof(xx10[0]), x10_len );
    m_writeStmt->setDataBuffer(13, (dvoid*)xx11, OCCIINT , sizeof(xx11[0]), x11_len );
    m_writeStmt->setDataBuffer(14, (dvoid*)xx12, OCCIINT , sizeof(xx12[0]), x12_len );

    m_writeStmt->executeArrayUpdate(nrows);

    delete [] ids;
    delete [] iovid_vec;
    delete [] xx1;
    delete [] xx2;
    delete [] xx3;
    delete [] xx4;
    delete [] xx5;
    delete [] xx6;
    delete [] xx7;
    delete [] xx8;
    delete [] xx9;
    delete [] xx10;
    delete [] xx11;
    delete [] xx12;


    delete [] ids_len;
    delete [] iov_len;
    delete [] x1_len;
    delete [] x2_len;
    delete [] x3_len;
    delete [] x4_len;
    delete [] x5_len;
    delete [] x6_len;
    delete [] x7_len;
    delete [] x8_len;
    delete [] x9_len;
    delete [] x10_len;
    delete [] x11_len;
    delete [] x12_len;


  } catch (SQLException &e) {
    throw(std::runtime_error("MonPedestalsDat::writeArrayDB():  "+e.getMessage()));
  }
}

void MODDCCDetailsDat::writeDB ( const EcalLogicID *  ecid, const MODDCCDetailsDat *  item, MODRunIOV *  iov  ) throw ( std::runtime_error )

private

Definition at line 61 of file MODDCCDetailsDat.cc.

References alignCSCRings::e, and o2o::iov.

{
  this->checkConnection();
  this->checkPrepare();

  int iovID = iov->fetchID();
  if (!iovID) { throw(std::runtime_error("MODDCCDetailsDat::writeDB:  IOV not in DB")); }

  int logicID = ecid->getLogicID();
  if (!logicID) { throw(std::runtime_error("MODDCCDetailsDat::writeDB:  Bad EcalLogicID")); }
  
  try {
    m_writeStmt->setInt(1, iovID);
    m_writeStmt->setInt(2, logicID);
    m_writeStmt->setInt(3, item->getQPLL() );
    m_writeStmt->setInt(4, item->getOpticalLink() );
    m_writeStmt->setInt(5, item->getDataTimeout() );
    m_writeStmt->setInt(6, item->getHeader() );
    m_writeStmt->setInt(7, item->getEventNumber() );
    m_writeStmt->setInt(8, item->getBXNumber() );
    m_writeStmt->setInt(9, item->getEvenParity() );
    m_writeStmt->setInt(10, item->getOddParity() );
    m_writeStmt->setInt(11, item->getBlockSize() );
    m_writeStmt->setInt(12, item->getAlmostFullFIFO() );
    m_writeStmt->setInt(13, item->getFullFIFO() );
    m_writeStmt->setInt(14, item->getForcedFullSupp() );

    m_writeStmt->executeUpdate();
  } catch (SQLException &e) {
    throw(std::runtime_error("MODDCCDetailsDat::writeDB():  "+e.getMessage()));
  }
}

Friends And Related Function Documentation

friend class EcalCondDBInterface

friend

Definition at line 13 of file MODDCCDetailsDat.h.

Member Data Documentation

int MODDCCDetailsDat::m_alff

private

Definition at line 81 of file MODDCCDetailsDat.h.

Referenced by getAlmostFullFIFO(), and setAlmostFullFIFO().

int MODDCCDetailsDat::m_blsi

private

Definition at line 80 of file MODDCCDetailsDat.h.

Referenced by getBlockSize(), and setBlockSize().

int MODDCCDetailsDat::m_bxnu

private

Definition at line 77 of file MODDCCDetailsDat.h.

Referenced by getBXNumber(), and setBXNumber().

int MODDCCDetailsDat::m_evnu

private

Definition at line 76 of file MODDCCDetailsDat.h.

Referenced by getEventNumber(), and setEventNumber().

int MODDCCDetailsDat::m_evpa

private

Definition at line 78 of file MODDCCDetailsDat.h.

Referenced by getEvenParity(), and setEvenParity().

int MODDCCDetailsDat::m_fuff

private

Definition at line 82 of file MODDCCDetailsDat.h.

Referenced by getFullFIFO(), and setFullFIFO().

int MODDCCDetailsDat::m_fusu

private

Definition at line 83 of file MODDCCDetailsDat.h.

Referenced by getForcedFullSupp(), and setForcedFullSupp().

int MODDCCDetailsDat::m_head

private

Definition at line 75 of file MODDCCDetailsDat.h.

Referenced by getHeader(), and setHeader().

int MODDCCDetailsDat::m_odpa

private

Definition at line 79 of file MODDCCDetailsDat.h.

Referenced by getOddParity(), and setOddParity().

int MODDCCDetailsDat::m_opto

private

Definition at line 73 of file MODDCCDetailsDat.h.

Referenced by getOpticalLink(), and setOpticalLink().

int MODDCCDetailsDat::m_qpll

private

Definition at line 72 of file MODDCCDetailsDat.h.

Referenced by getQPLL(), and setQPLL().

int MODDCCDetailsDat::m_tout

private

Definition at line 74 of file MODDCCDetailsDat.h.

Referenced by getDataTimeout(), and setDataTimeout().