|
|
|
#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 alignCSCRings::e, 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.
References alignCSCRings::e.
{
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 groupFilesInBlocks::temp.
Referenced by fetchData().
| void DCULVRBTempsDat::setT2 | ( | float | temp | ) | [inline] |
Definition at line 24 of file DCULVRBTempsDat.h.
References m_t2, and groupFilesInBlocks::temp.
Referenced by fetchData().
| void DCULVRBTempsDat::setT3 | ( | float | temp | ) | [inline] |
Definition at line 27 of file DCULVRBTempsDat.h.
References m_t3, and groupFilesInBlocks::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, data, alignCSCRings::e, 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 alignCSCRings::e, and 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.
1.7.3