RunH4TablePositionDat Class Reference

#include <RunH4TablePositionDat.h>

Inheritance diagram for RunH4TablePositionDat:

Public Member Functions
int	getNumEvents () const
int	getNumSpills () const
std::string	getTable ()
int	getTableX () const
int	getTableY () const
	RunH4TablePositionDat ()
void	setNumEvents (int num)
void	setNumSpills (int num)
void	setTableX (int num)
void	setTableY (int num)
	~RunH4TablePositionDat ()
Public Member Functions inherited from IDataItem
	IDataItem ()
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, RunH4TablePositionDat > *fillMap, RunIOV *iov) noexcept(false)
void	prepareWrite () noexcept(false)
void	writeDB (const EcalLogicID *ecid, const RunH4TablePositionDat *item, RunIOV *iov) noexcept(false)

Private Attributes
int	m_numEvents
int	m_numSpills
int	m_table_x
int	m_table_y

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 () noexcept(false)
void	createReadStatement () noexcept(false)
void	setPrefetchRowCount (int ncount) noexcept(false)
void	terminateReadStatement () noexcept(false)
void	terminateWriteStatement () noexcept(false)
Protected Member Functions inherited from IDBObject
void	checkConnection () const noexcept(false)
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 RunH4TablePositionDat.h.

Constructor & Destructor Documentation

RunH4TablePositionDat::RunH4TablePositionDat

(

)

Definition at line 11 of file RunH4TablePositionDat.cc.

References NULL.

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

  m_table_x = 0;
  m_table_y = 0;
  m_numSpills = 0;
  m_numEvents = 0;
}

RunH4TablePositionDat::~RunH4TablePositionDat

(

)

Definition at line 26 of file RunH4TablePositionDat.cc.

{
}

Member Function Documentation

void RunH4TablePositionDat::fetchData ( std::map< EcalLogicID, RunH4TablePositionDat > *  fillMap, RunIOV *  iov  )

privatenoexcept

Definition at line 78 of file RunH4TablePositionDat.cc.

References alignCSCRings::e, o2o::iov, AlCaHLTBitMon_ParallelJobs::p, setNumEvents(), setNumSpills(), setTableX(), and setTableY().

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

  iov->setConnection(m_env, m_conn);
  int iovID = iov->fetchID();
  if (!iovID) { 
    //  throw(std::runtime_error("RunH4TablePositionDat::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.table_x, d.table_y, d.number_of_spills, d.number_of_events "
         "FROM channelview cv JOIN run_h4_table_position_dat 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, RunH4TablePositionDat > p;
    RunH4TablePositionDat 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.setTableX( rset->getInt(7) );
      dat.setTableY( rset->getInt(8) );
      dat.setNumSpills( rset->getInt(9) );
      dat.setNumEvents( rset->getInt(10) );

      p.second = dat;
      fillMap->insert(p);
    }

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

int RunH4TablePositionDat::getNumEvents ( ) const

inline

Definition at line 30 of file RunH4TablePositionDat.h.

References m_numEvents.

{ return m_numEvents; }

int RunH4TablePositionDat::getNumSpills ( ) const

inline

Definition at line 27 of file RunH4TablePositionDat.h.

References m_numSpills.

{ return m_numSpills; }

std::string RunH4TablePositionDat::getTable ( )

inlinevirtual

Implements IDataItem.

Definition at line 18 of file RunH4TablePositionDat.h.

{ return "RUN_H4_TABLE_POSITION_DAT"; }

int RunH4TablePositionDat::getTableX ( ) const

inline

Definition at line 21 of file RunH4TablePositionDat.h.

References m_table_x.

{ return m_table_x; }

int RunH4TablePositionDat::getTableY ( ) const

inline

Definition at line 24 of file RunH4TablePositionDat.h.

References m_table_y.

{ return m_table_y; }

void RunH4TablePositionDat::prepareWrite ( )

privatevirtualnoexcept

Implements IDataItem.

Definition at line 32 of file RunH4TablePositionDat.cc.

References alignCSCRings::e.

{
  this->checkConnection();

  try {
    m_writeStmt = m_conn->createStatement();
    m_writeStmt->setSQL("INSERT INTO run_h4_table_position_dat (iov_id, logic_id, "
            "table_x, table_y, number_of_spills, number_of_events ) "
            "VALUES (:iov_id, :logic_id, "
            ":table_x, :table_y, :number_of_spills, :number_of_events)");
  } catch (SQLException &e) {
    throw(std::runtime_error("RunH4TablePositionDat::prepareWrite():  "+e.getMessage()));
  }
}

void RunH4TablePositionDat::setNumEvents ( int  num )

inline

Definition at line 29 of file RunH4TablePositionDat.h.

References m_numEvents, and pileupDistInMC::num.

Referenced by fetchData().

{ m_numEvents = num; }

void RunH4TablePositionDat::setNumSpills ( int  num )

inline

Definition at line 26 of file RunH4TablePositionDat.h.

References m_numSpills, and pileupDistInMC::num.

Referenced by fetchData().

{ m_numSpills = num; }

void RunH4TablePositionDat::setTableX ( int  num )

inline

Definition at line 20 of file RunH4TablePositionDat.h.

References m_table_x, and pileupDistInMC::num.

Referenced by fetchData().

{ m_table_x = num; }

void RunH4TablePositionDat::setTableY ( int  num )

inline

Definition at line 23 of file RunH4TablePositionDat.h.

References m_table_y, and pileupDistInMC::num.

Referenced by fetchData().

{ m_table_y = num; }

void RunH4TablePositionDat::writeDB ( const EcalLogicID *  ecid, const RunH4TablePositionDat *  item, RunIOV *  iov  )

privatenoexcept

Definition at line 50 of file RunH4TablePositionDat.cc.

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

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

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

  int logicID = ecid->getLogicID();
  if (!logicID) { throw(std::runtime_error("RunH4TablePositionDat::writeDB:  Bad EcalLogicID")); }
  
  try {
    m_writeStmt->setInt(1, iovID);
    m_writeStmt->setInt(2, logicID);
    m_writeStmt->setInt(3, item->getTableX());
    m_writeStmt->setInt(4, item->getTableY());
    m_writeStmt->setInt(5, item->getNumSpills());
    m_writeStmt->setInt(6, item->getNumEvents());

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

Friends And Related Function Documentation

friend class EcalCondDBInterface

friend

Definition at line 13 of file RunH4TablePositionDat.h.

Member Data Documentation

int RunH4TablePositionDat::m_numEvents

private

Definition at line 46 of file RunH4TablePositionDat.h.

Referenced by getNumEvents(), and setNumEvents().

int RunH4TablePositionDat::m_numSpills

private

Definition at line 45 of file RunH4TablePositionDat.h.

Referenced by getNumSpills(), and setNumSpills().

int RunH4TablePositionDat::m_table_x

private

Definition at line 43 of file RunH4TablePositionDat.h.

Referenced by getTableX(), and setTableX().

int RunH4TablePositionDat::m_table_y

private

Definition at line 44 of file RunH4TablePositionDat.h.

Referenced by getTableY(), and setTableY().