DCUTag Class Reference

#include <DCUTag.h>

Inheritance diagram for DCUTag:

Public Member Functions
	DCUTag ()
int	fetchID () noexcept(false) override
std::string	getGeneralTag () const
LocationDef	getLocationDef () const
bool	operator!= (const DCUTag &t) const
bool	operator== (const DCUTag &t) const
void	setByID (int id) noexcept(false) override
void	setGeneralTag (std::string tag)
void	setLocationDef (const LocationDef &locDef)
	~DCUTag () 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	fetchAllTags (std::vector< DCUTag > *fillVec) noexcept(false)
void	fetchParentIDs (int *locId) noexcept(false)
int	writeDB () noexcept(false)

Private Attributes
std::string	m_genTag
LocationDef	m_locDef

Friends
class	DCUIOV
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

Tag for Run information

Definition at line 13 of file DCUTag.h.

Constructor & Destructor Documentation

DCUTag::DCUTag

(

)

Definition at line 9 of file DCUTag.cc.

{
  m_env = nullptr;
  m_conn = nullptr;
  m_ID = 0;
  m_genTag = "default";
  m_locDef = LocationDef();
}

DCUTag::~DCUTag ( )

override

Definition at line 20 of file DCUTag.cc.

{
}

Member Function Documentation

void DCUTag::fetchAllTags ( std::vector< DCUTag > *  fillVec )

privatenoexcept

Definition at line 174 of file DCUTag.cc.

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

{
  this->checkConnection();
  try {
    Statement* stmt = m_conn->createStatement();
    stmt->setSQL("SELECT tag_id FROM dcu_tag ORDER BY tag_id");
    ResultSet* rset = stmt->executeQuery();
    
    DCUTag dcutag;
    dcutag.setConnection(m_env, m_conn);
    while(rset->next()) {
      dcutag.setByID( rset->getInt(1) );
      fillVec->push_back( dcutag );
    }
    m_conn->terminateStatement(stmt);
  } catch (SQLException &e) {
    throw(std::runtime_error("DCUTag::fetchAllTags:  "+e.getMessage()));
  }
}

int DCUTag::fetchID ( )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 62 of file DCUTag.cc.

References MillePedeFileConverter_cfg::e.

{
  // Return tag from memory if available
  if (m_ID) {
    return m_ID;
  }
  
  this->checkConnection();

  // fetch the parent IDs
  int locID;
  this->fetchParentIDs(&locID);

  // fetch this ID
  try {
    Statement* stmt = m_conn->createStatement();
    stmt->setSQL("SELECT tag_id FROM dcu_tag WHERE "
         "gen_tag     = :1 AND "
         "location_id = :2");
    stmt->setString(1, m_genTag);
    stmt->setInt(2, locID);

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

  return m_ID;
}

void DCUTag::fetchParentIDs ( int *  locId )

privatenoexcept

Definition at line 197 of file DCUTag.cc.

{
  // get the location
  m_locDef.setConnection(m_env, m_conn);
  *locID = m_locDef.fetchID();

  if (! *locID) { 
    throw(std::runtime_error("DCUTag::writeDB:  Given location does not exist in DB")); 
  }
}

string DCUTag::getGeneralTag

(

)

const

Definition at line 26 of file DCUTag.cc.

{
  return m_genTag;
}

LocationDef DCUTag::getLocationDef

(

)

const

Definition at line 45 of file DCUTag.cc.

{
  return m_locDef;
}

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

inline

Definition at line 39 of file DCUTag.h.

References protons_cff::t.

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

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

inline

Definition at line 33 of file DCUTag.h.

References m_genTag, and m_locDef.

    { 
      return (m_genTag == t.m_genTag &&
          m_locDef == t.m_locDef);
    }

void DCUTag::setByID ( int  id )

overridevirtualnoexcept

Implements IUniqueDBObject.

Definition at line 102 of file DCUTag.cc.

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

Referenced by fetchAllTags().

{
  this->checkConnection();

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

    stmt->setSQL("SELECT gen_tag, location_id FROM dcu_tag WHERE tag_id = :1");
    stmt->setInt(1, id);

    ResultSet* rset = stmt->executeQuery();
    if (rset->next()) {
      m_genTag = rset->getString(1);
      int locID = rset->getInt(2);

      m_locDef.setConnection(m_env, m_conn);
      m_locDef.setByID(locID);

      m_ID = id;
    } else {
      throw(std::runtime_error("DCUTag::setByID:  Given tag_id is not in the database"));
    }

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

void DCUTag::setGeneralTag

(

std::string

tag

)

Definition at line 35 of file DCUTag.cc.

{
  if (genTag != m_genTag) {
    m_ID = 0;
    m_genTag = genTag;
  }
}

void DCUTag::setLocationDef

(

const LocationDef &

locDef

)

Definition at line 52 of file DCUTag.cc.

{
  if (locDef != m_locDef) {
    m_ID = 0;
    m_locDef = locDef;
  }
}

int DCUTag::writeDB ( )

privatenoexcept

Definition at line 133 of file DCUTag.cc.

References MillePedeFileConverter_cfg::e.

{
  // see if this data is already in the DB
  if (this->fetchID()) { 
    return m_ID; 
  }

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

  // fetch the parent IDs
  int locID;
  this->fetchParentIDs(&locID);

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

    stmt->setSQL("INSERT INTO dcu_tag (tag_id, gen_tag, location_id) "
         "VALUES (dcu_tag_sq.NextVal, :1, :2)");
    stmt->setString(1, m_genTag);
    stmt->setInt(2, locID);

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

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

  return m_ID;
}

Friends And Related Function Documentation

friend class DCUIOV

friend

Definition at line 15 of file DCUTag.h.

friend class EcalCondDBInterface

friend

Definition at line 16 of file DCUTag.h.

Member Data Documentation

std::string DCUTag::m_genTag

private

Definition at line 43 of file DCUTag.h.

Referenced by operator==().

LocationDef DCUTag::m_locDef

private

Definition at line 44 of file DCUTag.h.

Referenced by operator==().