CMS 3D CMS Logo

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

#include <FEConfigMainInfo.h>

Inheritance diagram for FEConfigMainInfo:
IODConfig IDBObject

Public Member Functions

 FEConfigMainInfo ()
 
int getBstId () const
 
int getBttId () const
 
int getBxtId () const
 
Tm getDBTime () const
 
std::string getDescription () const
 
int getFgrId () const
 
int getId () const
 
int getLinId () const
 
int getLUTId () const
 
int getPedId () const
 
int getSliId () const
 
int getSpiId () const
 
std::string getTable () override
 
int getTimId () const
 
int getVersion () const
 
int getWeiId () const
 
bool operator!= (const FEConfigMainInfo &r) const
 
bool operator== (const FEConfigMainInfo &r) const
 
void setBstId (int x)
 
void setBttId (int x)
 
void setBxtId (int x)
 
void setDBTime (const Tm &x)
 
void setDescription (std::string x)
 
void setFgrId (int x)
 
void setId (int id)
 
void setLinId (int x)
 
void setLUTId (int x)
 
void setPedId (int x)
 
void setSliId (int x)
 
void setSpiId (int x)
 
void setTimId (int x)
 
void setVersion (int id)
 
void setWeiId (int x)
 
 ~FEConfigMainInfo () override
 
- Public Member Functions inherited from IODConfig
std::string getConfigTag ()
 
void setConfigTag (std::string x)
 
- 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 clear ()
 
void fetchData (FEConfigMainInfo *result) noexcept(false)
 
int fetchID () noexcept(false)
 
int fetchIDLast () noexcept(false)
 
int fetchNextId () noexcept(false)
 
void insertConfig () noexcept(false)
 
void prepareWrite () noexcept(false) override
 
void setByID (int id) noexcept(false)
 
void writeDB () noexcept(false)
 

Private Attributes

int m_bst_id
 
int m_btt_id
 
int m_bxt_id
 
Tm m_db_time
 
std::string m_description
 
int m_fgr_id
 
int m_ID
 
int m_lin_id
 
int m_lut_id
 
int m_ped_id
 
int m_sli_id
 
int m_spi_id
 
int m_tim_id
 
int m_version
 
int m_wei_id
 

Friends

class EcalCondDBInterface
 

Additional Inherited Members

- Public Types inherited from IODConfig
typedef oracle::occi::Clob Clob
 
typedef oracle::occi::SQLException SQLException
 
typedef oracle::occi::Statement Statement
 
typedef oracle::occi::Stream Stream
 
- Public Attributes inherited from IODConfig
std::string m_config_tag
 
- Static Public Attributes inherited from IDBObject
static int const ECALDB_NROWS = 1024
 
- Protected Member Functions inherited from IODConfig
void checkPrepare () noexcept(false)
 
void createReadStatement () noexcept(false)
 
void populateClob (Clob &clob, std::string fname, unsigned int bufsize) noexcept(false)
 
unsigned char * readClob (Clob &clob, int size) 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 IODConfig
Statementm_readStmt
 
Statementm_writeStmt
 
- Protected Attributes inherited from IDBObject
oracle::occi::Connection * m_conn
 
oracle::occi::Environment * m_env
 

Detailed Description

Definition at line 14 of file FEConfigMainInfo.h.

Constructor & Destructor Documentation

FEConfigMainInfo::FEConfigMainInfo ( )

Definition at line 11 of file FEConfigMainInfo.cc.

References hitfit::clear().

11  {
12  m_env = nullptr;
13  m_conn = nullptr;
14  m_writeStmt = nullptr;
15  m_readStmt = nullptr;
16 
17  m_ID = 0;
18  m_version = 0;
19  clear();
20 }
oracle::occi::Environment * m_env
Definition: IDBObject.h:33
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
Statement * m_writeStmt
Definition: IODConfig.h:33
Statement * m_readStmt
Definition: IODConfig.h:34
FEConfigMainInfo::~FEConfigMainInfo ( )
override

Definition at line 22 of file FEConfigMainInfo.cc.

22 {}

Member Function Documentation

void FEConfigMainInfo::clear ( void  )
private

Definition at line 24 of file FEConfigMainInfo.cc.

24  {
25  m_description = "";
26  m_ped_id = 0;
27  m_lin_id = 0;
28  m_lut_id = 0;
29  m_sli_id = 0;
30  m_fgr_id = 0;
31  m_wei_id = 0;
32  m_bxt_id = 0;
33  m_btt_id = 0;
34  m_tim_id = 0;
35  m_spi_id = 0;
36  m_bst_id = 0;
37 
38  m_db_time = Tm();
39 }
std::string m_description
Definition: Tm.h:13
void FEConfigMainInfo::fetchData ( FEConfigMainInfo result)
privatenoexcept

Definition at line 229 of file FEConfigMainInfo.cc.

References gather_cfg::cout, DateHandler::dateToTm(), cuy::dh, MillePedeFileConverter_cfg::e, and mps_fire::result.

229  {
230  std::cout << " ### 1 getId from FEConfigMainInfo = " << result->getId() << std::endl;
231  std::cout << " tag/version " << result->getConfigTag() << "/" << result->getVersion() << std::endl;
232 
233  this->checkConnection();
235  // result->clear();
236 
237  int idid = 0;
238 
239  if (result->getId() == 0) {
240  //throw(std::runtime_error("FEConfigMainInfo::fetchData(): no Id defined for this FEConfigMainInfo "));
241  idid = result->fetchID();
242  result->setId(idid);
243  }
244 
245  try {
246  m_readStmt->setSQL("SELECT * FROM FE_CONFIG_MAIN WHERE conf_id = :1 ");
247 
248  std::cout << " ### 2 getId from FEConfigMainInfo = " << result->getId() << std::endl;
249 
250  // good m_readStmt->setInt(1, result->getId());
251  m_readStmt->setInt(1, result->getId());
252  ResultSet* rset = m_readStmt->executeQuery();
253 
254  rset->next();
255 
256  result->setId(rset->getInt(1));
257 
258  setPedId(rset->getInt(2));
259  setLinId(rset->getInt(3));
260  setLUTId(rset->getInt(4));
261  setFgrId(rset->getInt(5));
262  setSliId(rset->getInt(6));
263  setWeiId(rset->getInt(7));
264  setSpiId(rset->getInt(8));
265  setTimId(rset->getInt(9));
266  setBxtId(rset->getInt(10));
267  setBttId(rset->getInt(11));
268  setBstId(rset->getInt(12));
269 
270  result->setConfigTag(rset->getString(13));
271  result->setVersion(rset->getInt(14));
272  result->setDescription(rset->getString(15));
273  Date dbdate = rset->getDate(16);
274  result->setDBTime(dh.dateToTm(dbdate));
275 
276  } catch (SQLException& e) {
277  throw(std::runtime_error("FEConfigMainInfo::fetchData(): " + e.getMessage()));
278  }
279 }
void setSpiId(int x)
void setDescription(std::string x)
oracle::occi::Environment * m_env
Definition: IDBObject.h:33
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
void setLinId(int x)
void setTimId(int x)
int fetchID() noexcept(false)
void setBxtId(int x)
void setId(int id)
void setVersion(int id)
void setLUTId(int x)
void setFgrId(int x)
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
void setPedId(int x)
int getId() const
void setWeiId(int x)
void setDBTime(const Tm &x)
int getVersion() const
void setConfigTag(std::string x)
Definition: IODConfig.h:29
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
Statement * m_readStmt
Definition: IODConfig.h:34
std::string getConfigTag()
Definition: IODConfig.h:30
void setSliId(int x)
dh
Definition: cuy.py:355
void setBstId(int x)
void setBttId(int x)
int FEConfigMainInfo::fetchID ( )
privatenoexcept

Definition at line 59 of file FEConfigMainInfo.cc.

References gather_cfg::cout, cuy::dh, and MillePedeFileConverter_cfg::e.

59  {
60  // Return from memory if available
61  if (m_ID > 0) {
62  return m_ID;
63  }
64 
65  this->checkConnection();
66 
68 
69  std::cout << " tag/version " << getConfigTag() << "/" << getVersion() << std::endl;
70 
71  try {
72  Statement* stmt = m_conn->createStatement();
73  if (m_version != 0) {
74  stmt->setSQL(
75  "SELECT conf_id from FE_CONFIG_MAIN "
76  "WHERE tag = :tag "
77  " and version = :version ");
78  stmt->setString(1, m_config_tag);
79  stmt->setInt(2, m_version);
80  std::cout << " using query with version " << endl;
81  } else {
82  // always select the last inserted one with a given tag
83  stmt->setSQL(
84  "SELECT conf_id from FE_CONFIG_MAIN "
85  "WHERE tag = :1 and version= (select max(version) from FE_CONFIG_MAIN where tag=:2) ");
86  stmt->setString(1, m_config_tag);
87  stmt->setString(2, m_config_tag);
88  std::cout << " using query WITHOUT version " << endl;
89  }
90 
91  ResultSet* rset = stmt->executeQuery();
92 
93  if (rset->next()) {
94  m_ID = rset->getInt(1);
95  } else {
96  m_ID = 0;
97  }
98  std::cout << m_ID << endl;
99  m_conn->terminateStatement(stmt);
100  } catch (SQLException& e) {
101  throw(std::runtime_error("FEConfigMainInfo::fetchID: " + e.getMessage()));
102  }
103  setByID(m_ID);
104  return m_ID;
105 }
oracle::occi::Environment * m_env
Definition: IDBObject.h:33
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
void setByID(int id) noexcept(false)
std::string m_config_tag
Definition: IODConfig.h:25
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
oracle::occi::Statement Statement
Definition: IODConfig.h:21
int getVersion() const
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
std::string getConfigTag()
Definition: IODConfig.h:30
dh
Definition: cuy.py:355
int FEConfigMainInfo::fetchIDLast ( )
privatenoexcept

Definition at line 163 of file FEConfigMainInfo.cc.

References cuy::dh, and MillePedeFileConverter_cfg::e.

163  {
164  this->checkConnection();
165 
167 
168  try {
169  Statement* stmt = m_conn->createStatement();
170  stmt->setSQL("SELECT max(conf_id) FROM fe_config_main ");
171  ResultSet* rset = stmt->executeQuery();
172 
173  if (rset->next()) {
174  m_ID = rset->getInt(1);
175  } else {
176  m_ID = 0;
177  }
178  m_conn->terminateStatement(stmt);
179  } catch (SQLException& e) {
180  throw(std::runtime_error("ODRunConfigInfo::fetchIDLast: " + e.getMessage()));
181  }
182 
183  setByID(m_ID);
184  return m_ID;
185 }
oracle::occi::Environment * m_env
Definition: IDBObject.h:33
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
void setByID(int id) noexcept(false)
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
oracle::occi::Statement Statement
Definition: IODConfig.h:21
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
dh
Definition: cuy.py:355
int FEConfigMainInfo::fetchNextId ( )
privatenoexcept

Definition at line 40 of file FEConfigMainInfo.cc.

References MillePedeFileConverter_cfg::e, and mps_fire::result.

40  {
41  int result = 0;
42  try {
43  this->checkConnection();
44 
45  m_readStmt = m_conn->createStatement();
46  m_readStmt->setSQL("select fe_config_main_sq.NextVal from dual");
47  ResultSet* rset = m_readStmt->executeQuery();
48  while (rset->next()) {
49  result = rset->getInt(1);
50  }
51  m_conn->terminateStatement(m_readStmt);
52  return result;
53 
54  } catch (SQLException& e) {
55  throw(std::runtime_error("FEConfigMainInfo::fetchNextId(): " + e.getMessage()));
56  }
57 }
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
Statement * m_readStmt
Definition: IODConfig.h:34
int FEConfigMainInfo::getBstId ( ) const
inline

Definition at line 64 of file FEConfigMainInfo.h.

References m_bst_id.

Referenced by EcalTPGParamBuilder::analyze(), and popcon::EcalTPGBadStripHandler::getNewObjects().

64 { return m_bst_id; }
int FEConfigMainInfo::getBttId ( ) const
inline

Definition at line 61 of file FEConfigMainInfo.h.

References m_btt_id.

Referenced by EcalTPGParamBuilder::analyze(), and popcon::EcalTPGBadTTHandler::getNewObjects().

61 { return m_btt_id; }
int FEConfigMainInfo::getBxtId ( ) const
inline

Definition at line 58 of file FEConfigMainInfo.h.

References m_bxt_id.

Referenced by EcalTPGParamBuilder::analyze(), and popcon::EcalTPGBadXTHandler::getNewObjects().

58 { return m_bxt_id; }
Tm FEConfigMainInfo::getDBTime ( ) const
inline

Definition at line 27 of file FEConfigMainInfo.h.

References m_db_time.

27 { return m_db_time; }
std::string FEConfigMainInfo::getDescription ( ) const
inline

Definition at line 31 of file FEConfigMainInfo.h.

References m_description.

31 { return m_description; }
std::string m_description
int FEConfigMainInfo::getFgrId ( ) const
inline
int FEConfigMainInfo::getId ( void  ) const
inline

Definition at line 25 of file FEConfigMainInfo.h.

References m_ID.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

25 { return m_ID; }
int FEConfigMainInfo::getLinId ( ) const
inline
int FEConfigMainInfo::getLUTId ( ) const
inline
int FEConfigMainInfo::getPedId ( ) const
inline
int FEConfigMainInfo::getSliId ( ) const
inline
int FEConfigMainInfo::getSpiId ( ) const
inline
std::string FEConfigMainInfo::getTable ( )
inlineoverridevirtual

Implements IODConfig.

Definition at line 21 of file FEConfigMainInfo.h.

21 { return "FE_CONFIG_MAIN"; }
int FEConfigMainInfo::getTimId ( ) const
inline

Definition at line 55 of file FEConfigMainInfo.h.

References m_tim_id.

Referenced by EcalTPGParamBuilder::analyze().

55 { return m_tim_id; }
int FEConfigMainInfo::getVersion ( ) const
inline

Definition at line 67 of file FEConfigMainInfo.h.

References m_version.

Referenced by popcon::EcalTPGBadXTHandler::getNewObjects().

67 { return m_version; }
int FEConfigMainInfo::getWeiId ( ) const
inline
void FEConfigMainInfo::insertConfig ( )
privatenoexcept

Definition at line 281 of file FEConfigMainInfo.cc.

References MillePedeFileConverter_cfg::e, and GlobalTrackerMuonAlignment_cfi::writeDB.

281  {
282  try {
283  prepareWrite();
284  writeDB();
285  m_conn->commit();
287  } catch (std::runtime_error& e) {
288  m_conn->rollback();
289  throw(e);
290  } catch (...) {
291  m_conn->rollback();
292  throw(std::runtime_error("FEConfigMainInfo::insertConfig: Unknown exception caught"));
293  }
294 }
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
void prepareWrite() noexcept(false) override
void writeDB() noexcept(false)
void terminateWriteStatement() noexcept(false)
Definition: IODConfig.h:42
bool FEConfigMainInfo::operator!= ( const FEConfigMainInfo r) const
inline

Definition at line 71 of file FEConfigMainInfo.h.

References alignCSCRings::r.

71 { return !(*this == r); }
bool FEConfigMainInfo::operator== ( const FEConfigMainInfo r) const
inline

Definition at line 70 of file FEConfigMainInfo.h.

References m_ID.

70 { return (m_ID == r.m_ID); }
void FEConfigMainInfo::prepareWrite ( )
overrideprivatevirtualnoexcept

Implements IODConfig.

Definition at line 107 of file FEConfigMainInfo.cc.

References MillePedeFileConverter_cfg::e.

107  {
108  this->checkConnection();
109 
110  int next_id = fetchNextId();
111 
112  try {
113  m_writeStmt = m_conn->createStatement();
114  m_writeStmt->setSQL(
115  "INSERT INTO fe_config_main (conf_id, ped_conf_id, lin_conf_id, lut_conf_id, fgr_conf_id, sli_conf_id, "
116  "wei_conf_id, spi_conf_id, tim_conf_id, bxt_conf_id, btt_conf_id, bst_conf_id, tag, version, description) "
117  " VALUES (:1, :2, :3 , :4, :5, :6 ,:7, :8, :9, :10, :11, :12, :13, :14, :15 )");
118 
119  m_writeStmt->setInt(1, next_id);
120  m_ID = next_id;
121 
122  } catch (SQLException& e) {
123  throw(std::runtime_error("FEConfigMainInfo::prepareWrite(): " + e.getMessage()));
124  }
125 }
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
Statement * m_writeStmt
Definition: IODConfig.h:33
int fetchNextId() noexcept(false)
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
void FEConfigMainInfo::setBstId ( int  x)
inline

Definition at line 63 of file FEConfigMainInfo.h.

References m_bst_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setBttId ( int  x)
inline

Definition at line 60 of file FEConfigMainInfo.h.

References m_btt_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setBxtId ( int  x)
inline

Definition at line 57 of file FEConfigMainInfo.h.

References m_bxt_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setByID ( int  id)
privatenoexcept

Definition at line 187 of file FEConfigMainInfo.cc.

References gather_cfg::cout, DateHandler::dateToTm(), cuy::dh, MillePedeFileConverter_cfg::e, and triggerObjects_cff::id.

187  {
188  this->checkConnection();
189 
191 
192  cout << "FEConfigMainInfo::setByID called for id " << id << endl;
193 
194  try {
195  Statement* stmt = m_conn->createStatement();
196 
197  stmt->setSQL("SELECT * FROM FE_CONFIG_MAIN WHERE conf_id = :1 ");
198  stmt->setInt(1, id);
199 
200  ResultSet* rset = stmt->executeQuery();
201  if (rset->next()) {
202  setId(rset->getInt(1));
203  setPedId(rset->getInt(2));
204  setLinId(rset->getInt(3));
205  setLUTId(rset->getInt(4));
206  setFgrId(rset->getInt(5));
207  setSliId(rset->getInt(6));
208  setWeiId(rset->getInt(7));
209  setSpiId(rset->getInt(8));
210  setTimId(rset->getInt(9));
211  setBxtId(rset->getInt(10));
212  setBttId(rset->getInt(11));
213  setBstId(rset->getInt(12));
214  setConfigTag(rset->getString(13));
215  setVersion(rset->getInt(14));
216  setDescription(rset->getString(15));
217  Date dbdate = rset->getDate(16);
218  setDBTime(dh.dateToTm(dbdate));
219  m_ID = id;
220  } else {
221  throw(std::runtime_error("FEConfigMainInfo::setByID: Given cycle_id is not in the database"));
222  }
223  m_conn->terminateStatement(stmt);
224  } catch (SQLException& e) {
225  throw(std::runtime_error("FEConfigMainInfo::setByID: " + e.getMessage()));
226  }
227 }
void setSpiId(int x)
void setDescription(std::string x)
oracle::occi::Environment * m_env
Definition: IDBObject.h:33
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
void setLinId(int x)
void setTimId(int x)
void setBxtId(int x)
void setId(int id)
void setVersion(int id)
void setLUTId(int x)
void setFgrId(int x)
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
void setPedId(int x)
void setWeiId(int x)
oracle::occi::Statement Statement
Definition: IODConfig.h:21
void setDBTime(const Tm &x)
void setConfigTag(std::string x)
Definition: IODConfig.h:29
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
void setSliId(int x)
dh
Definition: cuy.py:355
void setBstId(int x)
void setBttId(int x)
void FEConfigMainInfo::setDBTime ( const Tm x)
inline

Definition at line 28 of file FEConfigMainInfo.h.

References m_db_time, and x.

void FEConfigMainInfo::setDescription ( std::string  x)
inline

Definition at line 30 of file FEConfigMainInfo.h.

References m_description, and x.

30 { m_description = x; }
std::string m_description
void FEConfigMainInfo::setFgrId ( int  x)
inline

Definition at line 42 of file FEConfigMainInfo.h.

References m_fgr_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setId ( int  id)
inline

Definition at line 24 of file FEConfigMainInfo.h.

References triggerObjects_cff::id, and m_ID.

void FEConfigMainInfo::setLinId ( int  x)
inline

Definition at line 36 of file FEConfigMainInfo.h.

References m_lin_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setLUTId ( int  x)
inline

Definition at line 39 of file FEConfigMainInfo.h.

References m_lut_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setPedId ( int  x)
inline

Definition at line 33 of file FEConfigMainInfo.h.

References m_ped_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setSliId ( int  x)
inline

Definition at line 45 of file FEConfigMainInfo.h.

References m_sli_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setSpiId ( int  x)
inline

Definition at line 51 of file FEConfigMainInfo.h.

References m_spi_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setTimId ( int  x)
inline

Definition at line 54 of file FEConfigMainInfo.h.

References m_tim_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::setVersion ( int  id)
inline
void FEConfigMainInfo::setWeiId ( int  x)
inline

Definition at line 48 of file FEConfigMainInfo.h.

References m_wei_id, and x.

Referenced by EcalTPGDBApp::writeToConfDB_TPGMain().

void FEConfigMainInfo::writeDB ( )
privatenoexcept

Definition at line 127 of file FEConfigMainInfo.cc.

References gather_cfg::cout, cuy::dh, and MillePedeFileConverter_cfg::e.

127  {
128  this->checkConnection();
129  this->checkPrepare();
130 
131  // Validate the data, use infinity-till convention
133 
134  try {
135  m_writeStmt->setInt(2, this->getPedId());
136  m_writeStmt->setInt(3, this->getLinId());
137  m_writeStmt->setInt(4, this->getLUTId());
138  m_writeStmt->setInt(5, this->getFgrId());
139  m_writeStmt->setInt(6, this->getSliId());
140  m_writeStmt->setInt(7, this->getWeiId());
141  m_writeStmt->setInt(8, this->getSpiId());
142  m_writeStmt->setInt(9, this->getTimId());
143  m_writeStmt->setInt(10, this->getBxtId());
144  m_writeStmt->setInt(11, this->getBttId());
145  m_writeStmt->setInt(12, this->getBstId());
146  m_writeStmt->setString(13, this->getConfigTag());
147  m_writeStmt->setInt(14, this->getVersion());
148  m_writeStmt->setString(15, this->getDescription());
149  m_writeStmt->executeUpdate();
150 
151  } catch (SQLException& e) {
152  throw(std::runtime_error("FEConfigMainInfo::writeDB: " + e.getMessage()));
153  }
154  // Now get the ID
155  if (!this->fetchID()) {
156  throw(std::runtime_error("FEConfigMainInfo::writeDB: Failed to write"));
157  }
158  setByID(m_ID);
159 
160  cout << "FEConfigMainInfo::writeDB>> done inserting FEConfigMainInfo with id=" << m_ID << endl;
161 }
oracle::occi::Environment * m_env
Definition: IDBObject.h:33
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
std::string getDescription() const
Statement * m_writeStmt
Definition: IODConfig.h:33
void setByID(int id) noexcept(false)
int fetchID() noexcept(false)
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
int getTimId() const
int getLinId() const
int getSpiId() const
int getWeiId() const
int getFgrId() const
int getBttId() const
int getVersion() const
int getPedId() const
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
int getBxtId() const
int getBstId() const
std::string getConfigTag()
Definition: IODConfig.h:30
int getLUTId() const
dh
Definition: cuy.py:355
void checkPrepare() noexcept(false)
Definition: IODConfig.h:36
int getSliId() const

Friends And Related Function Documentation

friend class EcalCondDBInterface
friend

Definition at line 16 of file FEConfigMainInfo.h.

Member Data Documentation

int FEConfigMainInfo::m_bst_id
private

Definition at line 84 of file FEConfigMainInfo.h.

Referenced by getBstId(), and setBstId().

int FEConfigMainInfo::m_btt_id
private

Definition at line 83 of file FEConfigMainInfo.h.

Referenced by getBttId(), and setBttId().

int FEConfigMainInfo::m_bxt_id
private

Definition at line 82 of file FEConfigMainInfo.h.

Referenced by getBxtId(), and setBxtId().

Tm FEConfigMainInfo::m_db_time
private

Definition at line 88 of file FEConfigMainInfo.h.

Referenced by getDBTime(), and setDBTime().

std::string FEConfigMainInfo::m_description
private

Definition at line 89 of file FEConfigMainInfo.h.

Referenced by getDescription(), and setDescription().

int FEConfigMainInfo::m_fgr_id
private

Definition at line 80 of file FEConfigMainInfo.h.

Referenced by getFgrId(), and setFgrId().

int FEConfigMainInfo::m_ID
private

Definition at line 75 of file FEConfigMainInfo.h.

Referenced by getId(), operator==(), and setId().

int FEConfigMainInfo::m_lin_id
private

Definition at line 77 of file FEConfigMainInfo.h.

Referenced by getLinId(), and setLinId().

int FEConfigMainInfo::m_lut_id
private

Definition at line 78 of file FEConfigMainInfo.h.

Referenced by getLUTId(), and setLUTId().

int FEConfigMainInfo::m_ped_id
private

Definition at line 76 of file FEConfigMainInfo.h.

Referenced by getPedId(), and setPedId().

int FEConfigMainInfo::m_sli_id
private

Definition at line 79 of file FEConfigMainInfo.h.

Referenced by getSliId(), and setSliId().

int FEConfigMainInfo::m_spi_id
private

Definition at line 86 of file FEConfigMainInfo.h.

Referenced by getSpiId(), and setSpiId().

int FEConfigMainInfo::m_tim_id
private

Definition at line 85 of file FEConfigMainInfo.h.

Referenced by getTimId(), and setTimId().

int FEConfigMainInfo::m_version
private

Definition at line 87 of file FEConfigMainInfo.h.

Referenced by getVersion(), and setVersion().

int FEConfigMainInfo::m_wei_id
private

Definition at line 81 of file FEConfigMainInfo.h.

Referenced by getWeiId(), and setWeiId().