#include <CaliIOV.h>

Inheritance diagram for CaliIOV:

Public Member Functions
	CaliIOV ()

int	fetchID () noexcept(false) override

CaliTag	getCaliTag () const

int	getID ()

Tm	getSince () const

Tm	getTill () const

bool	operator!= (const CaliIOV &m) const

bool	operator== (const CaliIOV &m) const

void	setByID (int id) noexcept(false) override

void	setCaliTag (const CaliTag &tag)

void	setSince (const Tm &since)

void	setTill (const Tm &till)

	~CaliIOV () 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	setByTm (CaliTag *tag, const Tm &time) noexcept(false)

int	writeDB () noexcept(false)

Private Attributes
CaliTag	m_caliTag

Tm	m_since

Tm	m_till

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 CaliIOV.h.

Constructor & Destructor Documentation

◆ CaliIOV()

CaliIOV::CaliIOV ( )

Definition at line 12 of file CaliIOV.cc.

                  {
   m_conn = nullptr;
   m_ID = 0;
   m_since = Tm();
   m_till = Tm();
 }

◆ ~CaliIOV()

CaliIOV::~CaliIOV ( )

override

Definition at line 19 of file CaliIOV.cc.

19 {}

Member Function Documentation

◆ fetchID()

int CaliIOV::fetchID ( )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 48 of file CaliIOV.cc.

                                      {
   // Return from memory if available
   if (m_ID) {
     return m_ID;
   }
  
   this->checkConnection();
  
   m_caliTag.setConnection(m_env, m_conn);
   int tagID = m_caliTag.fetchID();
   if (!tagID) {
     return 0;
   }
  
   DateHandler dh(m_env, m_conn);
  
   if (m_till.isNull()) {
     m_till = dh.getPlusInfTm();
   }
  
   try {
     Statement* stmt = m_conn->createStatement();
     stmt->setSQL(
         "SELECT iov_id FROM cali_iov "
         "WHERE tag_id = :tag_id AND "
         "since = :since AND "
         "till = :till");
     stmt->setInt(1, tagID);
     stmt->setDate(2, dh.tmToDate(m_since));
     stmt->setDate(3, dh.tmToDate(m_till));
  
     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("CaliIOV::fetchID:  " + e.getMessage()));
   }
  
   return m_ID;
 }

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

◆ getCaliTag()

CaliTag CaliIOV::getCaliTag ( ) const

Definition at line 46 of file CaliIOV.cc.

46 { return m_caliTag; }

◆ getID()

int CaliIOV::getID ( )

inline

Definition at line 30 of file CaliIOV.h.

30 { return m_ID; };

References IUniqueDBObject::m_ID.

◆ getSince()

Tm CaliIOV::getSince ( ) const

Definition at line 28 of file CaliIOV.cc.

28 { return m_since; }

◆ getTill()

Tm CaliIOV::getTill ( ) const

Definition at line 37 of file CaliIOV.cc.

37 { return m_till; }

◆ operator!=()

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

inline

Definition at line 39 of file CaliIOV.h.

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

References visualization-live-secondInstance_cfg::m.

◆ operator==()

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

inline

Definition at line 35 of file CaliIOV.h.

                                                  {
     return (m_caliTag == m.m_caliTag && m_since == m.m_since && m_till == m.m_till);
   }

References visualization-live-secondInstance_cfg::m, m_caliTag, m_since, and m_till.

◆ setByID()

void CaliIOV::setByID ( int id )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 94 of file CaliIOV.cc.

                                             {
   this->checkConnection();
  
   DateHandler dh(m_env, m_conn);
  
   try {
     Statement* stmt = m_conn->createStatement();
  
     stmt->setSQL("SELECT tag_id, since, till FROM cali_iov WHERE iov_id = :1");
     stmt->setInt(1, id);
  
     ResultSet* rset = stmt->executeQuery();
     if (rset->next()) {
       int tagID = rset->getInt(1);
       Date since = rset->getDate(2);
       Date till = rset->getDate(3);
  
       m_since = dh.dateToTm(since);
       m_till = dh.dateToTm(till);
  
       m_caliTag.setConnection(m_env, m_conn);
       m_caliTag.setByID(tagID);
       m_ID = id;
     } else {
       throw(std::runtime_error("CaliTag::setByID:  Given tag_id is not in the database"));
     }
  
     m_conn->terminateStatement(stmt);
   } catch (SQLException& e) {
     throw(std::runtime_error("CaliTag::setByID:  " + e.getMessage()));
   }
 }

References cuy::dh, MillePedeFileConverter_cfg::e, triggerObjects_cff::id, writeEcalDQMStatus::since, and ntuplemaker::till.

◆ setByTm()

void CaliIOV::setByTm	(	CaliTag *	tag,
		const Tm &	time
	)

privatenoexcept

Definition at line 174 of file CaliIOV.cc.

                                                                      {
   this->checkConnection();
  
   tag->setConnection(m_env, m_conn);
   int tagID = tag->fetchID();
  
   if (!tagID) {
     throw(std::runtime_error("CaliIOV::setByTm:  Given CaliTag does not exist in the DB"));
   }
  
   DateHandler dh(m_env, m_conn);
  
   Date eventDate = dh.tmToDate(eventTm);
  
   try {
     Statement* stmt = m_conn->createStatement();
  
     stmt->setSQL(
         "SELECT iov_id, since, till FROM cali_iov "
         "WHERE tag_id = :1 AND since <= :2 AND till > :3");
     stmt->setInt(1, tagID);
     stmt->setDate(2, eventDate);
     stmt->setDate(3, eventDate);
  
     ResultSet* rset = stmt->executeQuery();
     if (rset->next()) {
       m_caliTag = *tag;
  
       m_ID = rset->getInt(1);
       Date sinceDate = rset->getDate(2);
       Date tillDate = rset->getDate(3);
  
       m_since = dh.dateToTm(sinceDate);
       m_till = dh.dateToTm(tillDate);
     } else {
       throw(std::runtime_error("CaliIOV::setByTm:  Given subrun is not in the database"));
     }
  
     m_conn->terminateStatement(stmt);
   } catch (SQLException& e) {
     throw(std::runtime_error("CaliIOV::setByTm:  " + e.getMessage()));
   }
 }

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

Referenced by EcalCondDBInterface::fetchCaliIOV().

◆ setCaliTag()

void CaliIOV::setCaliTag ( const CaliTag & tag )

Definition at line 39 of file CaliIOV.cc.

                                            {
   if (tag != m_caliTag) {
     m_ID = 0;
     m_caliTag = tag;
   }
 }

References makeGlobalPositionRcd_cfg::tag.

◆ setSince()

void CaliIOV::setSince ( const Tm & since )

Definition at line 21 of file CaliIOV.cc.

                                       {
   if (since != m_since) {
     m_ID = 0;
     m_since = since;
   }
 }

References writeEcalDQMStatus::since.

◆ setTill()

void CaliIOV::setTill ( const Tm & till )

Definition at line 30 of file CaliIOV.cc.

                                     {
   if (till != m_till) {
     m_ID = 0;
     m_till = till;
   }
 }

References ntuplemaker::till.

◆ writeDB()

int CaliIOV::writeDB ( )

privatenoexcept

Definition at line 127 of file CaliIOV.cc.

                                      {
   this->checkConnection();
  
   // Check if this IOV has already been written
   if (this->fetchID()) {
     return m_ID;
   }
  
   m_caliTag.setConnection(m_env, m_conn);
   int tagID = m_caliTag.writeDB();
  
   // Validate the data, use infinity-till convention
   DateHandler dh(m_env, m_conn);
  
   if (m_since.isNull()) {
     throw(std::runtime_error("CaliIOV::writeDB:  Must setSince before writing"));
   }
  
   if (m_till.isNull()) {
     m_till = dh.getPlusInfTm();
   }
  
   try {
     Statement* stmt = m_conn->createStatement();
  
     stmt->setSQL(
         "INSERT INTO cali_iov (iov_id, tag_id, since, till) "
         "VALUES (cali_iov_sq.NextVal, :1, :2, :3)");
     stmt->setInt(1, tagID);
     stmt->setDate(2, dh.tmToDate(m_since));
     stmt->setDate(3, dh.tmToDate(m_till));
  
     stmt->executeUpdate();
  
     m_conn->terminateStatement(stmt);
   } catch (SQLException& e) {
     throw(std::runtime_error("CaliIOV::writeDB:  " + e.getMessage()));
   }
  
   // Now get the ID
   if (!this->fetchID()) {
     throw(std::runtime_error("CaliIOV::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 CaliIOV.h.

Member Data Documentation

◆ m_caliTag

CaliTag CaliIOV::m_caliTag

private

Definition at line 45 of file CaliIOV.h.

Referenced by operator==().

◆ m_since

Tm CaliIOV::m_since

private

Definition at line 43 of file CaliIOV.h.

Referenced by operator==().

◆ m_till

Tm CaliIOV::m_till

private

Definition at line 44 of file CaliIOV.h.

Referenced by operator==().

Public Member Functions

Private Member Functions

Private Attributes

Friends

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ CaliIOV()

◆ ~CaliIOV()

Member Function Documentation

◆ fetchID()

◆ getCaliTag()

◆ getID()

◆ getSince()

◆ getTill()

◆ operator!=()

◆ operator==()

◆ setByID()

◆ setByTm()

◆ setCaliTag()

◆ setSince()

◆ setTill()

◆ writeDB()

Friends And Related Function Documentation

◆ EcalCondDBInterface

Member Data Documentation

◆ m_caliTag

◆ m_since

◆ m_till