#include <RunLaserRunDat.h>

Inheritance diagram for RunLaserRunDat:

Public Member Functions
std::string	getLaserSequenceCond () const

std::string	getLaserSequenceType () const

std::string	getTable () override

	RunLaserRunDat ()

void	setLaserSequenceCond (std::string x)

void	setLaserSequenceType (std::string x)

	~RunLaserRunDat () override

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, RunLaserRunDat > fillMap, RunIOV iov) noexcept(false)

void	prepareWrite () noexcept(false) override

void	writeDB (const EcalLogicID ecid, const RunLaserRunDat item, RunIOV *iov) noexcept(false)

Private Attributes
std::string	m_laserSeqCond

std::string	m_laserSeqType

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 RunLaserRunDat.h.

Constructor & Destructor Documentation

RunLaserRunDat::RunLaserRunDat ( )

Definition at line 11 of file RunLaserRunDat.cc.

 {
   m_env = nullptr;
   m_conn = nullptr;
   m_writeStmt = nullptr;
   m_laserSeqType = "";
   m_laserSeqCond = "";
 }

RunLaserRunDat::~RunLaserRunDat ( )

override

Definition at line 22 of file RunLaserRunDat.cc.

23 {

24 }

Member Function Documentation

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

privatenoexcept

Definition at line 72 of file RunLaserRunDat.cc.

References MillePedeFileConverter_cfg::e, AlCaHLTBitMon_ParallelJobs::p, setLaserSequenceCond(), setLaserSequenceType(), and AlCaHLTBitMon_QueryRunRegistry::string.

Referenced by getLaserSequenceCond().

 {
   this->checkConnection();
   fillMap->clear();
 
   iov->setConnection(m_env, m_conn);
   int iovID = iov->fetchID();
   if (!iovID) { 
     //  throw(std::runtime_error("RunLaserRunDat::writeDB:  IOV not in DB")); 
     return;
   }
 
   try {
     Statement* stmt = m_conn->createStatement();
     stmt->setSQL("SELECT cv.name, cv.logic_id, cv.id1, cv.id2, cv.id3, cv.maps_to, "
          "d.laser_sequence_type, d.laser_sequence_cond "
          "FROM channelview cv JOIN run_laserrun_config_dat d "
          "ON cv.logic_id = d.logic_id AND cv.name = cv.maps_to "
          "WHERE d.iov_id = :iov_id");
     stmt->setInt(1, iovID);
     ResultSet* rset = stmt->executeQuery();
     
     std::pair< EcalLogicID, RunLaserRunDat > p;
     RunLaserRunDat dat;
     while(rset->next()) {
       p.first = EcalLogicID( getOraString(rset,1),     // name
                  rset->getInt(2),        // logic_id
                  rset->getInt(3),        // id1
                  rset->getInt(4),        // id2
                  rset->getInt(5),        // id3
                  getOraString(rset,6));    // maps_to
 
       dat.setLaserSequenceType( getOraString(rset,7));    // maps_to
       dat.setLaserSequenceCond( getOraString(rset,8));    // maps_to
 
       p.second = dat;
       fillMap->insert(p);
     }
     m_conn->terminateStatement(stmt);
   } catch (SQLException &e) {
     throw(std::runtime_error(std::string("RunLaserRunDat::fetchData():  ")+getOraMessage(&e)));
   }
 }

std::string RunLaserRunDat::getLaserSequenceCond ( ) const

inline

Definition at line 24 of file RunLaserRunDat.h.

References fetchData(), m_laserSeqCond, noexcept, prepareWrite(), and writeDB().

24 { return m_laserSeqCond; }

RunLaserRunDat::m_laserSeqCond

std::string m_laserSeqCond

Definition: RunLaserRunDat.h:38

std::string RunLaserRunDat::getLaserSequenceType ( ) const

inline

Definition at line 21 of file RunLaserRunDat.h.

References m_laserSeqType.

21 { return m_laserSeqType; }

RunLaserRunDat::m_laserSeqType

std::string m_laserSeqType

Definition: RunLaserRunDat.h:37

std::string RunLaserRunDat::getTable ( )

inlineoverridevirtual

Implements IDataItem.

Definition at line 18 of file RunLaserRunDat.h.

18 { return "RUN_LASERRUN_CONFIG_DAT"; }

void RunLaserRunDat::prepareWrite ( )

overrideprivatevirtualnoexcept

Implements IDataItem.

Definition at line 28 of file RunLaserRunDat.cc.

References MillePedeFileConverter_cfg::e, and AlCaHLTBitMon_QueryRunRegistry::string.

Referenced by getLaserSequenceCond().

 {
   this->checkConnection();
 
   try {
     m_writeStmt = m_conn->createStatement();
     m_writeStmt->setSQL("INSERT INTO run_laserrun_config_dat (iov_id, logic_id, "
             "laser_sequence_type, laser_sequence_cond) "
             "VALUES (:1, :2, "
             ":3, :4 )");
   } catch (SQLException &e) {
     throw(std::runtime_error(std::string("RunLaserRunDat::prepareWrite():  ")+getOraMessage(&e)));
   }
 }

void RunLaserRunDat::setLaserSequenceCond ( std::string x )

inline

Definition at line 23 of file RunLaserRunDat.h.

References m_laserSeqCond, and x.

Referenced by fetchData().

23 { m_laserSeqCond = x; }

RunLaserRunDat::m_laserSeqCond

std::string m_laserSeqCond

Definition: RunLaserRunDat.h:38

DDAxes::x

void RunLaserRunDat::setLaserSequenceType ( std::string x )

inline

Definition at line 20 of file RunLaserRunDat.h.

References m_laserSeqType, and x.

Referenced by fetchData().

20 { m_laserSeqType = x; }

RunLaserRunDat::m_laserSeqType

std::string m_laserSeqType

Definition: RunLaserRunDat.h:37

DDAxes::x

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

privatenoexcept

Definition at line 46 of file RunLaserRunDat.cc.

References MillePedeFileConverter_cfg::e, and AlCaHLTBitMon_QueryRunRegistry::string.

Referenced by getLaserSequenceCond().

 {
   this->checkConnection();
   this->checkPrepare();
 
   int iovID = iov->fetchID();
   if (!iovID) { throw(std::runtime_error("RunLaserRunDat::writeDB:  IOV not in DB")); }
 
   int logicID = ecid->getLogicID();
   if (!logicID) { throw(std::runtime_error("RunLaserRunDat::writeDB:  Bad EcalLogicID")); }
   
   try {
     m_writeStmt->setInt(1, iovID);
     m_writeStmt->setInt(2, logicID);
     m_writeStmt->setString(3, item->getLaserSequenceType());
     m_writeStmt->setString(4, item->getLaserSequenceCond());
 
     m_writeStmt->executeUpdate();
   } catch (SQLException &e) {
     throw(std::runtime_error(std::string("RunLaserRunDat::writeDB():  ")+getOraMessage(&e)));
   }
 }