CMS 3D CMS Logo

List of all members | Public Member Functions | Private Member Functions | Private Attributes | Friends
MonLaserStatusDat Class Reference

#include <MonLaserStatusDat.h>

Inheritance diagram for MonLaserStatusDat:
IDataItem IDBObject

Public Member Functions

float getLaserFanout () const
 
float getLaserFilter () const
 
float getLaserPower () const
 
float getLaserWavelength () const
 
std::string getTable () override
 
 MonLaserStatusDat ()
 
void setLaserFanout (float p)
 
void setLaserFilter (float p)
 
void setLaserPower (float p)
 
void setLaserWavelength (float p)
 
 ~MonLaserStatusDat () 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, MonLaserStatusDat > *fillMap, MonRunIOV *iov) noexcept(false)
 
void prepareWrite () noexcept(false) override
 
void writeArrayDB (const std::map< EcalLogicID, MonLaserStatusDat > *data, MonRunIOV *iov) noexcept(false)
 
void writeDB (const EcalLogicID *ecid, const MonLaserStatusDat *item, MonRunIOV *iov) noexcept(false)
 

Private Attributes

float m_laserFanout
 
float m_laserFilter
 
float m_laserPower
 
float m_laserWavelength
 

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

Constructor & Destructor Documentation

MonLaserStatusDat::MonLaserStatusDat ( )

Definition at line 10 of file MonLaserStatusDat.cc.

11 {
12  m_env = nullptr;
13  m_conn = nullptr;
14  m_writeStmt = nullptr;
15  m_readStmt = nullptr;
16 
17  m_laserPower = 0;
18  m_laserFilter = 0;
20  m_laserFanout = 0;
21 }
oracle::occi::Environment * m_env
Definition: IDBObject.h:38
oracle::occi::Statement * m_writeStmt
Definition: IDataItem.h:28
oracle::occi::Connection * m_conn
Definition: IDBObject.h:39
oracle::occi::Statement * m_readStmt
Definition: IDataItem.h:29
MonLaserStatusDat::~MonLaserStatusDat ( )
override

Definition at line 25 of file MonLaserStatusDat.cc.

26 {
27 }

Member Function Documentation

void MonLaserStatusDat::fetchData ( std::map< EcalLogicID, MonLaserStatusDat > *  fillMap,
MonRunIOV iov 
)
privatenoexcept

Definition at line 78 of file MonLaserStatusDat.cc.

References MillePedeFileConverter_cfg::e, AlCaHLTBitMon_ParallelJobs::p, setLaserFanout(), setLaserFilter(), setLaserPower(), setLaserWavelength(), and AlCaHLTBitMon_QueryRunRegistry::string.

Referenced by getLaserFanout().

80 {
81  this->checkConnection();
82  fillMap->clear();
83 
84  iov->setConnection(m_env, m_conn);
85  int iovID = iov->fetchID();
86  if (!iovID) {
87  // throw(std::runtime_error("MonLaserStatusDat::writeDB: IOV not in DB"));
88  return;
89  }
90 
91  try {
92 
93  m_readStmt->setSQL("SELECT cv.name, cv.logic_id, cv.id1, cv.id2, cv.id3, cv.maps_to, "
94  "d.laser_power, d.laser_filter, d.laser_wavelength, d.laser_fanout "
95  "FROM channelview cv JOIN mon_laser_status_dat d "
96  "ON cv.logic_id = d.logic_id AND cv.name = cv.maps_to "
97  "WHERE d.iov_id = :iov_id");
98  m_readStmt->setInt(1, iovID);
99  ResultSet* rset = m_readStmt->executeQuery();
100 
101  std::pair< EcalLogicID, MonLaserStatusDat > p;
102  MonLaserStatusDat dat;
103  while(rset->next()) {
104  p.first = EcalLogicID( getOraString(rset,1), // name
105  rset->getInt(2), // logic_id
106  rset->getInt(3), // id1
107  rset->getInt(4), // id2
108  rset->getInt(5), // id3
109  getOraString(rset,6)); // maps_to
110 
111  dat.setLaserPower( rset->getFloat(7) );
112  dat.setLaserFilter( rset->getFloat(8) );
113  dat.setLaserWavelength( rset->getFloat(9) );
114  dat.setLaserFanout( rset->getFloat(10) );
115 
116  p.second = dat;
117  fillMap->insert(p);
118  }
119  } catch (SQLException &e) {
120  throw(std::runtime_error(std::string("MonLaserStatusDat::fetchData(): ")+getOraMessage(&e)));
121  }
122 }
void setLaserFanout(float p)
oracle::occi::Environment * m_env
Definition: IDBObject.h:38
oracle::occi::Connection * m_conn
Definition: IDBObject.h:39
void setLaserFilter(float p)
void setLaserPower(float p)
void setLaserWavelength(float p)
int fetchID() noexcept(false) override
Definition: MonRunIOV.cc:118
void checkConnection() const noexcept(false)
Definition: IDBObject.h:41
oracle::occi::Statement * m_readStmt
Definition: IDataItem.h:29
void setConnection(oracle::occi::Environment *env, oracle::occi::Connection *conn)
Definition: IDBObject.h:23
float MonLaserStatusDat::getLaserFanout ( ) const
inline

Definition at line 29 of file MonLaserStatusDat.h.

References data, fetchData(), m_laserFanout, noexcept, prepareWrite(), writeArrayDB(), and writeDB().

29 { return m_laserFanout; }
float MonLaserStatusDat::getLaserFilter ( ) const
inline

Definition at line 23 of file MonLaserStatusDat.h.

References m_laserFilter.

23 { return m_laserFilter; }
float MonLaserStatusDat::getLaserPower ( ) const
inline

Definition at line 20 of file MonLaserStatusDat.h.

References m_laserPower.

20 { return m_laserPower; }
float MonLaserStatusDat::getLaserWavelength ( ) const
inline

Definition at line 26 of file MonLaserStatusDat.h.

References m_laserWavelength.

26 { return m_laserWavelength; }
std::string MonLaserStatusDat::getTable ( )
inlineoverridevirtual

Implements IDataItem.

Definition at line 18 of file MonLaserStatusDat.h.

18 { return "MON_LASER_STATUS_DAT"; }
void MonLaserStatusDat::prepareWrite ( )
overrideprivatevirtualnoexcept

Implements IDataItem.

Definition at line 31 of file MonLaserStatusDat.cc.

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

Referenced by getLaserFanout().

33 {
34  this->checkConnection();
35 
36  try {
37  m_writeStmt = m_conn->createStatement();
38  m_writeStmt->setSQL("INSERT INTO mon_laser_status_dat (iov_id, logic_id, "
39  "laser_power, laser_filter, laser_wavelength, laser_fanout) "
40  "VALUES (:iov_id, :logic_id, "
41  ":3, :4, :5, :6)");
42  } catch (SQLException &e) {
43  throw(std::runtime_error(std::string("MonLaserStatusDat::prepareWrite(): ")+getOraMessage(&e)));
44  }
45 }
oracle::occi::Statement * m_writeStmt
Definition: IDataItem.h:28
oracle::occi::Connection * m_conn
Definition: IDBObject.h:39
void checkConnection() const noexcept(false)
Definition: IDBObject.h:41
void MonLaserStatusDat::setLaserFanout ( float  p)
inline
void MonLaserStatusDat::setLaserFilter ( float  p)
inline
void MonLaserStatusDat::setLaserPower ( float  p)
inline
void MonLaserStatusDat::setLaserWavelength ( float  p)
inline
void MonLaserStatusDat::writeArrayDB ( const std::map< EcalLogicID, MonLaserStatusDat > *  data,
MonRunIOV iov 
)
privatenoexcept

Referenced by getLaserFanout().

void MonLaserStatusDat::writeDB ( const EcalLogicID ecid,
const MonLaserStatusDat item,
MonRunIOV iov 
)
privatenoexcept

Definition at line 49 of file MonLaserStatusDat.cc.

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

Referenced by getLaserFanout().

51 {
52  this->checkConnection();
53  this->checkPrepare();
54 
55  int iovID = iov->fetchID();
56  if (!iovID) { throw(std::runtime_error("MonLaserStatusDat::writeDB: IOV not in DB")); }
57 
58  int logicID = ecid->getLogicID();
59  if (!logicID) { throw(std::runtime_error("MonLaserStatusDat::writeDB: Bad EcalLogicID")); }
60 
61  try {
62  m_writeStmt->setInt(1, iovID);
63  m_writeStmt->setInt(2, logicID);
64 
65  m_writeStmt->setFloat(3, item->getLaserPower() );
66  m_writeStmt->setFloat(4, item->getLaserFilter() );
67  m_writeStmt->setFloat(5, item->getLaserWavelength() );
68  m_writeStmt->setFloat(6, item->getLaserFanout() );
69 
70  m_writeStmt->executeUpdate();
71  } catch (SQLException &e) {
72  throw(std::runtime_error(std::string("MonLaserStatusDat::writeDB(): ")+getOraMessage(&e)));
73  }
74 }
float getLaserWavelength() const
oracle::occi::Statement * m_writeStmt
Definition: IDataItem.h:28
float getLaserPower() const
void checkPrepare() noexcept(false)
Definition: IDataItem.h:31
int fetchID() noexcept(false) override
Definition: MonRunIOV.cc:118
void checkConnection() const noexcept(false)
Definition: IDBObject.h:41
float getLaserFilter() const
int getLogicID() const
Definition: EcalLogicID.cc:41
float getLaserFanout() const

Friends And Related Function Documentation

friend class EcalCondDBInterface
friend

Definition at line 13 of file MonLaserStatusDat.h.

Member Data Documentation

float MonLaserStatusDat::m_laserFanout
private

Definition at line 48 of file MonLaserStatusDat.h.

Referenced by getLaserFanout(), and setLaserFanout().

float MonLaserStatusDat::m_laserFilter
private

Definition at line 46 of file MonLaserStatusDat.h.

Referenced by getLaserFilter(), and setLaserFilter().

float MonLaserStatusDat::m_laserPower
private

Definition at line 45 of file MonLaserStatusDat.h.

Referenced by getLaserPower(), and setLaserPower().

float MonLaserStatusDat::m_laserWavelength
private

Definition at line 47 of file MonLaserStatusDat.h.

Referenced by getLaserWavelength(), and setLaserWavelength().