|
|
|
#include <FEConfigPedInfo.h>
Public Member Functions | |
| FEConfigPedInfo () | |
| int | fetchID () throw (std::runtime_error) |
| int | fetchNextId () throw (std::runtime_error) |
| Tm | getDBTime () const |
| int | getID () |
| int | getId () const |
| 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 () | |
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 |
Definition at line 11 of file FEConfigPedInfo.h.
| FEConfigPedInfo::FEConfigPedInfo | ( | ) |
Definition at line 13 of file FEConfigPedInfo.cc.
References 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.
{
}
| 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(), ExpressReco_HICollisions_FallBack::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 ExpressReco_HICollisions_FallBack::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(), ExpressReco_HICollisions_FallBack::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 ExpressReco_HICollisions_FallBack::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] |
| int FEConfigPedInfo::getId | ( | ) | const [inline] |
Definition at line 26 of file FEConfigPedInfo.h.
References m_ID.
Referenced by getID().
{ return m_ID; }
| int FEConfigPedInfo::getID | ( | ) | [inline] |
Definition at line 29 of file FEConfigPedInfo.h.
References getId().
Referenced by EcalTPGDBApp::writeToConfDB_TPGPedestals().
{ return getId() ;}
| int FEConfigPedInfo::getIOVId | ( | ) | const [inline] |
| std::string FEConfigPedInfo::getTable | ( | ) | [inline, virtual] |
Implements IODConfig.
Definition at line 19 of file FEConfigPedInfo.h.
{ return "FE_CONFIG_PED_INFO"; }
| int FEConfigPedInfo::getVersion | ( | ) | const [inline] |
| bool FEConfigPedInfo::operator!= | ( | const FEConfigPedInfo & | r | ) | const [inline] |
Definition at line 47 of file FEConfigPedInfo.h.
References csvReporter::r.
{ return !(*this == r); }
| bool FEConfigPedInfo::operator== | ( | const FEConfigPedInfo & | r | ) | const [inline] |
| void FEConfigPedInfo::prepareWrite | ( | ) | throw (std::runtime_error) [private, virtual] |
Implements IODConfig.
Definition at line 60 of file FEConfigPedInfo.cc.
References ExpressReco_HICollisions_FallBack::e, and CastorDbASCIIIO::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 ExpressReco_HICollisions_FallBack::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 ExpressReco_HICollisions_FallBack::x.
| void FEConfigPedInfo::setId | ( | int | id | ) | [inline] |
Definition at line 25 of file FEConfigPedInfo.h.
References ExpressReco_HICollisions_FallBack::id, and m_ID.
Referenced by popcon::EcalTPGPedestalsHandler::getNewObjects(), EcalTPGDBApp::readFromConfDB_TPGPedestals(), and setID().
| void FEConfigPedInfo::setID | ( | int | id | ) | [inline] |
| void FEConfigPedInfo::setIOVId | ( | int | iov_id | ) | [inline] |
Definition at line 22 of file FEConfigPedInfo.h.
References m_iov_id.
Referenced by EcalTPGDBApp::writeToConfDB_TPGPedestals().
{ m_iov_id = iov_id; }
| void FEConfigPedInfo::setParameters | ( | std::map< std::string, std::string > | my_keys_map | ) |
| void FEConfigPedInfo::setVersion | ( | int | id | ) | [inline] |
Definition at line 31 of file FEConfigPedInfo.h.
References ExpressReco_HICollisions_FallBack::id, and m_version.
| void FEConfigPedInfo::writeDB | ( | ) | throw (std::runtime_error) [private] |
Definition at line 100 of file FEConfigPedInfo.cc.
References ExpressReco_HICollisions_FallBack::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"));
}
}
friend class EcalCondDBInterface [friend] |
Reimplemented from IDBObject.
Definition at line 13 of file FEConfigPedInfo.h.
Tm FEConfigPedInfo::m_db_time [private] |
Definition at line 53 of file FEConfigPedInfo.h.
Referenced by getDBTime(), and setDBTime().
int FEConfigPedInfo::m_ID [private] |
Definition at line 52 of file FEConfigPedInfo.h.
Referenced by getId(), operator==(), and setId().
int FEConfigPedInfo::m_iov_id [private] |
Definition at line 51 of file FEConfigPedInfo.h.
Referenced by getIOVId(), and setIOVId().
int FEConfigPedInfo::m_version [private] |
Definition at line 54 of file FEConfigPedInfo.h.
Referenced by getVersion(), and setVersion().
1.7.3