test
CMS 3D CMS Logo

 All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Properties Friends Macros Pages
CaliGeneralDat.cc
Go to the documentation of this file.
1 #include <stdexcept>
2 #include <string>
4 
8 
9 using namespace std;
10 using namespace oracle::occi;
11 
13 {
14  m_env = NULL;
15  m_conn = NULL;
16  m_writeStmt = NULL;
17 
18  m_numEvents = 0;
19  m_comments = "none";
20 }
21 
22 
23 
25 {
26 }
27 
28 
29 
31  throw(std::runtime_error)
32 {
33  this->checkConnection();
34 
35  try {
36  m_writeStmt = m_conn->createStatement();
37  m_writeStmt->setSQL("INSERT INTO cali_general_dat (iov_id, logic_id, "
38  "num_events, comments) "
39  "VALUES (:iov_id, :logic_id, "
40  ":3, :4)");
41  } catch (SQLException &e) {
42  throw(std::runtime_error("CaliGeneralDat::prepareWrite(): "+e.getMessage()));
43  }
44 }
45 
46 
47 
49  throw(std::runtime_error)
50 {
51  this->checkConnection();
52  this->checkPrepare();
53 
54  int iovID = iov->fetchID();
55  if (!iovID) { throw(std::runtime_error("CaliGeneralDat::writeDB: IOV not in DB")); }
56 
57  int logicID = ecid->getLogicID();
58  if (!logicID) { throw(std::runtime_error("CaliGeneralDat::writeDB: Bad EcalLogicID")); }
59 
60  try {
61  m_writeStmt->setInt(1, iovID);
62  m_writeStmt->setInt(2, logicID);
63 
64  m_writeStmt->setInt(3, item->getNumEvents() );
65  m_writeStmt->setString(4, item->getComments() );
66 
67  m_writeStmt->executeUpdate();
68  } catch (SQLException &e) {
69  throw(std::runtime_error("CaliGeneralDat::writeDB(): "+e.getMessage()));
70  }
71 }
72 
73 
74 
75 void CaliGeneralDat::fetchData(std::map< EcalLogicID, CaliGeneralDat >* fillMap, CaliIOV* iov)
76  throw(std::runtime_error)
77 {
78  this->checkConnection();
79  fillMap->clear();
80 
81  iov->setConnection(m_env, m_conn);
82  int iovID = iov->fetchID();
83  if (!iovID) {
84  // throw(std::runtime_error("CaliGeneralDat::writeDB: IOV not in DB"));
85  return;
86  }
87 
88  try {
89 
90  m_readStmt->setSQL("SELECT cv.name, cv.logic_id, cv.id1, cv.id2, cv.id3, cv.maps_to, "
91  "d.num_events, d.comments "
92  "FROM channelview cv JOIN cali_general_dat d "
93  "ON cv.logic_id = d.logic_id AND cv.name = cv.maps_to "
94  "WHERE d.iov_id = :iov_id");
95  m_readStmt->setInt(1, iovID);
96  ResultSet* rset = m_readStmt->executeQuery();
97 
98  std::pair< EcalLogicID, CaliGeneralDat > p;
99  CaliGeneralDat dat;
100  while(rset->next()) {
101  p.first = EcalLogicID( rset->getString(1), // name
102  rset->getInt(2), // logic_id
103  rset->getInt(3), // id1
104  rset->getInt(4), // id2
105  rset->getInt(5), // id3
106  rset->getString(6)); // maps_to
107 
108  dat.setNumEvents( rset->getInt(7) );
109  dat.setComments( rset->getString(8) );
110 
111  p.second = dat;
112  fillMap->insert(p);
113  }
114  } catch (SQLException &e) {
115  throw(std::runtime_error("CaliGeneralDat::fetchData(): "+e.getMessage()));
116  }
117 }
#define NULL
Definition: scimark2.h:8
oracle::occi::SQLException SQLException
Definition: HcalDbOmds.cc:27
void setComments(std::string comments)
tuple iov
Definition: o2o.py:307
void writeDB(const EcalLogicID *ecid, const CaliGeneralDat *item, CaliIOV *iov)
void setNumEvents(int n)
void fetchData(std::map< EcalLogicID, CaliGeneralDat > *fillVec, CaliIOV *iov)
oracle::occi::ResultSet ResultSet
Definition: HcalDbOmds.cc:26