MODRunIOV Class Reference

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

{}

Member Function Documentation

fetchID()

int MODRunIOV::fetchID ( )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 61 of file MODRunIOV.cc.

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

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

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.

References IUniqueDBObject::m_ID.

{ return m_ID; };

getRunIOV()

RunIOV MODRunIOV::getRunIOV

(

)

Definition at line 32 of file MODRunIOV.cc.

{ return m_runIOV; }

getSubRunEnd()

Tm MODRunIOV::getSubRunEnd

(

)

const

Definition at line 59 of file MODRunIOV.cc.

{ return m_subRunEnd; }

getSubRunNumber()

run_t MODRunIOV::getSubRunNumber

(

)

const

Definition at line 41 of file MODRunIOV.cc.

{ return m_subRunNum; }

getSubRunStart()

Tm MODRunIOV::getSubRunStart

(

)

const

Definition at line 50 of file MODRunIOV.cc.

{ return m_subRunStart; }

operator!=()

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

inline

Definition at line 43 of file MODRunIOV.h.

References visualization-live-secondInstance_cfg::m.

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

operator==()

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

inline

Definition at line 38 of file MODRunIOV.h.

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

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

setByID()

void MODRunIOV::setByID ( int  id )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 113 of file MODRunIOV.cc.

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

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

setByRun()

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

privatenoexcept

Definition at line 207 of file MODRunIOV.cc.

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

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

setID()

void MODRunIOV::setID

(

int

id

)

Definition at line 23 of file MODRunIOV.cc.

References EcalPhiSymFlatTableProducers_cfi::id.

{ m_ID = 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.

References mps_fire::end.

                                          {
  if (end != m_subRunEnd) {
    m_ID = 0;
    m_subRunEnd = 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.

References isotrackNtupler::start.

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

writeDB()

int MODRunIOV::writeDB ( )

privatenoexcept

Definition at line 148 of file MODRunIOV.cc.

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

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

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