CMS 3D CMS Logo

ODVfeToRejectInfo.cc
Go to the documentation of this file.
1 #include <stdexcept>
2 #include <string>
3 #include <cstring>
5 #include <cstdlib>
7 
8 using namespace std;
9 using namespace oracle::occi;
10 
12  m_env = nullptr;
13  m_conn = nullptr;
14  m_writeStmt = nullptr;
15  m_readStmt = nullptr;
16  m_config_tag = "";
17  m_ID = 0;
18  m_version = 0;
19  clear();
20 }
21 
23 
25 
27  int result = 0;
28  try {
29  this->checkConnection();
30 
31  m_readStmt = m_conn->createStatement();
32  m_readStmt->setSQL("select COND2CONF_INFO_SQ.NextVal from DUAL ");
33  ResultSet* rset = m_readStmt->executeQuery();
34  while (rset->next()) {
35  result = rset->getInt(1);
36  }
37  result++;
38  m_conn->terminateStatement(m_readStmt);
39  return result;
40 
41  } catch (SQLException& e) {
42  throw(std::runtime_error(std::string("ODVfeToRejectInfo::fetchNextId(): ") + e.getMessage()));
43  }
44 }
45 
47  this->checkConnection();
48 
49  int next_id = 0;
50  if (getId() == 0) {
51  next_id = fetchNextId();
52  }
53 
54  try {
55  m_writeStmt = m_conn->createStatement();
56  m_writeStmt->setSQL("INSERT INTO " + getTable() +
57  " ( rec_id, tag, version) "
58  " VALUES ( :1, :2, :3 ) ");
59 
60  m_writeStmt->setInt(1, next_id);
61  m_ID = next_id;
62 
63  } catch (SQLException& e) {
64  throw(std::runtime_error(std::string("ODVfeToRejectInfo::prepareWrite(): ") + e.getMessage()));
65  }
66 }
67 
68 void ODVfeToRejectInfo::setParameters(const std::map<string, string>& my_keys_map) {
69  // parses the result of the XML parser that is a map of
70  // string string with variable name variable value
71 
72  for (std::map<std::string, std::string>::const_iterator ci = my_keys_map.begin(); ci != my_keys_map.end(); ci++) {
73  if (ci->first == "VERSION")
74  setVersion(atoi(ci->second.c_str()));
75  if (ci->first == "TAG")
76  setConfigTag(ci->second);
77  }
78 }
79 
81  this->checkConnection();
82  this->checkPrepare();
83 
84  try {
85  // number 1 is the id
86  m_writeStmt->setString(2, this->getConfigTag());
87  m_writeStmt->setInt(3, this->getVersion());
88 
89  m_writeStmt->executeUpdate();
90 
91  } catch (SQLException& e) {
92  throw(std::runtime_error(std::string("ODVfeToRejectInfo::writeDB(): ") + e.getMessage()));
93  }
94  // Now get the ID
95  if (!this->fetchID()) {
96  throw(std::runtime_error("ODVfeToRejectInfo::writeDB: Failed to write"));
97  } else {
98  int old_version = this->getVersion();
99  m_readStmt = m_conn->createStatement();
100  this->fetchData(this);
101  m_conn->terminateStatement(m_readStmt);
102  if (this->getVersion() != old_version)
103  std::cout << "ODVfeToRejectInfo>>WARNING version is " << getVersion() << endl;
104  }
105 }
106 
108  this->checkConnection();
109  result->clear();
110  if (result->getId() == 0 && (result->getConfigTag().empty())) {
111  throw(std::runtime_error("ODVfeToRejectInfo::fetchData(): no Id defined for this ODVfeToRejectInfo "));
112  }
113 
114  try {
115  if (result->getId() != 0) {
116  m_readStmt->setSQL("SELECT * FROM " + getTable() + " where rec_id = :1 ");
117  m_readStmt->setInt(1, result->getId());
118  } else if (!result->getConfigTag().empty()) {
119  if (result->getVersion() != 0) {
120  m_readStmt->setSQL("SELECT * FROM " + getTable() +
121  " WHERE tag = :tag "
122  " and version = :version ");
123  m_readStmt->setString(1, result->getConfigTag());
124  m_readStmt->setInt(2, result->getVersion());
125  } else {
126  // always select the last inserted one with a given tag
127  m_readStmt->setSQL("SELECT * FROM " + getTable() + " WHERE tag = :1 and version= (select max(version) from " +
128  getTable() + " where tag=:2) ");
129  m_readStmt->setString(1, result->getConfigTag());
130  m_readStmt->setString(2, result->getConfigTag());
131  }
132 
133  } else {
134  // we should never pass here
135  throw(std::runtime_error("ODVfeToRejectInfo::fetchData(): no Id defined for this record "));
136  }
137 
138  ResultSet* rset = m_readStmt->executeQuery();
139 
140  rset->next();
141 
142  // 1 is the id and 2 is the config tag and 3 is the version
143 
144  result->setId(rset->getInt(1));
145  result->setConfigTag(rset->getString(2));
146  result->setVersion(rset->getInt(3));
147 
148  } catch (SQLException& e) {
149  throw(std::runtime_error(std::string("ODVfeToRejectInfo::fetchData(): ") + e.getMessage()));
150  }
151 }
152 
154  // Return from memory if available
155  if (m_ID != 0) {
156  return m_ID;
157  }
158 
159  this->checkConnection();
160 
161  try {
162  Statement* stmt = m_conn->createStatement();
163  stmt->setSQL("SELECT rec_id FROM " + getTable() + " WHERE tag=:1 and version=:2 ");
164 
165  stmt->setString(1, getConfigTag());
166  stmt->setInt(2, getVersion());
167 
168  ResultSet* rset = stmt->executeQuery();
169 
170  if (rset->next()) {
171  m_ID = rset->getInt(1);
172  } else {
173  m_ID = 0;
174  }
175  m_conn->terminateStatement(stmt);
176  } catch (SQLException& e) {
177  throw(std::runtime_error(std::string("ODVfeToRejectInfo::fetchID: ") + e.getMessage()));
178  }
179 
180  return m_ID;
181 }
int fetchID() noexcept(false)
~ODVfeToRejectInfo() override
void prepareWrite() noexcept(false) override
void writeDB() noexcept(false)
oracle::occi::Statement Statement
Definition: IODConfig.h:21
int fetchNextId() noexcept(false)
static unsigned int getId()
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
void clear(HadCaloObj &c)
Definition: data.h:124
void setParameters(const std::map< std::string, std::string > &my_keys_map)
void fetchData(ODVfeToRejectInfo *result) noexcept(false)