#include <ODCond2ConfInfo.h>

Inheritance diagram for ODCond2ConfInfo:

Public Member Functions
int	fetchID () noexcept(false)

int	fetchNextId () noexcept(false)

Tm	getDBDate () const

std::string	getDescription () const

int	getId () const

std::string	getLocation () const

Tm	getRecordDate () const

int	getRunNumber () const

std::string	getTable () override

std::string	getType () const

	ODCond2ConfInfo ()

void	setDBDate (const Tm &x)

void	setDescription (std::string x)

void	setId (int id)

void	setLocation (std::string x)

void	setParameters (const std::map< std::string, std::string > &my_keys_map)

void	setRecordDate (const Tm &x)

void	setRunNumber (int id)

void	setType (std::string x)

	~ODCond2ConfInfo () 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 (ODCond2ConfInfo *result) noexcept(false)

void	fetchParents () noexcept(false)

void	prepareWrite () noexcept(false) override

void	writeDB () noexcept(false)

Private Attributes
Tm	m_db_time

std::string	m_desc

int	m_ID

std::string	m_loc

int	m_loc_id

Tm	m_rec_time

int	m_run

int	m_typ_id

std::string	m_type

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 const int	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
Statement *	m_readStmt

Statement *	m_writeStmt

Protected Attributes inherited from IDBObject
oracle::occi::Connection *	m_conn

oracle::occi::Environment *	m_env

Detailed Description

Definition at line 12 of file ODCond2ConfInfo.h.

Constructor & Destructor Documentation

◆ ODCond2ConfInfo()

ODCond2ConfInfo::ODCond2ConfInfo ( )

Definition at line 12 of file ODCond2ConfInfo.cc.

                                  {
   m_env = nullptr;
   m_conn = nullptr;
   m_writeStmt = nullptr;
   m_readStmt = nullptr;
   m_config_tag = "";
   m_ID = 0;
   clear();
 }

References clear().

◆ ~ODCond2ConfInfo()

ODCond2ConfInfo::~ODCond2ConfInfo ( )

override

Definition at line 33 of file ODCond2ConfInfo.cc.

33 {}

Member Function Documentation

◆ clear()

void ODCond2ConfInfo::clear ( void )

private

Definition at line 22 of file ODCond2ConfInfo.cc.

                             {
   m_type = "";
   m_loc = "";
   m_run = 0;
   m_desc = "";
   m_rec_time = Tm();
   m_db_time = Tm();
   m_typ_id = 0;
   m_loc_id = 0;
 }

References RunInfoPI::m_run.

◆ fetchData()

void ODCond2ConfInfo::fetchData ( ODCond2ConfInfo * result )

privatenoexcept

Definition at line 154 of file ODCond2ConfInfo.cc.

                                                                        {
   this->checkConnection();
   result->clear();
  
   DateHandler dh(m_env, m_conn);
  
   if (result->getId() == 0) {
     throw(std::runtime_error("ODCond2ConfInfo::fetchData(): no Id defined for this ODCond2ConfInfo "));
   }
  
   try {
     m_readStmt->setSQL(
         "SELECT rec_id, REC_TYPE, rec_date, location, "
         "run_number, short_desc, db_timestamp FROM " +
         getTable() +
         " , COND2CONF_TYPE_DEF , location_def "
         " where  rec_id = :1  AND COND2CONF_TYPE_DEF.def_id=" +
         getTable() + ".REC_TYPE_ID AND location_def.def_id=LOCATION_ID ");
     m_readStmt->setInt(1, result->getId());
     ResultSet* rset = m_readStmt->executeQuery();
  
     rset->next();
  
     // 1 is the id and 2 is the config tag and 3 is the version
  
     //    result->setId(rset->getInt(1));
  
     result->setType(rset->getString(2));
     Date startDate = rset->getDate(3);
     result->setLocation(rset->getString(4));
     result->setRunNumber(rset->getInt(5));
     result->setDescription(rset->getString(6));
     Date endDate = rset->getDate(7);
  
     m_rec_time = dh.dateToTm(startDate);
     m_db_time = dh.dateToTm(endDate);
  
   } catch (SQLException& e) {
     throw(std::runtime_error(std::string("ODCond2ConfInfo::fetchData():  ") + e.getMessage()));
   }
 }

References cuy::dh, MillePedeFileConverter_cfg::e, mps_fire::result, and AlCaHLTBitMon_QueryRunRegistry::string.

◆ fetchID()

int ODCond2ConfInfo::fetchID ( )

noexcept

Definition at line 196 of file ODCond2ConfInfo.cc.

                                              {
   // Return from memory if available
   if (m_ID != 0) {
     return m_ID;
   }
  
   this->checkConnection();
  
   fetchParents();
  
   try {
     Statement* stmt = m_conn->createStatement();
     stmt->setSQL("SELECT rec_id FROM " + getTable() +
                  "WHERE  rec_type_id=:1 and (run_number=:2 or short_desc=:3 ) order by rec_id DESC ");
  
     stmt->setInt(1, m_typ_id);
     stmt->setInt(2, getRunNumber());
     stmt->setString(3, getDescription());
  
     ResultSet* rset = stmt->executeQuery();
  
     if (rset->next()) {
       m_ID = rset->getInt(1);
     } else {
       m_ID = 0;
     }
     m_conn->terminateStatement(stmt);
   } catch (SQLException& e) {
     throw(std::runtime_error(std::string("ODCond2ConfInfo::fetchID:  ") + e.getMessage()));
   }
  
   return m_ID;
 }

References MillePedeFileConverter_cfg::e, DeadROCCounter::getRunNumber(), and AlCaHLTBitMon_QueryRunRegistry::string.

◆ fetchNextId()

int ODCond2ConfInfo::fetchNextId ( )

noexcept

Definition at line 35 of file ODCond2ConfInfo.cc.

                                                  {
   int result = 0;
   try {
     this->checkConnection();
  
     m_readStmt = m_conn->createStatement();
     m_readStmt->setSQL("select COND2CONF_INFO_SQ.NextVal from DUAL ");
     ResultSet* rset = m_readStmt->executeQuery();
     while (rset->next()) {
       result = rset->getInt(1);
     }
     result++;
     m_conn->terminateStatement(m_readStmt);
     return result;
  
   } catch (SQLException& e) {
     throw(std::runtime_error(std::string("ODCond2ConfInfo::fetchNextId():  ") + e.getMessage()));
   }
 }

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

◆ fetchParents()

void ODCond2ConfInfo::fetchParents ( )

privatenoexcept

Definition at line 55 of file ODCond2ConfInfo.cc.

                                                    {
   if (m_typ_id == 0) {
     if (!getType().empty()) {
       try {
         this->checkConnection();
         m_readStmt = m_conn->createStatement();
         m_readStmt->setSQL("select def_id from COND2CONF_TYPE_DEF where rec_type=" + getType());
         ResultSet* rset = m_readStmt->executeQuery();
         while (rset->next()) {
           m_typ_id = rset->getInt(1);
         }
         m_conn->terminateStatement(m_readStmt);
  
       } catch (SQLException& e) {
         throw(std::runtime_error(std::string("ODCond2ConfInfo::fetchParents():  ") + e.getMessage()));
       }
     }
   }
   if (m_loc_id == 0) {
     if (!getLocation().empty()) {
       try {
         this->checkConnection();
         m_readStmt = m_conn->createStatement();
         m_readStmt->setSQL("select def_id from location_def where location=" + getLocation());
         ResultSet* rset = m_readStmt->executeQuery();
         while (rset->next()) {
           m_loc_id = rset->getInt(1);
         }
         m_conn->terminateStatement(m_readStmt);
       } catch (SQLException& e) {
         throw(std::runtime_error(std::string("ODCond2ConfInfo::fetchParents():  ") + e.getMessage()));
       }
     }
   }
 }

References MillePedeFileConverter_cfg::e, relativeConstraints::empty, and AlCaHLTBitMon_QueryRunRegistry::string.

◆ getDBDate()

Tm ODCond2ConfInfo::getDBDate ( ) const

inline

Definition at line 40 of file ODCond2ConfInfo.h.

40 { return m_db_time; }

References m_db_time.

◆ getDescription()

std::string ODCond2ConfInfo::getDescription ( ) const

inline

Definition at line 37 of file ODCond2ConfInfo.h.

37 { return m_desc; }

References m_desc.

◆ getId()

int ODCond2ConfInfo::getId ( void ) const

inline

Definition at line 22 of file ODCond2ConfInfo.h.

22 { return m_ID; }

References m_ID.

◆ getLocation()

std::string ODCond2ConfInfo::getLocation ( ) const

inline

Definition at line 31 of file ODCond2ConfInfo.h.

31 { return m_loc; }

References m_loc.

◆ getRecordDate()

Tm ODCond2ConfInfo::getRecordDate ( ) const

inline

Definition at line 28 of file ODCond2ConfInfo.h.

28 { return m_rec_time; }

References m_rec_time.

◆ getRunNumber()

int ODCond2ConfInfo::getRunNumber ( ) const

inline

Definition at line 34 of file ODCond2ConfInfo.h.

34 { return m_run; }

References m_run.

◆ getTable()

std::string ODCond2ConfInfo::getTable ( )

inlineoverridevirtual

Implements IODConfig.

Definition at line 19 of file ODCond2ConfInfo.h.

19 { return "COND_2_CONF_INFO"; }

◆ getType()

std::string ODCond2ConfInfo::getType ( void ) const

inline

Definition at line 25 of file ODCond2ConfInfo.h.

25 { return m_type; }

References m_type.

◆ prepareWrite()

void ODCond2ConfInfo::prepareWrite ( )

overrideprivatevirtualnoexcept

Implements IODConfig.

Definition at line 91 of file ODCond2ConfInfo.cc.

                                                    {
   this->checkConnection();
  
   int next_id = 0;
   if (getId() == 0) {
     next_id = fetchNextId();
   }
  
   fetchParents();
   try {
     m_writeStmt = m_conn->createStatement();
     m_writeStmt->setSQL("INSERT INTO " + getTable() +
                         " ( rec_id, rec_type_id, rec_date, "
                         "location_id, run_number, short_desc ) "
                         " VALUES ( :1, :2, :3 , :4, :5, :6 ) ");
  
     m_writeStmt->setInt(1, next_id);
     m_writeStmt->setInt(3, m_typ_id);
     m_writeStmt->setInt(4, m_loc_id);
  
     m_ID = next_id;
  
   } catch (SQLException& e) {
     throw(std::runtime_error(std::string("ODCond2ConfInfo::prepareWrite():  ") + e.getMessage()));
   }
 }

References MillePedeFileConverter_cfg::e, getId(), and AlCaHLTBitMon_QueryRunRegistry::string.

◆ setDBDate()

void ODCond2ConfInfo::setDBDate ( const Tm & x )

inline

Definition at line 39 of file ODCond2ConfInfo.h.

39 { m_db_time = x; }

References m_db_time, and x.

◆ setDescription()

void ODCond2ConfInfo::setDescription ( std::string x )

inline

Definition at line 36 of file ODCond2ConfInfo.h.

36 { m_desc = x; }

References m_desc, and x.

◆ setId()

void ODCond2ConfInfo::setId ( int id )

inline

Definition at line 21 of file ODCond2ConfInfo.h.

21 { m_ID = id; }

References triggerObjects_cff::id, and m_ID.

◆ setLocation()

void ODCond2ConfInfo::setLocation ( std::string x )

inline

Definition at line 30 of file ODCond2ConfInfo.h.

30 { m_loc = x; }

References m_loc, and x.

◆ setParameters()

void ODCond2ConfInfo::setParameters ( const std::map< std::string, std::string > & my_keys_map )

Definition at line 118 of file ODCond2ConfInfo.cc.

                                                                              {
   // parses the result of the XML parser that is a map of
   // string string with variable name variable value
  
   for (std::map<std::string, std::string>::const_iterator ci = my_keys_map.begin(); ci != my_keys_map.end(); ci++) {
     //    if(ci->first==  "TAG") setConfigTag(ci->second);
   }
   std::cout << "method not yet implemented" << std::endl;
 }

References gather_cfg::cout.

◆ setRecordDate()

void ODCond2ConfInfo::setRecordDate ( const Tm & x )

inline

Definition at line 27 of file ODCond2ConfInfo.h.

27 { m_rec_time = x; }

References m_rec_time, and x.

◆ setRunNumber()

void ODCond2ConfInfo::setRunNumber ( int id )

inline

Definition at line 33 of file ODCond2ConfInfo.h.

33 { m_run = id; }

References triggerObjects_cff::id, and m_run.

◆ setType()

void ODCond2ConfInfo::setType ( std::string x )

inline

Definition at line 24 of file ODCond2ConfInfo.h.

24 { m_type = x; }

References m_type, and x.

◆ writeDB()

void ODCond2ConfInfo::writeDB ( )

privatenoexcept

Definition at line 128 of file ODCond2ConfInfo.cc.

                                               {
   this->checkConnection();
   this->checkPrepare();
  
   DateHandler dh(m_env, m_conn);
   if (m_rec_time.isNull()) {
     int very_old_time = 0;
     m_rec_time = Tm(very_old_time);
   }
  
   try {
     m_writeStmt->setDate(3, dh.tmToDate(this->m_rec_time));
     m_writeStmt->setInt(5, this->getRunNumber());
     m_writeStmt->setString(6, this->getDescription());
  
     m_writeStmt->executeUpdate();
  
   } catch (SQLException& e) {
     throw(std::runtime_error(std::string("ODCond2ConfInfo::writeDB():  ") + e.getMessage()));
   }
   // Now get the ID
   if (!this->fetchID()) {
     throw(std::runtime_error("ODCond2ConfInfo::writeDB:  Failed to write"));
   }
 }

References cuy::dh, MillePedeFileConverter_cfg::e, DeadROCCounter::getRunNumber(), and AlCaHLTBitMon_QueryRunRegistry::string.

Friends And Related Function Documentation

◆ EcalCondDBInterface

friend class EcalCondDBInterface

friend

Definition at line 14 of file ODCond2ConfInfo.h.

Member Data Documentation

◆ m_db_time

Tm ODCond2ConfInfo::m_db_time

private

Definition at line 67 of file ODCond2ConfInfo.h.

Referenced by getDBDate(), and setDBDate().

◆ m_desc

std::string ODCond2ConfInfo::m_desc

private

Definition at line 66 of file ODCond2ConfInfo.h.

Referenced by getDescription(), and setDescription().

◆ m_ID

int ODCond2ConfInfo::m_ID

private

Definition at line 61 of file ODCond2ConfInfo.h.

Referenced by getId(), and setId().

◆ m_loc

std::string ODCond2ConfInfo::m_loc

private

Definition at line 64 of file ODCond2ConfInfo.h.

Referenced by getLocation(), and setLocation().

◆ m_loc_id

int ODCond2ConfInfo::m_loc_id

private

Definition at line 68 of file ODCond2ConfInfo.h.

◆ m_rec_time

Tm ODCond2ConfInfo::m_rec_time

private

Definition at line 63 of file ODCond2ConfInfo.h.

Referenced by getRecordDate(), and setRecordDate().

◆ m_run

int ODCond2ConfInfo::m_run

private

Definition at line 65 of file ODCond2ConfInfo.h.

Referenced by getRunNumber(), and setRunNumber().

◆ m_typ_id

int ODCond2ConfInfo::m_typ_id

private

Definition at line 69 of file ODCond2ConfInfo.h.

◆ m_type

std::string ODCond2ConfInfo::m_type

private

Definition at line 62 of file ODCond2ConfInfo.h.

Referenced by getType(), and setType().

Public Member Functions

Private Member Functions

Private Attributes

Friends

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ ODCond2ConfInfo()

◆ ~ODCond2ConfInfo()

Member Function Documentation

◆ clear()

◆ fetchData()

◆ fetchID()

◆ fetchNextId()

◆ fetchParents()

◆ getDBDate()

◆ getDescription()

◆ getId()

◆ getLocation()

◆ getRecordDate()

◆ getRunNumber()

◆ getTable()

◆ getType()

◆ prepareWrite()

◆ setDBDate()

◆ setDescription()

◆ setId()

◆ setLocation()

◆ setParameters()

◆ setRecordDate()

◆ setRunNumber()

◆ setType()

◆ writeDB()

Friends And Related Function Documentation

◆ EcalCondDBInterface

Member Data Documentation

◆ m_db_time

◆ m_desc

◆ m_ID

◆ m_loc

◆ m_loc_id

◆ m_rec_time

◆ m_run

◆ m_typ_id

◆ m_type