#include <FEConfigSpikeInfo.h>

Inheritance diagram for FEConfigSpikeInfo:

Public Member Functions
	FEConfigSpikeInfo ()

int	fetchID () throw (std::runtime_error)

int	fetchNextId () throw (std::runtime_error)

Tm	getDBTime () const

int	getId () const

int	getID ()

std::string	getTable ()

int	getVersion () const

bool	operator!= (const FEConfigSpikeInfo &r) const

bool	operator== (const FEConfigSpikeInfo &r) const

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

void	setDBTime (Tm x)

void	setId (int id)

void	setID (int id)

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

void	setVersion (int id)

	~FEConfigSpikeInfo ()

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

void	fetchLastData (FEConfigSpikeInfo *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_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 FEConfigSpikeInfo.h.

Constructor & Destructor Documentation

FEConfigSpikeInfo::FEConfigSpikeInfo ( )

Definition at line 13 of file FEConfigSpikeInfo.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();   
 }

FEConfigSpikeInfo::~FEConfigSpikeInfo ( )

Definition at line 31 of file FEConfigSpikeInfo.cc.

32 {

33 }

Member Function Documentation

void FEConfigSpikeInfo::clear ( void )

private

Definition at line 26 of file FEConfigSpikeInfo.cc.

26 {

27 }

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

private

Definition at line 125 of file FEConfigSpikeInfo.cc.

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

 {
   this->checkConnection();
   result->clear();
   if(result->getId()==0 && (result->getConfigTag()=="") ){
     throw(std::runtime_error("FEConfigSpikeInfo::fetchData(): no Id defined for this FEConfigSpikeInfo "));
   }
 
   try {
     DateHandler dh(m_env, m_conn);
 
     m_readStmt->setSQL("SELECT * FROM " + getTable() +   
                        " where ( spi_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));
     Date dbdate = rset->getDate(4);
     result->setDBTime( dh.dateToTm( dbdate ));
 
   } catch (SQLException &e) {
     throw(std::runtime_error("FEConfigSpikeInfo::fetchData():  "+e.getMessage()));
   }
 }

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

Definition at line 184 of file FEConfigSpikeInfo.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 spi_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("FEConfigSpikeInfo::fetchID:  "+e.getMessage()));
   }
 
   return m_ID;
 }

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

private

Definition at line 159 of file FEConfigSpikeInfo.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   spi_conf_id = ( select max( spi_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));
     Date dbdate = rset->getDate(4);
     result->setDBTime( dh.dateToTm( dbdate ));
 
   } catch (SQLException &e) {
     throw(std::runtime_error("FEConfigSpikeInfo::fetchData():  "+e.getMessage()));
   }
 }

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

Definition at line 37 of file FEConfigSpikeInfo.cc.

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

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

Tm FEConfigSpikeInfo::getDBTime ( ) const

inline

Definition at line 31 of file FEConfigSpikeInfo.h.

References m_db_time.

31 { return m_db_time;}

FEConfigSpikeInfo::m_db_time

Tm m_db_time

Definition: FEConfigSpikeInfo.h:49

int FEConfigSpikeInfo::getId ( ) const

inline

Definition at line 22 of file FEConfigSpikeInfo.h.

References m_ID.

Referenced by getID(), and EcalTPGDBApp::writeToConfDB_Spike().

22 { return m_ID; }

FEConfigSpikeInfo::m_ID

int m_ID

Definition: FEConfigSpikeInfo.h:48

int FEConfigSpikeInfo::getID ( )

inline

Definition at line 25 of file FEConfigSpikeInfo.h.

References getId().

25 { return getId() ;}

FEConfigSpikeInfo::getId

int getId() const

Definition: FEConfigSpikeInfo.h:22

std::string FEConfigSpikeInfo::getTable ( )

inlinevirtual

Implements IODConfig.

Definition at line 19 of file FEConfigSpikeInfo.h.

19 { return "FE_CONFIG_SPIKE_INFO"; }

int FEConfigSpikeInfo::getVersion ( ) const

inline

Definition at line 28 of file FEConfigSpikeInfo.h.

References m_version.

28 { return m_version; }

FEConfigSpikeInfo::m_version

int m_version

Definition: FEConfigSpikeInfo.h:50

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

inline

Definition at line 43 of file FEConfigSpikeInfo.h.

References alignCSCRings::r.

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

alignCSCRings.r

list r

Definition: alignCSCRings.py:92

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

inline

Definition at line 42 of file FEConfigSpikeInfo.h.

References m_ID.

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

FEConfigSpikeInfo::m_ID

int m_ID

Definition: FEConfigSpikeInfo.h:48

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

privatevirtual

Implements IODConfig.

Definition at line 59 of file FEConfigSpikeInfo.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()+" ( spi_conf_id, tag, version ) " 
             " VALUES ( :1, :2, :3 ) " );
 
     m_writeStmt->setInt(1, next_id);
     m_ID=next_id;
 
   } catch (SQLException &e) {
     throw(std::runtime_error("FEConfigSpikeInfo::prepareWrite():  "+e.getMessage()));
   }
 
 }

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

Definition at line 218 of file FEConfigSpikeInfo.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 "+ getTable()+" WHERE spi_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));
        Date dbdate = rset->getDate(4);
        this->setDBTime( dh.dateToTm( dbdate ));
      } else {
        throw(std::runtime_error("FEConfigSpikeInfo::setByID: Given spi_conf_id is not in the database"));
      }
      
      m_conn->terminateStatement(stmt);
    } catch (SQLException &e) {
      throw(std::runtime_error("FEConfigSpikeInfo::setByID:  "+e.getMessage()));
    }
 }

void FEConfigSpikeInfo::setDBTime ( Tm x )

inline

Definition at line 32 of file FEConfigSpikeInfo.h.

References m_db_time, and vdt::x.

32 { m_db_time=x; }

FEConfigSpikeInfo::m_db_time

Tm m_db_time

Definition: FEConfigSpikeInfo.h:49

vdt::x

x

Definition: VDTMath.h:216

void FEConfigSpikeInfo::setId ( int id )

inline

Definition at line 21 of file FEConfigSpikeInfo.h.

References errorMatrix2Lands_multiChannel::id, and m_ID.

Referenced by popcon::EcalTPGSpikeThresholdHandler::getNewObjects(), and setID().

21 { m_ID = id; }

FEConfigSpikeInfo::m_ID

int m_ID

Definition: FEConfigSpikeInfo.h:48

errorMatrix2Lands_multiChannel.id

tuple id

Definition: errorMatrix2Lands_multiChannel.py:151

void FEConfigSpikeInfo::setID ( int id )

inline

Definition at line 24 of file FEConfigSpikeInfo.h.

References setId().

24 {setId(id);}

FEConfigSpikeInfo::setId

void setId(int id)

Definition: FEConfigSpikeInfo.h:21

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

Definition at line 83 of file FEConfigSpikeInfo.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);
     
   }
   
 }

void FEConfigSpikeInfo::setVersion ( int id )

inline

Definition at line 27 of file FEConfigSpikeInfo.h.

References errorMatrix2Lands_multiChannel::id, and m_version.

27 { m_version = id; }

FEConfigSpikeInfo::m_version

int m_version

Definition: FEConfigSpikeInfo.h:50

errorMatrix2Lands_multiChannel.id

tuple id

Definition: errorMatrix2Lands_multiChannel.py:151

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

private

Definition at line 98 of file FEConfigSpikeInfo.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->executeUpdate();
 
 
   } catch (SQLException &e) {
     throw(std::runtime_error("FEConfigSpikeInfo::writeDB():  "+e.getMessage()));
   }
   // Now get the ID
   if (!this->fetchID()) {
     throw(std::runtime_error("FEConfigSpikeInfo::writeDB:  Failed to write"));
   }
 
 
 }