|
|
|
#include <ODSRPCycle.h>
Public Member Functions | |
| int | getId () const |
| int | getSRPConfigurationID () const |
| std::string | getTable () |
| ODSRPCycle () | |
| bool | operator!= (const ODSRPCycle &m) const |
| bool | operator== (const ODSRPCycle &m) const |
| void | setId (int id) |
| void | setSRPConfigurationID (int x) |
| ~ODSRPCycle () | |
Private Member Functions | |
| void | clear () |
| void | fetchData (ODSRPCycle *result) throw (std::runtime_error) |
| int | fetchID () throw (std::runtime_error) |
| void | insertConfig () throw (std::runtime_error) |
| void | prepareWrite () throw (std::runtime_error) |
| void | setByID (int id) throw (std::runtime_error) |
| void | writeDB () throw (std::runtime_error) |
Private Attributes | |
| int | m_ID |
| int | m_srp_config_id |
Friends | |
| class | EcalCondDBInterface |
| class | ODEcalCycle |
Definition at line 11 of file ODSRPCycle.h.
| ODSRPCycle::ODSRPCycle | ( | ) |
Definition at line 9 of file ODSRPCycle.cc.
References NULL.
{
m_env = NULL;
m_conn = NULL;
m_writeStmt = NULL;
m_readStmt = NULL;
//
m_ID = 0;
m_srp_config_id = 0;
}
| ODSRPCycle::~ODSRPCycle | ( | ) |
Definition at line 21 of file ODSRPCycle.cc.
{
}
| void ODSRPCycle::clear | ( | void | ) | [private] |
Definition at line 66 of file ODSRPCycle.cc.
{
m_srp_config_id=0;
}
| void ODSRPCycle::fetchData | ( | ODSRPCycle * | result | ) | throw (std::runtime_error) [private] |
Definition at line 131 of file ODSRPCycle.cc.
References alignCSCRings::e, and query::result.
{
this->checkConnection();
result->clear();
if(result->getId()==0){
throw(std::runtime_error("ODSRPConfig::fetchData(): no Id defined for this ODSRPConfig "));
}
try {
m_readStmt->setSQL("SELECT srp_configuration_id FROM ecal_srp_cycle "
"WHERE cycle_id = :1 ");
m_readStmt->setInt(1, result->getId());
ResultSet* rset = m_readStmt->executeQuery();
rset->next();
result->setSRPConfigurationID( rset->getInt(1) );
} catch (SQLException &e) {
throw(std::runtime_error("ODSRPCycle::fetchData(): "+e.getMessage()));
}
}
| int ODSRPCycle::fetchID | ( | ) | throw (std::runtime_error) [private] |
Definition at line 71 of file ODSRPCycle.cc.
References alignCSCRings::e.
{
// Return from memory if available
if (m_ID) {
return m_ID;
}
this->checkConnection();
try {
Statement* stmt = m_conn->createStatement();
stmt->setSQL("SELECT cycle_id, srp_configuration_id FROM ecal_srp_cycle "
"WHERE cycle_id = :1 ");
stmt->setInt(1, m_ID);
ResultSet* rset = stmt->executeQuery();
if (rset->next()) {
m_ID = rset->getInt(1);
m_srp_config_id = rset->getInt(2);
} else {
m_ID = 0;
}
m_conn->terminateStatement(stmt);
} catch (SQLException &e) {
throw(std::runtime_error("ODSRPCycle::fetchID: "+e.getMessage()));
}
return m_ID;
}
| int ODSRPCycle::getId | ( | ) | const [inline] |
| int ODSRPCycle::getSRPConfigurationID | ( | ) | const [inline] |
| std::string ODSRPCycle::getTable | ( | ) | [inline, virtual] |
| void ODSRPCycle::insertConfig | ( | ) | throw (std::runtime_error) [private] |
Definition at line 158 of file ODSRPCycle.cc.
References alignCSCRings::e.
Referenced by ODEcalCycle::writeDB().
{
try {
prepareWrite();
writeDB();
m_conn->commit();
terminateWriteStatement();
} catch (std::runtime_error &e) {
m_conn->rollback();
throw(e);
} catch (...) {
m_conn->rollback();
throw(std::runtime_error("EcalCondDBInterface::insertDataSet: Unknown exception caught"));
}
}
| bool ODSRPCycle::operator!= | ( | const ODSRPCycle & | m | ) | const [inline] |
| bool ODSRPCycle::operator== | ( | const ODSRPCycle & | m | ) | const [inline] |
| void ODSRPCycle::prepareWrite | ( | ) | throw (std::runtime_error) [private, virtual] |
Implements IODConfig.
Definition at line 26 of file ODSRPCycle.cc.
References alignCSCRings::e.
{
this->checkConnection();
try {
m_writeStmt = m_conn->createStatement();
m_writeStmt->setSQL("INSERT INTO ECAL_SRP_Cycle (cycle_id, srp_configuration_id ) "
"VALUES (:1, :2 )");
} catch (SQLException &e) {
throw(std::runtime_error("ODSRPCycle::prepareWrite(): "+e.getMessage()));
}
}
| void ODSRPCycle::setByID | ( | int | id | ) | throw (std::runtime_error) [private] |
Definition at line 104 of file ODSRPCycle.cc.
References alignCSCRings::e.
{
this->checkConnection();
try {
Statement* stmt = m_conn->createStatement();
stmt->setSQL("SELECT cycle_id, srp_configuration_id FROM ecal_srp_cycle "
"WHERE cycle_id = :1 ");
stmt->setInt(1, id);
ResultSet* rset = stmt->executeQuery();
if (rset->next()) {
m_ID = rset->getInt(1);
m_srp_config_id = rset->getInt(2);
} else {
m_ID = 0;
}
m_conn->terminateStatement(stmt);
} catch (SQLException &e) {
throw(std::runtime_error("ODSRPCycle::fetchID: "+e.getMessage()));
}
}
| void ODSRPCycle::setId | ( | int | id | ) | [inline] |
Definition at line 21 of file ODSRPCycle.h.
References m_ID.
Referenced by ODEcalCycle::writeDB().
{m_ID=id;}
| void ODSRPCycle::setSRPConfigurationID | ( | int | x | ) | [inline] |
Definition at line 25 of file ODSRPCycle.h.
References m_srp_config_id, and x.
Referenced by ODEcalCycle::writeDB().
{m_srp_config_id=x;}
| void ODSRPCycle::writeDB | ( | ) | throw (std::runtime_error) [private] |
Definition at line 41 of file ODSRPCycle.cc.
References alignCSCRings::e, and getId().
{
this->checkConnection();
this->checkPrepare();
try {
m_writeStmt->setInt(1, this->getId());
m_writeStmt->setInt(2, this->getSRPConfigurationID());
m_writeStmt->executeUpdate();
} catch (SQLException &e) {
throw(std::runtime_error("ODSRPCycle::writeDB: "+e.getMessage()));
}
// Now get the ID
if (!this->fetchID()) {
throw(std::runtime_error("ODSRPCycle::writeDB: Failed to write"));
}
}
friend class EcalCondDBInterface [friend] |
Reimplemented from IDBObject.
Definition at line 13 of file ODSRPCycle.h.
friend class ODEcalCycle [friend] |
Definition at line 14 of file ODSRPCycle.h.
int ODSRPCycle::m_ID [private] |
Definition at line 34 of file ODSRPCycle.h.
Referenced by getId(), operator==(), and setId().
int ODSRPCycle::m_srp_config_id [private] |
Definition at line 35 of file ODSRPCycle.h.
Referenced by getSRPConfigurationID(), and setSRPConfigurationID().
1.7.3