RunSeqDef Class Reference

#include <RunSeqDef.h>

Inheritance diagram for RunSeqDef:

Public Member Functions
int	fetchID () noexcept(false) override
std::string	getRunSeq () const
RunTypeDef	getRunTypeDef () const
bool	operator!= (const RunSeqDef &t) const
bool	operator== (const RunSeqDef &t) const
	RunSeqDef ()
void	setByID (int id) noexcept(false) override
void	setRunSeq (std::string runseq)
void	setRunTypeDef (const RunTypeDef &runTypeDef)
	~RunSeqDef () 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 ()

Protected Member Functions
void	fetchAllDefs (std::vector< RunSeqDef > *fillVec) noexcept(false)
int	writeDB () noexcept(false)
Protected Member Functions inherited from IDBObject
void	checkConnection () const noexcept(false)

Protected Attributes
std::string	m_runSeq
RunTypeDef	m_runType
Protected Attributes inherited from IUniqueDBObject
int	m_ID
Protected Attributes inherited from IDBObject
oracle::occi::Connection *	m_conn
oracle::occi::Environment *	m_env

Friends
class	EcalCondDBInterface
class	ODRunConfigSeqInfo

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

Detailed Description

Def for Location information

Definition at line 13 of file RunSeqDef.h.

Constructor & Destructor Documentation

RunSeqDef::RunSeqDef

(

)

Definition at line 9 of file RunSeqDef.cc.

                     {
  m_env = nullptr;
  m_conn = nullptr;
  m_ID = 0;
  m_runSeq = "";
  m_runType = RunTypeDef();
}

RunSeqDef::~RunSeqDef ( )

override

Definition at line 17 of file RunSeqDef.cc.

{}

Member Function Documentation

void RunSeqDef::fetchAllDefs ( std::vector< RunSeqDef > *  fillVec )

protectednoexcept

Definition at line 91 of file RunSeqDef.cc.

References alignCSCRings::e, setByID(), and IDBObject::setConnection().

                                                                          {
  this->checkConnection();
  try {
    Statement* stmt = m_conn->createStatement();
    stmt->setSQL("SELECT def_id FROM ecal_sequence_type_def ORDER BY def_id");
    ResultSet* rset = stmt->executeQuery();

    RunSeqDef runSeqDef;
    runSeqDef.setConnection(m_env, m_conn);

    while (rset->next()) {
      runSeqDef.setByID(rset->getInt(1));
      fillVec->push_back(runSeqDef);
    }
  } catch (SQLException& e) {
    throw(std::runtime_error("RunSeqDef::fetchAllDefs:  " + e.getMessage()));
  }
}

int RunSeqDef::fetchID ( )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 27 of file RunSeqDef.cc.

References alignCSCRings::e.

                                       {
  // Return def from memory if available
  if (m_ID) {
    return m_ID;
  }

  this->checkConnection();

  // get the run type
  m_runType.setConnection(m_env, m_conn);
  int run_type_id = m_runType.fetchID();

  try {
    Statement* stmt = m_conn->createStatement();
    stmt->setSQL(
        "SELECT def_id FROM ecal_sequence_type_def WHERE "
        " run_type_def_id   = :1 and sequence_type_string = :2 ");

    stmt->setInt(1, run_type_id);
    stmt->setString(2, m_runSeq);

    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("RunSeqDef::fetchID:  " + e.getMessage()));
  }

  return m_ID;
}

string RunSeqDef::getRunSeq

(

)

const

Definition at line 19 of file RunSeqDef.cc.

{ return m_runSeq; }

RunTypeDef RunSeqDef::getRunTypeDef

(

)

const

Definition at line 23 of file RunSeqDef.cc.

{ return m_runType; }

bool RunSeqDef::operator!= ( const RunSeqDef &  t ) const

inline

Definition at line 34 of file RunSeqDef.h.

References m_runSeq.

{ return m_runSeq != t.m_runSeq; }

bool RunSeqDef::operator== ( const RunSeqDef &  t ) const

inline

Definition at line 33 of file RunSeqDef.h.

References m_runSeq.

{ return m_runSeq == t.m_runSeq; }

void RunSeqDef::setByID ( int  id )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 63 of file RunSeqDef.cc.

References alignCSCRings::e.

Referenced by fetchAllDefs().

                                              {
  this->checkConnection();

  try {
    Statement* stmt = m_conn->createStatement();

    stmt->setSQL("SELECT run_type_def_id, sequence_type_string FROM ecal_sequence_type_def WHERE def_id = :1");
    stmt->setInt(1, id);

    int idruntype = 0;
    ResultSet* rset = stmt->executeQuery();
    if (rset->next()) {
      idruntype = rset->getInt(1);
      m_runSeq = rset->getString(2);
    } else {
      throw(std::runtime_error("RunSeqDef::setByID:  Given def_id is not in the database"));
    }

    m_conn->terminateStatement(stmt);

    m_runType.setConnection(m_env, m_conn);
    m_runType.setByID(idruntype);

  } catch (SQLException& e) {
    throw(std::runtime_error("RunSeqDef::setByID:  " + e.getMessage()));
  }
}

void RunSeqDef::setRunSeq

(

std::string

runseq

)

Definition at line 21 of file RunSeqDef.cc.

{ m_runSeq = runseq; }

void RunSeqDef::setRunTypeDef

(

const RunTypeDef &

runTypeDef

)

Definition at line 25 of file RunSeqDef.cc.

{ m_runType = runTypeDef; }

int RunSeqDef::writeDB ( )

protectednoexcept

Definition at line 110 of file RunSeqDef.cc.

References alignCSCRings::e.

                                       {
  // see if this data is already in the DB
  try {
    if (this->fetchID()) {
      return m_ID;
    }
  } catch (SQLException& e) {
    // it does not exist yet
  }

  // check the connectioin
  this->checkConnection();

  // get the run type
  m_runType.setConnection(m_env, m_conn);
  int run_type_id = m_runType.fetchID();

  // write new seq def to the DB
  try {
    Statement* stmt = m_conn->createStatement();

    stmt->setSQL(
        "insert into ecal_sequence_type_def(RUN_TYPE_DEF_ID, SEQUENCE_TYPE_STRING) values "
        " ( :1, :2 )");
    stmt->setInt(1, run_type_id);
    stmt->setString(2, m_runSeq);

    stmt->executeUpdate();

    m_conn->terminateStatement(stmt);
  } catch (SQLException& e) {
    throw(std::runtime_error("RunSeqDef::writeDB:  " + e.getMessage()));
  }

  // now get the tag_id
  if (!this->fetchID()) {
    throw(std::runtime_error("RunSeqDef::writeDB:  Failed to write"));
  }

  return m_ID;
}

Friends And Related Function Documentation

friend class EcalCondDBInterface

friend

Definition at line 16 of file RunSeqDef.h.

friend class ODRunConfigSeqInfo

friend

Definition at line 15 of file RunSeqDef.h.

Member Data Documentation

std::string RunSeqDef::m_runSeq

protected

Definition at line 38 of file RunSeqDef.h.

Referenced by operator!=(), and operator==().

RunTypeDef RunSeqDef::m_runType

protected

Definition at line 39 of file RunSeqDef.h.