#include <FEConfigLinInfo.h>

Inheritance diagram for FEConfigLinInfo:

Public Member Functions
	FEConfigLinInfo ()

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 FEConfigLinInfo &r) const

bool	operator== (const FEConfigLinInfo &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)

	~FEConfigLinInfo ()

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

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

Constructor & Destructor Documentation

FEConfigLinInfo::FEConfigLinInfo ( )

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

FEConfigLinInfo::~FEConfigLinInfo ( )

Definition at line 32 of file FEConfigLinInfo.cc.

33 {

34 }

Member Function Documentation

void FEConfigLinInfo::clear ( void )

private

Definition at line 26 of file FEConfigLinInfo.cc.

                            {
    m_iov_id=0;
 }

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

private

Definition at line 128 of file FEConfigLinInfo.cc.

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

 {
   this->checkConnection();
   result->clear();
   if(result->getId()==0 && (result->getConfigTag()=="") ){
     throw(std::runtime_error("FEConfigLinInfo::fetchData(): no Id defined for this FEConfigLinInfo "));
   }
 
   try {
     DateHandler dh(m_env, m_conn);
 
     m_readStmt->setSQL("SELECT * FROM " + getTable() +   
                        " where ( lin_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("FEConfigLinInfo::fetchData():  "+e.getMessage()));
   }
 }

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

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

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

private

Definition at line 163 of file FEConfigLinInfo.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   lin_conf_id = ( select max( lin_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("FEConfigLinInfo::fetchData():  "+e.getMessage()));
   }
 }

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

Definition at line 38 of file FEConfigLinInfo.cc.

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

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

Tm FEConfigLinInfo::getDBTime ( ) const

inline

Definition at line 35 of file FEConfigLinInfo.h.

References m_db_time.

35 { return m_db_time;}

FEConfigLinInfo::m_db_time

Tm m_db_time

Definition: FEConfigLinInfo.h:53

int FEConfigLinInfo::getId ( ) const

inline

Definition at line 26 of file FEConfigLinInfo.h.

References m_ID.

Referenced by getID().

26 { return m_ID; }

FEConfigLinInfo::m_ID

int m_ID

Definition: FEConfigLinInfo.h:52

int FEConfigLinInfo::getID ( )

inline

Definition at line 29 of file FEConfigLinInfo.h.

References getId().

Referenced by EcalTPGDBApp::writeToConfDB_TPGLinearCoef().

29 { return getId() ;}

FEConfigLinInfo::getId

int getId() const

Definition: FEConfigLinInfo.h:26

int FEConfigLinInfo::getIOVId ( ) const

inline

Definition at line 23 of file FEConfigLinInfo.h.

References m_iov_id.

23 {return m_iov_id; }

FEConfigLinInfo::m_iov_id

int m_iov_id

Definition: FEConfigLinInfo.h:51

std::string FEConfigLinInfo::getTable ( )

inlinevirtual

Implements IODConfig.

Definition at line 19 of file FEConfigLinInfo.h.

19 { return "FE_CONFIG_LIN_INFO"; }

int FEConfigLinInfo::getVersion ( ) const

inline

Definition at line 32 of file FEConfigLinInfo.h.

References m_version.

32 { return m_version; }

FEConfigLinInfo::m_version

int m_version

Definition: FEConfigLinInfo.h:54

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

inline

Definition at line 47 of file FEConfigLinInfo.h.

References alignCSCRings::r.

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

alignCSCRings.r

list r

Definition: alignCSCRings.py:92

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

inline

Definition at line 46 of file FEConfigLinInfo.h.

References m_ID.

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

FEConfigLinInfo::m_ID

int m_ID

Definition: FEConfigLinInfo.h:52

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

privatevirtual

Implements IODConfig.

Definition at line 60 of file FEConfigLinInfo.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()+" ( lin_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("FEConfigLinInfo::prepareWrite():  "+e.getMessage()));
   }
 
 }

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

Definition at line 223 of file FEConfigLinInfo.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_lin_info WHERE lin_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("FEConfigLinInfo::setByID:  Given config_id is not in the database"));
      }
      
      m_conn->terminateStatement(stmt);
    } catch (SQLException &e) {
      throw(std::runtime_error("FEConfigLinInfo::setByID:  "+e.getMessage()));
    }
 }

void FEConfigLinInfo::setDBTime ( Tm x )

inline

Definition at line 36 of file FEConfigLinInfo.h.

References m_db_time, and vdt::x.

36 { m_db_time=x; }

FEConfigLinInfo::m_db_time

Tm m_db_time

Definition: FEConfigLinInfo.h:53

vdt::x

x

Definition: VDTMath.h:216

void FEConfigLinInfo::setId ( int id )

inline

Definition at line 25 of file FEConfigLinInfo.h.

References errorMatrix2Lands_multiChannel::id, and m_ID.

Referenced by popcon::EcalTPGLinConstHandler::getNewObjects(), popcon::EcalTPGPhysicsConstHandler::getNewObjects(), and setID().

25 { m_ID = id; }

FEConfigLinInfo::m_ID

int m_ID

Definition: FEConfigLinInfo.h:52

errorMatrix2Lands_multiChannel.id

tuple id

Definition: errorMatrix2Lands_multiChannel.py:151

void FEConfigLinInfo::setID ( int id )

inline

Definition at line 28 of file FEConfigLinInfo.h.

References setId().

28 {setId(id);}

FEConfigLinInfo::setId

void setId(int id)

Definition: FEConfigLinInfo.h:25

void FEConfigLinInfo::setIOVId ( int iov_id )

inline

Definition at line 22 of file FEConfigLinInfo.h.

References m_iov_id.

Referenced by EcalTPGDBApp::writeToConfDB_TPGLinearCoef().

22 { m_iov_id = iov_id; }

FEConfigLinInfo::m_iov_id

int m_iov_id

Definition: FEConfigLinInfo.h:51

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

Definition at line 84 of file FEConfigLinInfo.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 FEConfigLinInfo::setVersion ( int id )

inline

Definition at line 31 of file FEConfigLinInfo.h.

References errorMatrix2Lands_multiChannel::id, and m_version.

31 { m_version = id; }

FEConfigLinInfo::m_version

int m_version

Definition: FEConfigLinInfo.h:54

errorMatrix2Lands_multiChannel.id

tuple id

Definition: errorMatrix2Lands_multiChannel.py:151

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

private

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