#include <MODRunIOV.h>

Inheritance diagram for MODRunIOV:

Public Member Functions
int	fetchID () noexcept(false) override

int	getID ()

RunIOV	getRunIOV ()

Tm	getSubRunEnd () const

run_t	getSubRunNumber () const

Tm	getSubRunStart () const

	MODRunIOV ()

bool	operator!= (const MODRunIOV &m) const

bool	operator== (const MODRunIOV &m) const

void	setByID (int id) noexcept(false) override

void	setID (int id)

void	setRunIOV (const RunIOV &iov)

void	setSubRunEnd (const Tm &end)

void	setSubRunNumber (subrun_t subrun)

void	setSubRunStart (const Tm &start)

	~MODRunIOV () override

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	fetchParentIDs (int *runIOVID) noexcept(false)

void	setByRun (RunIOV *runiov, subrun_t subrun) noexcept(false)

int	writeDB () noexcept(false)

Private Attributes
RunIOV	m_runIOV

Tm	m_subRunEnd

subrun_t	m_subRunNum

Tm	m_subRunStart

Friends
class	EcalCondDBInterface

Additional Inherited Members
Static Public Attributes inherited from IDBObject
static const int	ECALDB_NROWS = 1024

Protected Member Functions inherited from IDBObject
void	checkConnection () const noexcept(false)

Protected Attributes inherited from IUniqueDBObject
int	m_ID

Protected Attributes inherited from IDBObject
oracle::occi::Connection *	m_conn

oracle::occi::Environment *	m_env

Detailed Description

Definition at line 13 of file MODRunIOV.h.

Constructor & Destructor Documentation

◆ MODRunIOV()

MODRunIOV::MODRunIOV ( )

Definition at line 12 of file MODRunIOV.cc.

                      {
   m_conn = nullptr;
   m_ID = 0;
   m_runIOV = RunIOV();
   m_subRunNum = 0;
   m_subRunStart = Tm();
   m_subRunEnd = Tm();
 }

◆ ~MODRunIOV()

MODRunIOV::~MODRunIOV ( )

override

Definition at line 21 of file MODRunIOV.cc.

21 {}

Member Function Documentation

◆ fetchID()

int MODRunIOV::fetchID ( )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 61 of file MODRunIOV.cc.

                                        {
   // Return from memory if available
   if (m_ID) {
     return m_ID;
   }
  
   this->checkConnection();
  
   // fetch the parent IDs
   int runIOVID;
   this->fetchParentIDs(&runIOVID);
  
   if (!runIOVID) {
     return 0;
   }
  
   DateHandler dh(m_env, m_conn);
  
   if (m_subRunEnd.isNull()) {
     m_subRunEnd = dh.getPlusInfTm();
   }
  
   try {
     Statement* stmt = m_conn->createStatement();
     stmt->setSQL(
         "SELECT iov_id FROM OD_run_iov "
         "WHERE "
         "run_iov_id   = :1 AND "
         "subrun_num   = :2 AND "
         "subrun_start = :3 AND "
         "subrun_end   = :4");
  
     stmt->setInt(1, runIOVID);
     stmt->setInt(2, m_subRunNum);
     stmt->setDate(3, dh.tmToDate(m_subRunStart));
     stmt->setDate(4, dh.tmToDate(m_subRunEnd));
  
     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("MODRunIOV::fetchID:  " + e.getMessage()));
   }
  
   return m_ID;
 }

References cuy::dh, and MillePedeFileConverter_cfg::e.

◆ fetchParentIDs()

void MODRunIOV::fetchParentIDs ( int * runIOVID )

privatenoexcept

Definition at line 197 of file MODRunIOV.cc.

                                                             {
   // get the RunIOV
   m_runIOV.setConnection(m_env, m_conn);
   *runIOVID = m_runIOV.fetchID();
  
   if (!*runIOVID) {
     throw(std::runtime_error("MODRunIOV:  Given RunIOV does not exist in DB"));
   }
 }

◆ getID()

int MODRunIOV::getID ( )

inline

Definition at line 21 of file MODRunIOV.h.

21 { return m_ID; };

References IUniqueDBObject::m_ID.

◆ getRunIOV()

RunIOV MODRunIOV::getRunIOV ( )

Definition at line 32 of file MODRunIOV.cc.

32 { return m_runIOV; }

◆ getSubRunEnd()

Tm MODRunIOV::getSubRunEnd ( ) const

Definition at line 59 of file MODRunIOV.cc.

59 { return m_subRunEnd; }

◆ getSubRunNumber()

run_t MODRunIOV::getSubRunNumber ( ) const

Definition at line 41 of file MODRunIOV.cc.

41 { return m_subRunNum; }

◆ getSubRunStart()

Tm MODRunIOV::getSubRunStart ( ) const

Definition at line 50 of file MODRunIOV.cc.

50 { return m_subRunStart; }

◆ operator!=()

bool MODRunIOV::operator!= ( const MODRunIOV & m ) const

inline

Definition at line 43 of file MODRunIOV.h.

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

References visualization-live-secondInstance_cfg::m.

◆ operator==()

bool MODRunIOV::operator== ( const MODRunIOV & m ) const

inline

Definition at line 38 of file MODRunIOV.h.

                                                    {
     return (m_runIOV == m.m_runIOV && m_subRunNum == m.m_subRunNum && m_subRunStart == m.m_subRunStart &&
             m_subRunEnd == m.m_subRunEnd);
   }

References visualization-live-secondInstance_cfg::m, m_runIOV, m_subRunEnd, m_subRunNum, and m_subRunStart.

◆ setByID()

void MODRunIOV::setByID ( int id )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 113 of file MODRunIOV.cc.

                                               {
   this->checkConnection();
  
   DateHandler dh(m_env, m_conn);
  
   try {
     Statement* stmt = m_conn->createStatement();
  
     stmt->setSQL("SELECT run_iov_id, subrun_num, subrun_start, subrun_end FROM OD_run_iov WHERE iov_id = :1");
     stmt->setInt(1, id);
  
     ResultSet* rset = stmt->executeQuery();
     if (rset->next()) {
       int runIOVID = rset->getInt(1);
       m_subRunNum = rset->getInt(2);
       Date startDate = rset->getDate(3);
       Date endDate = rset->getDate(4);
  
       m_subRunStart = dh.dateToTm(startDate);
       m_subRunEnd = dh.dateToTm(endDate);
  
       m_runIOV.setConnection(m_env, m_conn);
       m_runIOV.setByID(runIOVID);
  
       m_ID = id;
     } else {
       throw(std::runtime_error("MODRunIOV::setByID:  Given id is not in the database"));
     }
  
     m_conn->terminateStatement(stmt);
   } catch (SQLException& e) {
     throw(std::runtime_error("MODRunIOV::setByID:  " + e.getMessage()));
   }
 }

References cuy::dh, MillePedeFileConverter_cfg::e, and triggerObjects_cff::id.

◆ setByRun()

void MODRunIOV::setByRun	(	RunIOV *	runiov,
		subrun_t	subrun
	)

privatenoexcept

Definition at line 207 of file MODRunIOV.cc.

                                                                         {
   this->checkConnection();
  
   runiov->setConnection(m_env, m_conn);
   int runIOVID = runiov->fetchID();
  
   if (!runIOVID) {
     throw(std::runtime_error("MODRunIOV::setByRun:  Given RunIOV does not exist in DB"));
   }
  
   DateHandler dh(m_env, m_conn);
  
   try {
     Statement* stmt = m_conn->createStatement();
  
     stmt->setSQL(
         "SELECT iov_id, subrun_start, subrun_end FROM OD_run_iov "
         "WHERE run_iov_id = :1 AND subrun_num = :2");
     stmt->setInt(1, runIOVID);
     stmt->setInt(2, subrun);
  
     ResultSet* rset = stmt->executeQuery();
     if (rset->next()) {
       m_runIOV = *runiov;
       m_subRunNum = subrun;
  
       m_ID = rset->getInt(1);
       Date startDate = rset->getDate(2);
       Date endDate = rset->getDate(3);
  
       m_subRunStart = dh.dateToTm(startDate);
       m_subRunEnd = dh.dateToTm(endDate);
     } else {
       throw(std::runtime_error("MODRunIOV::setByRun:  Given subrun is not in the database"));
     }
  
     m_conn->terminateStatement(stmt);
   } catch (SQLException& e) {
     throw(std::runtime_error("MODRunIOV::setByRun:  " + e.getMessage()));
   }
 }

References cuy::dh, and MillePedeFileConverter_cfg::e.

◆ setID()

void MODRunIOV::setID ( int id )

Definition at line 23 of file MODRunIOV.cc.

23 { m_ID = id; }

References triggerObjects_cff::id.

◆ setRunIOV()

void MODRunIOV::setRunIOV ( const RunIOV & iov )

Definition at line 25 of file MODRunIOV.cc.

                                            {
   if (iov != m_runIOV) {
     m_ID = 0;
     m_runIOV = iov;
   }
 }

◆ setSubRunEnd()

void MODRunIOV::setSubRunEnd ( const Tm & end )

Definition at line 52 of file MODRunIOV.cc.

                                           {
   if (end != m_subRunEnd) {
     m_ID = 0;
     m_subRunEnd = end;
   }
 }

References mps_fire::end.

◆ setSubRunNumber()

void MODRunIOV::setSubRunNumber ( subrun_t subrun )

Definition at line 34 of file MODRunIOV.cc.

                                                {
   if (subrun != m_subRunNum) {
     m_ID = 0;
     m_subRunNum = subrun;
   }
 }

◆ setSubRunStart()

void MODRunIOV::setSubRunStart ( const Tm & start )

Definition at line 43 of file MODRunIOV.cc.

                                               {
   if (start != m_subRunStart) {
     m_ID = 0;
     m_subRunStart = start;
   }
 }

References command_line::start.

◆ writeDB()

int MODRunIOV::writeDB ( )

privatenoexcept

Definition at line 148 of file MODRunIOV.cc.

                                        {
   this->checkConnection();
  
   // Check if this IOV has already been written
   if (this->fetchID()) {
     return m_ID;
   }
  
   // fetch Parent IDs
   int runIOVID;
   this->fetchParentIDs(&runIOVID);
  
   // Validate the data, use infinity-till convention
   DateHandler dh(m_env, m_conn);
  
   if (m_subRunStart.isNull()) {
     throw(std::runtime_error("MODRunIOV::writeDB:  Must setSubRunStart before writing"));
   }
  
   if (m_subRunEnd.isNull()) {
     m_subRunEnd = dh.getPlusInfTm();
   }
  
   try {
     Statement* stmt = m_conn->createStatement();
  
     stmt->setSQL(
         "INSERT INTO od_run_iov (iov_id,  run_iov_id, subrun_num, subrun_start, subrun_end) "
         "VALUES (OD_run_iov_sq.NextVal, :1, :2, :3, :4)");
     stmt->setInt(1, runIOVID);
     stmt->setInt(2, m_subRunNum);
     stmt->setDate(3, dh.tmToDate(m_subRunStart));
     stmt->setDate(4, dh.tmToDate(m_subRunEnd));
  
     stmt->executeUpdate();
  
     m_conn->terminateStatement(stmt);
   } catch (SQLException& e) {
     throw(std::runtime_error("MODRunIOV::writeDB:  " + e.getMessage()));
   }
  
   // Now get the ID
   if (!this->fetchID()) {
     throw(std::runtime_error("MODRunIOV::writeDB:  Failed to write"));
   }
  
   return m_ID;
 }

References cuy::dh, and MillePedeFileConverter_cfg::e.

Friends And Related Function Documentation

◆ EcalCondDBInterface

friend class EcalCondDBInterface

friend

Definition at line 15 of file MODRunIOV.h.

Member Data Documentation

◆ m_runIOV

RunIOV MODRunIOV::m_runIOV

private

Definition at line 47 of file MODRunIOV.h.

Referenced by operator==().

◆ m_subRunEnd

Tm MODRunIOV::m_subRunEnd

private

Definition at line 50 of file MODRunIOV.h.

Referenced by operator==().

◆ m_subRunNum

subrun_t MODRunIOV::m_subRunNum

private

Definition at line 48 of file MODRunIOV.h.

Referenced by operator==().

◆ m_subRunStart

Tm MODRunIOV::m_subRunStart

private

Definition at line 49 of file MODRunIOV.h.

Referenced by operator==().

Public Member Functions

Private Member Functions

Private Attributes

Friends

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ MODRunIOV()

◆ ~MODRunIOV()

Member Function Documentation

◆ fetchID()

◆ fetchParentIDs()

◆ getID()

◆ getRunIOV()

◆ getSubRunEnd()

◆ getSubRunNumber()

◆ getSubRunStart()

◆ operator!=()

◆ operator==()

◆ setByID()

◆ setByRun()

◆ setID()

◆ setRunIOV()

◆ setSubRunEnd()

◆ setSubRunNumber()

◆ setSubRunStart()

◆ writeDB()

Friends And Related Function Documentation

◆ EcalCondDBInterface

Member Data Documentation

◆ m_runIOV

◆ m_subRunEnd

◆ m_subRunNum

◆ m_subRunStart