#include <DCULVRBTempsDat.h>
Public Member Functions | |
DCULVRBTempsDat () | |
float | getT1 () const |
float | getT2 () const |
float | getT3 () const |
std::string | getTable () |
void | setT1 (float temp) |
void | setT2 (float temp) |
void | setT3 (float temp) |
~DCULVRBTempsDat () | |
Private Member Functions | |
void | fetchData (std::map< EcalLogicID, DCULVRBTempsDat > *fillVec, DCUIOV *iov) throw (std::runtime_error) |
void | prepareWrite () throw (std::runtime_error) |
void | writeArrayDB (const std::map< EcalLogicID, DCULVRBTempsDat > *data, DCUIOV *iov) throw (std::runtime_error) |
void | writeDB (const EcalLogicID *ecid, const DCULVRBTempsDat *item, DCUIOV *iov) throw (std::runtime_error) |
Private Attributes | |
float | m_t1 |
float | m_t2 |
float | m_t3 |
Friends | |
class | EcalCondDBInterface |
Definition at line 12 of file DCULVRBTempsDat.h.
DCULVRBTempsDat::DCULVRBTempsDat | ( | ) |
Definition at line 12 of file DCULVRBTempsDat.cc.
References NULL.
DCULVRBTempsDat::~DCULVRBTempsDat | ( | ) |
Definition at line 26 of file DCULVRBTempsDat.cc.
{ }
void DCULVRBTempsDat::fetchData | ( | std::map< EcalLogicID, DCULVRBTempsDat > * | fillVec, |
DCUIOV * | iov | ||
) | throw (std::runtime_error) [private] |
Definition at line 78 of file DCULVRBTempsDat.cc.
References edm::pset::fillMap(), o2o::iov, AlCaHLTBitMon_ParallelJobs::p, setT1(), setT2(), and setT3().
{ this->checkConnection(); fillMap->clear(); iov->setConnection(m_env, m_conn); int iovID = iov->fetchID(); if (!iovID) { // throw(std::runtime_error("DCULVRBTempsDat::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.t1, d.t2, d.t3 " "FROM channelview cv JOIN dcu_lvrb_temps_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, DCULVRBTempsDat > p; DCULVRBTempsDat 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.setT1( rset->getFloat(7) ); dat.setT2( rset->getFloat(8) ); dat.setT3( rset->getFloat(9) ); p.second = dat; fillMap->insert(p); } } catch (SQLException &e) { throw(std::runtime_error("DCULVRBTempsDat::fetchData(): "+e.getMessage())); } }
float DCULVRBTempsDat::getT1 | ( | ) | const [inline] |
Definition at line 22 of file DCULVRBTempsDat.h.
References m_t1.
Referenced by writeArrayDB().
{ return m_t1; }
float DCULVRBTempsDat::getT2 | ( | ) | const [inline] |
Definition at line 25 of file DCULVRBTempsDat.h.
References m_t2.
Referenced by writeArrayDB().
{ return m_t2; }
float DCULVRBTempsDat::getT3 | ( | ) | const [inline] |
Definition at line 28 of file DCULVRBTempsDat.h.
References m_t3.
Referenced by writeArrayDB().
{ return m_t3; }
std::string DCULVRBTempsDat::getTable | ( | ) | [inline, virtual] |
Implements IDataItem.
Definition at line 19 of file DCULVRBTempsDat.h.
{ return "DCU_LVRB_TEMPS_DAT"; }
void DCULVRBTempsDat::prepareWrite | ( | ) | throw (std::runtime_error) [private, virtual] |
Implements IDataItem.
Definition at line 32 of file DCULVRBTempsDat.cc.
{ this->checkConnection(); try { m_writeStmt = m_conn->createStatement(); m_writeStmt->setSQL("INSERT INTO dcu_lvrb_temps_dat (iov_id, logic_id, " "t1, t2, t3) " "VALUES (:iov_id, :logic_id, " ":3, :4, :5)"); } catch (SQLException &e) { throw(std::runtime_error("DCULVRBTempsDat::prepareWrite(): "+e.getMessage())); } }
void DCULVRBTempsDat::setT1 | ( | float | temp | ) | [inline] |
Definition at line 21 of file DCULVRBTempsDat.h.
References m_t1, and cond::rpcobtemp::temp.
Referenced by fetchData().
void DCULVRBTempsDat::setT2 | ( | float | temp | ) | [inline] |
Definition at line 24 of file DCULVRBTempsDat.h.
References m_t2, and cond::rpcobtemp::temp.
Referenced by fetchData().
void DCULVRBTempsDat::setT3 | ( | float | temp | ) | [inline] |
Definition at line 27 of file DCULVRBTempsDat.h.
References m_t3, and cond::rpcobtemp::temp.
Referenced by fetchData().
void DCULVRBTempsDat::writeArrayDB | ( | const std::map< EcalLogicID, DCULVRBTempsDat > * | data, |
DCUIOV * | iov | ||
) | throw (std::runtime_error) [private] |
Definition at line 123 of file DCULVRBTempsDat.cc.
References prof2calltree::count, AlCaHLTBitMon_QueryRunRegistry::data, EcalLogicID::getLogicID(), getT1(), getT2(), getT3(), o2o::iov, AlCaHLTBitMon_ParallelJobs::p, x, detailsBasic3DVector::y, and z.
{ this->checkConnection(); this->checkPrepare(); int iovID = iov->fetchID(); if (!iovID) { throw(std::runtime_error("DCULVRBTempsDat::writeArrayDB: IOV not in DB")); } int nrows=data->size(); int* ids= new int[nrows]; int* iovid_vec= new int[nrows]; float* xx= new float[nrows]; float* yy= new float[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 DCULVRBTempsDat* dataitem; int count=0; typedef map< EcalLogicID, DCULVRBTempsDat >::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("DCULVRBTempsDat::writeArrayDB: Bad EcalLogicID")); } ids[count]=logicID; iovid_vec[count]=iovID; dataitem = &(p->second); // dataIface.writeDB( channel, dataitem, iov); float x=dataitem->getT1(); float y=dataitem->getT2(); float z=dataitem->getT3(); 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, OCCIFLOAT , sizeof(xx[0]), x_len ); m_writeStmt->setDataBuffer(4, (dvoid*)yy, OCCIFLOAT , 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("DCULVRBTempsDat::writeArrayDB(): "+e.getMessage())); } }
void DCULVRBTempsDat::writeDB | ( | const EcalLogicID * | ecid, |
const DCULVRBTempsDat * | item, | ||
DCUIOV * | iov | ||
) | throw (std::runtime_error) [private] |
Definition at line 50 of file DCULVRBTempsDat.cc.
References o2o::iov.
{ this->checkConnection(); this->checkPrepare(); int iovID = iov->fetchID(); if (!iovID) { throw(std::runtime_error("DCULVRBTempsDat::writeDB: IOV not in DB")); } int logicID = ecid->getLogicID(); if (!logicID) { throw(std::runtime_error("DCULVRBTempsDat::writeDB: Bad EcalLogicID")); } try { m_writeStmt->setInt(1, iovID); m_writeStmt->setInt(2, logicID); m_writeStmt->setFloat(3, item->getT1() ); m_writeStmt->setFloat(4, item->getT2() ); m_writeStmt->setFloat(5, item->getT3() ); m_writeStmt->executeUpdate(); } catch (SQLException &e) { throw(std::runtime_error("DCULVRBTempsDat::writeDB(): "+e.getMessage())); } }
friend class EcalCondDBInterface [friend] |
Reimplemented from IDBObject.
Definition at line 14 of file DCULVRBTempsDat.h.
float DCULVRBTempsDat::m_t1 [private] |
Definition at line 45 of file DCULVRBTempsDat.h.
float DCULVRBTempsDat::m_t2 [private] |
Definition at line 46 of file DCULVRBTempsDat.h.
float DCULVRBTempsDat::m_t3 [private] |
Definition at line 47 of file DCULVRBTempsDat.h.