CMS 3D CMS Logo

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

#include <RunDCSMagnetDat.h>

Inheritance diagram for RunDCSMagnetDat:
IDataItem IDBObject

Public Types

typedef oracle::occi::ResultSet ResultSet
 

Public Member Functions

std::string getMagnetAccount ()
 
float getMagnetCurrent () const
 
std::string getTable ()
 
Tm getTime () const
 
 RunDCSMagnetDat ()
 
void setMagnetCurrent (float t)
 
void setTime (const Tm &start)
 
 ~RunDCSMagnetDat ()
 
- 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, RunDCSMagnetDat > *fillMap, RunIOV *iov) noexcept(false)
 
void fetchLastData (std::map< EcalLogicID, RunDCSMagnetDat > *fillMap) noexcept(false)
 
void fillTheMap (ResultSet *, std::map< EcalLogicID, RunDCSMagnetDat > *)
 
ResultSetgetMagnetRset ()
 
int nowMicroseconds ()
 
void prepareWrite () noexcept(false)
 
void writeDB (const EcalLogicID *ecid, const RunDCSMagnetDat *item, RunIOV *iov) noexcept(false)
 

Private Attributes

float m_current
 
Tm m_time
 

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 15 of file RunDCSMagnetDat.h.

Member Typedef Documentation

typedef oracle::occi::ResultSet RunDCSMagnetDat::ResultSet

Definition at line 17 of file RunDCSMagnetDat.h.

Constructor & Destructor Documentation

RunDCSMagnetDat::RunDCSMagnetDat ( )

Definition at line 15 of file RunDCSMagnetDat.cc.

References NULL.

16 {
17  m_env = NULL;
18  m_conn = NULL;
19  m_writeStmt = NULL;
20  m_readStmt = NULL;
21 
22  m_current = 0;
23  m_time=Tm();
24 }
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
#define NULL
Definition: scimark2.h:8
oracle::occi::Statement * m_readStmt
Definition: IDataItem.h:29
Definition: Tm.h:13
RunDCSMagnetDat::~RunDCSMagnetDat ( )

Definition at line 28 of file RunDCSMagnetDat.cc.

29 {
30 }

Member Function Documentation

void RunDCSMagnetDat::fetchData ( std::map< EcalLogicID, RunDCSMagnetDat > *  fillMap,
RunIOV iov 
)
privatenoexcept

Definition at line 62 of file RunDCSMagnetDat.cc.

References gather_cfg::cout.

Referenced by getMagnetCurrent().

64 {
65 
66  std::cout<<"going to call fetchLastData"<<std::endl;
67  fetchLastData(fillMap);
68  std::cout<<"returned from fetchLastData"<<std::endl;
69 
70 }
void fetchLastData(std::map< EcalLogicID, RunDCSMagnetDat > *fillMap) noexcept(false)
void RunDCSMagnetDat::fetchLastData ( std::map< EcalLogicID, RunDCSMagnetDat > *  fillMap)
privatenoexcept

Definition at line 153 of file RunDCSMagnetDat.cc.

References gather_cfg::cout, MillePedeFileConverter_cfg::e, and AlCaHLTBitMon_ParallelJobs::p.

Referenced by getMagnetCurrent().

155 {
156  this->checkConnection();
157 
158  std::cout<<"fetchLastData>>1"<<std::endl;
159 
160  fillMap->clear();
161 
162  std::cout<<"fetchLastData>>2"<<std::endl;
163 
164 
165  try {
166  std::pair< EcalLogicID, RunDCSMagnetDat > p;
167  RunDCSMagnetDat dat;
168  std::cout<<"fetchLastData>>3"<<std::endl;
169 
170  ResultSet* rset = getMagnetRset();
171 
172  std::cout<<"fetchLastData>>4"<<std::endl;
173 
174  fillTheMap(rset, fillMap);
175  std::cout<<"fetchLastData>>5"<<std::endl;
176 
177 
178  }
179  catch (SQLException &e) {
180 #if defined(_GLIBCXX_USE_CXX11_ABI) && (_GLIBCXX_USE_CXX11_ABI == 0)
181  throw(std::runtime_error("RunDCSMagnetDat::fetchData(): "+e.getMessage()));
182 #else
183  throw(std::runtime_error("RunDCSMagnetDat::fetchData(): error code " + std::to_string(e.getErrorCode())));
184 #endif
185  }
186 }
void checkConnection() const noexcept(false)
Definition: IDBObject.h:41
oracle::occi::ResultSet ResultSet
void fillTheMap(ResultSet *, std::map< EcalLogicID, RunDCSMagnetDat > *)
ResultSet * getMagnetRset()
void RunDCSMagnetDat::fillTheMap ( ResultSet rset,
std::map< EcalLogicID, RunDCSMagnetDat > *  fillMap 
)
private

Definition at line 99 of file RunDCSMagnetDat.cc.

References gather_cfg::cout, DateHandler::dateToTm(), cuy::dh, MillePedeFileConverter_cfg::e, AlCaHLTBitMon_ParallelJobs::p, setMagnetCurrent(), and setTime().

Referenced by getMagnetCurrent().

100  {
101 
102  // method for last value queries
103 
104  std::pair< EcalLogicID, RunDCSMagnetDat > p;
105  RunDCSMagnetDat dat;
107 
108  try {
109  while(rset->next()) {
110  p.first = EcalLogicID( rset->getString(1), // name
111  rset->getInt(2), // logic_id
112  rset->getInt(3), // id1
113  rset->getInt(4), // id2
114  rset->getInt(5), // id3
115  rset->getString(6)); // maps_to
116 
117  std::cout<<"done the logic id"<<std::endl;
118  dat.setMagnetCurrent( rset->getFloat(7) );
119  std::cout<<"done the magnet current"<<std::endl;
120 
121  Date sinceDate = rset->getDate(8);
122  std::cout<<"done the date"<<std::endl;
123 
124  Tm sinceTm = dh.dateToTm( sinceDate );
125  dat.setTime(sinceTm);
126 
127  p.second = dat;
128  fillMap->insert(p);
129  }
130  }
131  catch (SQLException &e) {
132 #if defined(_GLIBCXX_USE_CXX11_ABI) && (_GLIBCXX_USE_CXX11_ABI == 0)
133  throw(std::runtime_error("RunDCSMagnetDat::fetchData(): "+e.getMessage()));
134 #else
135  throw(std::runtime_error("RunDCSMagnetDat::fetchData(): error code " + std::to_string(e.getErrorCode())));
136 #endif
137  }
138 }
oracle::occi::Environment * m_env
Definition: IDBObject.h:38
oracle::occi::Connection * m_conn
Definition: IDBObject.h:39
void setMagnetCurrent(float t)
void setTime(const Tm &start)
dh
Definition: cuy.py:353
Definition: Tm.h:13
std::string RunDCSMagnetDat::getMagnetAccount ( )
inline

Definition at line 25 of file RunDCSMagnetDat.h.

25 { return "CMS_DCS_ENV_PVSS_COND"; }
float RunDCSMagnetDat::getMagnetCurrent ( ) const
inline
ResultSet * RunDCSMagnetDat::getMagnetRset ( )
private

Definition at line 73 of file RunDCSMagnetDat.cc.

References gather_cfg::cout, cuy::dh, MillePedeFileConverter_cfg::e, NULL, and das::query().

Referenced by getMagnetCurrent().

73  {
74 
76 
77  ResultSet* rset = NULL;
78  string query="SELECT c.name, c.logic_id, c.id1, c.id2, c.id3, c.maps_to , v.value_number, v.change_date from "+ getMagnetAccount()+
79  ".CMSFWMAGNET_LV v, channelview c where v.dpe_name= 'CURRENT' and c.name=maps_to and c.name='EB' " ;
80  try {
81 
82  std::cout<<"query:"<<query<<std::endl;
83 
84  m_readStmt->setSQL(query);
85  rset = m_readStmt->executeQuery();
86  }
87  catch (SQLException e) {
88 #if defined(_GLIBCXX_USE_CXX11_ABI) && (_GLIBCXX_USE_CXX11_ABI == 0)
89  throw(std::runtime_error("RunDCSMagnetDat::getBarrelRset(): " + e.getMessage() + " " + query));
90 #else
91  throw(std::runtime_error("RunDCSMagnetDat::getBarrelRset(): error code " + std::to_string(e.getErrorCode()) + " " + query));
92 #endif
93  }
94  return rset;
95 }
oracle::occi::Environment * m_env
Definition: IDBObject.h:38
oracle::occi::Connection * m_conn
Definition: IDBObject.h:39
std::string getMagnetAccount()
#define NULL
Definition: scimark2.h:8
def query(query_str, verbose=False)
Definition: das.py:5
Definition: query.py:1
oracle::occi::ResultSet ResultSet
oracle::occi::Statement * m_readStmt
Definition: IDataItem.h:29
dh
Definition: cuy.py:353
std::string RunDCSMagnetDat::getTable ( )
inlinevirtual

Implements IDataItem.

Definition at line 24 of file RunDCSMagnetDat.h.

24 { return "CMSFWMAGNET_LV"; }
Tm RunDCSMagnetDat::getTime ( void  ) const

Definition at line 37 of file RunDCSMagnetDat.cc.

Referenced by getMagnetCurrent().

38 {
39  return m_time;
40 }
int RunDCSMagnetDat::nowMicroseconds ( )
private

Definition at line 143 of file RunDCSMagnetDat.cc.

References Tm::microsTime(), and Tm::setToCurrentGMTime().

Referenced by getMagnetCurrent().

143  {
144  Tm t_now_gmt;
145 
146  t_now_gmt.setToCurrentGMTime();
147  int t_now_gmt_micros = t_now_gmt.microsTime();
148  return t_now_gmt_micros;
149 }
void setToCurrentGMTime()
Definition: Tm.cc:177
uint64_t microsTime() const
Definition: Tm.cc:126
Definition: Tm.h:13
void RunDCSMagnetDat::prepareWrite ( )
privatevirtualnoexcept

Implements IDataItem.

Definition at line 46 of file RunDCSMagnetDat.cc.

Referenced by getMagnetCurrent().

48 {
49 
50 
51 }
void RunDCSMagnetDat::setMagnetCurrent ( float  t)
inline

Definition at line 26 of file RunDCSMagnetDat.h.

References m_current, and lumiQTWidget::t.

Referenced by fillTheMap().

void RunDCSMagnetDat::setTime ( const Tm start)

Definition at line 32 of file RunDCSMagnetDat.cc.

References command_line::start.

Referenced by fillTheMap(), and getMagnetCurrent().

33 {
34  m_time = start;
35 }
void RunDCSMagnetDat::writeDB ( const EcalLogicID ecid,
const RunDCSMagnetDat item,
RunIOV iov 
)
privatenoexcept

Definition at line 55 of file RunDCSMagnetDat.cc.

Referenced by getMagnetCurrent().

57 {
58 }

Friends And Related Function Documentation

friend class EcalCondDBInterface
friend

Definition at line 19 of file RunDCSMagnetDat.h.

Member Data Documentation

float RunDCSMagnetDat::m_current
private

Definition at line 53 of file RunDCSMagnetDat.h.

Referenced by getMagnetCurrent(), and setMagnetCurrent().

Tm RunDCSMagnetDat::m_time
private

Definition at line 54 of file RunDCSMagnetDat.h.