CMS 3D CMS Logo

All Classes Namespaces Files Functions Variables Typedefs Enumerations Enumerator Properties Friends Macros Modules Pages
List of all members | Public Member Functions | Private Member Functions | Private Attributes | Friends
ODScanCycle Class Reference

#include <ODScanCycle.h>

Inheritance diagram for ODScanCycle:
IODConfig IDBObject

Public Member Functions

int getId () const
 
int getScanConfigurationID () const
 
std::string getTable () override
 
 ODScanCycle ()
 
bool operator!= (const ODScanCycle &m) const
 
bool operator== (const ODScanCycle &m) const
 
void setId (int id)
 
void setScanConfigurationID (int x)
 
 ~ODScanCycle () 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 (ODScanCycle *result) noexcept(false)
 
int fetchID () 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_ID
 
int m_scan_config_id
 

Friends

class EcalCondDBInterface
 
class ODEcalCycle
 

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 9 of file ODScanCycle.h.

Constructor & Destructor Documentation

◆ ODScanCycle()

ODScanCycle::ODScanCycle ( )

Definition at line 9 of file ODScanCycle.cc.

9  {
10  m_env = nullptr;
11  m_conn = nullptr;
12  m_writeStmt = nullptr;
13  m_readStmt = nullptr;
14  //
15  m_ID = 0;
16  m_scan_config_id = 0;
17 }
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
int m_scan_config_id
Definition: ODScanCycle.h:33
Statement * m_readStmt
Definition: IODConfig.h:34

◆ ~ODScanCycle()

ODScanCycle::~ODScanCycle ( )
override

Definition at line 19 of file ODScanCycle.cc.

19 {}

Member Function Documentation

◆ clear()

void ODScanCycle::clear ( void  )
private

Definition at line 54 of file ODScanCycle.cc.

54 { m_scan_config_id = 0; }
int m_scan_config_id
Definition: ODScanCycle.h:33

◆ fetchData()

void ODScanCycle::fetchData ( ODScanCycle result)
privatenoexcept

Definition at line 109 of file ODScanCycle.cc.

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

109  {
110  this->checkConnection();
111  result->clear();
112 
113  if (result->getId() == 0) {
114  throw(std::runtime_error("ODScanConfig::fetchData(): no Id defined for this ODScanConfig "));
115  }
116 
117  try {
118  m_readStmt->setSQL(
119  "SELECT scan_configuration_id FROM ecal_scan_cycle "
120  "WHERE cycle_id = :1 ");
121 
122  m_readStmt->setInt(1, result->getId());
123  ResultSet *rset = m_readStmt->executeQuery();
124 
125  rset->next();
126 
127  result->setScanConfigurationID(rset->getInt(1));
128 
129  } catch (SQLException &e) {
130  throw(std::runtime_error("ODScanCycle::fetchData(): " + e.getMessage()));
131  }
132 }
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
void clear()
Definition: ODScanCycle.cc:54
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
Statement * m_readStmt
Definition: IODConfig.h:34

◆ fetchID()

int ODScanCycle::fetchID ( )
privatenoexcept

Definition at line 56 of file ODScanCycle.cc.

References MillePedeFileConverter_cfg::e.

56  {
57  // Return from memory if available
58  if (m_ID) {
59  return m_ID;
60  }
61 
62  this->checkConnection();
63 
64  try {
65  Statement *stmt = m_conn->createStatement();
66  stmt->setSQL(
67  "SELECT cycle_id, scan_id FROM ecal_scan_cycle "
68  "WHERE cycle_id = :1 ");
69  stmt->setInt(1, m_ID);
70  ResultSet *rset = stmt->executeQuery();
71 
72  if (rset->next()) {
73  m_ID = rset->getInt(1);
74  m_scan_config_id = rset->getInt(2);
75  } else {
76  m_ID = 0;
77  }
78  m_conn->terminateStatement(stmt);
79  } catch (SQLException &e) {
80  throw(std::runtime_error("ODScanCycle::fetchID: " + e.getMessage()));
81  }
82 
83  return m_ID;
84 }
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
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
int m_scan_config_id
Definition: ODScanCycle.h:33

◆ getId()

int ODScanCycle::getId ( void  ) const
inline

Definition at line 20 of file ODScanCycle.h.

References m_ID.

20 { return m_ID; };

◆ getScanConfigurationID()

int ODScanCycle::getScanConfigurationID ( ) const
inline

Definition at line 24 of file ODScanCycle.h.

References m_scan_config_id.

24 { return m_scan_config_id; }
int m_scan_config_id
Definition: ODScanCycle.h:33

◆ getTable()

std::string ODScanCycle::getTable ( )
inlineoverridevirtual

Implements IODConfig.

Definition at line 17 of file ODScanCycle.h.

17 { return "ECAL_Scan_CYCLE"; }

◆ insertConfig()

void ODScanCycle::insertConfig ( )
privatenoexcept

Definition at line 134 of file ODScanCycle.cc.

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

Referenced by ODEcalCycle::writeDB().

134  {
135  try {
136  prepareWrite();
137  writeDB();
138  m_conn->commit();
140  } catch (std::runtime_error &e) {
141  m_conn->rollback();
142  throw(e);
143  } catch (...) {
144  m_conn->rollback();
145  throw(std::runtime_error("EcalCondDBInterface::insertDataSet: Unknown exception caught"));
146  }
147 }
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
void terminateWriteStatement() noexcept(false)
Definition: IODConfig.h:42
void prepareWrite() noexcept(false) override
Definition: ODScanCycle.cc:21
void writeDB() noexcept(false)
Definition: ODScanCycle.cc:34

◆ operator!=()

bool ODScanCycle::operator!= ( const ODScanCycle m) const
inline

◆ operator==()

bool ODScanCycle::operator== ( const ODScanCycle m) const
inline

◆ prepareWrite()

void ODScanCycle::prepareWrite ( )
overrideprivatevirtualnoexcept

Implements IODConfig.

Definition at line 21 of file ODScanCycle.cc.

References MillePedeFileConverter_cfg::e.

21  {
22  this->checkConnection();
23 
24  try {
25  m_writeStmt = m_conn->createStatement();
26  m_writeStmt->setSQL(
27  "INSERT INTO ECAL_Scan_Cycle (cycle_id, scan_id ) "
28  "VALUES (:1, :2 )");
29  } catch (SQLException &e) {
30  throw(std::runtime_error("ODScanCycle::prepareWrite(): " + e.getMessage()));
31  }
32 }
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
Statement * m_writeStmt
Definition: IODConfig.h:33
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20

◆ setByID()

void ODScanCycle::setByID ( int  id)
privatenoexcept

Definition at line 86 of file ODScanCycle.cc.

References MillePedeFileConverter_cfg::e.

86  {
87  this->checkConnection();
88 
89  try {
90  Statement *stmt = m_conn->createStatement();
91  stmt->setSQL(
92  "SELECT cycle_id, scan_configuration_id FROM ecal_scan_cycle "
93  "WHERE cycle_id = :1 ");
94  stmt->setInt(1, id);
95  ResultSet *rset = stmt->executeQuery();
96 
97  if (rset->next()) {
98  m_ID = rset->getInt(1);
99  m_scan_config_id = rset->getInt(2);
100  } else {
101  m_ID = 0;
102  }
103  m_conn->terminateStatement(stmt);
104  } catch (SQLException &e) {
105  throw(std::runtime_error("ODScanCycle::fetchID: " + e.getMessage()));
106  }
107 }
oracle::occi::Connection * m_conn
Definition: IDBObject.h:34
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
int m_scan_config_id
Definition: ODScanCycle.h:33

◆ setId()

void ODScanCycle::setId ( int  id)
inline

Definition at line 19 of file ODScanCycle.h.

References l1ctLayer2EG_cff::id, and m_ID.

Referenced by ODEcalCycle::writeDB().

◆ setScanConfigurationID()

void ODScanCycle::setScanConfigurationID ( int  x)
inline

Definition at line 23 of file ODScanCycle.h.

References m_scan_config_id, and x.

Referenced by ODEcalCycle::writeDB().

◆ writeDB()

void ODScanCycle::writeDB ( )
privatenoexcept

Definition at line 34 of file ODScanCycle.cc.

References MillePedeFileConverter_cfg::e, and getId().

34  {
35  this->checkConnection();
36  this->checkPrepare();
37 
38  try {
39  m_writeStmt->setInt(1, this->getId());
40  m_writeStmt->setInt(2, this->getScanConfigurationID());
41 
42  m_writeStmt->executeUpdate();
43 
44  } catch (SQLException &e) {
45  throw(std::runtime_error("ODScanCycle::writeDB: " + e.getMessage()));
46  }
47 
48  // Now get the ID
49  if (!this->fetchID()) {
50  throw(std::runtime_error("ODScanCycle::writeDB: Failed to write"));
51  }
52 }
int getId() const
Definition: ODScanCycle.h:20
Statement * m_writeStmt
Definition: IODConfig.h:33
void checkConnection() const noexcept(false)
Definition: IDBObject.h:36
int fetchID() noexcept(false)
Definition: ODScanCycle.cc:56
int getScanConfigurationID() const
Definition: ODScanCycle.h:24
oracle::occi::SQLException SQLException
Definition: IODConfig.h:20
void checkPrepare() noexcept(false)
Definition: IODConfig.h:36

Friends And Related Function Documentation

◆ EcalCondDBInterface

friend class EcalCondDBInterface
friend

Definition at line 11 of file ODScanCycle.h.

◆ ODEcalCycle

friend class ODEcalCycle
friend

Definition at line 12 of file ODScanCycle.h.

Member Data Documentation

◆ m_ID

int ODScanCycle::m_ID
private

Definition at line 32 of file ODScanCycle.h.

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

◆ m_scan_config_id

int ODScanCycle::m_scan_config_id
private

Definition at line 33 of file ODScanCycle.h.

Referenced by getScanConfigurationID(), and setScanConfigurationID().