|
|
|
#include <CaliGainRatioDat.h>
Public Member Functions | |
| CaliGainRatioDat () | |
| float | getG1G12 () const |
| float | getG6G12 () const |
| std::string | getTable () |
| bool | getTaskStatus () const |
| void | setG1G12 (float c) |
| void | setG6G12 (float c) |
| void | setTaskStatus (bool s) |
| ~CaliGainRatioDat () | |
Private Member Functions | |
| void | fetchData (std::map< EcalLogicID, CaliGainRatioDat > *fillVec, CaliIOV *iov) throw (std::runtime_error) |
| void | prepareWrite () throw (std::runtime_error) |
| void | writeArrayDB (const std::map< EcalLogicID, CaliGainRatioDat > *data, CaliIOV *iov) throw (std::runtime_error) |
| void | writeDB (const EcalLogicID *ecid, const CaliGainRatioDat *item, CaliIOV *iov) throw (std::runtime_error) |
Private Attributes | |
| float | m_g1_g12 |
| float | m_g6_g12 |
| bool | m_taskStatus |
Friends | |
| class | EcalCondDBInterface |
Definition at line 12 of file CaliGainRatioDat.h.
| CaliGainRatioDat::CaliGainRatioDat | ( | ) |
Definition at line 12 of file CaliGainRatioDat.cc.
References NULL.
{
m_env = NULL;
m_conn = NULL;
m_writeStmt = NULL;
m_g1_g12 = 0;
m_g6_g12 = 0;
m_taskStatus = false;
}
| CaliGainRatioDat::~CaliGainRatioDat | ( | ) |
Definition at line 25 of file CaliGainRatioDat.cc.
{
}
| void CaliGainRatioDat::fetchData | ( | std::map< EcalLogicID, CaliGainRatioDat > * | fillVec, |
| CaliIOV * | iov | ||
| ) | throw (std::runtime_error) [private] |
Definition at line 77 of file CaliGainRatioDat.cc.
References alignCSCRings::e, edm::pset::fillMap(), o2o::iov, AlCaHLTBitMon_ParallelJobs::p, setG1G12(), setG6G12(), and setTaskStatus().
{
this->checkConnection();
fillMap->clear();
iov->setConnection(m_env, m_conn);
int iovID = iov->fetchID();
if (!iovID) {
// throw(std::runtime_error("CaliGainRatioDat::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.g1_g6, d.g6_g12, d.task_status "
"FROM channelview cv JOIN cali_gain_ratio_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, CaliGainRatioDat > p;
CaliGainRatioDat 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.setG1G12( rset->getFloat(7) );
dat.setG6G12( rset->getFloat(8) );
dat.setTaskStatus( rset->getInt(9) );
p.second = dat;
fillMap->insert(p);
}
} catch (SQLException &e) {
throw(std::runtime_error("CaliGainRatioDat::fetchData(): "+e.getMessage()));
}
}
| float CaliGainRatioDat::getG1G12 | ( | ) | const [inline] |
Definition at line 22 of file CaliGainRatioDat.h.
References m_g1_g12.
Referenced by writeArrayDB().
{ return m_g1_g12; }
| float CaliGainRatioDat::getG6G12 | ( | ) | const [inline] |
Definition at line 25 of file CaliGainRatioDat.h.
References m_g6_g12.
Referenced by writeArrayDB().
{ return m_g6_g12; }
| std::string CaliGainRatioDat::getTable | ( | ) | [inline, virtual] |
Implements IDataItem.
Definition at line 19 of file CaliGainRatioDat.h.
{ return "CALI_GAIN_RATIO_DAT"; }
| bool CaliGainRatioDat::getTaskStatus | ( | ) | const [inline] |
Definition at line 28 of file CaliGainRatioDat.h.
References m_taskStatus.
Referenced by writeArrayDB().
{ return m_taskStatus; }
| void CaliGainRatioDat::prepareWrite | ( | ) | throw (std::runtime_error) [private, virtual] |
Implements IDataItem.
Definition at line 31 of file CaliGainRatioDat.cc.
References alignCSCRings::e.
{
this->checkConnection();
try {
m_writeStmt = m_conn->createStatement();
m_writeStmt->setSQL("INSERT INTO cali_gain_ratio_dat (iov_id, logic_id, "
"g1_g6, g6_g12, task_status) "
"VALUES (:iov_id, :logic_id, "
":3, :4, :5)");
} catch (SQLException &e) {
throw(std::runtime_error("CaliGainRatioDat::prepareWrite(): "+e.getMessage()));
}
}
| void CaliGainRatioDat::setG1G12 | ( | float | c | ) | [inline] |
Definition at line 21 of file CaliGainRatioDat.h.
References trackerHits::c, and m_g1_g12.
Referenced by fetchData().
| void CaliGainRatioDat::setG6G12 | ( | float | c | ) | [inline] |
Definition at line 24 of file CaliGainRatioDat.h.
References trackerHits::c, and m_g6_g12.
Referenced by fetchData().
| void CaliGainRatioDat::setTaskStatus | ( | bool | s | ) | [inline] |
Definition at line 27 of file CaliGainRatioDat.h.
References m_taskStatus, and alignCSCRings::s.
Referenced by fetchData().
{ m_taskStatus = s; }
| void CaliGainRatioDat::writeArrayDB | ( | const std::map< EcalLogicID, CaliGainRatioDat > * | data, |
| CaliIOV * | iov | ||
| ) | throw (std::runtime_error) [private] |
Definition at line 122 of file CaliGainRatioDat.cc.
References prof2calltree::count, AlCaHLTBitMon_QueryRunRegistry::data, alignCSCRings::e, getG1G12(), getG6G12(), EcalLogicID::getLogicID(), getTaskStatus(), o2o::iov, AlCaHLTBitMon_ParallelJobs::p, x, and detailsBasic3DVector::y.
{
this->checkConnection();
this->checkPrepare();
int iovID = iov->fetchID();
if (!iovID) { throw(std::runtime_error("CaliGainRatioDat::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];
int* st= new int[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* st_len= new ub2[nrows];
const EcalLogicID* channel;
const CaliGainRatioDat* dataitem;
int count=0;
typedef map< EcalLogicID, CaliGainRatioDat >::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("CaliGainRatioDat::writeArrayDB: Bad EcalLogicID")); }
ids[count]=logicID;
iovid_vec[count]=iovID;
dataitem = &(p->second);
// dataIface.writeDB( channel, dataitem, iov);
float x=dataitem->getG1G12();
float y=dataitem->getG6G12();
int statu=dataitem->getTaskStatus();
xx[count]=x;
yy[count]=y;
st[count]=statu;
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]);
st_len[count]=sizeof(st[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*)st, OCCIINT , sizeof(st[0]), st_len );
m_writeStmt->executeArrayUpdate(nrows);
delete [] ids;
delete [] iovid_vec;
delete [] xx;
delete [] yy;
delete [] st;
delete [] ids_len;
delete [] iov_len;
delete [] x_len;
delete [] y_len;
delete [] st_len;
} catch (SQLException &e) {
throw(std::runtime_error("CaliGainRatio::writeArrayDB(): "+e.getMessage()));
}
}
| void CaliGainRatioDat::writeDB | ( | const EcalLogicID * | ecid, |
| const CaliGainRatioDat * | item, | ||
| CaliIOV * | iov | ||
| ) | throw (std::runtime_error) [private] |
Definition at line 49 of file CaliGainRatioDat.cc.
References alignCSCRings::e, and o2o::iov.
{
this->checkConnection();
this->checkPrepare();
int iovID = iov->fetchID();
if (!iovID) { throw(std::runtime_error("CaliGainRatioDat::writeDB: IOV not in DB")); }
int logicID = ecid->getLogicID();
if (!logicID) { throw(std::runtime_error("CaliGainRatioDat::writeDB: Bad EcalLogicID")); }
try {
m_writeStmt->setInt(1, iovID);
m_writeStmt->setInt(2, logicID);
m_writeStmt->setFloat(3, item->getG1G12() );
m_writeStmt->setFloat(4, item->getG6G12() );
m_writeStmt->setInt(5, item->getTaskStatus() );
m_writeStmt->executeUpdate();
} catch (SQLException &e) {
throw(std::runtime_error("CaliGainRatioDat::writeDB(): "+e.getMessage()));
}
}
friend class EcalCondDBInterface [friend] |
Reimplemented from IDBObject.
Definition at line 14 of file CaliGainRatioDat.h.
float CaliGainRatioDat::m_g1_g12 [private] |
Definition at line 44 of file CaliGainRatioDat.h.
Referenced by getG1G12(), and setG1G12().
float CaliGainRatioDat::m_g6_g12 [private] |
Definition at line 45 of file CaliGainRatioDat.h.
Referenced by getG6G12(), and setG6G12().
bool CaliGainRatioDat::m_taskStatus [private] |
Definition at line 46 of file CaliGainRatioDat.h.
Referenced by getTaskStatus(), and setTaskStatus().
1.7.3