|
|
|
#include <FEConfigTimingInfo.h>
Public Member Functions | |
| FEConfigTimingInfo () | |
| 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 FEConfigTimingInfo &r) const |
| bool | operator== (const FEConfigTimingInfo &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) |
| ~FEConfigTimingInfo () | |
Private Member Functions | |
| void | clear () |
| void | fetchData (FEConfigTimingInfo *result) throw (std::runtime_error) |
| void | fetchLastData (FEConfigTimingInfo *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 |
Definition at line 11 of file FEConfigTimingInfo.h.
| FEConfigTimingInfo::FEConfigTimingInfo | ( | ) |
Definition at line 13 of file FEConfigTimingInfo.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();
}
| FEConfigTimingInfo::~FEConfigTimingInfo | ( | ) |
Definition at line 31 of file FEConfigTimingInfo.cc.
{
}
| void FEConfigTimingInfo::clear | ( | void | ) | [private] |
Definition at line 26 of file FEConfigTimingInfo.cc.
{
}
| void FEConfigTimingInfo::fetchData | ( | FEConfigTimingInfo * | result | ) | throw (std::runtime_error) [private] |
Definition at line 125 of file FEConfigTimingInfo.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("FEConfigTimingInfo::fetchData(): no Id defined for this FEConfigTimingInfo "));
}
try {
DateHandler dh(m_env, m_conn);
m_readStmt->setSQL("SELECT * FROM " + getTable() +
" where ( tim_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("FEConfigTimingInfo::fetchData(): "+e.getMessage()));
}
}
| int FEConfigTimingInfo::fetchID | ( | ) | throw (std::runtime_error) |
Definition at line 184 of file FEConfigTimingInfo.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 tim_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("FEConfigTimingInfo::fetchID: "+e.getMessage()));
}
return m_ID;
}
| void FEConfigTimingInfo::fetchLastData | ( | FEConfigTimingInfo * | result | ) | throw (std::runtime_error) [private] |
Definition at line 159 of file FEConfigTimingInfo.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 tim_conf_id = ( select max( tim_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("FEConfigTimingInfo::fetchData(): "+e.getMessage()));
}
}
| int FEConfigTimingInfo::fetchNextId | ( | ) | throw (std::runtime_error) |
Definition at line 37 of file FEConfigTimingInfo.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_TIM_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("FEConfigTimingInfo::fetchNextId(): "+e.getMessage()));
}
}
| Tm FEConfigTimingInfo::getDBTime | ( | ) | const [inline] |
| int FEConfigTimingInfo::getID | ( | ) | [inline] |
| int FEConfigTimingInfo::getId | ( | ) | const [inline] |
Definition at line 23 of file FEConfigTimingInfo.h.
References m_ID.
Referenced by getID().
{ return m_ID; }
| std::string FEConfigTimingInfo::getTable | ( | ) | [inline, virtual] |
Implements IODConfig.
Definition at line 19 of file FEConfigTimingInfo.h.
{ return "FE_CONFIG_TIME_INFO"; }
| int FEConfigTimingInfo::getVersion | ( | ) | const [inline] |
| bool FEConfigTimingInfo::operator!= | ( | const FEConfigTimingInfo & | r | ) | const [inline] |
Definition at line 44 of file FEConfigTimingInfo.h.
References csvReporter::r.
{ return !(*this == r); }
| bool FEConfigTimingInfo::operator== | ( | const FEConfigTimingInfo & | r | ) | const [inline] |
| void FEConfigTimingInfo::prepareWrite | ( | ) | throw (std::runtime_error) [private, virtual] |
Implements IODConfig.
Definition at line 59 of file FEConfigTimingInfo.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()+" ( tim_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("FEConfigTimingInfo::prepareWrite(): "+e.getMessage()));
}
}
| void FEConfigTimingInfo::setByID | ( | int | id | ) | throw (std::runtime_error) |
Definition at line 218 of file FEConfigTimingInfo.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 "+ getTable()+" WHERE tim_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("FEConfigTimingInfo::setByID: Given tim_conf_id is not in the database"));
}
m_conn->terminateStatement(stmt);
} catch (SQLException &e) {
throw(std::runtime_error("FEConfigTimingInfo::setByID: "+e.getMessage()));
}
}
| void FEConfigTimingInfo::setDBTime | ( | Tm | x | ) | [inline] |
Definition at line 33 of file FEConfigTimingInfo.h.
References m_db_time, and ExpressReco_HICollisions_FallBack::x.
| void FEConfigTimingInfo::setID | ( | int | id | ) | [inline] |
| void FEConfigTimingInfo::setId | ( | int | id | ) | [inline] |
Definition at line 22 of file FEConfigTimingInfo.h.
References ExpressReco_HICollisions_FallBack::id, and m_ID.
Referenced by setID().
| void FEConfigTimingInfo::setParameters | ( | std::map< std::string, std::string > | my_keys_map | ) |
| void FEConfigTimingInfo::setVersion | ( | int | id | ) | [inline] |
Definition at line 28 of file FEConfigTimingInfo.h.
References ExpressReco_HICollisions_FallBack::id, and m_version.
| void FEConfigTimingInfo::writeDB | ( | ) | throw (std::runtime_error) [private] |
Definition at line 98 of file FEConfigTimingInfo.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->executeUpdate();
} catch (SQLException &e) {
throw(std::runtime_error("FEConfigTimingInfo::writeDB(): "+e.getMessage()));
}
// Now get the ID
if (!this->fetchID()) {
throw(std::runtime_error("FEConfigTimingInfo::writeDB: Failed to write"));
}
}
friend class EcalCondDBInterface [friend] |
Reimplemented from IDBObject.
Definition at line 13 of file FEConfigTimingInfo.h.
Tm FEConfigTimingInfo::m_db_time [private] |
Definition at line 49 of file FEConfigTimingInfo.h.
Referenced by getDBTime(), and setDBTime().
int FEConfigTimingInfo::m_ID [private] |
Definition at line 48 of file FEConfigTimingInfo.h.
Referenced by getId(), operator==(), and setId().
int FEConfigTimingInfo::m_version [private] |
Definition at line 50 of file FEConfigTimingInfo.h.
Referenced by getVersion(), and setVersion().
1.7.3