#include <MonOccupancyDat.h>
Public Member Functions | |
float | getAvgEnergy () const |
int | getEventsOverHighThreshold () const |
int | getEventsOverLowThreshold () const |
std::string | getTable () |
MonOccupancyDat () | |
void | setAvgEnergy (float energy) |
void | setEventsOverHighThreshold (int events) |
void | setEventsOverLowThreshold (int events) |
~MonOccupancyDat () | |
Private Member Functions | |
void | fetchData (std::map< EcalLogicID, MonOccupancyDat > *fillVec, MonRunIOV *iov) throw (std::runtime_error) |
void | prepareWrite () throw (std::runtime_error) |
void | writeArrayDB (const std::map< EcalLogicID, MonOccupancyDat > *data, MonRunIOV *iov) throw (std::runtime_error) |
void | writeDB (const EcalLogicID *ecid, const MonOccupancyDat *item, MonRunIOV *iov) throw (std::runtime_error) |
Private Attributes | |
float | m_avgEnergy |
int | m_eventsOverHighThreshold |
int | m_eventsOverLowThreshold |
Friends | |
class | EcalCondDBInterface |
Definition at line 12 of file MonOccupancyDat.h.
MonOccupancyDat::MonOccupancyDat | ( | ) |
Definition at line 10 of file MonOccupancyDat.cc.
References NULL.
{ m_env = NULL; m_conn = NULL; m_writeStmt = NULL; m_readStmt = NULL; m_eventsOverLowThreshold = 0; m_eventsOverHighThreshold = 0; m_avgEnergy = 0; }
MonOccupancyDat::~MonOccupancyDat | ( | ) |
Definition at line 24 of file MonOccupancyDat.cc.
{ }
void MonOccupancyDat::fetchData | ( | std::map< EcalLogicID, MonOccupancyDat > * | fillVec, |
MonRunIOV * | iov | ||
) | throw (std::runtime_error) [private] |
Definition at line 76 of file MonOccupancyDat.cc.
References edm::pset::fillMap(), o2o::iov, L1TEmulatorMonitor_cff::p, setAvgEnergy(), setEventsOverHighThreshold(), and setEventsOverLowThreshold().
{ this->checkConnection(); fillMap->clear(); iov->setConnection(m_env, m_conn); int iovID = iov->fetchID(); if (!iovID) { // throw(std::runtime_error("MonOccupancyDat::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.events_over_low_threshold, d.events_over_high_threshold, d.avg_energy " "FROM channelview cv JOIN mon_occupancy_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, MonOccupancyDat > p; MonOccupancyDat 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.setEventsOverLowThreshold( rset->getInt(7) ); dat.setEventsOverHighThreshold( rset->getInt(8) ); dat.setAvgEnergy( rset->getFloat(9) ); p.second = dat; fillMap->insert(p); } } catch (SQLException &e) { throw(std::runtime_error("MonOccupancyDat::fetchData(): "+e.getMessage())); } }
float MonOccupancyDat::getAvgEnergy | ( | ) | const [inline] |
Definition at line 28 of file MonOccupancyDat.h.
References m_avgEnergy.
Referenced by writeArrayDB().
{ return m_avgEnergy; }
int MonOccupancyDat::getEventsOverHighThreshold | ( | ) | const [inline] |
Definition at line 25 of file MonOccupancyDat.h.
References m_eventsOverHighThreshold.
Referenced by popcon::EcalChannelStatusHandler::cosmicsAnalysis(), and writeArrayDB().
{ return m_eventsOverHighThreshold; }
int MonOccupancyDat::getEventsOverLowThreshold | ( | ) | const [inline] |
Definition at line 22 of file MonOccupancyDat.h.
References m_eventsOverLowThreshold.
Referenced by writeArrayDB().
{ return m_eventsOverLowThreshold; }
std::string MonOccupancyDat::getTable | ( | ) | [inline, virtual] |
Implements IDataItem.
Definition at line 19 of file MonOccupancyDat.h.
{ return "MON_OCCUPANCY_DAT"; }
void MonOccupancyDat::prepareWrite | ( | ) | throw (std::runtime_error) [private, virtual] |
Implements IDataItem.
Definition at line 30 of file MonOccupancyDat.cc.
{ this->checkConnection(); try { m_writeStmt = m_conn->createStatement(); m_writeStmt->setSQL("INSERT INTO mon_occupancy_dat (iov_id, logic_id, " "events_over_low_threshold, events_over_high_threshold, avg_energy) " "VALUES (:iov_id, :logic_id, " ":3, :4, :5)"); } catch (SQLException &e) { throw(std::runtime_error("MonOccupancyDat::prepareWrite(): "+e.getMessage())); } }
void MonOccupancyDat::setAvgEnergy | ( | float | energy | ) | [inline] |
Definition at line 27 of file MonOccupancyDat.h.
References relval_parameters_module::energy, and m_avgEnergy.
Referenced by fetchData().
{ m_avgEnergy = energy; }
void MonOccupancyDat::setEventsOverHighThreshold | ( | int | events | ) | [inline] |
Definition at line 24 of file MonOccupancyDat.h.
References patZpeak::events, and m_eventsOverHighThreshold.
Referenced by fetchData().
{ m_eventsOverHighThreshold = events; }
void MonOccupancyDat::setEventsOverLowThreshold | ( | int | events | ) | [inline] |
Definition at line 21 of file MonOccupancyDat.h.
References patZpeak::events, and m_eventsOverLowThreshold.
Referenced by fetchData().
{ m_eventsOverLowThreshold = events; }
void MonOccupancyDat::writeArrayDB | ( | const std::map< EcalLogicID, MonOccupancyDat > * | data, |
MonRunIOV * | iov | ||
) | throw (std::runtime_error) [private] |
Definition at line 121 of file MonOccupancyDat.cc.
References prof2calltree::count, runTheMatrix::data, getAvgEnergy(), getEventsOverHighThreshold(), getEventsOverLowThreshold(), EcalLogicID::getLogicID(), o2o::iov, L1TEmulatorMonitor_cff::p, x, detailsBasic3DVector::y, and z.
{ this->checkConnection(); this->checkPrepare(); int iovID = iov->fetchID(); if (!iovID) { throw(std::runtime_error("MonOccupancyDat::writeArrayDB: IOV not in DB")); } int nrows=data->size(); int* ids= new int[nrows]; int* iovid_vec= new int[nrows]; int* xx= new int[nrows]; int* yy= new int[nrows]; float* zz= new float[nrows]; ub2* ids_len= new ub2[nrows]; ub2* iov_len= new ub2[nrows]; ub2* x_len= new ub2[nrows]; ub2* y_len= new ub2[nrows]; ub2* z_len= new ub2[nrows]; const EcalLogicID* channel; const MonOccupancyDat* dataitem; int count=0; typedef map< EcalLogicID, MonOccupancyDat >::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("MonOccupancyDat::writeArrayDB: Bad EcalLogicID")); } ids[count]=logicID; iovid_vec[count]=iovID; dataitem = &(p->second); // dataIface.writeDB( channel, dataitem, iov); int x=dataitem->getEventsOverLowThreshold(); int y=dataitem->getEventsOverHighThreshold(); float z=dataitem->getAvgEnergy(); xx[count]=x; yy[count]=y; zz[count]=z; ids_len[count]=sizeof(ids[count]); iov_len[count]=sizeof(iovid_vec[count]); x_len[count]=sizeof(xx[count]); y_len[count]=sizeof(yy[count]); z_len[count]=sizeof(zz[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*)xx, OCCIINT , sizeof(xx[0]), x_len ); m_writeStmt->setDataBuffer(4, (dvoid*)yy, OCCIINT , sizeof(yy[0]), y_len ); m_writeStmt->setDataBuffer(5, (dvoid*)zz, OCCIFLOAT , sizeof(zz[0]), z_len ); m_writeStmt->executeArrayUpdate(nrows); delete [] ids; delete [] iovid_vec; delete [] xx; delete [] yy; delete [] zz; delete [] ids_len; delete [] iov_len; delete [] x_len; delete [] y_len; delete [] z_len; } catch (SQLException &e) { throw(std::runtime_error("MonOccupancyDat::writeArrayDB(): "+e.getMessage())); } }
void MonOccupancyDat::writeDB | ( | const EcalLogicID * | ecid, |
const MonOccupancyDat * | item, | ||
MonRunIOV * | iov | ||
) | throw (std::runtime_error) [private] |
Definition at line 48 of file MonOccupancyDat.cc.
References o2o::iov.
{ this->checkConnection(); this->checkPrepare(); int iovID = iov->fetchID(); if (!iovID) { throw(std::runtime_error("MonOccupancyDat::writeDB: IOV not in DB")); } int logicID = ecid->getLogicID(); if (!logicID) { throw(std::runtime_error("MonOccupancyDat::writeDB: Bad EcalLogicID")); } try { m_writeStmt->setInt(1, iovID); m_writeStmt->setInt(2, logicID); m_writeStmt->setInt(3, item->getEventsOverLowThreshold() ); m_writeStmt->setInt(4, item->getEventsOverHighThreshold() ); m_writeStmt->setFloat(5, item->getAvgEnergy() ); m_writeStmt->executeUpdate(); } catch (SQLException &e) { throw(std::runtime_error("MonOccupancyDat::writeDB(): "+e.getMessage())); } }
friend class EcalCondDBInterface [friend] |
Reimplemented from IDBObject.
Definition at line 14 of file MonOccupancyDat.h.
float MonOccupancyDat::m_avgEnergy [private] |
Definition at line 47 of file MonOccupancyDat.h.
Referenced by getAvgEnergy(), and setAvgEnergy().
int MonOccupancyDat::m_eventsOverHighThreshold [private] |
Definition at line 46 of file MonOccupancyDat.h.
Referenced by getEventsOverHighThreshold(), and setEventsOverHighThreshold().
int MonOccupancyDat::m_eventsOverLowThreshold [private] |
Definition at line 45 of file MonOccupancyDat.h.
Referenced by getEventsOverLowThreshold(), and setEventsOverLowThreshold().