#include <FEConfigPedInfo.h>

Inheritance diagram for FEConfigPedInfo:

Public Member Functions
	FEConfigPedInfo ()

int	fetchID () throw (std::runtime_error)

int	fetchNextId () throw (std::runtime_error)

Tm	getDBTime () const

int	getId () const

int	getID ()

int	getIOVId () const

std::string	getTable ()

int	getVersion () const

bool	operator!= (const FEConfigPedInfo &r) const

bool	operator== (const FEConfigPedInfo &r) const

void	setByID (int id) throw (std::runtime_error)

void	setDBTime (Tm x)

void	setId (int id)

void	setID (int id)

void	setIOVId (int iov_id)

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

void	setVersion (int id)

	~FEConfigPedInfo ()

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 (FEConfigPedInfo *result) throw (std::runtime_error)

void	fetchLastData (FEConfigPedInfo *result) throw (std::runtime_error)

void	prepareWrite () throw (std::runtime_error)

void	writeDB () throw (std::runtime_error)

Private Attributes
Tm	m_db_time

int	m_ID

int	m_iov_id

int	m_version

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 () throw (std::runtime_error)

void	createReadStatement () throw (std::runtime_error)

void	populateClob (Clob &clob, std::string fname, unsigned int bufsize) throw (std::runtime_error)

unsigned char *	readClob (Clob &clob, int size) throw (std::runtime_error)

void	setPrefetchRowCount (int ncount) throw (std::runtime_error)

void	terminateReadStatement () throw (std::runtime_error)

void	terminateWriteStatement () throw (std::runtime_error)

Protected Member Functions inherited from IDBObject
void	checkConnection () const throw (std::runtime_error)

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 11 of file FEConfigPedInfo.h.

Constructor & Destructor Documentation

FEConfigPedInfo::FEConfigPedInfo ( )

Definition at line 13 of file FEConfigPedInfo.cc.

References hitfit::clear(), and NULL.

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

FEConfigPedInfo::~FEConfigPedInfo ( )

Definition at line 32 of file FEConfigPedInfo.cc.

33 {

34 }

Member Function Documentation

void FEConfigPedInfo::clear ( void )

private

Definition at line 26 of file FEConfigPedInfo.cc.

                            {
    m_iov_id=0;
 }

void FEConfigPedInfo::fetchData	(	FEConfigPedInfo *	result	)
throw	(	std::runtime_error
	)

private

Definition at line 128 of file FEConfigPedInfo.cc.

References DateHandler::dateToTm(), alignCSCRings::e, and query::result.

 {
   this->checkConnection();
   result->clear();
   if(result->getId()==0 && (result->getConfigTag()=="") ){
     throw(std::runtime_error("FEConfigPedInfo::fetchData(): no Id defined for this FEConfigPedInfo "));
   }
 
   try {
     DateHandler dh(m_env, m_conn);
 
     m_readStmt->setSQL("SELECT * FROM " + getTable() +   
                        " where ( ped_conf_id= :1 or (tag=:2 AND version=:3 ) )" );
     m_readStmt->setInt(1, result->getId());
     m_readStmt->setString(2, result->getConfigTag());
     m_readStmt->setInt(3, result->getVersion());
     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->setConfigTag(rset->getString(2));
     result->setVersion(rset->getInt(3));
     result->setIOVId(rset->getInt(4));
     Date dbdate = rset->getDate(5);
     result->setDBTime( dh.dateToTm( dbdate ));
 
   } catch (SQLException &e) {
     throw(std::runtime_error("FEConfigPedInfo::fetchData():  "+e.getMessage()));
   }
 }

int FEConfigPedInfo::fetchID	(		)
throw	(	std::runtime_error
	)

Definition at line 189 of file FEConfigPedInfo.cc.

References alignCSCRings::e.

 {
   // Return from memory if available
   if (m_ID!=0) {
     return m_ID;
   }
 
   this->checkConnection();
 
   try {
     Statement* stmt = m_conn->createStatement();
     stmt->setSQL("SELECT ped_conf_id FROM "+ getTable()+
                  " WHERE  tag=:1 and version=:2 " );
 
     stmt->setString(1, getConfigTag() );
     stmt->setInt(2, getVersion() );
 
     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("FEConfigPedInfo::fetchID:  "+e.getMessage()));
   }
 
   return m_ID;
 }

void FEConfigPedInfo::fetchLastData	(	FEConfigPedInfo *	result	)
throw	(	std::runtime_error
	)

private

Definition at line 163 of file FEConfigPedInfo.cc.

References DateHandler::dateToTm(), alignCSCRings::e, and query::result.

 {
   this->checkConnection();
   result->clear();
   try {
     DateHandler dh(m_env, m_conn);
 
     m_readStmt->setSQL("SELECT * FROM " + getTable() +   
                        " where   ped_conf_id = ( select max( ped_conf_id) from "+ getTable() +" ) " );
     ResultSet* rset = m_readStmt->executeQuery();
 
     rset->next();
 
     result->setId(rset->getInt(1));
     result->setConfigTag(rset->getString(2));
     result->setVersion(rset->getInt(3));
     result->setIOVId(rset->getInt(4));
     Date dbdate = rset->getDate(5);
     result->setDBTime( dh.dateToTm( dbdate ));
 
   } catch (SQLException &e) {
     throw(std::runtime_error("FEConfigPedInfo::fetchData():  "+e.getMessage()));
   }
 }

int FEConfigPedInfo::fetchNextId	(		)
throw	(	std::runtime_error
	)

Definition at line 38 of file FEConfigPedInfo.cc.

References alignCSCRings::e, and query::result.

                                                           {
 
   int result=0;
   try {
     this->checkConnection();
 
     m_readStmt = m_conn->createStatement(); 
     m_readStmt->setSQL("select FE_CONFIG_PED_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("FEConfigPedInfo::fetchNextId():  "+e.getMessage()));
   }
 
 }

Tm FEConfigPedInfo::getDBTime ( ) const

inline

Definition at line 35 of file FEConfigPedInfo.h.

References m_db_time.

35 { return m_db_time;}

FEConfigPedInfo::m_db_time

Tm m_db_time

Definition: FEConfigPedInfo.h:53

int FEConfigPedInfo::getId ( ) const

inline

Definition at line 26 of file FEConfigPedInfo.h.

References m_ID.

Referenced by getID().

26 { return m_ID; }

FEConfigPedInfo::m_ID

int m_ID

Definition: FEConfigPedInfo.h:52

int FEConfigPedInfo::getID ( )

inline

Definition at line 29 of file FEConfigPedInfo.h.

References getId().

Referenced by EcalTPGDBApp::writeToConfDB_TPGPedestals().

29 { return getId() ;}

FEConfigPedInfo::getId

int getId() const

Definition: FEConfigPedInfo.h:26

int FEConfigPedInfo::getIOVId ( ) const

inline

Definition at line 23 of file FEConfigPedInfo.h.

References m_iov_id.

23 {return m_iov_id; }

FEConfigPedInfo::m_iov_id

int m_iov_id

Definition: FEConfigPedInfo.h:51

std::string FEConfigPedInfo::getTable ( )

inlinevirtual

Implements IODConfig.

Definition at line 19 of file FEConfigPedInfo.h.

19 { return "FE_CONFIG_PED_INFO"; }

int FEConfigPedInfo::getVersion ( ) const

inline

Definition at line 32 of file FEConfigPedInfo.h.

References m_version.

32 { return m_version; }

FEConfigPedInfo::m_version

int m_version

Definition: FEConfigPedInfo.h:54

bool FEConfigPedInfo::operator!= ( const FEConfigPedInfo & r ) const

inline

Definition at line 47 of file FEConfigPedInfo.h.

References alignCSCRings::r.

47 { return !(*this == r); }

alignCSCRings.r

list r

Definition: alignCSCRings.py:92

bool FEConfigPedInfo::operator== ( const FEConfigPedInfo & r ) const

inline

Definition at line 46 of file FEConfigPedInfo.h.

References m_ID.

46 { return (m_ID == r.m_ID ); }

FEConfigPedInfo::m_ID

int m_ID

Definition: FEConfigPedInfo.h:52

void FEConfigPedInfo::prepareWrite	(		)
throw	(	std::runtime_error
	)

privatevirtual

Implements IODConfig.

Definition at line 60 of file FEConfigPedInfo.cc.

References alignCSCRings::e, and getId().

 {
   this->checkConnection();
 
   int next_id=0;
   if(getId()==0){
     next_id=fetchNextId();
   }
 
   try {
     m_writeStmt = m_conn->createStatement();
     m_writeStmt->setSQL("INSERT INTO "+getTable()+" ( ped_conf_id, tag, version, iov_id) " 
             " VALUES ( :1, :2, :3 , :4) " );
 
     m_writeStmt->setInt(1, next_id);
     m_ID=next_id;
 
   } catch (SQLException &e) {
     throw(std::runtime_error("FEConfigPedInfo::prepareWrite():  "+e.getMessage()));
   }
 
 }

void FEConfigPedInfo::setByID	(	int	id	)
throw	(	std::runtime_error
	)

Definition at line 223 of file FEConfigPedInfo.cc.

References DateHandler::dateToTm(), and alignCSCRings::e.

 {
    this->checkConnection();
 
    DateHandler dh(m_env, m_conn);
 
    try {
      Statement* stmt = m_conn->createStatement();
 
      stmt->setSQL("SELECT * FROM fe_config_ped_info WHERE ped_conf_id = :1");
      stmt->setInt(1, id);
      
      ResultSet* rset = stmt->executeQuery();
      if (rset->next()) {
        this->setId(rset->getInt(1));
        this->setConfigTag(rset->getString(2));
        this->setVersion(rset->getInt(3));
        this->setIOVId(rset->getInt(4));
        Date dbdate = rset->getDate(5);
        this->setDBTime( dh.dateToTm( dbdate ));
      } else {
        throw(std::runtime_error("FEConfigPedInfo::setByID:  Given config_id is not in the database"));
      }
      
      m_conn->terminateStatement(stmt);
    } catch (SQLException &e) {
      throw(std::runtime_error("FEConfigPedInfo::setByID:  "+e.getMessage()));
    }
 }

void FEConfigPedInfo::setDBTime ( Tm x )

inline

Definition at line 36 of file FEConfigPedInfo.h.

References m_db_time, and vdt::x.

36 { m_db_time=x; }

vdt::x

x

Definition: VDTMath.h:216

FEConfigPedInfo::m_db_time

Tm m_db_time

Definition: FEConfigPedInfo.h:53

void FEConfigPedInfo::setId ( int id )

inline

Definition at line 25 of file FEConfigPedInfo.h.

References errorMatrix2Lands_multiChannel::id, and m_ID.

Referenced by EcalTPGParamBuilder::analyze(), popcon::EcalTPGPedestalsHandler::getNewObjects(), EcalTPGDBApp::readFromConfDB_TPGPedestals(), and setID().

25 { m_ID = id; }

FEConfigPedInfo::m_ID

int m_ID

Definition: FEConfigPedInfo.h:52

errorMatrix2Lands_multiChannel.id

tuple id

Definition: errorMatrix2Lands_multiChannel.py:151

void FEConfigPedInfo::setID ( int id )

inline

Definition at line 28 of file FEConfigPedInfo.h.

References setId().

28 {setId(id);}

FEConfigPedInfo::setId

void setId(int id)

Definition: FEConfigPedInfo.h:25

void FEConfigPedInfo::setIOVId ( int iov_id )

inline

Definition at line 22 of file FEConfigPedInfo.h.

References m_iov_id.

Referenced by EcalTPGDBApp::writeToConfDB_TPGPedestals().

22 { m_iov_id = iov_id; }

FEConfigPedInfo::m_iov_id

int m_iov_id

Definition: FEConfigPedInfo.h:51

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

Definition at line 84 of file FEConfigPedInfo.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 >::iterator ci=
      my_keys_map.begin(); ci!=my_keys_map.end(); ci++ ) {
     
     if(ci->first==  "VERSION") setVersion(atoi(ci->second.c_str()) );
     if(ci->first==  "TAG") setConfigTag(ci->second);
     if(ci->first==  "IOV_ID") setIOVId(atoi(ci->second.c_str()) );
     
   }
   
 }

void FEConfigPedInfo::setVersion ( int id )

inline

Definition at line 31 of file FEConfigPedInfo.h.

References errorMatrix2Lands_multiChannel::id, and m_version.

31 { m_version = id; }

errorMatrix2Lands_multiChannel.id

tuple id

Definition: errorMatrix2Lands_multiChannel.py:151

FEConfigPedInfo::m_version

int m_version

Definition: FEConfigPedInfo.h:54

void FEConfigPedInfo::writeDB	(		)
throw	(	std::runtime_error
	)

private

Definition at line 100 of file FEConfigPedInfo.cc.

References alignCSCRings::e.

 {
   this->checkConnection();
   this->checkPrepare();
 
   try {
 
     // number 1 is the id 
     m_writeStmt->setString(2, this->getConfigTag());
     m_writeStmt->setInt(3, this->getVersion());
     m_writeStmt->setInt(4, this->getIOVId());
 
     m_writeStmt->executeUpdate();
 
 
   } catch (SQLException &e) {
     throw(std::runtime_error("FEConfigPedInfo::writeDB():  "+e.getMessage()));
   }
   // Now get the ID
   if (!this->fetchID()) {
     throw(std::runtime_error("FEConfigPedInfo::writeDB:  Failed to write"));
   }
 
 
 }