CaliIOV Class Reference

#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 int const	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.

{}

Member Function Documentation

fetchID()

int CaliIOV::fetchID ( )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 48 of file CaliIOV.cc.

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

                                     {
  // 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;
}

getCaliTag()

CaliTag CaliIOV::getCaliTag

(

)

const

Definition at line 46 of file CaliIOV.cc.

{ return m_caliTag; }

getID()

int CaliIOV::getID ( )

inline

Definition at line 30 of file CaliIOV.h.

References IUniqueDBObject::m_ID.

{ return m_ID; };

getSince()

Tm CaliIOV::getSince

(

)

const

Definition at line 28 of file CaliIOV.cc.

{ return m_since; }

getTill()

Tm CaliIOV::getTill

(

)

const

Definition at line 37 of file CaliIOV.cc.

{ return m_till; }

operator!=()

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

inline

Definition at line 39 of file CaliIOV.h.

References visualization-live-secondInstance_cfg::m.

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

operator==()

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

inline

Definition at line 35 of file CaliIOV.h.

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

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

setByID()

void CaliIOV::setByID ( int  id )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 94 of file CaliIOV.cc.

References cuy::dh, MillePedeFileConverter_cfg::e, l1ctLayer2EG_cff::id, SiStripBadComponentsDQMServiceTemplate_cfg::since, and ntuplemaker::till.

                                            {
  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()));
  }
}

setByTm()

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

privatenoexcept

Definition at line 174 of file CaliIOV.cc.

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

Referenced by EcalCondDBInterface::fetchCaliIOV().

                                                                     {
  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()));
  }
}

setCaliTag()

void CaliIOV::setCaliTag

(

const CaliTag &

tag

)

Definition at line 39 of file CaliIOV.cc.

References makeGlobalPositionRcd_cfg::tag.

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

setSince()

void CaliIOV::setSince

(

const Tm &

since

)

Definition at line 21 of file CaliIOV.cc.

References SiStripBadComponentsDQMServiceTemplate_cfg::since.

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

setTill()

void CaliIOV::setTill

(

const Tm &

till

)

Definition at line 30 of file CaliIOV.cc.

References ntuplemaker::till.

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

writeDB()

int CaliIOV::writeDB ( )

privatenoexcept

Definition at line 127 of file CaliIOV.cc.

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

                                     {
  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;
}

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==().