CMS 3D CMS Logo

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

#include <FEConfigWeightDat.h>

Inheritance diagram for FEConfigWeightDat:
IDataItem IDBObject

Public Member Functions

 FEConfigWeightDat ()
 
std::string getTable () override
 
int getWeightGroupId () const
 
void setWeightGroupId (int x)
 
 ~FEConfigWeightDat () 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, FEConfigWeightDat > *fillMap, FEConfigWeightInfo *iconf) noexcept(false)
 
void prepareWrite () noexcept(false) override
 
void writeArrayDB (const std::map< EcalLogicID, FEConfigWeightDat > *data, FEConfigWeightInfo *iconf) noexcept(false)
 
void writeDB (const EcalLogicID *ecid, const FEConfigWeightDat *item, FEConfigWeightInfo *iconf) noexcept(false)
 

Private Attributes

int m_group_id
 

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

Constructor & Destructor Documentation

FEConfigWeightDat::FEConfigWeightDat ( )

Definition at line 11 of file FEConfigWeightDat.cc.

12 {
13  m_env = nullptr;
14  m_conn = nullptr;
15  m_writeStmt = nullptr;
16  m_readStmt = nullptr;
17 
18  m_group_id = 0;
19 
20 }
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
FEConfigWeightDat::~FEConfigWeightDat ( )
override

Definition at line 24 of file FEConfigWeightDat.cc.

25 {
26 }

Member Function Documentation

void FEConfigWeightDat::fetchData ( std::map< EcalLogicID, FEConfigWeightDat > *  fillMap,
FEConfigWeightInfo iconf 
)
privatenoexcept

Definition at line 72 of file FEConfigWeightDat.cc.

References MillePedeFileConverter_cfg::e, AlCaHLTBitMon_ParallelJobs::p, setWeightGroupId(), and AlCaHLTBitMon_QueryRunRegistry::string.

Referenced by getWeightGroupId().

74 {
75  this->checkConnection();
76  fillMap->clear();
77 
78  iconf->setConnection(m_env, m_conn);
79  int iconfID = iconf->fetchID();
80  if (!iconfID) {
81  // throw(std::runtime_error("FEConfigWeightDat::writeDB: ICONF not in DB"));
82  return;
83  }
84 
85  try {
86 
87  m_readStmt->setSQL("SELECT cv.name, cv.logic_id, cv.id1, cv.id2, cv.id3, cv.maps_to, "
88  "d.group_id "
89  "FROM channelview cv JOIN fe_config_weight_dat d "
90  "ON cv.logic_id = d.logic_id AND cv.name = cv.maps_to "
91  "WHERE wei_conf_id = :wei_conf_id");
92  m_readStmt->setInt(1, iconfID);
93  ResultSet* rset = m_readStmt->executeQuery();
94 
95  std::pair< EcalLogicID, FEConfigWeightDat > p;
97  while(rset->next()) {
98  p.first = EcalLogicID( getOraString(rset,1), // name
99  rset->getInt(2), // logic_id
100  rset->getInt(3), // id1
101  rset->getInt(4), // id2
102  rset->getInt(5), // id3
103  getOraString(rset,6)); // maps_to
104 
105  dat.setWeightGroupId( rset->getInt(7) );
106 
107  p.second = dat;
108  fillMap->insert(p);
109  }
110  } catch (SQLException &e) {
111  throw(std::runtime_error(std::string("FEConfigWeightDat::fetchData: ")+getOraMessage(&e)));
112  }
113 }
oracle::occi::Environment * m_env
Definition: IDBObject.h:38
oracle::occi::Connection * m_conn
Definition: IDBObject.h:39
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
void setWeightGroupId(int x)
int fetchID() noexcept(false)
std::string FEConfigWeightDat::getTable ( )
inlineoverridevirtual

Implements IDataItem.

Definition at line 18 of file FEConfigWeightDat.h.

18 { return "FE_CONFIG_WEIGHT_DAT"; }
int FEConfigWeightDat::getWeightGroupId ( ) const
inline

Definition at line 21 of file FEConfigWeightDat.h.

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

Referenced by writeArrayDB().

21 { return m_group_id; }
void FEConfigWeightDat::prepareWrite ( )
overrideprivatevirtualnoexcept

Implements IDataItem.

Definition at line 30 of file FEConfigWeightDat.cc.

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

Referenced by getWeightGroupId().

32 {
33  this->checkConnection();
34 
35  try {
36  m_writeStmt = m_conn->createStatement();
37  m_writeStmt->setSQL("INSERT INTO fe_config_weight_dat (wei_conf_id, logic_id, "
38  "group_id ) "
39  "VALUES (:wei_conf_id, :logic_id, "
40  ":group_id )" );
41  } catch (SQLException &e) {
42  throw(std::runtime_error(std::string("FEConfigWeightDat::prepareWrite(): ")+getOraMessage(&e)));
43  }
44 }
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 FEConfigWeightDat::setWeightGroupId ( int  x)
inline

Definition at line 20 of file FEConfigWeightDat.h.

References m_group_id, and x.

Referenced by EcalTPGParamBuilder::analyze(), and fetchData().

void FEConfigWeightDat::writeArrayDB ( const std::map< EcalLogicID, FEConfigWeightDat > *  data,
FEConfigWeightInfo iconf 
)
privatenoexcept

Definition at line 115 of file FEConfigWeightDat.cc.

References KineDebug3::count(), data, MillePedeFileConverter_cfg::e, EcalLogicID::getLogicID(), getWeightGroupId(), AlCaHLTBitMon_ParallelJobs::p, AlCaHLTBitMon_QueryRunRegistry::string, x, and geometryCSVtoXML::xx.

Referenced by getWeightGroupId().

117 {
118  this->checkConnection();
119  this->checkPrepare();
120 
121  int iconfID = iconf->fetchID();
122  if (!iconfID) { throw(std::runtime_error("FEConfigWeightDat::writeArrayDB: ICONF not in DB")); }
123 
124 
125  int nrows=data->size();
126  int* ids= new int[nrows];
127  int* iconfid_vec= new int[nrows];
128  int* xx= new int[nrows];
129 
130  ub2* ids_len= new ub2[nrows];
131  ub2* iconf_len= new ub2[nrows];
132  ub2* x_len= new ub2[nrows];
133 
134 
135  const EcalLogicID* channel;
136  const FEConfigWeightDat* dataitem;
137  int count=0;
138  typedef map< EcalLogicID, FEConfigWeightDat >::const_iterator CI;
139  for (CI p = data->begin(); p != data->end(); ++p) {
140  channel = &(p->first);
141  int logicID = channel->getLogicID();
142  if (!logicID) { throw(std::runtime_error("FEConfigWeightDat::writeArrayDB: Bad EcalLogicID")); }
143  ids[count]=logicID;
144  iconfid_vec[count]=iconfID;
145 
146  dataitem = &(p->second);
147  // dataIface.writeDB( channel, dataitem, iconf);
148  int x=dataitem->getWeightGroupId();
149 
150  xx[count]=x;
151 
152  ids_len[count]=sizeof(ids[count]);
153  iconf_len[count]=sizeof(iconfid_vec[count]);
154 
155  x_len[count]=sizeof(xx[count]);
156 
157  count++;
158  }
159 
160 
161  try {
162  m_writeStmt->setDataBuffer(1, (dvoid*)iconfid_vec, OCCIINT, sizeof(iconfid_vec[0]),iconf_len);
163  m_writeStmt->setDataBuffer(2, (dvoid*)ids, OCCIINT, sizeof(ids[0]), ids_len );
164  m_writeStmt->setDataBuffer(3, (dvoid*)xx, OCCIINT , sizeof(xx[0]), x_len );
165 
166  m_writeStmt->executeArrayUpdate(nrows);
167 
168  delete [] ids;
169  delete [] iconfid_vec;
170  delete [] xx;
171 
172  delete [] ids_len;
173  delete [] iconf_len;
174  delete [] x_len;
175 
176  } catch (SQLException &e) {
177  throw(std::runtime_error(std::string("FEConfigWeightDat::writeArrayDB(): ")+getOraMessage(&e)));
178  }
179 }
oracle::occi::Statement * m_writeStmt
Definition: IDataItem.h:28
void checkPrepare() noexcept(false)
Definition: IDataItem.h:31
void checkConnection() const noexcept(false)
Definition: IDBObject.h:41
int getLogicID() const
Definition: EcalLogicID.cc:41
char data[epos_bytes_allocation]
Definition: EPOS_Wrapper.h:82
int getWeightGroupId() const
int fetchID() noexcept(false)
void FEConfigWeightDat::writeDB ( const EcalLogicID ecid,
const FEConfigWeightDat item,
FEConfigWeightInfo iconf 
)
privatenoexcept

Definition at line 47 of file FEConfigWeightDat.cc.

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

Referenced by getWeightGroupId().

49 {
50  this->checkConnection();
51  this->checkPrepare();
52 
53  int iconfID = iconf->fetchID();
54  if (!iconfID) { throw(std::runtime_error("FEConfigWeightDat::writeDB: ICONF not in DB")); }
55 
56  int logicID = ecid->getLogicID();
57  if (!logicID) { throw(std::runtime_error("FEConfigWeightDat::writeDB: Bad EcalLogicID")); }
58 
59  try {
60  m_writeStmt->setInt(1, iconfID);
61  m_writeStmt->setInt(2, logicID);
62  m_writeStmt->setInt(3, item->getWeightGroupId());
63 
64  m_writeStmt->executeUpdate();
65  } catch (SQLException &e) {
66  throw(std::runtime_error(std::string("FEConfigWeightDat::writeDB(): ")+getOraMessage(&e)));
67  }
68 }
oracle::occi::Statement * m_writeStmt
Definition: IDataItem.h:28
void checkPrepare() noexcept(false)
Definition: IDataItem.h:31
void checkConnection() const noexcept(false)
Definition: IDBObject.h:41
int getLogicID() const
Definition: EcalLogicID.cc:41
int getWeightGroupId() const
int fetchID() noexcept(false)

Friends And Related Function Documentation

friend class EcalCondDBInterface
friend

Definition at line 13 of file FEConfigWeightDat.h.

Member Data Documentation

int FEConfigWeightDat::m_group_id
private

Definition at line 35 of file FEConfigWeightDat.h.

Referenced by getWeightGroupId(), and setWeightGroupId().